Integrate 2Chat.io with Airtable and Google Contacts (Without Zapier)
Budget: $10 – $30 USD
We are looking for a skilled developer to integrate 2Chat.io with Airtable and Google Contacts while ensuring automation without Zapier. Our goal is to efficiently sync WhatsApp contacts with Airtable and then update or add them to the respective Google Contact lists based on specific models.
Scope of Work:
2Chat.io to Airtable Integration
Capture incoming WhatsApp messages.
Format phone numbers in E.164 international format (e.g., +49 1579 2625267).
Check Airtable for an existing contact based on the phone number.
If the contact exists, update the record; otherwise, create a new entry.
Ensure proper mapping of fields:
"Telefonnummer" → WhatsApp Number (formatted).
"Name" → WhatsApp Name.
"Kanal" → Always "WhatsApp".
"Model Kontakt" → Channel name from 2Chat.
Airtable to Google Contacts Integration (Per Model)
Each model has a separate Google Contacts account.
When a record is created or updated in Airtable, sync it with the correct model's Google Contacts account.
Identify which Google account to use based on the Model Kontakt field.
Ensure accurate mapping:
Telefonnummer → Phone number.
First Name → Name in Google Contacts.
GoogleAccount → Model Kontakt.
Authentication & Security:
Implement OAuth authentication for Google Contacts API.
Ensure proper handling of API keys and permissions for secure access.
Automation & Error Handling:
Use n8n (self-hosted automation tool) for workflow automation (already installed on the server).
Set up triggers for automatic syncing between platforms.
Implement error handling & logging for failed updates (e.g., incorrect phone format, missing credentials).
Provide a retry mechanism for failed entries.
Deliverables:
Fully functional 2Chat.io → Airtable → Google Contacts integration.
Detailed documentation with setup steps and API configurations.
Testing and validation to ensure correct data synchronization.
Requirements:
Experience with 2Chat.io API, Airtable API, and Google Contacts API.
Proficiency in Node.js, Python, or any relevant language for API automation.
Experience with OAuth authentication and n8n automation.
Prior experience in building scalable contact sync solutions.
Additional Information:
The solution must not use Zapier (due to cost constraints).
The client provides a dedicated server for script execution (n8n installed and accessible).
High volume processing required (10,000+ contact updates per day).
Scope of Work:
2Chat.io to Airtable Integration
Capture incoming WhatsApp messages.
Format phone numbers in E.164 international format (e.g., +49 1579 2625267).
Check Airtable for an existing contact based on the phone number.
If the contact exists, update the record; otherwise, create a new entry.
Ensure proper mapping of fields:
"Telefonnummer" → WhatsApp Number (formatted).
"Name" → WhatsApp Name.
"Kanal" → Always "WhatsApp".
"Model Kontakt" → Channel name from 2Chat.
Airtable to Google Contacts Integration (Per Model)
Each model has a separate Google Contacts account.
When a record is created or updated in Airtable, sync it with the correct model's Google Contacts account.
Identify which Google account to use based on the Model Kontakt field.
Ensure accurate mapping:
Telefonnummer → Phone number.
First Name → Name in Google Contacts.
GoogleAccount → Model Kontakt.
Authentication & Security:
Implement OAuth authentication for Google Contacts API.
Ensure proper handling of API keys and permissions for secure access.
Automation & Error Handling:
Use n8n (self-hosted automation tool) for workflow automation (already installed on the server).
Set up triggers for automatic syncing between platforms.
Implement error handling & logging for failed updates (e.g., incorrect phone format, missing credentials).
Provide a retry mechanism for failed entries.
Deliverables:
Fully functional 2Chat.io → Airtable → Google Contacts integration.
Detailed documentation with setup steps and API configurations.
Testing and validation to ensure correct data synchronization.
Requirements:
Experience with 2Chat.io API, Airtable API, and Google Contacts API.
Proficiency in Node.js, Python, or any relevant language for API automation.
Experience with OAuth authentication and n8n automation.
Prior experience in building scalable contact sync solutions.
Additional Information:
The solution must not use Zapier (due to cost constraints).
The client provides a dedicated server for script execution (n8n installed and accessible).
High volume processing required (10,000+ contact updates per day).