Skip to main content

Airtable Integration

Build fast, flexible database agents by connecting Airtable to SmythOS.

TL;DR

Grab your Airtable Personal Access Token and Base ID, store them securely in Vault, and then use SmythOS’s Airtable components to fetch, list, update, or create records in your bases.

List of Airtable Components

ComponentWhat it DoesInputsKey OutputsUse Case
Get RecordFetches a single record by IDbaseID, tableIdOrName, recordIDrecFields, recordIdView a customer’s profile from ID
List RecordsLists multiple records from a tablebaseID, tableIdOrNamerecordsDisplay rows from a dataset
List Records (Next Page)Paginates through additional recordsbaseID, tableIdOrName, offsetrecords, offsetRetrieve records beyond first page
Create a RecordCreates a single new recordbaseID, tableIdOrName, fieldsrecordIDAdd a support ticket or form submission
Create RecordsCreates multiple new recordsbaseID, tableIdOrName, bodyrecordsBulk-import contacts
Update RecordUpdates a single recordbaseID, tableIdOrName, recordID, bodyrecFields, recordIdEdit a user's status or info
List TablesReturns all tables in a basebaseID, triggertablesDynamically discover table names
Get Row DataRetrieve rows by field-based querybaseID, tableId, field_name, queryfields, idSearch for a user by email

Prerequisites

Before using any Airtable component in SmythOS, make sure to:

  1. Create an Airtable account.
  2. Visit Create Personal Access Token.
  3. Select necessary scopes and access to your desired base.
  4. Copy and store your token in SmythOS Vault.
Use Vault

Never expose tokens directly in components. Always store secrets in Vault and reference them by name.

Component Details

Get Record

Fetches a specific record from a table using its ID.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
tableIdOrNamerequiredTable name or ID
recordIDrequiredID of the record to fetch

Outputs

FieldDescription
recFieldsFields of the record
recordIdThe record ID
responseFull response object
headersHTTP headers from Airtable

List Records

Lists records from a table.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
tableIdOrNamerequiredTable name or ID

Outputs

FieldDescription
recordsArray of retrieved records
offsetOffset for pagination
responseRaw Airtable response
headersHTTP headers

List Records (Next Page)

Use this to paginate through a large dataset.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
tableIdOrNamerequiredTable name or ID
offsetrequiredOffset token from previous response

Outputs

FieldDescription
recordsPaginated records
offsetNext offset token
responseAirtable raw response
headersHTTP headers

Create a Record

Creates a single record in a given table.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
tableIdOrNamerequiredTable name
fieldsrequiredField data as JSON object

Outputs

FieldDescription
recordIDNew record ID
responseFull response from Airtable
headersHTTP headers

Create Records

Creates multiple records in batch.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
tableIdOrNamerequiredTable name
bodyoptionalArray of JSON record objects

Outputs

FieldDescription
recordsCreated records
responseAPI response
headersHTTP metadata

Update Record

Updates fields for a given record.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
tableIdOrNamerequiredTable name
recordIDrequiredRecord ID to update
bodyoptionalFields to update in JSON format

Outputs

FieldDescription
recFieldsUpdated record fields
recordIdUpdated record ID
responseFull API response
headersHTTP metadata

List Tables

Lists all tables from a base.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
triggerrequiredValue used to trigger this component

Outputs

FieldDescription
tablesTable metadata
responseAirtable response
headersHTTP headers

Get Row Data

Finds rows based on a field-value match.

Inputs

FieldRequiredDescription
baseIDrequiredAirtable Base ID
tableIdrequiredTable name or ID
field_namerequiredField to search
queryrequiredValue to search for

Outputs

FieldDescription
fieldsMatched field data
idMatching record IDs
responseFull API response
headersHTTP headers

Best Practices

TIP

Use consistent field naming across Airtable and your other systems to simplify mapping between components.

  • Always use Vault for secure key storage.
  • Use pagination components (List Records Next Page) for large datasets.
  • Validate case-sensitive table names and record IDs carefully.

What's Next?

Build powerful agents that automate your Airtable workflows:

  • Sync data from Google Sheets.
  • Use Get Record to fetch CRM data before replying to a user via OpenAI.
SmythOS Airtable Integration Visual