Airtable
App · Databases · 7 actions · 1 trigger
Work with Airtable bases, tables, and records.
Triggers
Start a workflow when something happens in Airtable. See how triggers work.
Airtable New Record
Triggers when a new record is added to an Airtable table
Filters
Narrow which events start a run.
base_idRequiredtable_nameRequired
Event fields
What a run starts with. Later steps read each field with an @ reference.
idtextfieldsobjectcreated_timetext
Actions
| Action | What it does |
|---|---|
| Create record | Create a new record in an Airtable table. |
| Delete record | Delete a record from an Airtable table. |
| Get record | Retrieve a single record by ID. |
| List bases | Retrieve all accessible Airtable bases. |
| List records | Retrieve records from an Airtable table. |
| List tables in a base | Fetch all tables for a specific Airtable base. |
| Update record | Update fields on an existing Airtable record. |
Create record
Create a new record in an Airtable table.
Inputs
- Base
base_idtextRequired - The Airtable base to use.
- Table
table_nametextRequired - The table to use.
- Fields
fieldsobjectRequired - The value to set for each field in the table.
Outputs
createdTimetext- Creation timestamp
fieldsobject- Record fields
idtext- Created record ID (use this as record_id in update_record or delete_record)
Example output
{
"createdTime": "2024-01-15T10:30:00Z",
"fields": {
"Email": "john@example.com",
"Name": "John Smith",
"Status": "Active"
},
"id": "rec9K3L2mN4P5Q6R"
}Delete record
Delete a record from an Airtable table.
Inputs
- Base
base_idtextRequired - The Airtable base to use.
- Table
table_nametextRequired - The table to use.
- Record
record_idtextRequired - The record to use.
Outputs
deletedtrue/false- Whether the item was deleted
Example output
{
"deleted": true
}Get record
Retrieve a single record by ID.
Inputs
- Base
base_idtextRequired - The Airtable base to use.
- Table
table_nametextRequired - The table to use.
- Record
record_idtextRequired - The record to use.
Outputs
createdTimetext- Creation timestamp
fieldsobject- Record fields
idtext- Record ID
Example output
{
"createdTime": "2024-01-15T10:30:00Z",
"fields": {
"Email": "john@example.com",
"Name": "John Smith",
"Status": "Active"
},
"id": "rec9K3L2mN4P5Q6R"
}List bases
Retrieve all accessible Airtable bases.
Inputs
None.
Outputs
baseslist- List of bases
Example output
{
"bases": [
{
"id": "appaBc123DeFg456",
"name": "Marketing Campaigns",
"permissionLevel": "create"
}
]
}List records
Retrieve records from an Airtable table.
Inputs
- Base
base_idtextRequired - The Airtable base to use.
- Table
table_nametextRequired - The table to use.
- Max records
max_recordsnumber - Maximum number of records to return.
- Filter formula
filter_formulatext - An Airtable filter formula that limits which records are returned, for example {Status} = 'Active'.
Outputs
recordslist- List of records
Example output
{
"records": [
{
"createdTime": "2024-01-15T10:30:00Z",
"fields": {
"Email": "john@example.com",
"Name": "John Smith",
"Status": "Active"
},
"id": "rec9K3L2mN4P5Q6R"
}
]
}List tables in a base
Fetch all tables for a specific Airtable base.
Inputs
- Base
base_idtextRequired - The Airtable base to use.
Outputs
tableslist- List of tables
Example output
{
"tables": [
{
"id": "tblXyz789AbC123",
"name": "Contacts",
"primaryFieldId": "fldPqR456StU789"
}
]
}Update record
Update fields on an existing Airtable record.
Inputs
- Base
base_idtextRequired - The Airtable base to use.
- Table
table_nametextRequired - The table to use.
- Record
record_idtextRequired - The record to use.
- Fields
fieldsobjectRequired - The value to set for each field in the table.
Outputs
createdTimetext- Creation timestamp
fieldsobject- Updated record fields
idtext- Record ID
Example output
{
"createdTime": "2024-01-15T10:30:00Z",
"fields": {
"Email": "john@example.com",
"Name": "John Smith",
"Status": "Inactive"
},
"id": "rec9K3L2mN4P5Q6R"
}