Airtable

Interact with Airtable to list, create, retrieve, or update records.

The Airtable node allows you to interact with your Airtable data by performing various operations such as listing records, creating new records, retrieving a specific record, and updating records. You can select the method you wish to execute and provide the necessary parameters such as the base ID, table name, and other optional fields depending on the method. Ensure you have a valid Airtable access token and that you have correctly configured your base and table details.

AirtableList Records

Base ID*Text

Table Name*Text

SortKey/value pairs

Filter By FormulaText

Max RecordsNumber

ViewText

As Separate OutputToggle

outputJSON

Node as configured in “List Records” mode. Fields marked * are required. Dots are connection handles.

Modes

This node reconfigures itself depending on the selected mode — each mode has its own fields.

Mode	What it does	Output
List Records	Retrieve a list of records from a table in Airtable.	JSON
Get Record	Retrieve a specific record from an Airtable table.	JSON
Create Record	Create new records in an Airtable table.	JSON
Update Record	Update a specific record in an Airtable table.	JSON
Upsert Record	Create a new record or update an existing one in a single call by matching on one or more fields.	JSON
Create Records	Create new records in an Airtable table.	JSON
Upsert Records	Create new records or update existing ones in a single call by matching on one or more fields.	JSON
Delete Record	Delete a specific record from an Airtable table.	JSON

List Records

Retrieve a list of records from a table in Airtable.

AirtableList Records

Base ID*Text

Table Name*Text

SortKey/value pairs

Filter By FormulaText

Max RecordsNumber

ViewText

As Separate OutputToggle

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.

Settings

Setting	Type	Default	Description
Sort	Key/value pairs	—	Provide a dictionary where each key is a field name and each value is 'asc' or 'desc' to specify sort order.
Filter By Formula	Text	—	Provide a formula to filter the records.
Max Records	Number	100	The maximum number of records to retrieve.
View	Text	—	Specify the name or ID of the view to retrieve records from.
As Separate Output	Toggle	Off	Output each record as a separate output item.

Output: JSON

Get Record

Retrieve a specific record from an Airtable table.

AirtableGet Record

Base ID*Text

Table Name*Text

Record ID*Text

Fields OnlyToggle

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.
Record ID	Text	Required	ID of the record to retrieve or update.

Settings

Setting	Type	Default	Description
Fields Only	Toggle	Off	Return only the record's fields, excluding metadata such as ID and timestamps.

Output: JSON

Create Record

Create new records in an Airtable table.

AirtableCreate Record

Base ID*Text

Table Name*Text

Fields*Text (multiline)

TypecastToggle

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.
Fields	Text (multiline)	Required	JSON object of fields to update.

Settings

Setting	Type	Default	Description
Typecast	Toggle	Off	Let Airtable coerce values to the correct field types (dates, single‑selects, lookups, etc.).

Output: JSON

Update Record

Update a specific record in an Airtable table.

AirtableUpdate Record

Base ID*Text

Table Name*Text

Record ID*Text

Fields*Text (multiline)

TypecastToggle

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.
Record ID	Text	Required	ID of the record to retrieve or update.
Fields	Text (multiline)	Required	JSON object of fields to update.

Settings

Setting	Type	Default	Description
Typecast	Toggle	Off	Let Airtable coerce values to the correct field types (dates, single‑selects, lookups, etc.).

Output: JSON

Upsert Record

Create a new record or update an existing one in a single call by matching on one or more fields.

AirtableUpsert Record

Base ID*Text

Table Name*Text

Fields*Text (multiline)

Fields To Merge OnList

TypecastToggle

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.
Fields	Text (multiline)	Required	JSON object of fields to update.

Settings

Setting	Type	Default	Description
Fields To Merge On	List	—	Field names Airtable should treat as the unique identifier(s) when deciding whether to create or update.
Typecast	Toggle	Off	Let Airtable coerce values to the correct field types (dates, single‑selects, lookups, etc.).

Output: JSON

Create Records

Create new records in an Airtable table.

AirtableCreate Records

Base ID*Text

Table Name*Text

Records*Text (multiline)

TypecastToggle

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.
Records	Text (multiline)	Required	JSON array of records to create.

Settings

Setting	Type	Default	Description
Typecast	Toggle	Off	Let Airtable coerce values to the correct field types (dates, single‑selects, lookups, etc.).

Output: JSON

Upsert Records

Create new records or update existing ones in a single call by matching on one or more fields.

AirtableUpsert Records

Base ID*Text

Table Name*Text

Records*Text (multiline)

Fields To Merge OnList

TypecastToggle

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.
Records	Text (multiline)	Required	JSON array of records to create.

Settings

Setting	Type	Default	Description
Fields To Merge On	List	—	Field names Airtable should treat as the unique identifier(s) when deciding whether to create or update.
Typecast	Toggle	Off	Let Airtable coerce values to the correct field types (dates, single‑selects, lookups, etc.).

Output: JSON

Delete Record

Delete a specific record from an Airtable table.

AirtableDelete Record

Base ID*Text

Table Name*Text

Record ID*Text

outputJSON

Inputs

Each input can be typed in directly or connected to another node's output.

Input	Type	Required	Description
Base ID	Text	Required	The ID of the base containing the table.
Table Name	Text	Required	The name of the table to interact with.
Record ID	Text	Required	ID of the record to retrieve or update.

Output: JSON

Output