n8n Airtable Integration: Sync Bases, Automate Records, and Build No-Code Workflows (2026)

Airtable combines the flexibility of a spreadsheet with the power of a database. When you connect it to n8n, you can automate data entry, sync records with other tools, and trigger workflows whenever a base changes.

n8n is an open-source workflow automation tool that connects APIs, databases, and services into visual pipelines.

If you want to build Airtable workflows faster, Synta is an MCP server for n8n that gives your AI assistant operational access to inspect, edit, validate, and test nodes directly inside your n8n instance.

What is Airtable and why use it with n8n?

Airtable is a no-code database used for project management, content calendars, CRMs, and inventory tracking. Teams love it for its grid views, forms, and automations, but those native automations are limited to Airtable's own ecosystem.

n8n breaks that boundary. You can:
- Create Airtable records from form submissions, emails, or webhooks.
- Sync Airtable rows to Google Sheets, Postgres, or Supabase.
- Trigger Slack alerts when a record status changes.
- Build approval workflows that read from and write back to Airtable.

How do I connect Airtable to n8n?

You need an Airtable personal access token.

Go to your Airtable developer hub and create a new token. Grant it the scopes your workflow needs: `data.records:read`, `data.records:write`, and `schema.bases:read`.

In n8n, open the Airtable node credentials and paste your token. Select your base and table from the dropdown. If the dropdown does not populate, verify that your token has the correct scopes and that the base is shared with your account.

How do I search and read records from Airtable?

Use the List operation to pull records. You can filter with a formula string that follows Airtable's formula syntax.

For example, to find all records where the Status field equals "In Progress":

{Status} = 'In Progress'

Set the Limit parameter to control how many records you fetch per execution. If your base has more records than the limit, enable pagination and loop through offsets using the Return All option or a recursive workflow pattern.

How do I create and update records in Airtable?

Use the Create operation to insert new rows. Map each n8n field to an Airtable column name. Column names must match exactly, including spaces.

For example, if your incoming webhook sends a lead with name and email:

Map `name` to the Airtable Name column and `email` to the Email column.

Use the Update operation when you have a record ID. You can obtain the ID from a previous List or Search step. Pass the ID and the fields you want to change. Unlisted fields remain untouched.

How do I handle linked records and attachments?

Linked records require the internal record ID of the linked row, not the display name. If you only have the display name, run a lookup step first to resolve the ID.

Attachments expect an array of objects with a `url` property. If you are uploading files from a previous node, make sure the URL is publicly accessible. Airtable will fetch and store the file during creation.

What are common Airtable rate limits and how do I avoid them?

Airtable enforces approximately 5 requests per second per base. If you exceed this, you will receive a 429 error and the node will fail.

Strategies to stay under the limit:
- Use the Split In Batches node to process records in chunks with a delay.
- Add a Wait node between batches.
- Cache lookup results so you do not query the same reference data repeatedly.
- For large sync jobs, consider Airtable's sync API or webhooks instead of polling.

Real-world Airtable automation examples

Lead capture to CRM
A Typeform submission triggers an n8n workflow that creates a lead record in Airtable, enriches it with Clearbit, and assigns a sales rep based on region.

Content calendar sync
When a Notion page moves to "Ready to Publish," n8n copies the title, author, and due date into an Airtable content calendar and notifies the team in Slack.

Inventory alerts
An hourly workflow lists low-stock items in Airtable and sends a reorder email to suppliers when the count drops below a threshold.

FAQ

Do I need a paid Airtable plan to use the n8n integration?
No. The personal access token works on free plans. Paid plans unlock higher rate limits and more permissions, which help for large workflows.

Why does my Airtable node say "Invalid request"?
Check that your column names match exactly, including spaces and capitalization. Also verify that your token has `data.records:write` scope if you are creating or updating records.

Can I trigger workflows when an Airtable record changes?
Airtable webhooks are available on some plans. Alternatively, poll the base on a schedule using the n8n Schedule Trigger and compare timestamps or use a last-modified field to detect changes.

How do I delete records from Airtable in n8n?
Use the Delete operation and pass the record ID. There is no bulk delete via a single call, so loop through IDs or use the Split In Batches node.

Can Synta help me build Airtable workflows faster?
Yes. Synta is an MCP server for n8n. It gives your AI assistant operational access to inspect node inputs, suggest field mappings, and validate Airtable outputs directly inside your n8n instance.