Airtable

Read, add, change and delete rows (records) in an Airtable table, and list your bases and their tables.

Needs an AirTable connection — 

Pick a saved connection in the Credential field, or create one from there. It signs in with a Bearer Token.

Connect AirTable →

Try it

workflow · save-page-to-airtable.awf 3 steps

Save Page to Airtable Reading List: a workflow with 3 steps, starting with Right-click a page and ending with Add a record to Airtable.

1. 1 Right-click a page(Context Menu — open its doc page) Context Menu
2. 2 Read the page details(Get Page Metadata — open its doc page) Get Page Metadata
3. 3 Add a record to Airtable(AirTable — open its doc page) AirTable

Open in AWFlow Copy .awf

What it does

The Airtable node works on two kinds of things (Resource):

• Base: list the bases your token can open (Get many), or get a base’s tables, fields and views (Get schema).
• Record: create, get, update or delete one record by its id, or search a table with an Airtable formula.

Once the credential is set, Base and Table are lists loaded from your account. After you pick a table, Fields shows one input per column of that table (choice columns show their options), so you fill values by column name instead of writing JSON. Update only changes the fields you fill; the others keep their values.

Search returns the records of a single response from Airtable; it does not page through very large tables.

When to use it

• Log every new lead, form entry or scraped product as a row in a table.
• Look up a record before deciding what to do next, for example with IF.
• Find rows that match a condition (status, date, price) and process them one by one.
• Use Google Sheets or Baserow / NocoDB instead if your data lives there.

Inputs and settings

For every choice

Setting	Type	What it does
Credential REQ(required)	Credential	The Credential to use to make the request.

7 choices · pick resource and operation to see its settings

Base

Get manyGet schema

Record

Create a record in a tableUpdate data in a tableDelete data from a tableGet data from a tableSearch data in a table

Settings for Base · Get many

Setting	Type	What it does
Limits	Number	The maximum number of records to return.

Showing settings for Base · Get many

Need an operation that isn't listed? — 

Call the AirTable API yourself with the HTTP Request node, and pick the same connection in its Credential field.

Use HTTP Request →

• Record is the record id, which starts with rec (for example recA1b2C3d4E5f6G7). Map it from a previous step, such as {{ $input.id }} after a Search.
• Filter By Formula uses Airtable’s formula language. Field names go in braces, and the whole formula is sent as is, for example AND({Status} = 'New', {Price} < 100). Leave it empty to return records without filtering.
• Limits on Base → Get many is not applied: the node returns all bases the token can see.

Outputs

• Output

• Record operations return the record as id, createdTime and fields (an object keyed by column name), for example {{ $input.fields.Email }}.
• Search returns a list of records. Use Split Out to handle them one per item.
• Base → Get many returns each base’s id, name and permissionLevel. Get schema returns each table with its fields and views.

Dependencies and credentials

• Credential (connection, Bearer Token): required. See Connect AirTable.

Use an Airtable personal access token. Create it at airtable.com under Builder hub → Personal access tokens, give it the scopes data.records:read, data.records:write and schema.bases:read, and add the bases it may access. Save it as a Bearer Token credential: see Create a credential.

Example workflow

1. A Context Menu trigger runs when you right-click a product page.
2. Get Page Metadata reads the page title and URL.
3. Airtable, Record → Create a record in a table, base Shopping, table Wishlist, with Fields Name = {{ $input.title }} and Link = {{ $input.url }}.
4. Browser Notification confirms the row was added.

Common issues

• “Airtable API Error: Invalid permissions, or the requested model was not found”. The token has no access to this base, or lacks a scope. Edit the token on Airtable, add the base and scopes, and run again.
• “Missing base ID” or “Missing table ID” when a list loads. Pick Base first, then Table; each list depends on the one above it.
• The Fields form is empty or a column is missing. Pick the table first. The form only shows text, email, URL, long text, number, duration, date, checkbox and single select columns. To fill other kinds (attachments, multiple selects, linked records, currency), use Http Request.
• Search returns nothing. Check the formula in Airtable’s own formula field first; a field name that does not match exactly makes every record fail the test.

Recipes with this node

Save the page you're on to an Airtable reading list beginner · 5 min Needs a connection

Related nodes

• Google Sheets: the same job in a spreadsheet.
• Baserow / NocoDB: open-source Airtable alternatives.
• Edit Fields: shape data before writing it.
• Http Request: call Airtable API endpoints this node does not cover.