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)

---

Quick Start

Run with real data

{
  "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.)

---

Pricing

This actor uses pay-per-event billing:

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

---

Troubleshooting

"API key is required"

• 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?

---

Built by John Rippy | Actor Arsenal