If you're an Airtable power user, you've hit the wall: Airtable's native automations are limited, Zapier gets expensive fast, and the built-in scripting doesn't talk to your other tools easily.
n8n changes that. It's a free, self-hostable automation platform that connects Airtable to anything — Slack, Gmail, Notion, Postgres, OpenAI, custom webhooks, REST APIs — with full conditional logic, loops, and branching. No per-task fees.
Here are 5 workflows that serious Airtable users actually need.
1. Auto-Sync Airtable Records to a Real Database
Airtable is great for prototyping but hits limits fast: 50K rows on free, no SQL joins, no triggers. When you outgrow it, you don't need to abandon your Airtable setup — just sync it.
What it does: Every hour, n8n reads all Airtable records modified in the last hour, upserts them into Postgres (or MySQL, SQLite, Supabase), and logs sync stats to a Google Sheet. Your Airtable stays as the friendly UI; the database becomes the source of truth for reports, analytics, and your engineering team.
Trigger: Schedule (hourly)
{
"name": "Airtable to Postgres Sync",
"nodes": [
{
"type": "n8n-nodes-base.scheduleTrigger",
"name": "Every Hour",
"parameters": { "rule": { "interval": [{ "field": "hours", "minutesInterval": 1 }] } }
},
{
"type": "n8n-nodes-base.airtable",
"name": "Get Modified Records",
"parameters": {
"operation": "list",
"filterByFormula": "IS_AFTER({Last Modified}, DATEADD(NOW(), -1, 'hours'))"
}
},
{
"type": "n8n-nodes-base.postgres",
"name": "Upsert to DB",
"parameters": {
"operation": "upsert",
"conflictTarget": "airtable_id"
}
},
{
"type": "n8n-nodes-base.googleSheets",
"name": "Log Sync Stats",
"parameters": { "operation": "append" }
}
]
}
Pro tip: Use Airtable's LAST_MODIFIED_TIME() formula field to track changes precisely. Set conflictTarget to your Airtable record ID so upserts are idempotent.
2. Airtable Record Created → Slack Alert + Personalized Email
The classic Airtable automation "send email on record creation" is basic. You want routing, enrichment, and multi-channel notification.
What it does: When a new record is created in your CRM base (new lead, new project, new ticket), n8n (1) posts a formatted Slack message with all key fields, (2) classifies the record using OpenAI (e.g., lead score, sentiment, priority), (3) updates the Airtable record with the AI classification, and (4) sends the contact a personalized welcome email.
Trigger: Airtable trigger (polling every minute)
{
"name": "New Airtable Record → Slack + AI + Email",
"nodes": [
{
"type": "n8n-nodes-base.airtableTrigger",
"name": "New Record",
"parameters": { "event": "create", "pollTimes": { "item": [{ "mode": "everyMinute" }] } }
},
{
"type": "n8n-nodes-base.slack",
"name": "Notify Team",
"parameters": { "text": "New record: *{{ $json.Name }}* — {{ $json.Status }}" }
},
{
"type": "@n8n/n8n-nodes-langchain.openAi",
"name": "Classify Record",
"parameters": { "prompt": "Score this lead 1-10 and return JSON: { score, reasoning, next_action }. Lead: {{ $json }}" }
},
{
"type": "n8n-nodes-base.airtable",
"name": "Update Record with Score",
"parameters": { "operation": "update" }
},
{
"type": "n8n-nodes-base.gmail",
"name": "Send Personalized Email"
}
]
}
3. Daily Airtable Status Report → Email Digest
Your Airtable base has projects, tasks, or tickets. You want a daily digest without opening 6 different views.
What it does: Every morning at 8 AM, n8n queries your Airtable base for records matching specific statuses (overdue, due today, in review, blocked), groups them by owner or category using a Code node, builds an HTML email with a clean summary table, and sends it to the whole team. One email replaces 15 minutes of manual checking.
Trigger: Schedule (daily 8AM)
{
"name": "Daily Airtable Digest",
"nodes": [
{
"type": "n8n-nodes-base.scheduleTrigger",
"name": "Daily 8AM",
"parameters": { "rule": { "interval": [{ "field": "cronExpression", "expression": "0 8 * * *" }] } }
},
{
"type": "n8n-nodes-base.airtable",
"name": "Get Overdue Items",
"parameters": { "operation": "list", "filterByFormula": "AND(IS_BEFORE({Due Date}, TODAY()), {Status} != 'Done')" }
},
{
"type": "n8n-nodes-base.airtable",
"name": "Get Due Today",
"parameters": { "operation": "list", "filterByFormula": "IS_SAME({Due Date}, TODAY(), 'day')" }
},
{
"type": "n8n-nodes-base.code",
"name": "Build HTML Digest",
"parameters": { "jsCode": "// Merge overdue + due today, build HTML table rows\nconst overdue = $('Get Overdue Items').all();\nconst today = $('Get Due Today').all();\nconst html = `<h2>Overdue (${overdue.length})</h2>` + overdue.map(i => `<li>${i.json.Name}</li>`).join('');\nreturn [{ json: { html } }];" }
},
{
"type": "n8n-nodes-base.gmail",
"name": "Send Digest",
"parameters": { "subject": "Daily Airtable Digest — {{ $now.toFormat('MMM d') }}" }
}
]
}
4. Airtable Form Submission → Multi-Step Onboarding
Airtable forms are great for capturing data. But native form automations are limited: no branching, no waiting, no multi-step sequences.
What it does: When someone submits your Airtable form (contact request, project intake, onboarding survey), n8n triggers a full multi-step onboarding: immediate confirmation email, creates a Notion page for the project, creates a Google Drive folder, sends a Slack notification, and schedules a follow-up email 3 days later via a Wait node.
Trigger: Airtable trigger (new record in form submissions table)
{
"name": "Form → Full Onboarding",
"nodes": [
{ "type": "n8n-nodes-base.airtableTrigger", "name": "New Form Submission" },
{ "type": "n8n-nodes-base.gmail", "name": "Confirmation Email" },
{ "type": "n8n-nodes-base.notion", "name": "Create Project Page" },
{ "type": "n8n-nodes-base.googleDrive", "name": "Create Drive Folder" },
{ "type": "n8n-nodes-base.slack", "name": "Notify Team" },
{ "type": "n8n-nodes-base.wait", "name": "Wait 3 Days", "parameters": { "amount": 3, "unit": "days" } },
{ "type": "n8n-nodes-base.gmail", "name": "Day 3 Follow-Up Email" }
]
}
Pro tip: Use the Airtable Update Record node after each step to write status back (e.g., Notion page: [URL], Drive folder: [URL]). Your Airtable base becomes a live dashboard of every onboarding step.
5. Bi-Directional Airtable ↔ Notion Sync
Teams split between Airtable (operations) and Notion (documentation/wikis) constantly re-enter data. Stop.
What it does: n8n runs every 15 minutes. Records created or updated in Airtable get synced to a Notion database (matching fields by name). Changes in Notion (status updates, comments) get pushed back to Airtable. A Code node handles field type mapping (Airtable multi-select → Notion multi-select, dates, URLs). Conflicts are resolved by last-modified timestamp.
Trigger: Schedule (every 15 minutes)
{
"name": "Airtable <-> Notion Sync",
"nodes": [
{
"type": "n8n-nodes-base.scheduleTrigger",
"name": "Every 15 Min",
"parameters": { "rule": { "interval": [{ "field": "minutes", "minutesInterval": 15 }] } }
},
{
"type": "n8n-nodes-base.airtable",
"name": "Get Airtable Changes",
"parameters": { "operation": "list", "filterByFormula": "IS_AFTER(LAST_MODIFIED_TIME(), DATEADD(NOW(), -15, 'minutes'))" }
},
{
"type": "n8n-nodes-base.code",
"name": "Map Fields",
"parameters": { "jsCode": "// Convert Airtable field format to Notion properties\nreturn items.map(item => ({\n json: {\n title: item.json.Name,\n status: item.json.Status,\n airtable_id: item.json.id\n }\n}));" }
},
{
"type": "n8n-nodes-base.notion",
"name": "Upsert Notion Page",
"parameters": { "operation": "update" }
},
{
"type": "n8n-nodes-base.notion",
"name": "Get Notion Changes",
"parameters": { "operation": "getAll", "filter": { "timestamp": "last_edited_time", "last_edited_time": { "past_minute": {} } } }
},
{
"type": "n8n-nodes-base.airtable",
"name": "Update Airtable",
"parameters": { "operation": "update" }
}
]
}
Get the Complete Template Pack
All 5 workflows above — plus 8 more — are available as ready-to-import .json files in the FlowKit n8n template pack.
Browse and download: https://stripeai.gumroad.com
Each template is fully documented with setup instructions, required credentials, and customization notes. Import, configure your credentials, and run.
Using any of these in your stack? Let me know in the comments what you're connecting Airtable to — I'm always looking for the next workflow to add.
Top comments (0)