How to connect Airtable to ChatGPT

  • ChatGPT gets 12 Airtable tools through one Metorial MCP URL.
  • Setup is 4 steps; teammates then sign in with SSO.
  • You need a ChatGPT plan or workspace that allows custom MCP servers.

What ChatGPT can do with Airtable

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Ask ChatGPT to use the manage comment tool in Airtable
  • Ask ChatGPT to use the get record tool in Airtable
  • Ask ChatGPT to use the update records tool in Airtable
  • Ask ChatGPT to use the create records tool in Airtable
  • Ask ChatGPT to use the manage table tool in Airtable

Add the Airtable MCP server to ChatGPT

Run these once. Afterwards, everyone you give access to signs in the same way.

  1. 1. Enable Airtable in Metorial

    In your Metorial portal, enable the Airtable MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

  2. 2. Add a custom MCP server

    On ChatGPT web, open Plugins, select +, then Add custom MCP server.

  3. 3. Paste your Metorial MCP URL

    Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>), choose OAuth and accept the risk notice.

  4. 4. Create and install the plugin

    Select Create as a plugin, install it and sign in to load Airtable tools.

Give your team Airtable in ChatGPT

Once Airtable is enabled in Metorial, teammates sign in with SSO and get the same connection in ChatGPT, with only the tools their role allows.

One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.

Airtable tools available in ChatGPT

Full descriptions and inputs are on the Airtable MCP server page.

  • Upsert Records: Find, create, or update records in a single operation.
  • List Bases: List all Airtable bases the authenticated user has access to.
  • Manage Field: Create a new field or update an existing field in a table within the specified Airtable base.
  • Get Base Schema: Retrieve the full schema of the specified Airtable base, including all tables, their fields (with types and options), and views.
  • List Records: List records from a table in the specified Airtable base.
  • Manage Comment: List, create, update, or delete comments on a record in the specified Airtable base.
  • Get Record: Retrieve a single record by its ID from a table in the specified Airtable base.
  • Update Records: Update one or more existing records in a table in the specified Airtable base.
  • Create Records: Create one or more records in a table in the specified Airtable base.
  • Manage Table: Create a new table or update an existing table in the specified Airtable base.
  • Delete Records: Delete one or more records from a table in the specified Airtable base.
  • Upload Attachment: Upload a base64-encoded file directly into an Airtable attachment field on an existing record.

Using Airtable tools in ChatGPT

What to expect once Airtable is connected.

  • Type @ and pick the plugin. The selection applies to that message only, so @mention it again when a follow-up needs fresh Airtable data.
  • For write actions, ChatGPT may ask you to confirm first, depending on the app permissions and the action.
  • Once published for a workspace, ChatGPT keeps a snapshot of the tool list. When your team adds Airtable tools in Metorial, an admin refreshes the actions in Workspace settings before they appear.
  • You can use several apps in one prompt, for example read Airtable data and then create a ticket in another app.

Troubleshooting ChatGPT

Add custom MCP server is missing
Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.
The plugin exists but no tools appear
Creating the plugin is not enough: install it from your plugins, then start a new conversation so ChatGPT loads its tools.
ChatGPT answers without using the tools
Pick the plugin with @ in the composer and name the action you want, for example "use Metorial to look up the latest ticket".

Based on the ChatGPT MCP documentation.

Frequently asked questions

Common questions about connecting Airtable to AI agents with Metorial.

  1. Does ChatGPT support the Airtable MCP server?
    Yes. ChatGPT connects to the Airtable MCP server through its connector settings, pointed at your Metorial URL. You need a ChatGPT plan or workspace that allows custom MCP servers.
  2. No. You sign in to Airtable once through Metorial, and ChatGPT uses that connection. No API keys go into ChatGPT's settings.
  3. All 12 Airtable tools your team allows, such as Upsert Records, List Bases, Manage Field. Admins can narrow that list per team.
  4. Yes. Role-based access control decides who can use Airtable and which of its tools appear in ChatGPT, and every call is logged with the person's identity.
  5. Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.

Connect Airtable to other AI clients

Connect other apps to ChatGPT