Airtable and Zapier connect to automate your database workflows. You can create, update, and find records, and start Zaps when records are added or changed.
Prerequisites
To use the Airtable app on Zapier, you must have:
- You must verify your email address on Airtable.
- For Airtable Enterprise Scale plan users, you must grant Zapier access to Airtable in your allowlist.
For Zapier Team or Enterprise users, you can use a static IP address to connect to Zapier. This is useful if your Airtable instance requires IP allowlisting.
Connect Airtable to Zapier
To create an app connection to Airtable on Zapier:
- Go to the Apps page.
- Click + Add connection.
- A new dialog box will appear. Search for and select Airtable.
- Click Add connection.
- A new browser tab or window will open.
- Log into Airtable to authenticate.
- Grant Zapier permission to access your account if prompted to.
Your Airtable account is now successfully connected to Zapier.
About Airtable's app
Triggers, searches, and actions
Triggers
- New Record - Triggers when a new record is created or new or existing records when first added to a selected view.
- New or Updated Record - Triggers when a record is created or updated.
Searches
- Find Record - Find a record in a table.
- Find Table - Find tables by searching for a keyword in table name or description.
- Find Base - Find bases by searching for a keyword in the base name. Only works with 5000 or fewer bases in the account.
- Find Record by ID - Find a specific record using its unique ID.
- Find Table by ID - Find a specific table using its unique ID.
- Find or Create Record - Find or Create Record.
Actions
- Create Record - Creates a new record with auto-populating fields.
- Create or Update Record - Find and update an existing record, or create a new one.
- Update Record - Update a record in a specific table.
- Create Records (Advanced) - Create up to 10 new records (supports line items).
- Delete Record - Delete a record in a table.
- API Request (Beta) - This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
Limitations
- You can create up to 20 tokens per Airtable user for third-party integrations like Zapier.
- API Rate limits apply and vary depending on your Airtable plan type.Airtable enforces a rate limit of 5 requests per second per base to ensure optimal performance across all pricing tiers. Additionally, there is a limit of 50 requests per second for all traffic using personal access tokens from a given user or service account. If you exceed this rate, you will receive a 429 status code and must wait 30 seconds before subsequent requests will succeed.
- Airtable uses OAuth to authenticate your account on Zapier. Personal Access Tokens (PAT) cannot be used with Zapier as the Airtable app on Zapier specifically uses OAuth authentication.
- Update actions in Zapier overwrite existing data rather than appending to it, which may not be suitable for all use cases where data preservation is important.
Templates
View all of Airtable's templates .
Use cases
- 9 Airtable automation ideas
- How to connect Airtable to webhooks
- How to create new Softr users from Airtable