Airtable

Airtable nodes let you read and write records in your Airtable bases. Each operation is a separate node.

All nodes require an Airtable connection configured with your personal access token.

Nodes

List Records

Retrieve records from an Airtable table.

Field	Description	Notes
Base ID	Airtable base ID (starts with app)	Required
Table Name	Table name or ID	Required
View	Restrict to a specific view	Optional
Filter Formula	Airtable formula to filter records	Optional. Supports templates
Sort Field	Field name to sort by	Optional
Sort Direction	asc or desc	Default: asc
Max Records	Maximum records to return	Optional

Supports streaming — each record is emitted individually to downstream nodes.

Create Record

Create a new record in a table.

Field	Description	Notes
Base ID	Airtable base ID	Required
Table Name	Table name or ID	Required
Fields	JSON object mapping field names to values	Required. Supports templates

Update Record

Update an existing record.

Field	Description	Notes
Base ID	Airtable base ID	Required
Table Name	Table name or ID	Required
Record ID	Record ID to update (starts with rec)	Required. Supports templates
Fields	JSON object of fields to update	Required. Supports templates

Delete Record

Delete a record from a table.

Field	Description	Notes
Base ID	Airtable base ID	Required
Table Name	Table name or ID	Required
Record ID	Record ID to delete	Required. Supports templates

Finding Your Base ID

1. Open your base in Airtable
2. The base ID is in the URL: https://airtable.com/appXXXXXXXXXXXX/...

Common Patterns

Sync Airtable to DataStore

1. Airtable List Records — fetch all records
2. Transform — map to target schema
3. DataStore Insert — store locally