Skip to main content

​
Airtable

The Airtable node lets you read and write data in Airtable bases — create, retrieve, update, and delete records, or list bases and tables. Airtable Node

​
Credentials

Two credential types are supported:
TypeDescription
Airtable Personal Access TokenToken-based authentication using an Airtable API key
Airtable OAuth2Platform-managed OAuth2 — sign in with your Airtable account
To create a credential:
  1. Go to Settings → Credentials → New Credential
  2. Select the desired Airtable credential type
  3. Complete the authentication flow

​
Operations

​
Record

OperationDescription
CreateAdd a new record to a table
GetRetrieve a single record by ID
Get ManyRetrieve multiple records with optional filters and sorting
UpdateUpdate fields on an existing record
UpsertCreate a record if it doesn’t exist, update it if it does
DeleteDelete a record by ID

​
Base

OperationDescription
Get ManyList all bases accessible to the credential, with optional permission-level filtering
Get SchemaRetrieve the schema (tables and fields) of a base

​
Parameters: Create Record

ParameterTypeRequiredDescription
BaseResource LocatorYesThe Airtable base to write to
TableResource LocatorYesThe table to create a record in
FieldsKey-ValueYesThe field names and values for the new record
Type CastBooleanNoAutomatically cast field values to the correct type

​
Parameters: Get Many Bases

ParameterTypeRequiredDescription
Return AllBooleanNoWhen enabled, returns all bases instead of up to a limit
Options — Permission LevelSelectNoFilter returned bases by permission level

​
Parameters: Get Many Records

ParameterTypeRequiredDescription
BaseResource LocatorYesThe Airtable base to read from
TableResource LocatorYesThe table to read records from
Filter by FormulaStringNoAirtable formula to filter records (e.g. {Status} = 'Active')
SortCollectionNoSort by one or more fields
Max RecordsNumberNoMaximum number of records to return
FieldsMulti-SelectNoReturn only these specific fields
ViewStringNoLimit results to a specific view

​
Output Data

A single record returned from Get or Create: 
{
  "id": "recXXXXXXXXXXXXXX",
  "createdTime": "2025-03-10T09:00:00.000Z",
  "fields": {
    "Name": "Acme Corp",
    "Status": "Active",
    "Revenue": 150000,
    "Tags": ["Enterprise", "US"]
  }
}
Reference fields in downstream nodes: 
{{ airtable.fields.Name }}
{{ airtable.fields.Status }}
{{ airtable.id }}

​
Filter Formula Examples

FormulaDescription
{Status} = 'Active'Records where Status equals “Active”
{Revenue} > 100000Records where Revenue is greater than 100,000
AND({Status} = 'Active', {Region} = 'US')Active records in the US
NOT({Email} = '')Records with a non-empty email
  • Airtable Trigger — Trigger an orchestration on Airtable record events
  • For Loop — Iterate over a list of retrieved records