Airtable

Files and knowledge

Airtable for AI agents. Managed auth, ready-made tools.

List, filter, create and update Airtable records on behalf of each of your users, in the bases they choose to share.

About Airtable

With the Airtable connector, your agent works with each user’s bases: it reads a base’s tables and fields, finds records with a filter, and creates, updates or deletes records. Each user connects their own Airtable account through managed OAuth and picks the bases to share, and your agent stays within those bases and the operations your project allows.

Airtable is a platform for building databases and apps on top of spreadsheet-like tables.

Tools

What your agent can do in Airtable.

Each tool is a capability the model can call. You decide which ones a project allows, and every call runs with the end user's own Airtable connection.

  • List bases

    Read
    airtable_list_bases

    List the bases the user shared with the connection.

  • Get a base schema

    Read
    airtable_get_schema

    Read a base's tables, fields and views.

  • List records

    Read
    airtable_list_records

    List the records in a table, filtered by a formula or a view, and sorted.

  • Get a record

    Read
    airtable_get_record

    Read one record and its field values.

  • Create records

    Write
    airtable_create_records

    Add one or more records to a table.

  • Update records

    Write
    airtable_update_records

    Change field values on one or more records.

  • Delete records

    Write
    airtable_delete_records

    Delete one or more records from a table.

  • Create a table

    Write
    airtable_create_table

    Add a table with its fields to a base.

Control

Limits you can set.

You decide what your agent may do in Airtable, and Agent200 runs every call within those limits.

  • Turn single tools on or off

    Allow airtable_list_records and the other read tools, and switch off airtable_delete_records if your agent should never remove data.

  • Restrict what the agent reaches

    Choose the endpoints and scopes a project may use. A call outside them is refused.

Get started

Connect Airtable
in three steps.

  1. 1

    Set up the SDK

    Add the Agent200 SDK to the codebase you already have and authenticate with your API key. The key covers every connector enabled for the project.

    agent.js
    Conceptual example
    Set up the SDK with the Agent200 API key
    // One Agent200 API key covers every connector enabled for the project.
    const agent200 = new Agent200({
      apiKey: process.env.AGENT200_API_KEY,
    });
  2. 2

    Let your user connect Airtable

    Each end user authorizes their own Airtable account once. Agent200 runs the OAuth flow, handles the callback, stores the tokens and refreshes them.

    connect.js
    Conceptual example
    Let an end user connect their account (managed OAuth)
    // Each end user authorizes their own Airtable account, once.
    const connection = await agent200
      .user("user_123")
      .connect("airtable");
    
    if (connection.authorizationUrl) {
      // Show this link to your user; Agent200 handles the rest.
      console.log(connection.authorizationUrl);
    }
  3. 3

    Run with the Airtable tools

    Name the user, the model and the tools. The model decides which Airtable tools to call, and Agent200 executes them with that user's connection.

    run.js
    Conceptual example
    Run a request with the connector's tools
    const result = await agent200
      .user("user_123")
      .run({
        model: "openai/gpt-5.6-sol",
        input: "Add this lead to the Leads table with status New",
        tools: ["airtable"],
      });
    
    console.log(result.output);

Access

Sign-in and permissions.

  • Who signs in

    Each of your users, once, on Airtable's own page. You never see or store their Airtable password.

  • What access is requested

    Read or write access to records and base schemas, as shown on Airtable's consent screen, and only for the bases and workspaces the user picks during sign-in.

For agents

Instructions for AI agents.

Using a coding agent? Paste this brief into it, or give it the address of this page. It describes the Airtable connector and how to use it.

Agent brief
Connector: Airtable, through Agent200. In code: "airtable".
What it does: List, filter, create and update Airtable records on behalf of each of your users, in the bases they choose to share.
Page: https://www.agent200.com/tools/airtable/

1. Get an Agent200 API key. If the developer has none, send them to https://agent200.com/platform/apikeys/ and ask them to choose "Create an API key". Read the key from the AGENT200_API_KEY environment variable. Never ask for it in chat, and never write it into code, prompts or logs.
2. Sign-in is managed OAuth. Each end user approves access once, on Airtable's own page, through the authorization link Agent200 returns. Never ask a user for a Airtable password or token in chat.
3. Give every request a stable id for the end user. Agent200 uses only that user's own connection.
4. Read tools: airtable_list_bases, airtable_get_schema, airtable_list_records, airtable_get_record. Write tools: airtable_create_records, airtable_update_records, airtable_delete_records, airtable_create_table. Name "airtable" in the tools of a request; the model decides which tool to call.
5. Stay within the project's settings. If a tool is turned off or a call is refused, tell the user. Do not work around it.
6. Before a write, confirm with the user, unless they asked for that exact change.
7. For setup with a specific framework, follow its guide:
   https://www.agent200.com/tools/airtable/framework/claude/
   https://www.agent200.com/tools/airtable/framework/chatgpt/
   https://www.agent200.com/tools/airtable/framework/claude-code/
   https://www.agent200.com/tools/airtable/framework/muse/
   https://www.agent200.com/tools/airtable/framework/grok-bot/
   https://www.agent200.com/tools/airtable/framework/openai-dots/
   https://www.agent200.com/tools/airtable/framework/claude-duet/
   https://www.agent200.com/tools/airtable/framework/hermes-agent/
   https://www.agent200.com/tools/airtable/framework/openclaw/

The code on the connector page is a conceptual example of the SDK. SDK reference: https://docs.igpt.ai/

This page is also available as Markdown, for agents and LLMs: /tools/airtable.md

Guides

Use Airtable with the AI you build on.

Step-by-step setup for Airtable with a specific model, assistant or agent framework.

FAQ

Airtable and Agent200, answered.

Who handles the Airtable OAuth flow and the tokens?

Agent200. It runs the authorization, handles the callback on its own domain, stores the tokens and refreshes them. You do not build or maintain an OAuth integration for Airtable.

Does my agent act as the end user?

Within what that user authorized, yes. Every request names an end user, and Agent200 uses only that user's Airtable connection, never another user's. It cannot reach anything the user or Airtable has not authorized.

Can I limit what my agent can do in Airtable?

Yes. You choose which services, endpoints and authorization scopes are allowed in your Agent200 configuration, and the agent works only within them.

  • Google Drive

    Google Drive

    Find, read and organize the files in each user's Drive.

    Managed OAuth Files and knowledge
  • OneDrive

    OneDrive

    Search, read, upload and share OneDrive files, including Word, Excel and PowerPoint documents, on behalf of each of your users.

    Managed OAuth Files and knowledge
  • Dropbox

    Dropbox

    Search, read, upload and organize Dropbox files, and create shared links, on behalf of each of your users.

    Managed OAuth Files and knowledge
  • Notion

    Notion

    Search, read and write Notion pages and databases on behalf of each of your users.

    Managed OAuth Files and knowledge
200 OK

Start with Airtable.
Your agent does the rest.

Your users connect their own Airtable accounts. Agent200 handles the OAuth, the tokens and every tool call.

Book a demo.
See it in action.

Tell us who you are, then pick a time for a 1:1 session with an expert from our team.

We use your details only to email you about Agent200. See the Privacy Policy.

Pick a time. We'll take it from there.

A 1:1 session with an expert from our team, about what you are building.

Open in Calendly (opens in a new tab)