Airtable MCP

Name: Airtable MCP
Rating: 4.5 (10 reviews)
Author: David Olusola

Fortgeschritten

Dies ist ein CRM, AI Chatbot-Bereich Automatisierungsworkflow mit 10 Nodes. Hauptsächlich werden AirtableTool, McpTrigger und andere Nodes verwendet. KI-gesteuertes Kontaktmanagement in Airtable mit Unterstützung für natürliche Sprachbefehle

Voraussetzungen

•Airtable API Key

Verwendete Nodes (10)

StickyNote

AirtableTool

McpTrigger

Kategorie

Kundenbeziehungsmanagement

KI-Chatbot

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

MCP Server Trigger

Get Record

Create Record

Delete Record

Search Record

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "nNmc3DeecTU28eVM",
  "meta": {
    "instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
    "templateCredsSetupCompleted": true
  },
  "name": "Airtable MCP",
  "tags": [],
  "nodes": [
    {
      "id": "57d9bacd-3ff4-48b3-a253-f47cc8fde5ab",
      "name": "MCP Server Trigger",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        780,
        120
      ],
      "webhookId": "your-webhook-id-here",
      "parameters": {
        "path": "your-webhook-path-here"
      },
      "typeVersion": 1.1
    },
    {
      "id": "5e1eb7f9-a1c7-44fc-acb2-38ea6b407896",
      "name": "Get Record",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        720,
        380
      ],
      "parameters": {
        "id": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Record_ID', ``, 'string') }}",
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_BASE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
          "cachedResultName": "contacts"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_TABLE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
          "cachedResultName": "contact data"
        },
        "options": {}
      },
      "typeVersion": 2.1
    },
    {
      "id": "6226cd66-19b5-4751-8db9-d0f45f017292",
      "name": "Create Record",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        860,
        580
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_BASE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
          "cachedResultName": "contacts"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_TABLE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
          "cachedResultName": "contact data"
        },
        "columns": {
          "value": {
            "Name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Name', ``, 'string') }}",
            "email": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('email', ``, 'string') }}",
            "Assignee": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Assignee', ``, 'string') }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Assignee",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Assignee",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "options",
              "display": true,
              "options": [
                {
                  "name": "Todo",
                  "value": "Todo"
                },
                {
                  "name": "In progress",
                  "value": "In progress"
                },
                {
                  "name": "Done",
                  "value": "Done"
                }
              ],
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "create"
      },
      "typeVersion": 2.1
    },
    {
      "id": "a6ec7651-1953-4c92-8a51-21f9c130df0c",
      "name": "Delete Record",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1200,
        360
      ],
      "parameters": {
        "id": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Record_ID', ``, 'string') }}",
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_BASE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
          "cachedResultName": "contacts"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_TABLE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
          "cachedResultName": "contact data"
        },
        "operation": "deleteRecord"
      },
      "typeVersion": 2.1
    },
    {
      "id": "303338ab-02c7-45ed-9978-31e254c9d34b",
      "name": "Search Record",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1060,
        520
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_BASE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID",
          "cachedResultName": "contacts"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_AIRTABLE_TABLE_ID",
          "cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID",
          "cachedResultName": "contact data"
        },
        "options": {},
        "operation": "search",
        "filterByFormula": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Filter_By_Formula', ``, 'string') }}"
      },
      "typeVersion": 2.1
    },
    {
      "id": "39d9b303-de3f-4af4-a464-26be930dda40",
      "name": "MCP Trigger Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        20
      ],
      "parameters": {
        "color": null,
        "height": 260,
        "content": "🚀 **MCP TRIGGER**\n**AUTHOR DAVID OLUSOLA**\n\nThis is the entry point for AI interactions. When an AI assistant needs to manage contacts, it triggers this workflow through the Model Context Protocol (MCP).\n\n**Function**: Receives AI requests and routes them to appropriate Airtable operations."
      },
      "typeVersion": 1
    },
    {
      "id": "2acfe724-42c5-4dd7-af33-47710e57b5b1",
      "name": "Get Record Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        500,
        340
      ],
      "parameters": {
        "color": null,
        "width": 220,
        "height": 140,
        "content": "🔍 **GET RECORD**\n\nRetrieves a specific contact record from Airtable using the Record ID.\n\n**Input**: Record_ID from AI\n**Output**: Complete contact details\n**Use Case**: \"Show me details for contact ID xyz\""
      },
      "typeVersion": 1
    },
    {
      "id": "f5b8fc28-da04-476c-ab9c-28b9019e73b5",
      "name": "Create Record Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        620
      ],
      "parameters": {
        "color": "orange",
        "width": 220,
        "height": 140,
        "content": "➕ **CREATE RECORD**\n\nAdds a new contact to the Airtable database.\n\n**Inputs**: Name, Email, Assignee\n**Output**: New record with auto-generated ID\n**Use Case**: \"Add John Doe with email john@example.com\""
      },
      "typeVersion": 1
    },
    {
      "id": "75303405-11b5-4f16-8cb1-b6fc136373b5",
      "name": "Delete Record Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1280,
        280
      ],
      "parameters": {
        "color": "red",
        "width": 200,
        "height": 120,
        "content": "🗑️ **DELETE RECORD**\n\nRemoves a contact from the database permanently.\n\n**Input**: Record_ID from AI\n**Output**: Confirmation of deletion\n**Use Case**: \"Delete contact ID xyz\""
      },
      "typeVersion": 1
    },
    {
      "id": "59f20c23-144e-439e-a0fd-a37ef9ec0a43",
      "name": "Search Record Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1060,
        640
      ],
      "parameters": {
        "color": "purple",
        "width": 220,
        "height": 140,
        "content": "🔎 **SEARCH RECORDS**\n\nFinds contacts based on specific criteria using Airtable formulas.\n\n**Input**: Filter_By_Formula from AI\n**Output**: Matching contact records\n**Use Case**: \"Find all contacts assigned to Sarah\""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "f96d97b6-70a4-4e38-b6fd-9bc678fc548f",
  "connections": {
    "5e1eb7f9-a1c7-44fc-acb2-38ea6b407896": {
      "ai_tool": [
        [
          {
            "node": "57d9bacd-3ff4-48b3-a253-f47cc8fde5ab",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "6226cd66-19b5-4751-8db9-d0f45f017292": {
      "ai_tool": [
        [
          {
            "node": "57d9bacd-3ff4-48b3-a253-f47cc8fde5ab",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "a6ec7651-1953-4c92-8a51-21f9c130df0c": {
      "ai_tool": [
        [
          {
            "node": "57d9bacd-3ff4-48b3-a253-f47cc8fde5ab",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "303338ab-02c7-45ed-9978-31e254c9d34b": {
      "ai_tool": [
        [
          {
            "node": "57d9bacd-3ff4-48b3-a253-f47cc8fde5ab",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}

Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Kundenbeziehungsmanagement, KI-Chatbot

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.