Mandala
Tools

Airtable

Read, create, and update Airtable

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.

Tools

airtable_list_records

Read records from an Airtable table

Input

ParameterTypeRequiredDescription
baseIdstringYesID of the Airtable base
tableIdstringYesID of the table
maxRecordsnumberNoMaximum number of records to return
filterFormulastringNoFormula to filter records (e.g., "({Field Name} = 'Value')")

Output

ParameterTypeDescription
recordsjsonArray of retrieved Airtable records
metadatajsonOperation metadata including pagination offset and total records count

airtable_get_record

Retrieve a single record from an Airtable table by its ID

Input

ParameterTypeRequiredDescription
baseIdstringYesID of the Airtable base
tableIdstringYesID or name of the table
recordIdstringYesID of the record to retrieve

Output

ParameterTypeDescription
recordjsonRetrieved Airtable record with id, createdTime, and fields
metadatajsonOperation metadata including record count

airtable_create_records

Write new records to an Airtable table

Input

ParameterTypeRequiredDescription
baseIdstringYesID of the Airtable base
tableIdstringYesID or name of the table
recordsjsonYesArray of records to create, each with a fields object

Output

ParameterTypeDescription
recordsjsonArray of created Airtable records
metadatajsonOperation metadata

airtable_update_record

Update an existing record in an Airtable table by ID

Input

ParameterTypeRequiredDescription
baseIdstringYesID of the Airtable base
tableIdstringYesID or name of the table
recordIdstringYesID of the record to update
fieldsjsonYesAn object containing the field names and their new values

Output

ParameterTypeDescription
recordjsonUpdated Airtable record with id, createdTime, and fields
metadatajsonOperation metadata including record count and updated field names

airtable_update_multiple_records

Update multiple existing records in an Airtable table

Input

ParameterTypeRequiredDescription
baseIdstringYesID of the Airtable base
tableIdstringYesID or name of the table
recordsjsonYesArray of records to update, each with an id and a fields object

Output

ParameterTypeDescription
recordsjsonArray of updated Airtable records
metadatajsonOperation metadata including record count and updated record IDs

Triggers

airtable_webhook

Trigger workflow from Airtable record changes like create, update, and delete events (requires Airtable credentials)

Output

ParameterTypeDescription
payloadsarrayThe payloads of the Airtable changes
latestPayload.timestampstringThe timestamp of the Airtable change
latestPayload.payloadFormatobjectThe format of the Airtable change
latestPayload.actionMetadata.sourcestringThe source of the Airtable change
latestPayload.actionMetadata.sourceMetadata.pageIdstringThe ID of the page that triggered the Airtable change
latestPayload.actionMetadata.changedTablesByIdobjectThe tables that were changed
latestPayload.actionMetadata.baseTransactionNumbernumberThe transaction number of the Airtable change
airtableChangesarrayChanges made to the Airtable table

Notes

  • Category: tools
  • Type: airtable
Airtable