8
n8n 中文网amn8n.com

Airtable MCP

中级

这是一个CRM, AI Chatbot领域的自动化工作流，包含 10 个节点。主要使用 AirtableTool, McpTrigger 等节点。 Airtable中的AI驱动联系人管理，支持自然语言命令

前置要求
  • •Airtable API Key

使用的节点 (10)

StickyNote
AirtableTool
McpTrigger

分类

客户关系管理
AI 聊天机器人
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "nNmc3DeecTU28eVM",
  "meta": {
    "instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
    "templateCredsSetupCompleted": true
  },
  "name": "Airtable MCP",
  "tags": [],
  "nodes": [
    {
      "id": "57d9bacd-3ff4-48b3-a253-f47cc8fde5ab",
      "name": "MCP 服务器触发器",
      "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": "获取记录",
      "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": "创建记录",
      "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": "删除记录",
      "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": "搜索记录",
      "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 触发器信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        20
      ],
      "parameters": {
        "color": null,
        "height": 260,
        "content": "🚀 **MCP 触发器**"
      },
      "typeVersion": 1
    },
    {
      "id": "2acfe724-42c5-4dd7-af33-47710e57b5b1",
      "name": "获取记录信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        500,
        340
      ],
      "parameters": {
        "color": null,
        "width": 220,
        "height": 140,
        "content": "🔍 **获取记录**"
      },
      "typeVersion": 1
    },
    {
      "id": "f5b8fc28-da04-476c-ab9c-28b9019e73b5",
      "name": "创建记录信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        620
      ],
      "parameters": {
        "color": "orange",
        "width": 220,
        "height": 140,
        "content": "➕ **创建记录**"
      },
      "typeVersion": 1
    },
    {
      "id": "75303405-11b5-4f16-8cb1-b6fc136373b5",
      "name": "删除记录信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1280,
        280
      ],
      "parameters": {
        "color": "red",
        "width": 200,
        "height": 120,
        "content": "🗑️ **删除记录**"
      },
      "typeVersion": 1
    },
    {
      "id": "59f20c23-144e-439e-a0fd-a37ef9ec0a43",
      "name": "搜索记录信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1060,
        640
      ],
      "parameters": {
        "color": "purple",
        "width": 220,
        "height": 140,
        "content": "🔎 **搜索记录**"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "f96d97b6-70a4-4e38-b6fd-9bc678fc548f",
  "connections": {
    "Get Record": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create Record": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Delete Record": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Search Record": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 客户关系管理, AI 聊天机器人

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

Gmail MCP工作流 - AI驱动的邮件管理
Gmail MCP工作流 - AI驱动的邮件管理
Gmail Tool
Mcp Trigger
15 节点David Olusola
工单管理
Google Sheets MCP - AI驱动的电子表格管理
Google Sheets MCP - AI驱动的电子表格管理系统
Google Sheets Tool
Mcp Trigger
15 节点David Olusola
文档提取
通过MCP服务器管理KlickTipp中的联系人
KlickTipp中的AI驱动联系人管理，通过MCP服务器
Tool Code
Klicktipp Tool
Mcp Trigger
+1
31 节点KlickTipp
客户关系管理
自动将新Calendly预约添加到Google表格
自动将新Calendly预约添加到Google表格
Code
Webhook
Google Sheets
+1
5 节点David Olusola
客户关系管理
为Zoom参会者自动创建Airtable CRM记录
为Zoom参会者自动创建Airtable CRM记录
Code
Webhook
Airtable
+1
4 节点David Olusola
客户关系管理
构建您的第一个带有备用模型的电子邮件代理
构建您的第一个自动化电子邮件支持代理（AI备用方案与日志记录）
Gmail
Gmail Trigger
Agent
+5
11 节点David Olusola
工单管理
工作流信息
难度等级
中级
节点数量10
分类2
节点类型3
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
David Olusola

David Olusola

@dae221

AI automation consultant working with ambitious businesses on their most complex operational challenges. For project inquiries, reach me at david@daexai.com

外部链接
在 n8n.io 查看 →

分享此工作流