Resources · Zapier integration

Airtable Zapier integrationAutomate Airtable with Zapier.

The Airtable Zapier integration gives you 2 triggers, 10 actions and 8 searches. Enough to fill a base from your other tools, keep records in sync and look things up before writing. Here is what each one does, what it costs and where it breaks.

See the 20 operations

Verified Trustpilot reviews · AI, automation & growth agency

Overview

What the Airtable Zapier integration actually does

It links your Airtable bases to the other apps you use, without code. Zapier watches a table for new or changed records, then writes, updates or looks up records for you. Everything runs on a schedule set by your plan, because none of the Airtable triggers is instant.

Three results people usually build first. A lead that lands in a form becomes a row in your CRM table through Create Record, with no copy and paste. A status changed by a teammate reaches the rest of the team, because New or Updated Record picks up the edit. And a clean-up Zap keeps two tables aligned: Find Record spots the matching row, Update Record fixes it.

What Zapier does not do here is just as useful to know. There is no trigger for a deleted record, so a Zap can never react to a row disappearing. Batch actions stop at 10 records per run, which rules out mass edits on large tables in one go. And no Airtable trigger is instant: on the free plan a new row can wait up to 15 minutes before anything happens. If you need a different trade-off, the same base is covered on the Airtable n8n integration and the Airtable Make integration pages. Read them side by side before you commit to one tool.

Vocabulary

Zapier vocabulary in one minute

Seven words come back on every line of this page. Here they are once, in plain English.

Zap
The automation you build: one trigger, then one or more actions that run every time that trigger event happens.
Trigger
The event that starts the Zap, such as a new record in a table. Once the Zap is on, Zapier waits for it.
Action
What the Zap does after it starts: the step that creates, updates or deletes something on your behalf.
Task
The unit Zapier bills: one action that completes successfully. Your plan allowance is a count of these.
Polling or instant
Polling means Zapier checks the app on a timer for new items. Instant means the app calls Zapier itself. Airtable only polls.
Filter
A step that lets the Zap continue only when the incoming data meets your condition, and stops it quietly otherwise.
Search step
A step that looks up a record that already exists, so the next steps can reuse what it found instead of guessing.
Cost

What an Airtable Zap really costs

Airtable is not a premium app, so it runs on the free plan. The catch is elsewhere.

  • Free plan100 tasks a month, unlimited Zaps
  • Free plan stepsOne trigger and one action
  • Trigger and checksNever billed
  • Failed actionNot counted

The trigger costs nothing, and neither does each check Zapier makes on your table. You pay one task per action that succeeds; an action that fails is not counted. A three-action Zap therefore burns three times what a one-action Zap does. The free plan stops at two steps, one trigger and one action. Add a filter or a search like Find Record and the Zap becomes multi-step, which needs a paid plan, even if it only adds one search.

Connect

Connect your Airtable account to Zapier

  1. 01

    Open the Apps page

    In your Zapier account, go to Apps and click + Add connection. A connection is your Airtable account linked once, then reused by every Zap that touches it.

  2. 02

    Find Airtable and confirm

    Type Airtable in the search box of the dialog that opens, pick it from the results, then click Add connection. A new tab opens on the Airtable sign-in screen.

  3. 03

    Sign in and grant access

    Log in to Airtable and allow Zapier to reach your account. Check that you have read or write rights on every base you did not create yourself, or the Zap will not see it.

First Zap

Your first Zap: flag urgent requests and link them

GoalEach new request added to a table is matched to its client record, and the client record is updated.

  1. 01

    Create the Zap, set New Record

    Start a new Zap, choose Airtable as the app, then New Record as the event. Select your connection, the base and the requests table.

  2. 02

    Test the trigger on a real row

    Run the test: Zapier brings back the three most recent records of the table. Pick one with a filled client name so the next steps have real values to map.

  3. 03

    Look up the client, then update it

    Add Find Record on the clients table, searching by the client name from the request. Then add Update Record and map the record it found into the Record field.

  4. 04

    Test each step and publish

    Test the search and the update one by one, read what came back, then click Publish. This Zap has three steps, so it needs a paid plan.

Triggers

Airtable triggers on Zapier

2 events start a Zap when something happens in Airtable. Zapier checks for them at the interval your plan allows.

1

New Record

Polling trigger

In Zapier“Triggers when a new record is created or new or existing records when first added to a selected view.”

Starts your Zap when a row appears in the table you choose, or when a record first shows up in a selected view. That second case is handy: build a view that only shows qualified leads, and the Zap fires when a lead enters it.

How it fires
Zapier goes and looks at regular intervals, and how often depends on your plan: every 15 minutes on the free one.
When to use it
a form, an import or a teammate adds rows and you want each new one copied, announced or enriched elsewhere.
Watch out
Airtable file links can expire; turn on the option that returns the file content, keeping in mind that files above 100MB end in an error.
2

New or Updated Record

Polling trigger

In Zapier“Triggers when a record is created or updated.”

Reacts to any record that is created or edited in the table. Zapier compares a date column against what it saw last time, so a change to a status, an owner or an amount is enough to set it off.

How it fires
Zapier goes and looks at regular intervals, and how often depends on your plan: every 15 minutes on the free one.
When to use it
a deal moves to Won or a task changes owner, and another app has to hear about it.
Watch out
by default Airtable drops empty fields from what it sends, so a cleared field looks missing rather than blank unless you switch on the option that includes empty fields.
Actions

Airtable actions on Zapier

Airtable gives you 10 actions. For each one: what it does for you, when to reach for it, and what to watch out for.

1

Add Comment to Record

Action

In Zapier“Add a comment to an existing record in Airtable.”

Posts a comment on an existing record. You pick the base, the table and the record, from the list or by its record ID, then write the comment text, which can mix fixed words and values from earlier steps.

When to use it
you want a trace of what happened elsewhere, like a reply from a client, without touching the record's fields.
2

Create Record

Action

In Zapier“Creates a new record with auto-populating fields.”

Adds one row to a table, and the editor loads that table's columns so you map each value to the right field.

When to use it
every new form entry, order or sign-up should land as a row without anyone retyping it.
3

Create Records (Advanced)

Action

In Zapier“Create up to 10 new records (supports line items).”

Writes several rows in a single step, built from line items, for example the products of one order.

When to use it
one incoming event carries a list and each item deserves its own row.
Watch out
the step stops at 10 records per run.
4

Create Base

Action

In Zapier“Create a new Airtable base in your workspace.”

Spins up a whole new base in one of your Airtable workspaces, with the number of tables you ask for.

When to use it
onboarding a client means handing them their own base from day one.
Watch out
it needs the workspace ID, which you read in the workspace URL or its settings.
5

Create or Update Record

Action

In Zapier“Find and update an existing record, or create a new one.”

Looks for a matching row through a column you name as the lookup field, edits it if it exists and creates it if not.

When to use it
a contact can come back twice and you refuse duplicates.
Watch out
the lookup value must match the stored value exactly, or a second row appears.
6

Create Table

Action

In Zapier“Create a new table in an existing Airtable base.”

Adds a fresh table, under the name you give it, inside a base that already exists. The base stays as it was; only the new table appears next to the others.

When to use it
each new project or client gets its own tracking table in a shared base, created the moment the project is signed in your other tool.
7

Delete Record

Action

In Zapier“Delete a record in a table.”

Removes one row from a table, chosen from the list or by its record ID.

When to use it
an unsubscribe or a cancelled order elsewhere should clear the matching row so nobody follows it up.
Watch out
pair it with a search step so the Zap deletes the right record, not the first one that looks close.
8

Update Record

Action

In Zapier“Update a record in a specific table.”

Changes the fields of one existing row, picked from the list or passed as a record ID from an earlier step.

When to use it
a payment clears in another tool and the matching invoice row should flip to Paid.
Watch out
attachments get replaced unless you turn on the option that appends them.
9

Update Multiple Records

Action

In Zapier“Update up to 10 records at once in a specific table.”

Edits a batch of rows in one table in a single step, once you say how many records it should handle.

When to use it
a status change on a project must ripple to all its tasks at once.
Watch out
the ceiling is 10 records per run, so bigger batches need another approach.
10

API Request (Beta)

Action

In Zapier“This is an advanced action which makes a raw HTTP request that includes this integration's authentication.”

Sends a raw request to Airtable using the connection you already set up, for cases the ready-made actions do not cover.

When to use it
you know the Airtable API and need a call none of the other actions makes.
Watch out
it only reaches Airtable's own addresses, and the Stop on error setting decides whether a failed call halts the Zap.
Searches

Airtable searches on Zapier

8 search steps look for data that already exists in Airtable, so a later step can use it.

Searches sit at the bottom of the event list, under SEARCH. They fetch something that already exists so the next step can use it. Three settings decide what happens when the result is not what you expected.

1

Find Record

SearchFind or create

In Zapier“Find a record in a table.”

Searches a table for a row whose fields hold a value, either containing it anywhere or matching it exactly.

When to use it
you have an email or a name and need the record behind it before updating anything.
Watch out
the editor also shows Find or Create Record; it is this same search with the create box ticked, not a separate step.
2

Find Record by ID

Search

In Zapier“Find a specific record using its unique ID.”

Pulls one record straight from its unique ID, the code that starts with rec, and returns all of its current values. No guessing on names or near matches.

When to use it
an earlier step or another app already stored the ID, and you want the record as it looks right now before deciding what to do next.
3

Find Table

Search

In Zapier“Find tables by searching for a keyword in table name or description.”

Lists tables of a base whose name or description contains your keyword, without caring about upper or lower case.

When to use it
your bases follow a naming pattern and the Zap must pick the right table on the fly.
4

Find Table by ID

Search

In Zapier“Find a specific table using its unique ID.”

Returns a single table from its ID, the code that begins with tbl.

When to use it
you saved table IDs somewhere else and need to confirm the table is still there before a later step writes to it, so the Zap fails early instead of halfway.
5

Find Base

Search

In Zapier“Find bases by searching for a keyword in the base name. Only works with 5000 or fewer bases in the account.”

Looks through your bases for a name containing a keyword, case ignored.

When to use it
one base per client, and the Zap must reach the right one from the client name.
Watch out
it only works on accounts with 5000 bases or fewer.
6

Find Base by ID

Search

In Zapier“Find a specific Airtable base by its ID.”

Fetches a base from its ID, the code that starts with app, without searching through names at all.

When to use it
a Zap built with Create Base stored the new base ID in a table, and a later Zap needs to reach that same base again to add tables or records to it.
7

Get All Records

Search

In Zapier“List all records from a table with pagination support.”

Pulls every row of a table, page after page, and hands the whole set to the following steps instead of a single match.

When to use it
a report, a summary sent to a manager or an export to another tool needs the full table, not just the one row that fits a search.
8

Get Base Schema

Search

In Zapier“Retrieve the complete schema for a base, including all tables and their field definitions.”

Returns the structure of a base: the list of its tables and the definition of each field.

When to use it
you document a base for a new teammate, or a later step needs to know which columns exist before it tries to write into them and fails on a missing one.

The three settings every search exposes

  1. Successful if no search results are found?
    Left as it is, a search that comes back empty stops the Zap and skips the steps that relied on it. Switch it on and the Zap carries on with nothing.
  2. Create X if it doesn't exist yet?
    Ticking it turns the search into a find-or-create: the setting above disappears and the step asks for the fields it needs to create the missing item.
  3. If multiple search results are found?
    Three options when several items match: keep the first one (the default), stop the Zap, or pass all of them on.
When it breaks

When an Airtable Zap breaks

Most failures come from a search that finds nothing, an error message Zapier documents for Airtable, or a Zap that feeds itself.

Zapier keeps a list of help articles tied to Airtable, and their titles alone tell you where people get stuck. Below, each case in a sentence. For a broken Zap that you cannot read, the Zapier troubleshooting page goes step by step.

  • Nothing can be found for the search

    Find Record came back empty and the Zap stopped there. Check the search value and the search type, or switch on the setting that lets the Zap continue.

  • Search by field and value, or a formula

    This error means the search step is missing what to look for: either a field plus a value, or a formula. Fill one of the two.

  • API billing plan limit exceeded

    Zapier lists this exact message among its Airtable errors and gives it a help article of its own. If you see it, read that article before you touch the Zap.

  • Old connections and the move to OAuth

    Zapier keeps an article on the move of Airtable connections from API keys to OAuth. If your connection is an old one, start there.

  • No catch-up on old records

    A Zap only sees what happens after it is published. Rows that existed before are ignored, and moving them is a separate job.

  • A Zap that triggers itself

    Updating records in the table that New or Updated Record watches sets the Zap off again, over and over, and eats your tasks fast.
Need help

Need help automating Airtable with Zapier?

A person reads every message.

FAQ

Airtable and Zapier: common questions

01Is the Airtable Zapier integration free?
Yes, as long as your Zap stays at two steps. Airtable is not a premium app, so the free plan accepts it, with 100 tasks a month and unlimited Zaps. The limit people miss is the step count: the free plan builds one trigger followed by one action and nothing else. The moment you add a filter, a second action or a search such as Find Record, the Zap turns multi-step and needs a paid plan. For simple row copying from a form, free is enough. For anything that looks a record up first, plan on paying.
02How many tasks does an Airtable Zap use?
One per action that succeeds, and nothing for the trigger. Zapier never bills the checks it makes on your table, however often it runs them. A Zap that watches for new records and then creates a row elsewhere uses one task per new record. Add an update and a comment after that, and each new record costs three tasks. A failed action is not counted. A few actions on some apps take more than one task, so watch the task history during the first days to see the real figure for your Zap.
03Is the Airtable integration real-time?
No. Both Airtable triggers, New Record and New or Updated Record, work by polling: Zapier asks Airtable for changes at a set interval. On the free plan that interval is 15 minutes, on Professional it is 2 minutes, and on Team and Enterprise it is 1 minute. Paid plans can also run a check by hand from the editor. There is no setting that makes an Airtable trigger instant, because the type comes from the app itself. If a delay of a few minutes breaks your process, that matters more than any other detail on this page.
04What does it take to connect Airtable to Zapier?
An Airtable account and access rights on the bases you want to automate. The connection runs from the Apps page of Zapier: add a connection, pick Airtable, sign in and allow access. If a base belongs to someone else, ask for read or write rights first, or the Zap will not list it. Some steps also expect things inside Airtable: New or Updated Record needs a last modified time column in the table, and Create Base needs your workspace ID, which you read in the workspace URL.
05Why do Airtable attachment links stop working in a Zap?
Because Airtable file links can expire after a while, so a link passed to another app may die later. Both triggers offer an option that returns the file content itself, in an extra file field, rather than just the link. Switch it on when the next step needs to store or send the file. One limit applies: a file above 100MB returns an error instead of its content. For Update Record and Create or Update Record, a separate option adds new files to the existing ones instead of replacing them.
06What if the Airtable operation you need is not on the list?
Then API Request (Beta) is the way out. It sends a raw request to Airtable using the connection you already made, so there is no extra sign-in. It is an advanced step meant for people who know the Airtable API: you choose the method and the address, and it only accepts Airtable's own addresses. Its Stop on error setting decides whether a failed call halts the Zap. Before going there, check the searches: Get All Records and Get Base Schema cover many cases that look missing at first.
07Zapier, Make or n8n for Airtable?
It depends on your criteria, not on a winner. Zapier suits a team that wants the shortest setup and plain step-by-step building, accepting per-task billing and a polling delay on Airtable triggers. Make and n8n each have their own Airtable integration page on this site. Compare the operation lists side by side for your own use case, then weigh who will maintain the automation and how often it will run.
Same platform

Other docs you might need on this stack.

Browse all integrations