自动化潜在客户情报
高级
这是一个Lead Generation领域的自动化工作流，包含 22 个节点。主要使用 If, Merge, Notion, ClickUp, Function 等节点。 自动化潜在客户情报：使用Clearbit丰富Google表格并同步到Notion和ClickUp
前置要求
- •Notion API Key
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "9KRdh9YURctQ9kIo",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "潜在客户资料丰富",
"tags": [
{
"id": "3LcAgx74tbyro0Qm",
"name": "lead-enrichment",
"createdAt": "2025-09-05T05:36:01.542Z",
"updatedAt": "2025-09-05T05:36:01.542Z"
},
{
"id": "VT2auW6qa9EXhGrO",
"name": "sales",
"createdAt": "2025-09-05T05:36:01.501Z",
"updatedAt": "2025-09-05T05:36:01.501Z"
}
],
"nodes": [
{
"id": "b5f6b0d6-369f-4c5f-b118-94a29839f8a9",
"name": "从邮箱提取域名",
"type": "n8n-nodes-base.function",
"position": [
-704,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "069a4d85-19c3-46b9-b759-4c8e5d9974c8",
"name": "获取公司 Logo",
"type": "n8n-nodes-base.httpRequest",
"position": [
-432,
-192
],
"parameters": {},
"typeVersion": 4.1
},
{
"id": "a729bd15-33db-441c-bc2f-a82c074587d3",
"name": "Clearbit 公司信息丰富",
"type": "n8n-nodes-base.httpRequest",
"position": [
-432,
0
],
"parameters": {},
"typeVersion": 4.1
},
{
"id": "6c4ef611-64ba-4913-a103-422ebd5d4aa7",
"name": "合并丰富数据",
"type": "n8n-nodes-base.function",
"position": [
64,
-80
],
"parameters": {},
"retryOnFail": false,
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "86cac053-0ae2-406f-ba48-ce2f92d90460",
"name": "附加到已丰富潜在客户表",
"type": "n8n-nodes-base.googleSheets",
"position": [
592,
-240
],
"parameters": {},
"typeVersion": 4
},
{
"id": "d9652af1-de37-4084-b206-a06b2434e023",
"name": "创建任务",
"type": "n8n-nodes-base.clickUp",
"position": [
352,
32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "19015249-6fcb-497e-8326-2635dbd72067",
"name": "检查是否未预订",
"type": "n8n-nodes-base.if",
"position": [
-976,
-80
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8557aea3-35f2-4664-85c8-fac0248c1173",
"name": "获取 sheet1 中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1200,
-80
],
"parameters": {},
"typeVersion": 4
},
{
"id": "bace46f7-0b1d-457b-9756-fb160f46a8d0",
"name": "点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1440,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a802822-cdde-401f-82a3-522e3ca98a76",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
-192,
-80
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "37248473-7f25-49f5-be69-87f71f8f89aa",
"name": "创建数据库页面",
"type": "n8n-nodes-base.notion",
"position": [
336,
-240
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "6a52ff0b-fbbf-4c71-8a15-1cc469216c1b",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1520,
-288
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "c0c3334c-a316-4d62-a9df-d8a497fb5a55",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1248,
112
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "89b26487-67da-4723-9912-4b5f5e52850b",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-336
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "a36e6320-2834-4fe9-83df-c5083a1453a7",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-768,
112
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "27b872b7-6892-4c6c-bf88-a03f972ca96a",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-512,
-432
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "33b11579-8056-47f2-a6b7-c8b0b96395ba",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
176
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "0f8134d0-9797-4e2d-bb31-9f698b1748e0",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
-240
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "739019a3-ef09-44d4-8d58-3aa1ed8ba4a1",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
80
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "8cc172f4-530f-4355-9480-9a01365f6c2d",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
304,
-464
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "09544996-9c73-4695-8214-9e213a4cf299",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
208
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "999336a9-ae3a-480c-8b48-568d2782f894",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
832,
-272
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ff63fd80-afca-4995-a991-478ed34df3c3",
"connections": {
"5a802822-cdde-401f-82a3-522e3ca98a76": {
"main": [
[
{
"node": "6c4ef611-64ba-4913-a103-422ebd5d4aa7",
"type": "main",
"index": 0
}
]
]
},
"069a4d85-19c3-46b9-b759-4c8e5d9974c8": {
"main": [
[
{
"node": "5a802822-cdde-401f-82a3-522e3ca98a76",
"type": "main",
"index": 0
}
]
]
},
"19015249-6fcb-497e-8326-2635dbd72067": {
"main": [
[
{
"node": "b5f6b0d6-369f-4c5f-b118-94a29839f8a9",
"type": "main",
"index": 0
}
]
]
},
"8557aea3-35f2-4664-85c8-fac0248c1173": {
"main": [
[
{
"node": "19015249-6fcb-497e-8326-2635dbd72067",
"type": "main",
"index": 0
}
]
]
},
"6c4ef611-64ba-4913-a103-422ebd5d4aa7": {
"main": [
[
{
"node": "37248473-7f25-49f5-be69-87f71f8f89aa",
"type": "main",
"index": 0
},
{
"node": "d9652af1-de37-4084-b206-a06b2434e023",
"type": "main",
"index": 0
}
]
]
},
"37248473-7f25-49f5-be69-87f71f8f89aa": {
"main": [
[
{
"node": "86cac053-0ae2-406f-ba48-ce2f92d90460",
"type": "main",
"index": 0
}
]
]
},
"b5f6b0d6-369f-4c5f-b118-94a29839f8a9": {
"main": [
[
{
"node": "069a4d85-19c3-46b9-b759-4c8e5d9974c8",
"type": "main",
"index": 0
},
{
"node": "a729bd15-33db-441c-bc2f-a82c074587d3",
"type": "main",
"index": 0
}
]
]
},
"a729bd15-33db-441c-bc2f-a82c074587d3": {
"main": [
[
{
"node": "5a802822-cdde-401f-82a3-522e3ca98a76",
"type": "main",
"index": 1
}
]
]
},
"86cac053-0ae2-406f-ba48-ce2f92d90460": {
"main": [
[]
]
},
"bace46f7-0b1d-457b-9756-fb160f46a8d0": {
"main": [
[
{
"node": "8557aea3-35f2-4664-85c8-fac0248c1173",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
新开发人员入职自动化
使用 GPT-4o 实现员工入职自动化：Jira、Notion 和 Gmail 集成
If
Set
Code
+
If
Set
Code
21 节点Rahul Joshi
人力资源
ClickUp中的任务分配与所有权
使用GPT-4 Mini的线索资质判定与自动分配：从Google Sheets到ClickUp
If
Code
Cron
+
If
Code
Cron
17 节点Rahul Joshi
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+
If
Set
Code
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用GPT-4o-mini、Gmail和ClickUp任务跟踪自动化候选人拒绝
使用GPT-4o-mini、Gmail和ClickUp任务跟踪自动化候选人拒绝
If
Code
Gmail
+
If
Code
Gmail
18 节点Rahul Joshi
人力资源
个性化拒绝/下一步邮件
使用Google Sheets、GPT-4o-mini、Gmail和ClickUp自动化候选人拒绝
If
Set
Code
+
If
Set
Code
38 节点Rahul Joshi
人力资源
退信与无效检测 (Gmail 触发器)
使用 Gmail、Google Sheets 和 Slack 自动化邮件退信与无效检测
Code
Cron
Gmail
+
Code
Cron
Gmail
26 节点Rahul Joshi
工作流信息
难度等级
高级
节点数量22
分类1
节点类型9
作者
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
外部链接
在 n8n.io 查看 →
分享此工作流