# 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.

- Page: https://www.agent200.com/tools/airtable/
- Category: Files and knowledge
- Authentication: Managed OAuth
- Identifier in code: `airtable`
- Create an API key: https://agent200.com/platform/apikeys/
- Updated: 2026-11-15

## Instructions for AI agents

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/

## About

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.

## Airtable tools

- **List bases** (`airtable_list_bases`, read): List the bases the user shared with the connection.
- **Get a base schema** (`airtable_get_schema`, read): Read a base's tables, fields and views.
- **List records** (`airtable_list_records`, read): List the records in a table, filtered by a formula or a view, and sorted.
- **Get a record** (`airtable_get_record`, read): Read one record and its field values.
- **Create records** (`airtable_create_records`, write): Add one or more records to a table.
- **Update records** (`airtable_update_records`, write): Change field values on one or more records.
- **Delete records** (`airtable_delete_records`, write): Delete one or more records from a table.
- **Create a table** (`airtable_create_table`, write): Add a table with its fields to a base.

## Limits you can set

**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

### Step 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.

File `agent.js`:

```js
// One Agent200 API key covers every connector enabled for the project.
const agent200 = new Agent200({
  apiKey: process.env.AGENT200_API_KEY,
});
```

(Conceptual example of the Agent200 SDK.)

### Step 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.

File `connect.js`:

```js
// 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);
}
```

(Conceptual example of the Agent200 SDK.)

### Step 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.

File `run.js`:

```js
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);
```

(Conceptual example of the Agent200 SDK.)

## 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.

## Example requests

- "Add this lead to the Leads table with status New"
- "Which tasks in our content calendar are due this week"
- "Mark the Hamilton order as shipped"
- "List the fields in the Inventory base"

## Guides: Airtable with your AI framework

- [Airtable + Claude](https://www.agent200.com/tools/airtable/framework/claude.md): Connect Airtable to Claude through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Airtable + ChatGPT](https://www.agent200.com/tools/airtable/framework/chatgpt.md): ChatGPT cannot send an API key to a custom MCP server, so this guide builds Airtable into your own agent with OpenAI's models and the Agent200 SDK.
- [Airtable + Claude Code](https://www.agent200.com/tools/airtable/framework/claude-code.md): Have Claude Code build a Airtable agent with the Agent200 SDK: managed OAuth, ready-made tools and one API key.
- [Airtable + Muse](https://www.agent200.com/tools/airtable/framework/muse.md): Connect Airtable to Muse through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Airtable + Grok Bot](https://www.agent200.com/tools/airtable/framework/grok-bot.md): Connect Airtable to Grok Bot through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Airtable + OpenAI Dots](https://www.agent200.com/tools/airtable/framework/openai-dots.md): Dots cannot send an API key to a custom MCP server, so this guide builds an always-on Airtable agent with OpenAI's models and the Agent200 SDK.
- [Airtable + Claude Duet](https://www.agent200.com/tools/airtable/framework/claude-duet.md): Connect Airtable to Claude Duet through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Airtable + Hermes Agent](https://www.agent200.com/tools/airtable/framework/hermes-agent.md): Connect Airtable to Hermes Agent through Agent200's MCP server: managed OAuth, ready-made tools and one API key.
- [Airtable + OpenClaw](https://www.agent200.com/tools/airtable/framework/openclaw.md): Connect Airtable to OpenClaw through Agent200's MCP server: managed OAuth, ready-made tools and one API key.

## FAQ

### 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.

## Related connectors

- [Google Drive](https://www.agent200.com/tools/google-drive.md): Find, read and organize the files in each user's Drive.
- [OneDrive](https://www.agent200.com/tools/onedrive.md): Search, read, upload and share OneDrive files, including Word, Excel and PowerPoint documents, on behalf of each of your users.
- [Dropbox](https://www.agent200.com/tools/dropbox.md): Search, read, upload and organize Dropbox files, and create shared links, on behalf of each of your users.
- [Notion](https://www.agent200.com/tools/notion.md): Search, read and write Notion pages and databases on behalf of each of your users.

---

Agent200: https://www.agent200.com/ · API keys: https://agent200.com/platform/apikeys/ · Docs: https://docs.igpt.ai/
