Airtable

Overview

Automate Airtable from your workflows. The Airtable node reads and writes records in any base your token can access, filters with Airtable formulas or views, and includes meta operations so a workflow (or an AI agent) can discover base IDs and table schemas on its own. Authenticates with a personal access token scoped to the bases you choose.

Operations

• Record — Create — add a record to a table from a JSON object of field name → value, with optional typecasting (Airtable converts strings into selects, dates, collaborators, …).
• Record — Update — change the given fields of an existing record by ID; fields you don't include keep their values.
• Record — Get — fetch a single record by its rec… ID.
• Record — Get Many — list a table's records with an optional filterByFormula, a view (uses that view's filters and order), a sort field, and a max-records cap. Pagination is handled automatically.
• Record — Delete — delete a record by ID.
• Base — Get Many — list every base the token can access, to discover base IDs.
• Table — Get Many — list a base's tables with their field names and views, so you always know the exact field names writes need.

Targeting a table

Record operations take a Base ID (app…, visible in your base URL: airtable.com/app…/tbl…) and a Table — the name shown on the table's tab (e.g. Employees) or its tbl… ID. Create and Update take the record's fields as JSON; values support {{variables}} from upstream nodes:

{
  "Name": "{{$json.name}}",
  "Status": "Open",
  "Due Date": "2026-08-15"
}

To find a record's ID, use Record — Get Many (each record comes back with its id) or add a formula field with RECORD_ID() in Airtable.

Output ($json)

• {{$json.id}} — the record ID (single-record operations)
• {{$json.fields}} — the record's field values, keyed by field name
• {{$json.records}} — the array of records (Get Many), each {id, fields, createdTime}
• {{$json.bases}} / {{$json.tables}} — arrays from the meta reads

Common Use Cases

• Log form submissions, orders, or leads as rows in an Airtable base.
• Look up matching records with a formula filter and branch on the result.
• Keep Airtable in sync with your CRM or database from workflow events.
• Let an Agent Loop query and update records as callable tools.

Required Credentials