Airtable Integration

Field	Description	Required	Format
Airtable Personal Access Token	Your Airtable Personal Access Token for API authentication	Yes	`patXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX`

list_bases — List all Airtable bases accessible with your API token

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "bases": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Bases",
      "type": "array"
    },
    "count": {
      "default": 0,
      "title": "Count",
      "type": "integer"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListBasesOutput",
  "type": "object"
}

list_tables — List all tables in a specific Airtable base with their fields and views

Parameters

string

required

The ID of the Airtable base (starts with ‘app’)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "tables": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Tables",
      "type": "array"
    },
    "count": {
      "default": 0,
      "title": "Count",
      "type": "integer"
    },
    "base_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Base Id"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListTablesOutput",
  "type": "object"
}

list_records — List records from an Airtable table with optional filtering and sorting

Parameters

string

required

The ID of the Airtable base

string

required

Name or ID of the table

integer

Maximum number of records to return (1-100) (Default: 100)

string

Airtable formula to filter records

string

Field name to sort by

string

Sort direction (‘asc’ or ‘desc’) (Default: asc)

string

Name or ID of a view to use for filtering/sorting

Response

{
  "$defs": {
    "AirtableRecord": {
      "additionalProperties": false,
      "properties": {
        "id": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Id"
        },
        "fields": {
          "additionalProperties": true,
          "title": "Fields",
          "type": "object"
        },
        "createdTime": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Createdtime"
        }
      },
      "title": "AirtableRecord",
      "type": "object"
    }
  },
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "records": {
      "items": {
        "$ref": "#/$defs/AirtableRecord"
      },
      "title": "Records",
      "type": "array"
    },
    "count": {
      "default": 0,
      "title": "Count",
      "type": "integer"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "base_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Base Id"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListRecordsOutput",
  "type": "object"
}

get_record — Get a specific record from an Airtable table by its ID

Parameters

string

required

The ID of the Airtable base

string

required

Name or ID of the table

string

required

The ID of the record (starts with ‘rec’)

Response

{
  "$defs": {
    "AirtableRecord": {
      "additionalProperties": false,
      "properties": {
        "id": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Id"
        },
        "fields": {
          "additionalProperties": true,
          "title": "Fields",
          "type": "object"
        },
        "createdTime": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Createdtime"
        }
      },
      "title": "AirtableRecord",
      "type": "object"
    }
  },
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "record": {
      "anyOf": [
        {
          "$ref": "#/$defs/AirtableRecord"
        },
        {
          "type": "null"
        }
      ],
      "default": null
    }
  },
  "required": [
    "success"
  ],
  "title": "GetRecordOutput",
  "type": "object"
}

create_records — Create one or more records in an Airtable table. Batched up to 10 per request.

Parameters

string

required

The ID of the Airtable base

string

required

Name or ID of the table

array

required

List of {field: value} record objects

boolean

If true, Airtable converts string values to the appropriate cell types (Default: false)

Response

{
  "$defs": {
    "AirtableRecord": {
      "additionalProperties": false,
      "properties": {
        "id": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Id"
        },
        "fields": {
          "additionalProperties": true,
          "title": "Fields",
          "type": "object"
        },
        "createdTime": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Createdtime"
        }
      },
      "title": "AirtableRecord",
      "type": "object"
    }
  },
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "records": {
      "items": {
        "$ref": "#/$defs/AirtableRecord"
      },
      "title": "Records",
      "type": "array"
    },
    "count": {
      "default": 0,
      "title": "Count",
      "type": "integer"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "base_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Base Id"
    }
  },
  "required": [
    "success"
  ],
  "title": "CreateRecordsOutput",
  "type": "object"
}

update_records — Update one or more records in an Airtable table. Each record must include `id`; remaining fields can be nested under `fields` or at the top level.

Parameters

string

required

The ID of the Airtable base

string

required

Name or ID of the table

array

required

Records to update; each is {‘id’: ‘rec…’, ‘fields’: {…}} or {‘id’: ‘rec…’, ‘field_a’: value, …}

boolean

If true, Airtable converts string values to the appropriate cell types (Default: false)

Response

{
  "$defs": {
    "AirtableRecord": {
      "additionalProperties": false,
      "properties": {
        "id": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Id"
        },
        "fields": {
          "additionalProperties": true,
          "title": "Fields",
          "type": "object"
        },
        "createdTime": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "null"
            }
          ],
          "default": null,
          "title": "Createdtime"
        }
      },
      "title": "AirtableRecord",
      "type": "object"
    }
  },
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "records": {
      "items": {
        "$ref": "#/$defs/AirtableRecord"
      },
      "title": "Records",
      "type": "array"
    },
    "count": {
      "default": 0,
      "title": "Count",
      "type": "integer"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "base_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Base Id"
    },
    "updated_count": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Updated Count"
    }
  },
  "required": [
    "success"
  ],
  "title": "UpdateRecordsOutput",
  "type": "object"
}

delete_records — Delete one or more records from an Airtable table. Batched up to 10 per request.

Parameters

string

required

The ID of the Airtable base

string

required

Name or ID of the table

array

required

List of record IDs to delete (each starts with ‘rec’)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "deleted_ids": {
      "items": {
        "type": "string"
      },
      "title": "Deleted Ids",
      "type": "array"
    },
    "count": {
      "default": 0,
      "title": "Count",
      "type": "integer"
    },
    "table": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Table"
    },
    "base_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Base Id"
    },
    "deleted_count": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Deleted Count"
    }
  },
  "required": [
    "success"
  ],
  "title": "DeleteRecordsOutput",
  "type": "object"
}

Using

Providers

Building

Tools

Airtable Integration for AI Agents & Workflows

Overview

Authentication

Personal Access Token

Required Credentials

Available Actions

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Limits & Quotas

AgentMail

Apify

Browserbase

Links

​Overview

​Authentication

​Personal Access Token

​Required Credentials

​Available Actions

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Limits & Quotas

​Related integrations

AgentMail

Apify

Browserbase

​Links

Overview

Authentication

Personal Access Token

Required Credentials

Available Actions

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Limits & Quotas

Related integrations

Links