Skip to content

How to Connect Airtable to ChatGPT with CorpusIQ MCP

Airtable holds the work that never makes it into a reporting tool: the content calendar, the hiring pipeline, the partnership tracker, the product roadmap. The records are current and the answers are not, because nobody exports a base to answer one question. Connecting Airtable to ChatGPT through CorpusIQ MCP makes those bases queryable in plain English, read-only, against the records as they stand.

Direct MCP retrieval is read-only and does not retain raw customer files or full connector response payloads; operational query logs are retained for up to 30 days.

What Questions Can You Ask?

  • "Which items in the content calendar are still in Draft two weeks before publish?"
  • "Show me every record in the hiring pipeline where stage is Onsite."
  • "How many partnership conversations are waiting on legal?"
  • "Pull the roadmap rows owned by the platform team and list their status."
  • "Which Airtable records mention this customer by name?"

The useful questions are usually the join questions. Airtable holds the commitment; the invoice, the ticket and the campaign hold the consequence. One question across both is the reason to connect the base at all.

FAQ: Common Questions

Is this read-only? Yes. The connector lists bases, tables, records and single records, and searches records by keyword. It never creates, edits or deletes a record, and it cannot change a base schema.
How does the connection authenticate? With an Airtable personal access token that you create. The token carries two read scopes, `data.records:read` and `schema.bases:read`, and it is granted access to specific bases. Anything the token cannot reach, the connector cannot see, which makes the token scope the whole permission model.
Do I need to share every base? No, and you probably should not. Grant the token the bases a question would actually use. A base you never ask about is a base you do not need to expose, and revoking it later is an edit to the token rather than a support request.
Can it answer across Airtable and my other systems? Yes, and that is the point of putting the base behind an MCP connector rather than opening Airtable in a second tab. "Which blocked roadmap items belong to accounts with an open support ticket" spans Airtable, the CRM and the helpdesk in one answer.
What about views and filters? The connector reads records from a table. Where a base uses views to hide archived or test rows, say so in the question, for example "active rows only, not the archive view". A view you rely on for filtering becomes a sentence in the question rather than a hidden default.
How current is the data? Live. When you ask, the connector reads Airtable as it stands. A record edited a minute ago is visible to the next question.
Where is my data stored? CorpusIQ does not retain raw customer files or full connector response payloads. Retrieval happens on demand. Operational query logs may persist for up to 30 days. See our [security documentation](../security/) for the detail.

How It Works

  1. You create an Airtable personal access token, give it the two read scopes and grant it the bases you want visible.
  2. You paste the token into CorpusIQ and the connector turns green.
  3. You add the CorpusIQ MCP server to ChatGPT. See the Quick Start guide.
  4. ChatGPT discovers the Airtable tools and calls them when a question needs base data.
  5. Answers name the base, table and record they came from.

Setup Guide

  1. Sign up at corpusiq.io. The 30-day trial needs no credit card.
  2. Create the token. Airtable, Developer hub, Personal access tokens, then add data.records:read and schema.bases:read and select the bases.
  3. Connect Airtable in the CorpusIQ dashboard with that token.
  4. Connect ChatGPT. Add the CorpusIQ MCP server per the Quick Start guide.
  5. Verify. Ask "list my bases" first. If the base list is right, the scope is right.
  6. Explore. Then ask the pipeline question that has been a manual filter for months.

Part of the MCP knowledge base at corpusiq.io - connect 40+ business tools to AI.

AI answers on your data. See where every number comes from.

Connect your tools and ask in ChatGPT, Claude, or Perplexity. Enterprise-grade answers in minutes. From $29.95/month.

Start free, no credit card
Contact Terms Privacy Pricing