Airtable API - Database & Records Automation

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)

You can test with Demo Mode first (free, no key needed) to see the output format before committing.

---

Quick Start

Test with Demo Mode (free, 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

Parameter	Type	Default	Required	Description
task	string	"list_records"	Yes*	Operation to perform
accessToken	string	-	Yes*	Airtable personal access token (from airtable.com/create/tokens)
baseId	string	-	No	Airtable base ID (starts with 'app')
tableIdOrName	string	-	No	Table ID (starts with 'tbl') or table name
recordId	string	-	No	Record ID for get/update/delete operations (starts with 'rec')
fieldId	string	-	No	Field ID for field operations (starts with 'fld')
fields	object	{}	No	Fields object for create/update record operations (JSON)
filterByFormula	string	-	No	Airtable formula to filter records (e.g., "{Status} = 'Active'")
sort	array	[]	No	Sort records by fields (JSON array: [{field: 'Name', direction: 'asc'}])
view	string	-	No	Airtable view to use for listing records
maxRecords	integer	100	No	Maximum number of records to return
tableName	string	-	No	Name for new table
tableDescription	string	-	No	Description for new table
tableFields	array	[]	No	Fields schema for new table (JSON array)
fieldName	string	-	No	Name for new field
fieldType	string	-	No	Type for new field
fieldOptions	object	{}	No	Additional options for field (JSON)
batchRecords	array	[]	No	Array of records for batch operations
webhookUrl	string	-	No	URL to send results to (Zapier, Make, n8n, etc.)
demoMode	boolean	true	No	Run with sample data (no access token required)

*Required when Demo Mode is off.

---

Pricing

This actor uses pay-per-event billing:

Event	Description	Price
API Request	Each Airtable API request processed	$0.01

Demo mode is free -- no charges for sample data.

---

Troubleshooting

"API key is required"

You have Demo Mode turned off but didn't provide an API key. Either:

• Turn Demo Mode on to test with sample data
• Add your API key in the input

"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