Skip to main content

Connect Airtable

This guide explains how to use SU MCP Gateway to connect ChatGPT or Claude to Airtable.

Capabilities, sign-in, and setup

TopicDetails
What you can doList the bases you can access, create new bases and tables, add records, and read data.
Sign-in methodAirtable sign-in (often already authorized). Sharing a base requires a one-time sign-in to Airtable in the browser.
Connect promptUsing SU MCP Gateway, connect to my Airtable.

What you need to know

If you haven't already done so, set up SU MCP Gateway first and then come back here to connect Airtable.

  • Screenshots are from ChatGPT, but the prompts, sign-in pages, and confirmation screens look the same in Claude.
  • Connection links expire after 10 minutes. If yours expires, ask the assistant to connect again for a new link.

How to connect Airtable

Ask ChatGPT to connect Airtable. If you've authorized it before, ChatGPT connects right away and confirms which bases it can see.

ChatGPT connecting to Airtable, listing bases, and creating a new base with a table (opens larger image)
Airtable connects, lists your bases, and creates a new base with a table. (Select image to enlarge.)

Try these prompts

If you're not sure where to start, try one of these:

  • List all Airtable bases I can access using SU MCP Gateway.
  • Create a new base "SU MCP Gateway Airtable", add a table called "Table 1", and then add my name and email as a record.
  • Share it with colleague@stanford.edu.
ChatGPT confirming the new record and asking you to sign in to Airtable to share the base (opens larger image)
ChatGPT adds the record, then asks you to sign in to Airtable before it can share the base. (Select image to enlarge.)

Sharing a base

SU MCP Gateway can't share an Airtable base directly, so ChatGPT opens Airtable in its built-in browser and asks you to sign in. Here's what to do:

  1. When the Airtable sign-in page opens, click Continue with Google and choose your Stanford account.
  2. Once you're signed in, reply Signed in in ChatGPT.
  3. ChatGPT finishes sharing the base and confirms the access level it gave (for example, read-only).
Airtable sign-in page open next to the ChatGPT chat (opens larger image)
The Airtable sign-in page opens next to your chat. (Select image to enlarge.)
Google account picker for signing in to Airtable (opens larger image)
Choose your Stanford Google account to sign in to Airtable. (Select image to enlarge.)
ChatGPT confirming that it shared the base (opens larger image)
After you sign in, ChatGPT can see the base and completes the share. (Select image to enlarge.)
The new base in Airtable with your record in Table 1 (opens larger image)
The new base in Airtable with your record in Table 1. (Select image to enlarge.)

Get help

If you need assistance, submit a help request for your tool:

Be sure to include:

  • The app you tried to connect (Airtable)
  • What you typed and how the assistant responded
  • A screenshot of any error

For fixes to common problems, see the troubleshooting guide.

Last modified