基于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
使用的节点 (40)
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 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)可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
自适应邮件自动回复器(GPT-4、RAG和人工反馈循环)
自适应邮件自动回复器(GPT-4、RAG和人工反馈循环)
If
Set
Gmail
+15
38 节点LeeWei
内容创作
AI邮件分诊与GPT-4警报系统及Telegram通知
AI邮件分诊与GPT-4警报系统及Telegram通知
If
Set
Gmail
+22
104 节点Peter Joslyn
客户支持
演示邮件分享
通过AI、Telegram机器人和网站爬取创建个性化邮件外联
If
Set
Xml
+20
58 节点Michael A Putra
客户培育
使用AI、ElevenLabs、PIAPI Shotstack/Creatomate生成视频并发布到YouTube
使用AI、ElevenLabs、PIAPI Shotstack/Creatomate生成视频并发布到YouTube
If
Set
Code
+16
79 节点Immanuel
人工智能
AIAuto - 带深度研究的终极人机回环内容v2
WordPress博客自动化,集成Airtable界面、人工审核和AI研究v2
If
Set
Xml
+23
228 节点Daniel Ng
内容创作