Keep Airtable contacts clean with an AI helper you can call from any n8n flow. It finds people, adds new records, or updates details from a simple text request. Built for sales teams that handle leads daily and need up to date info.

A caller workflow triggers it and sends a query field like Find Jane or Add Mike with email. A chat model powers a contact agent that reads the request and decides what action to take. It can search your Airtable base using the Get Contacts tool, or upsert a record with the Add or Update Contact tool. Name, email, and phone map to your table fields, and results return in a neat response while errors return a friendly try again message.

You need an OpenAI API key and an Airtable token with access to your contacts table. Make sure your table has fields named name, emailAddress, and phoneNumber or update the mapping to match your schema. Expect faster lead intake, fewer mistakes, and fewer duplicates because upsert matches on name. Common uses include form handoffs, call notes capture, and a chat handoff inside your CRM.

• Triggered by another workflow, making it easy to reuse across n8n
• OpenAI Chat Model gpt 4o interprets plain text queries
• Agent decides when to search or upsert and calls the right Airtable tool
• Get Contacts searches the selected Airtable base and table
• Add or Update Contact upserts records and maps name, emailAddress, and phoneNumber
• Response node returns a clean message, and Try Again provides a safe error reply
• AI outputs feed mapped fields so the database receives structured values

• Reduce manual contact entry from 15 minutes to 2 minutes per lead
• Automate up to 80% of contact updates from forms and calls
• Improve data accuracy by 50% with structured AI mapping
• Cut duplicate records by 60% using upsert with matching on name
• Connect OpenAI and Airtable in one flow with no code
• Handle hundreds of contact requests per day without extra staff

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Airtable and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In Airtable, create or choose a base and a Contacts table with fields named name, emailAddress, and phoneNumber. Use single line text for name and email, and phone number or text for phone.
4. In the n8n credentials manager, create an Airtable credential. Double click the Airtable nodes, choose 'Create new credential', and follow the on screen instructions. In your Airtable account, create a personal access token with read and write access to the target base, then paste it into n8n.
5. Open the Get Contacts node in n8n and select your Airtable credential, base, and table. Confirm the operation is set to search so the agent can look up existing records.
6. Open the Add or Update Contact node and select the same Airtable credential, base, and table. Set matching columns to name and confirm the field mapping for name, emailAddress, and phoneNumber.
7. In the n8n credentials manager, create an OpenAI credential. Double click the OpenAI Chat Model node, choose 'Create new credential', and follow the on screen instructions. Generate an API key in your OpenAI account and paste it into n8n.
8. Verify the OpenAI Chat Model node uses the gpt 4o model and is linked to the Contact Agent node as the language model. Leave the system message as provided or adjust text to fit your policy.
9. Create a small caller workflow to test. Add a Set node with a field named query and a sample value like Add John Doe john@example.com 5551234567. Add an Execute Workflow node to call this contact workflow and pass the Set node data.
10. Run the caller workflow. Check the execution output for the Response value and confirm a new or updated record appears in your Airtable table.
11. Troubleshoot as needed: confirm your Airtable token has base access, check field names match the mapping, adjust matching columns to include email if duplicates appear, and review any rate limit errors from OpenAI.