N8N Airtable Integration: Step-by-Step Tutorial (2026)

Airtable is where a lot of small businesses store their most important data: client records, project trackers, inventory lists, lead pipelines. N8N is where that data gets put to work. Together, they form one of the cleanest automation stacks available to SMBs today.

This tutorial shows you exactly how to set up the N8N Airtable integration, authenticate securely with a Personal Access Token, and build real workflows that read, create, update, and delete records automatically. If you are already comfortable with building basic N8N workflows, this guide will feel natural. If you are newer to N8N, start there first.

Why Connect N8N to Airtable?

Airtable is a powerful database, but it does not act on its own data. Records sit still until someone manually touches them. That is the gap N8N fills.

When you connect the two, you can:

• Automatically add form submissions to Airtable without a Zapier middleman
• Send Slack alerts when a record reaches a specific status
• Sync Airtable data to Google Sheets for weekly reporting
• Route new Airtable leads directly into HubSpot or your CRM
• Generate and email invoices from Airtable project records

The ROI shows up fast. Clients at our N8N automation practice typically recover 4 to 8 hours per week within the first month of connecting Airtable to their other tools.

What You Need Before You Start

• An N8N instance (cloud or self-hosted). See Build Your First N8N Workflow if you need setup help.
• An Airtable account (free tier works fine for this tutorial)
• An Airtable base with at least one table and a few records

You do not need any developer experience. The N8N Airtable node handles the API calls for you.

Step 1: Generate an Airtable Personal Access Token

Airtable no longer uses API keys for new integrations. You need a Personal Access Token (PAT).

1. Log in to Airtable and go to airtable.com/create/tokens
2. Click Create token
3. Give it a name (e.g., "N8N Integration")
4. Under Scopes, add the following:
   • data.records:read
   • data.records:write
   • schema.bases:read
5. Under Access, choose which bases this token can access. Select the base you want to automate, or choose "All bases" if you plan to use multiple.
6. Click Create token and copy it immediately. Airtable only shows it once.

Store this token somewhere secure. You will paste it into N8N in the next step.

Step 2: Add Airtable Credentials to N8N

1. Open your N8N instance and go to Settings > Credentials
2. Click Add Credential and search for "Airtable"
3. Select Airtable Personal Access Token API
4. Paste your token into the Access Token field
5. Click Save and then Test Connection to verify it works

Once the connection test passes, your credentials are ready. Every Airtable node in N8N can now use this credential.

Step 3: Understand the N8N Airtable Node Operations

The N8N Airtable node supports five core operations. Here is when to use each one:

Most workflows combine at least two of these. For example: List records in status "New Lead," then Update each one to "Contacted" after sending an email.

Step 4: Build Your First N8N Airtable Workflow

Let's walk through a concrete example: automatically log new webhook submissions to Airtable.

If you haven't already learned how N8N handles webhooks, read the N8N webhook tutorial first. This workflow assumes you have a Typeform or similar form sending data to an N8N webhook.

Workflow: Log Form Submissions to Airtable

1. Add a Webhook trigger node. Set method to POST and copy the webhook URL.
2. Add an Airtable node. Select your credential, choose Create operation.
3. In the Airtable node, select your Base and Table from the dropdowns.
4. Map the incoming webhook fields to your Airtable columns:
   • Name: {{ $json.name }}
   • Email: {{ $json.email }}
   • Message: {{ $json.message }}
   • Submitted At: {{ $now }}
5. Click Execute Node to test with a sample submission.
6. Activate the workflow.

Every form submission now lands in Airtable automatically. No manual copy-paste, no missed leads.

Step 5: Read and Filter Airtable Records

The List operation is powerful when combined with N8N's filtering and branching tools.

How to Filter Records in the Airtable Node

When using the List operation, you can apply an Airtable filter formula in the Filter by Formula field. This is standard Airtable formula syntax:

• Status = "Open" — returns only records where Status is Open
• AND(Status = "Active", DATEIFF(TODAY(), {Last Contact}, 'days') > 7) — records active and not contacted in 7 days
• NOT({Email} = "") — records where Email is not blank

Filtering at the Airtable level keeps your workflow efficient. You only pull records you actually need to process, which means fewer nodes and faster execution.

Sorting and Limiting Records

The List node also supports sorting (by any field, ascending or descending) and record limits. If you are processing records in batches, set a limit of 50 or 100 and use N8N's pagination options to loop through larger datasets.

Step 6: Update Records Automatically

Updating records is where N8N-Airtable automations really earn their keep. The key detail: you must pass the Airtable Record ID to update the right row.

When you use a List or Read node earlier in your workflow, each record includes an id field. That is the Record ID. In your Update node, set the ID field to {{ $json.id }} from the previous node's output.

Example: Update Lead Status After Sending Email

1. List node: pull records where Status = "New Lead"
2. Gmail node: send a personalized outreach email using the record's Name and Email fields
3. Airtable Update node: set Status to "Contacted" and Last Contact to {{ $now }}

This three-node sequence replaces what used to be an hour of manual CRM updates every morning.

Five Real Business Workflows Using N8N and Airtable

Here are automation patterns we have built for clients. Each one saves meaningful hours per week.

1. New Customer Onboarding Tracker

Trigger: form submission when a new client signs up. N8N creates an Airtable record with their details, sends a welcome email, and creates a task in their project management tool. The Airtable record becomes the single source of truth for onboarding status.

2. Invoice Generation from Project Records

Trigger: schedule (runs every Monday morning). N8N lists all Airtable records where Project Status = "Completed" and Invoice Sent = empty. For each record, it generates a PDF invoice, emails it to the client, and updates the Airtable record with the invoice date.

3. Lead Routing from Airtable to CRM

Trigger: schedule (runs every 15 minutes). N8N lists Airtable records where Lead Source = "Website" and CRM Synced = false. For each record, it creates a contact in HubSpot and updates the Airtable record to mark CRM Synced = true. No double data entry, no missed leads.

4. Weekly Status Report from Airtable to Slack

Trigger: schedule (every Friday at 4 PM). N8N pulls all Airtable project records, groups them by status, and posts a formatted summary to a Slack channel. Leadership gets visibility without anyone manually pulling data.

5. Inventory Alert System

Trigger: schedule (runs every morning). N8N reads Airtable inventory records and checks the Quantity field. For any item where Quantity falls below the Reorder Threshold, it sends an email alert and creates a purchase order draft. The team reorders before stock runs out.

Common Issues and How to Fix Them

Error: "Authentication failed"

Your Personal Access Token may have expired or lacks the required scopes. Generate a new token and ensure you have included data.records:read, data.records:write, and schema.bases:read. Re-enter it in N8N's credential settings.

Error: "Table not found"

The table name in your N8N node must match the Airtable table name exactly, including capitalization. Do not use the table ID format unless N8N specifically asks for it.

Records not updating

Check that you are passing the correct Record ID. Use an N8N Set node to explicitly extract {{ $json.id }} from your List/Read output before passing it to the Update node.

Hitting Airtable's API rate limits

Airtable's free plan allows 5 requests per second. If your workflow processes many records at once, add a Wait node between batches (set to 200ms). On paid Airtable plans, the limit increases significantly.

N8N vs Zapier for Airtable Integrations

Both tools connect to Airtable. Here is how they compare for this specific use case:

For teams who need full control over their Airtable data and complex multi-step logic, N8N wins clearly. See our detailed N8N vs Zapier vs Make comparison for a deeper breakdown.

What to Build Next

Once you have the basic N8N-Airtable connection working, the natural next steps are:

• Bidirectional sync: Use scheduled polling in N8N to detect Airtable changes and push them to your CRM or vice versa
• AI enrichment: Send Airtable records through an OpenAI node to generate summaries, classify leads, or draft responses
• Google Sheets sync: Mirror your Airtable data into Google Sheets for stakeholders who prefer spreadsheets (see our N8N Google Sheets integration guide)

If you want to understand what these workflows could save your business specifically, try the ROI calculator. Most SMBs see a payback period under 60 days.

Not sure if your current processes are worth automating? The AI readiness assessment takes five minutes and gives you a clear answer.

Ready to Get Started?

Book a free 30-minute discovery call. We'll identify your biggest opportunities and show you exactly what AI automation can do for your business.

Book a Free Discovery Call

Suyash Raj Founder of rajsuyash.com, an AI automation agency helping SMBs save time and scale with AI agents, N8N workflows, and voice automation.