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

Component	What it Does	Inputs	Key Outputs	Use Case
Get Record	Fetches a single record by ID	baseID, tableIdOrName, recordID	recFields, recordId	View a customer’s profile from ID
List Records	Lists multiple records from a table	baseID, tableIdOrName	records	Display rows from a dataset
List Records (Next Page)	Paginates through additional records	baseID, tableIdOrName, offset	records, offset	Retrieve records beyond first page
Create a Record	Creates a single new record	baseID, tableIdOrName, fields	recordID	Add a support ticket or form submission
Create Records	Creates multiple new records	baseID, tableIdOrName, body	records	Bulk-import contacts
Update Record	Updates a single record	baseID, tableIdOrName, recordID, body	recFields, recordId	Edit a user's status or info
List Tables	Returns all tables in a base	baseID, trigger	tables	Dynamically discover table names
Get Row Data	Retrieve rows by field-based query	baseID, tableId, field_name, query	fields, id	Search 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

Field	Required	Description
baseID	required	Airtable Base ID
tableIdOrName	required	Table name or ID
recordID	required	ID of the record to fetch

Outputs

Field	Description
recFields	Fields of the record
recordId	The record ID
response	Full response object
headers	HTTP headers from Airtable

List Records

Lists records from a table.

Inputs

Field	Required	Description
baseID	required	Airtable Base ID
tableIdOrName	required	Table name or ID

Outputs

Field	Description
records	Array of retrieved records
offset	Offset for pagination
response	Raw Airtable response
headers	HTTP headers

List Records (Next Page)

Use this to paginate through a large dataset.

Inputs

Field	Required	Description
baseID	required	Airtable Base ID
tableIdOrName	required	Table name or ID
offset	required	Offset token from previous response

Outputs

Field	Description
records	Paginated records
offset	Next offset token
response	Airtable raw response
headers	HTTP headers

Create a Record

Creates a single record in a given table.

Inputs

Field	Required	Description
baseID	required	Airtable Base ID
tableIdOrName	required	Table name
fields	required	Field data as JSON object

Outputs

Field	Description
recordID	New record ID
response	Full response from Airtable
headers	HTTP headers

Create Records

Creates multiple records in batch.

Inputs

Field	Required	Description
baseID	required	Airtable Base ID
tableIdOrName	required	Table name
body	optional	Array of JSON record objects

Outputs

Field	Description
records	Created records
response	API response
headers	HTTP metadata

Update Record

Updates fields for a given record.

Inputs

Field	Required	Description
baseID	required	Airtable Base ID
tableIdOrName	required	Table name
recordID	required	Record ID to update
body	optional	Fields to update in JSON format

Outputs

Field	Description
recFields	Updated record fields
recordId	Updated record ID
response	Full API response
headers	HTTP metadata

List Tables

Lists all tables from a base.

Inputs

Field	Required	Description
baseID	required	Airtable Base ID
trigger	required	Value used to trigger this component

Outputs

Field	Description
tables	Table metadata
response	Airtable response
headers	HTTP headers

Get Row Data

Finds rows based on a field-value match.

Inputs

Field	Required	Description
baseID	required	Airtable Base ID
tableId	required	Table name or ID
field_name	required	Field to search
query	required	Value to search for

Outputs

Field	Description
fields	Matched field data
id	Matching record IDs
response	Full API response
headers	HTTP 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.