Airtable Integration

Interact with Airtable databases, tables, and records

Airtable is built into meinGPT as a native tool (not an MCP server) and lets you interact directly with your Airtable databases. Create, read, update, and delete data in your Airtable workspace.

Setup

Prerequisites

  1. An Airtable account
  2. An Airtable Personal Access Token
    • Create a token at: https://airtable.com/create/tokens
    • Required permissions:
      • data.records:read - for reading records
      • data.records:write - for creating/updating records
      • schema.bases:read - for reading database structure
      • schema.bases:write - for creating/modifying tables

Configuration

When activating the tool, enter your Airtable Personal Access Token in the "Airtable Personal Access Token" field.

Main Functions

Database Operations

  • list_bases: Lists all accessible Airtable databases
  • list_tables: Shows all tables in a database with optional detail level
  • describe_table: Returns detailed information about a specific table

Record Operations

  • list_records: Lists records from a table with filter options
    • Supports filter formulas, sorting, and views
    • Pagination for large data sets
  • search_records: Searches text fields for specific terms
  • get_record: Retrieves a specific record by ID
  • create_record: Creates a new record
  • update_records: Updates up to 10 records simultaneously
  • delete_records: Deletes up to 10 records simultaneously

Schema Operations

  • create_table: Creates a new table with defined fields
  • update_table: Changes name or description of a table
  • create_field: Adds a new field to a table
  • update_field: Changes name or description of a field

Usage Examples

Search and Filter Records

"Find all customers in Berlin"
"Show me tasks with status 'Open' sorted by priority"
"Search for products with 'Premium' in the name"

Manage Data

"Create a new customer entry with name and email"
"Update the status of task ID xyz to 'Done'"
"Delete all entries with status 'Archived'"

Adjust Table Structure

"Create a new table 'Projects' with fields for name, status, and deadline"
"Add a number field 'Budget' to the project table"

Filter Formulas

Airtable supports complex filter formulas:

  • {Status} = "Active" - Exact match
  • AND({Price} > 100, {Category} = "Premium") - Multiple conditions
  • OR(FIND("important", {Notes}), {Priority} = "High") - OR connection
  • NOT({Archived}) - Negation

Advantages

  • Real-time Data: Direct access to current data
  • No Synchronization Needed: Changes are immediately visible
  • Full API Functionality: All Airtable features available
  • Batch Operations: Efficient processing of multiple records

Limitations

  • Maximum 10 records per update/delete operation
  • API rate limits: 5 requests per second
  • Filter formulas must follow Airtable syntax
  • Search function only available for text fields
Was this page helpful?