How to Connect n8n to Airtable: The Complete Integration Guide (2025)
Airtable is the spreadsheet-database hybrid that thousands of teams use to run their operations — CRMs, content calendars, inventory, project trackers. On its own, though, Airtable waits for you to type. Connect it to n8n and it starts filling itself: new leads land as records, statuses update automatically, and your team gets notified the moment something changes. This guide walks through the full n8n + Airtable integration, from authentication to production-ready automations.
What you can build with n8n + Airtable
Because Airtable behaves like a database with a friendly UI, it pairs naturally with almost any workflow. Common patterns include capturing form submissions as records, syncing Airtable with your CRM, sending Slack or email alerts when a field changes, enriching records with external APIs, and generating scheduled reports from a base. Anything you'd normally copy-paste into Airtable becomes a trigger or an action node.
Step 1 — Get your Airtable Personal Access Token
Airtable deprecated legacy API keys in favor of Personal Access Tokens (PATs). In your Airtable account, open the developer hub, create a new token, and grant it the scopes you need — typically data.records:read and data.records:write — plus access to the specific base you'll automate. Copy the token immediately; Airtable only shows it once.
Step 2 — Add the Airtable credential in n8n
In n8n, open Credentials → New → Airtable Personal Access Token API, paste the PAT, and save. n8n validates it on save, so a green check means you're connected. If you self-host n8n, no extra configuration is required — the node talks to Airtable's REST API directly over HTTPS.
Step 3 — Choose your trigger
Airtable doesn't push real-time webhooks to n8n for every change, so most automations use one of two trigger styles. The Airtable Trigger node polls a base on a schedule (say, every minute) and emits new or updated records. Alternatively, trigger the workflow from the source of the data — a Typeform webhook, a Stripe event, a form submission — and write to Airtable as an action. The second approach is instant and is what most production workflows use.
⚡ Skip the build — get the ready-made template
This template captures every Typeform submission straight into Airtable and alerts your team by email — a working example of everything below, ready to import.
Get "Typeform Response → Airtable Record + Team Email Alert" on Gumroad →
Step 4 — Create and update records
The Airtable node exposes the operations you'd expect: Create, Update, Upsert, Get, List, and Delete. Pick your base and table from the dropdowns, then map incoming fields to Airtable columns. Use Upsert with a matching column (like email) to avoid duplicate records — it updates an existing row if found, or creates one if not. This single setting eliminates the most common Airtable automation bug.
Step 5 — Handle Airtable's rate limits
Airtable caps the API at 5 requests per second per base. If you're processing a batch, add a Loop Over Items node with a small wait, or enable batching in the node options. n8n's built-in retry-on-fail also helps ride out the occasional 429 response without dropping data.
A real example: form to record to alert
The most requested Airtable automation is dead simple in n8n: a webhook receives a form submission, a Set node cleans the fields, an Airtable node upserts the record, and an email or Slack node notifies the owner. That four-node workflow replaces a manual copy-paste that teams do dozens of times a day — and it never forgets to send the alert.
Troubleshooting common issues
If records aren't appearing, check that your PAT has write scope and access to the specific base. If field mapping fails, remember Airtable field names are case-sensitive and must match exactly. And if your trigger fires twice, you're likely polling and also writing from the source — pick one path, not both.
Ready to automate? Get this template on Gumroad →
Import the JSON, plug in your credentials, and it runs in minutes.
