Airtable Tools provide AI Agents with the capability to interact with Airtable, allowing them to perform various operations such as finding bases, tables, and records, as well as creating, updating, and deleting records.

List of Airtable Tools

Tool NameDescription
Find Airtable BasesFind bases on Airtable
Find Airtable TablesFind tables on Airtable
Find Airtable RecordsFind records on Airtable
Create Airtable RecordsCreate records on Airtable
Update Airtable RecordUpdate record on Airtable
Delete Airtable RecordDelete record on Airtable

Find Bases

Description

This tool allows AI Agents to find bases on Airtable. It can be used to retrieve a list of available bases, which is useful for further operations that require base IDs.

System Tool ID and Tool Description for Agents

  • Tool ID: airtable_find_bases
  • Description: Find bases on Airtable

Arguments

NameRequiredTypeDescription
offsetOptionalstringOffset for getting the next page of results when iterating over pages.

Find Tables

Description

This tool enables AI Agents to find tables within a specific Airtable base. It’s useful for discovering available tables before performing operations on them.

System Tool ID and Tool Description for Agents

  • Tool ID: airtable_find_tables
  • Description: Find tables on Airtable

Arguments

NameRequiredTypeDescription
base_idRequiredstringThe ID of the base to find tables in.
offsetOptionalstringOffset for getting the next page of results when iterating over pages.

Find Records

Description

This tool allows AI Agents to search for records within a specific table of an Airtable base. It provides flexibility in finding records based on certain criteria.

System Tool ID and Tool Description for Agents

  • Tool ID: airtable_find_records
  • Description: Find records on Airtable

Arguments

NameRequiredTypeDescription
base_idRequiredstringThe ID of the base containing the table.
table_idRequiredstringThe ID of the table to search records in.
filter_by_formulaOptionalstringAirtable web API param to search records.
offsetOptionalstringOffset for getting the next page of results when iterating over pages.

Create Records

Description

This tool enables AI Agents to create new records in a specified table of an Airtable base. It’s useful for adding new data to Airtable.

System Tool ID and Tool Description for Agents

  • Tool ID: airtable_create_records
  • Description: Create records on Airtable.

Arguments

NameRequiredTypeDescription
base_idRequiredstringThe ID of the base containing the table.
table_idRequiredstringThe ID of the table to create records in.
recordsRequiredarray of objectsAn array of record objects to create. Each object should have a fields property.
records[].fieldsRequiredobjectA dynamic object where keys are strings (field names) and values can be of any type.

Update Record

Description

This tool allows AI Agents to update an existing record in a specified table of an Airtable base. It’s useful for modifying data in Airtable.

System Tool ID and Tool Description for Agents

  • Tool ID: airtable_update_record
  • Description: Update record on Airtable.

Arguments

NameRequiredTypeDescription
base_idRequiredstringThe ID of the base containing the table.
table_idRequiredstringThe ID of the table containing the record.
record_idRequiredstringThe ID of the record to update.
fieldsRequiredobjectA dynamic object where keys are strings (field names) and values can be of any type.

Delete Record

Description

This tool enables AI Agents to delete a specific record from a table in an Airtable base. It’s useful for removing unwanted data from Airtable.

System Tool ID and Tool Description for Agents

  • Tool ID: airtable_delete_record
  • Description: Delete record on Airtable.

Arguments

NameRequiredTypeDescription
base_idRequiredstringThe ID of the base containing the table.
table_idRequiredstringThe ID of the table containing the record.
record_idRequiredstringThe ID of the record to delete.

All these tools return their responses as JSON strings. Agents should parse these strings to work with the returned data.

Be cautious when using update and delete operations, as they permanently modify the data in Airtable. Always ensure you have the correct record IDs before performing these operations.