Airtable
Read, create, and update Airtable
Configuration
List Records
Operation
List Records
Airtable Account*
Select Airtable account
Base ID*
Enter your base ID (e.g., appXXXXXXXXXXXXXX)
Table ID*
Enter table ID (e.g., tblXXXXXXXXXXXXXX)
Max Records
Maximum records to return (optional)
Filter Formula
Airtable formula to filter records (optional)
List Records (
airtable_list_records)Read records from an Airtable table
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID of the table |
maxRecords | number | No | Maximum number of records to return |
filterFormula | string | No | Formula to filter records (e.g., "({Field Name} = 'Value')") |
Output
| Parameter | Type | Description |
|---|---|---|
id | string | id output |
createdTime | string | createdTime output |
Get Record
Operation
Get Record
Airtable Account*
Select Airtable account
Base ID*
Enter your base ID (e.g., appXXXXXXXXXXXXXX)
Table ID*
Enter table ID (e.g., tblXXXXXXXXXXXXXX)
Record ID*
ID of the record (e.g., recXXXXXXXXXXXXXX)
Get Record (
airtable_get_record)Retrieve a single record from an Airtable table by its ID
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID or name of the table |
recordId | string | Yes | ID of the record to retrieve |
Output
| Parameter | Type | Description |
|---|---|---|
record | json | Retrieved Airtable record with id, createdTime, and fields |
Create Records
Operation
Create Records
Airtable Account*
Select Airtable account
Base ID*
Enter your base ID (e.g., appXXXXXXXXXXXXXX)
Table ID*
Enter table ID (e.g., tblXXXXXXXXXXXXXX)
Records (JSON Array)*
json
For Create: `[{ "fields": { ... } }]`\n
Create Records (
airtable_create_records)Write new records to an Airtable table
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID or name of the table |
records | json | Yes | Array of records to create, each with a fields object |
fields | string | No | No description |
Output
| Parameter | Type | Description |
|---|---|---|
id | string | id output |
createdTime | string | createdTime output |
Update Record
Operation
Update Record
Airtable Account*
Select Airtable account
Base ID*
Enter your base ID (e.g., appXXXXXXXXXXXXXX)
Table ID*
Enter table ID (e.g., tblXXXXXXXXXXXXXX)
Record ID*
ID of the record (e.g., recXXXXXXXXXXXXXX)
Fields (JSON Object)*
json
Fields to update: `{ "Field Name": "New Value" }`
Update Record (
airtable_update_record)Update an existing record in an Airtable table by ID
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
baseId | string | Yes | ID of the Airtable base |
tableId | string | Yes | ID or name of the table |
recordId | string | Yes | ID of the record to update |
fields | json | Yes | An object containing the field names and their new values |
Output
| Parameter | Type | Description |
|---|---|---|
record | json | Updated Airtable record with id, createdTime, and fields |
Usage Instructions
Integrates Airtable into the workflow. Can create, get, list, or update Airtable records. Can be used in trigger mode to trigger a workflow when an update is made to an Airtable table.
Notes
- Category:
tools - Type:
airtable