Airtable
Airtable is a flexible database-spreadsheet hybrid that's ideal as a no-code data store for n8n automations — CRMs, content calendars, and trackers.
Some links on n8n.school are affiliate links. If you sign up or purchase through them, we may earn a commission at no extra cost to you. We only recommend tools we genuinely believe help you automate better.
Best use case with n8n
Using a friendly, visual database as the backbone of your n8n automations — lightweight CRMs, content calendars, and trackers your whole team can read and edit.
Airtable is a favorite data store for n8n users who want something more structured than a spreadsheet but friendlier than a SQL database. It's the "single source of truth" behind countless automations — CRMs, content calendars, order trackers, and more.
Why Airtable pairs so well with n8n
n8n needs somewhere to read from and write to, and Airtable's clean UI means non-technical teammates can manage that data without touching the automation. You build the workflow once; your team lives in the Airtable base.
Common pattern
A webhook captures a lead → n8n creates an Airtable record → a teammate works the lead in a Kanban view → a status change triggers the next n8n workflow.
Key n8n nodes & operations
The Airtable node supports the operations you'll reach for most:
- Create — append new records (leads, orders, content ideas).
- Update / Upsert — keep records in sync without duplicates.
- Search — find records by formula (e.g.
Status = "New"). - List — pull records for reporting or batch processing.
- Get / Delete — fetch or remove a single record by ID.
- Trigger — start a workflow when records are created or updated.
Pricing, at a glance
| Plan | Cost | Records / base | Best for |
|---|---|---|---|
| Free | $0 | 1,000 | Testing & small automations |
| Team | ~$20/user/mo | 50,000 | Growing teams & CRMs |
| Business | ~$45/user/mo | 125,000 | Agencies & higher volume |
Watch the rate limit
Airtable caps the API at 5 requests per second per base. For bulk n8n workflows, batch your operations or add a small wait to avoid 429 errors.
Airtable vs the alternatives
- Choose Airtable for the friendliest UI and team collaboration.
- Choose Supabase when you need a real Postgres database, scale, or vector search for AI.
- Choose Google Sheets for the cheapest, simplest option.
Use Airtable as your automation database
Start free and connect it to n8n in minutes.
Affiliate link — we may earn a commission at no extra cost to you.
Tips for using Airtable with n8n
- Use Upsert to avoid duplicate records when re-running workflows.
- Store the Airtable record ID in downstream tools so you can update later.
- Filter with formulas in the Search node instead of pulling everything.
- Keep field names stable — renaming fields can break expressions.
Key features
- Spreadsheet-like UI with relational database power
- Rich field types: attachments, links, formulas, rollups
- Grid, Kanban, Calendar, Gallery & Form views
- Native n8n trigger + action nodes
- REST API with per-base documentation
- Automations, interfaces, and sync across bases
Pros & cons
Pros
- Extremely approachable for non-technical teammates
- Best-in-class UI for managing automation data
- Flexible field types and multiple views
- First-class n8n integration (trigger and CRUD)
Cons
- Record limits and per-seat pricing get costly at scale
- Not a true SQL database — limited for heavy querying
- API rate limit of 5 requests/sec per base
Related articles
Alternatives
Supabase is an open-source Postgres backend with auth, storage, and vector search — a powerful database layer for n8n and AI workflows.
Pricing: Free tier (2 projects, 500MB DB); Pro ~$25/mo per project; usage-based above limits
Google Sheets is a free, familiar spreadsheet that works great as a simple data source and destination for n8n workflows.
Pricing: Free with a Google account; Workspace plans for business
Notion is an all-in-one workspace and flexible database that pairs with n8n to automate docs, wikis, CRMs, and content pipelines.
Pricing: Free for personal use; Plus ~$10/user/mo; Business ~$15–18/user/mo