Airtable API - Database & Records Automation avatar

Airtable API - Database & Records Automation

Pricing

from $0.05 / 1,000 results

Go to Apify Store
Airtable API - Database & Records Automation

Airtable API - Database & Records Automation

Automate your Airtable bases with the official API. List, create, update, and delete records. Manage tables and fields. Sync data between Airtable and other systems. Perfect for CRM automation, inventory management, project tracking, and data pipelines.

Pricing

from $0.05 / 1,000 results

Rating

0.0

(0)

Developer

The Howlers

The Howlers

Maintained by Community

Actor stats

0

Bookmarked

6

Total users

0

Monthly active users

10 days ago

Last modified

Features

Limited permissions

Share

Automate Airtable bases with the official API. List, create, update, and delete records. Manage tables and fields. Sync data between Airtable and other systems. Perfect for CRM automation, inventory management, and data pipelines.

BYOK (Bring Your Own Key): you provide your own API credentials.


Before You Start

This actor requires your own API credentials to fetch real data.

Where to get your key: Airtable personal access token (from airtable.com/create/tokens)

Demo Mode is off by default, so runs with an access token fetch real data. Set demoMode to true to get sample data that shows the output format, no key needed. A run without an access token also returns sample data instead of failing.


Quick Start

Test with Demo Mode (no task charges, no API key needed)

{
"demoMode": true
}

Run with real data

{
"demoMode": false,
"task": "list_records",
"accessToken": "YOUR_API_KEY_HERE",
"fields": {},
"sort": [],
"maxRecords": 100,
"tableFields": [],
"fieldOptions": {},
"batchRecords": []
}

Input Parameters

ParameterTypeDefaultRequiredDescription
taskstring"list_records"Yes*Operation to perform
accessTokenstring-Yes*Airtable personal access token (from airtable.com/create/tokens)
baseIdstring-NoAirtable base ID (starts with 'app')
tableIdOrNamestring-NoTable ID (starts with 'tbl') or table name
recordIdstring-NoRecord ID for get/update/delete operations (starts with 'rec')
fieldIdstring-NoField ID for field operations (starts with 'fld')
fieldsobject{}NoFields object for create/update record operations (JSON)
filterByFormulastring-NoAirtable formula to filter records (e.g., "{Status} = 'Active'")
sortarray[]NoSort records by fields (JSON array: [{field: 'Name', direction: 'asc'}])
viewstring-NoAirtable view to use for listing records
maxRecordsinteger100NoMaximum number of records to return
tableNamestring-NoName for new table
tableDescriptionstring-NoDescription for new table
tableFieldsarray[]NoFields schema for new table (JSON array)
fieldNamestring-NoName for new field
fieldTypestring-NoType for new field
fieldOptionsobject{}NoAdditional options for field (JSON)
batchRecordsarray[]NoArray of records for batch operations
webhookUrlstring-NoURL to send results to (Zapier, Make, n8n, etc.)
demoModebooleanfalseNoRun with sample data (no access token required)

*Needed for real data. With Demo Mode off and no access token, the run returns sample data.


Pricing

This actor uses pay-per-event billing:

EventWhen it is chargedPrice
Actor startOnce when the run starts, one event per GB of memory (minimum one). At the default 1 GB of memory a run starts at $0.10$0.10 per GB
ResultEach item written to the default dataset$0.00005
List RecordsOnce per successful list_records query, including one that matches no records$0.02
Get RecordOnce per get_record task that returns the record$0.01
Create RecordOnce per create_record task that Airtable confirms$0.02
Update RecordOnce per update_record task that Airtable confirms$0.02
Delete RecordOnce per delete_record task that Airtable confirms$0.01
List TablesOnce per list_tables task$0.01
Get TableOnce per get_table task that finds the table$0.01
Create TableOnce per create_table task that Airtable confirms$0.03
List FieldsOnce per list_fields task$0.01
Create FieldOnce per create_field task that Airtable confirms$0.03
Update FieldOnce per update_field task that Airtable confirms$0.02
List BasesOnce per list_bases task$0.01
Get BaseOnce per get_base task$0.01
Batch Create RecordsPer batch of up to 10 records that Airtable creates$0.05
Batch Update RecordsPer batch of up to 10 records that Airtable updates$0.05
Batch Delete RecordsPer batch of up to 10 records that Airtable deletes$0.05

Demo mode charges no task events. A demo run still pays the Actor start event and one Result event for its sample row.

A single-record, list or schema task that fails (for example a wrong token or a missing table) charges no task event. Batch tasks are charged one event per batch of up to 10 records as soon as Airtable accepts that batch. If a later batch fails, the batches Airtable already accepted stay charged, those records stay written in Airtable, and the error row reports them as batchesCompletedBeforeError. Every run, including a failed one, pays the Actor start event, and the error row counts as one Result.

If the run reaches its maximum total charge, the remaining batches are not sent to Airtable and the result row lists how many records were skipped.


Troubleshooting

I got sample data instead of my records

The run had no access token, so it returned sample data (the row says demoMode: true). Add your Airtable personal access token in the input and keep Demo Mode off to work with your own base.

"API error 403" or "Unauthorized"

Your API key is invalid, expired, or doesn't have access to this specific API endpoint. Double-check your key and account permissions.

"API error 429" or "Rate limit"

Too many requests. Wait a minute and try again, or reduce the number of items per run.

No results or empty dataset

Check the run log for error messages. Common causes:

  • Invalid input format (check the examples above)
  • API key without proper permissions
  • The target data doesn't exist or is too small to track

How do I test without an API key?

Enable Demo Mode in the input. This returns realistic sample data so you can verify the output format works for your workflow.


Built by John Rippy | Actor Arsenal