Connect Your Airtable Data to Your AI (chatgpt, Claude Etc.) with an Mcp

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "nodes": [
    {
      "id": "9bb5111f-da86-46a0-87cb-9a04c1f62741",
      "name": "Search Contacts",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        144,
        208
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "app1bfDNQWWNpiwal",
          "cachedResultUrl": "https://airtable.com/app1bfDNQWWNpiwal",
          "cachedResultName": "Contacts (YT n8n Tutorial Base)"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblubuxXAzrkV59GY",
          "cachedResultUrl": "https://airtable.com/app1bfDNQWWNpiwal/tblubuxXAzrkV59GY",
          "cachedResultName": "Contacts"
        },
        "options": {},
        "operation": "search"
      },
      "credentials": {
        "airtableTokenApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "215ec127-f9f9-41ca-8806-dba42671774a",
      "name": "Search Companies",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        304,
        208
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "app1bfDNQWWNpiwal",
          "cachedResultUrl": "https://airtable.com/app1bfDNQWWNpiwal",
          "cachedResultName": "Contacts (YT n8n Tutorial Base)"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblih4kyMEc5y5Fsx",
          "cachedResultUrl": "https://airtable.com/app1bfDNQWWNpiwal/tblih4kyMEc5y5Fsx",
          "cachedResultName": "Companies"
        },
        "options": {},
        "operation": "search"
      },
      "credentials": {
        "airtableTokenApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "561a7b86-873e-4140-a5a9-d325f8c4aaa8",
      "name": "Airtable CRM MCP Trigger",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        48,
        0
      ],
      "parameters": {
        "path": "20c5d050-e533-469d-a15e-98da73e32cf7"
      },
      "typeVersion": 2
    },
    {
      "id": "doc-note-1771263655470",
      "name": "Workflow Description",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -652,
        -150
      ],
      "parameters": {
        "width": 600,
        "height": 894,
        "content": "## Workflow Overview\n\nThis workflow creates an MCP (Model-Client-Protocol) server that exposes your Airtable data as AI-powered tools, allowing external applications like ChatGPT or custom GPTs to query your data using natural language.\n\n### First Setup\n\n1. **Airtable Connection**: Create an Airtable Personal Access Token at airtable.com/create/tokens with the following scopes:\n   - `data.records:read`\n   - `data.records:write`\n   - `schema.bases:read`\n\n2. **n8n Credential**: Add the token to n8n by creating a new Airtable Personal Access Token API credential.\n\n3. **External Application**: To use this server, enable Developer Mode in ChatGPT settings (or your preferred AI client) and add the MCP Server URL as a new app.\n\n### Configuration\n\n- **Airtable Base & Tables**: Update both Airtable Tool nodes to point to your own Airtable base and tables instead of the default Contacts and Companies tables.\n- **Search Tools**: Customize which tables are searchable or add additional Airtable Tool nodes for more tables.\n- **MCP Endpoint**: After publishing, copy the Production URL from the MCP Server Trigger node to connect external applications.\n\nOnce configured and published, external AI applications can query your Airtable data in real-time using natural language."
      },
      "typeVersion": 1
    },
    {
      "id": "contact-note-1771263708643",
      "name": "Creator Contact Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -652,
        -610
      ],
      "parameters": {
        "color": 5,
        "width": 600,
        "height": 440,
        "content": "# Contact Us:\n## Milan @ SmoothWork - [Book a Free Consulting Call](https://smoothwork.ai/book-a-call/)\n![Milan](https://gravatar.com/avatar/95700d17ba300a9f14c1b8cacf933df7720027b3adda9cbe6183d89142925422?r=pg&d=retro&size=100)\n\n\n### We help businesses eliminate busywork by building compact business tools tailored to your process.\n### Contact us for customizing this, or building similar automations.\n\n\ud83d\udce7 hello@smoothwork.ai\n\u25b6\ufe0f [Check us on YouTube](https://www.youtube.com/@vasarmilan)\n\ud83d\udcde [Book a Free Consulting Call](https://smoothwork.ai/book-a-call/)\n\ud83d\udcbc [Add me on Linkedin](https://www.linkedin.com/in/mil%C3%A1n-v%C3%A1s%C3%A1rhelyi-3a9985123/)\n"
      },
      "typeVersion": 1
    },
    {
      "id": "video-note-1771324743905",
      "name": "Video Walkthrough",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -42,
        -610
      ],
      "parameters": {
        "width": 420,
        "height": 340,
        "content": "# Video Walkthrough\n[![image.png](https://vasarmilan-public.s3.us-east-1.amazonaws.com/blog_thumbnails/thumbnail_recidrbznaXlmqFUI.jpg)](https://youtu.be/lQh1fuIrBN8)"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Search Contacts": {
      "ai_tool": [
        [
          {
            "node": "Airtable CRM MCP Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Search Companies": {
      "ai_tool": [
        [
          {
            "node": "Airtable CRM MCP Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• airtableTokenApi

About this workflow

[](https://youtu.be/lQh1fuIrBN8)

Source: https://n8n.io/workflows/13458/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.