Skip to content
Nappai Documentation

Airtable

Airtable works with the records of an Airtable table from a flow: it reads them, creates new records and updates or deletes existing ones.

When to use it

  • Saving in Airtable the contacts or orders that arrive through a form.
  • Giving an agent access to look up an Airtable table.
  • Updating a record’s status when a process finishes.
  • Reading the records of a specific view to prepare a report.

Configuration

The Operation field decides what the component does: Read (default), Create, Update or Delete. Once you pick the credential, Base Name fills with your bases; once you pick the base, Table Name fills with its tables. Once you pick the table, one field per column appears, used with Create and Update.

You need an Airtable API credential with your Airtable account access token. See Credentials.

FieldWhat it does
Credential (required)The Airtable API credential.
OperationWhat the component does.
ModeBasic (default) uses default options when reading. Advanced shows Fields To Read, Max Records, Filter By Formula and View Name.
Base NameThe Airtable base.
Table NameThe table inside the base.
Record IDWith Update and Delete, the ID of the record to change or delete.
Fields To ReadWith Read in Advanced mode, the columns to read.
Max RecordsWith Read in Advanced mode, the maximum number of records to read. Default: 10.
Filter By FormulaWith Read in Advanced mode, an Airtable formula to read only the records that meet it.
View NameWith Read in Advanced mode, the Airtable view that sets the order and filter of the records.

Output

The Result output holds the records read or the record created, updated or deleted.

In tool mode, an agent can use the component by itself. See Tool Mode.

Example

A language school keeps information requests in Airtable.

  1. Add Airtable with the Airtable API credential.
  2. Choose Create, the Students base and the Requests table.
  3. Connect the form’s name, email and course to each column’s field.