8
n8n 中文网amn8n.com

基于Airtable CRM、Gmail和网络研究的AI销售助手

高级

这是一个Lead Nurturing, AI Chatbot领域的自动化工作流,包含 40 个节点。主要使用 If, Gmail, Switch, Airtable, Markdown 等节点。 基于Airtable CRM、Gmail和网络研究的AI销售助手

前置要求
  • Google 账号和 Gmail API 凭证
  • Airtable API Key
  • 可能需要目标 API 的认证凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "205780d3749915e5b72849aad8492ed96140f3a3cf0d7f077a27e6df51ded409",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "9b0ba1c4-5dd1-43f8-98e5-abfd7bd1d8dc",
      "name": "Airtable 触发器",
      "type": "n8n-nodes-base.airtableTrigger",
      "position": [
        1088,
        -1072
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9a344fcc-d384-4c60-acb3-99a44e46264d",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1888,
        -1104
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "c1e14790-ddb8-48f5-96e7-1ca20d4b63ff",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1888,
        -992
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "095cf6f4-8856-49ad-acf5-b9a7eb6e7866",
      "name": "条件分支",
      "type": "n8n-nodes-base.switch",
      "position": [
        1296,
        -1136
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "5710d262-9fe6-4031-bf3d-17a0229a084e",
      "name": "Google Docs",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -1472
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "0b045dbc-0c8c-4bc0-be60-fc0186844b10",
      "name": "Google Docs1",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -1312
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1d92913a-78c7-4d03-9445-4afafcd89252",
      "name": "Google Docs2",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -1152
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "62a4d242-49e5-4537-bfb6-e8fb1f1fea95",
      "name": "Google Docs3",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -992
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4bae46d2-5f57-43c3-af55-0886a89e54c1",
      "name": "Google Docs4",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -848
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "27eebad7-0a72-4e00-9868-22d6bf522d2a",
      "name": "Google Docs5",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -688
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "b807198b-8fc2-4331-bed4-c1f51ce7c547",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        2048,
        -992
      ],
      "webhookId": "2dd23eca-0dc7-4a28-affa-b43c29d654f7",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "788f1409-ed9d-4b00-a347-d34c99515ea3",
      "name": "Gmail 触发器",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -1104,
        -1040
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "2bf44ed5-f20b-4fe1-89e3-01e35d53a264",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -592,
        -1168
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "335ea4a6-c1bc-4318-94bb-3942b8326cb9",
      "name": "添加潜在客户到 CRM",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -592,
        -1280
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "e8da2651-0cf3-44d7-bd0d-5481a78f76da",
      "name": "OpenAI 聊天模型2",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        352,
        -1088
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "8e41c355-03cc-41e4-9a17-be85572f7db5",
      "name": "潜在客户摘要 Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        384,
        -1280
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "c093dea0-c354-47cb-89ac-974f36bd7048",
      "name": "Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        16,
        -1280
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4fa09741-3a4c-4844-859c-fda44a4e8485",
      "name": "查找网站 URL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -288,
        -1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "c629527b-7105-4a46-8a7b-36dc53dd5574",
      "name": "抓取网站 URL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -144,
        -1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "f5e0c3ec-331d-42e9-86fb-d745dc81dea9",
      "name": "查找 LinkedIn URL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        208,
        -1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "e3e621d9-30fa-4fda-85c6-fb532c4ecd90",
      "name": "Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        672,
        -1280
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "b9e4481b-06de-4990-8113-bd1392632750",
      "name": "Airtable1",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        -240,
        -688
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "bb1d0afb-459c-449a-935b-7d986477f0a2",
      "name": "Airtable2",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        -128,
        -688
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "1227903a-ea70-43db-81d7-c1e1fbd74d53",
      "name": "Airtable3",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -592,
        -944
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "8f63a0b4-7624-4ea4-94bd-f5ab3bac8b4c",
      "name": "条件判断",
      "type": "n8n-nodes-base.if",
      "position": [
        -432,
        -944
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "38dbcccb-b8fc-4304-8955-ba3a390e8898",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -432,
        -1168
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "6b04ceb7-3383-41dc-a1a9-7c96cb90973b",
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        496,
        -976
      ],
      "webhookId": "e14c59fb-727d-4ee5-bc45-fed20e4ff4fa",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "957b79c2-7047-43b1-b119-6f941895aba1",
      "name": "结构化输出解析器1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        112,
        -736
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "306b01c1-ad55-4982-a3ff-985ca503095f",
      "name": "条件分支1",
      "type": "n8n-nodes-base.switch",
      "position": [
        304,
        -960
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "19c7245a-8849-4517-881f-a4a77e0e2e8d",
      "name": "AI Agent1",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -224,
        -960
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "bdf20c43-42e9-499d-9423-b3e50bb8c245",
      "name": "OpenAI 聊天模型3",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -320,
        -816
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "52910e39-56c9-447e-b58d-3e56432907c3",
      "name": "条件分支2",
      "type": "n8n-nodes-base.switch",
      "position": [
        -896,
        -1040
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "aa51ae7c-7a98-456f-88f3-5c1ab6d6292b",
      "name": "Gmail2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        128,
        -960
      ],
      "webhookId": "c1084588-31cf-48dc-83f5-3b701ae3683d",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "34f72c0c-d550-4d02-b31c-db242eff2d2c",
      "name": "Google Docs6",
      "type": "n8n-nodes-base.googleDocsTool",
      "position": [
        -32,
        -688
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "da40f628-84dd-475c-a33f-e5ea3f0da0c2",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2096,
        -1552
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ac9acec8-abd0-41be-80c3-f7d9b87ef63f",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1168,
        -1248
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1cb01be9-7a02-426e-9b66-db914bd95ad8",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -1472
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0ff676d6-4c73-4156-be91-5b11001cee0c",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -1376
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "03a716df-9943-46da-a7c4-eecf08c32c50",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        -1568
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0e2a64cd-dcc3-4937-a7a9-120bac1c7ad9",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -1568
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "AI Agent1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Gmail2": {
      "main": [
        [
          {
            "node": "Switch1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Google Docs",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs3",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs4",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch1": {
      "main": [
        [
          {
            "node": "Gmail1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch2": {
      "main": [
        [
          {
            "node": "Add lead to CRM",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Airtable3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Markdown": {
      "main": [
        [
          {
            "node": "Find Linkedin URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent1": {
      "main": [
        [
          {
            "node": "Gmail2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Airtable1": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Airtable2": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Airtable3": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs1": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs2": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs3": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs4": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs5": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs6": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Gmail Trigger": {
      "main": [
        [
          {
            "node": "Switch2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add lead to CRM": {
      "main": [
        [
          {
            "node": "Find website URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Airtable Trigger": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find website URL": {
      "main": [
        [
          {
            "node": "Scrape website URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Linkedin URL": {
      "main": [
        [
          {
            "node": "Lead summary Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Lead summary Agent": {
      "main": [
        [
          {
            "node": "Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Add lead to CRM",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "Lead summary Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model3": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Scrape website URL": {
      "main": [
        [
          {
            "node": "Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Add lead to CRM",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 客户培育, AI 聊天机器人

需要付费吗?

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

工作流信息
难度等级
高级
节点数量40
分类2
节点类型16
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

外部链接
在 n8n.io 查看

分享此工作流