潜在客户资料丰富
高级
这是一个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": {
"Merge": {
"main": [
[
{
"node": "Merge Enrichment Data",
"type": "main",
"index": 0
}
]
]
},
"Get Company Logo": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Check If Unbooked": {
"main": [
[
{
"node": "Extract Domain from Email",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet1": {
"main": [
[
{
"node": "Check If Unbooked",
"type": "main",
"index": 0
}
]
]
},
"Merge Enrichment Data": {
"main": [
[
{
"node": "Create a database page",
"type": "main",
"index": 0
},
{
"node": "Create a task",
"type": "main",
"index": 0
}
]
]
},
"Create a database page": {
"main": [
[
{
"node": "Append to Enriched Leads Sheet",
"type": "main",
"index": 0
}
]
]
},
"Extract Domain from Email": {
"main": [
[
{
"node": "Get Company Logo",
"type": "main",
"index": 0
},
{
"node": "Clearbit Company Enrichment",
"type": "main",
"index": 0
}
]
]
},
"Clearbit Company Enrichment": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Append to Enriched Leads Sheet": {
"main": [
[]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Get row(s) in sheet1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Lead Generation等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
新开发人员入职自动化
使用 GPT-4o 实现员工入职自动化：Jira、Notion 和 Gmail 集成
If
Set
Code
+9
21 节点Rahul Joshi
HR
使用 Google Forms、Sheets 和 GoHighLevel CRM 自动处理潜在客户录入与去重
使用 Google Forms、Sheets 和 GoHighLevel CRM 自动处理潜在客户录入与去重
If
Code
Filter
+4
18 节点Rahul Joshi
Lead Generation
ClickUp中的任务分配与所有权
使用GPT-4 Mini的线索资质判定与自动分配：从Google Sheets到ClickUp
If
Code
Cron
+5
17 节点Rahul Joshi
Lead Generation
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
Lead Generation
结构化面试反馈收集
使用GPT-4o-mini、Gmail和ClickUp任务跟踪自动化候选人拒绝
If
Code
Gmail
+6
18 节点Rahul Joshi
HR
个性化拒绝/下一步邮件
使用Google Sheets、GPT-4o-mini、Gmail和ClickUp自动化候选人拒绝
If
Set
Code
+7
38 节点Rahul Joshi
HR
工作流信息
难度等级
高级
节点数量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 上查看 →
分享此工作流