基于公司ID的Apollo数据丰富
高级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 27 个节点。主要使用 If, Set, Code, Wait, Webhook 等节点。 使用Apollo、Google Sheets和Telegram基于公司ID丰富采购联系人
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (27)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "qaJfgkpdXGb8k24x",
"meta": {
"instanceId": "a5fd400c6ce3e6fce31bb31916a9cfa04e30e08115d80423a7e69507457fa5bb",
"templateCredsSetupCompleted": true
},
"name": "基于公司ID的Apollo数据丰富",
"tags": [],
"nodes": [
{
"id": "d30e14d8-f655-40c1-9d7a-447bee02a0a3",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7f7f9dd6-e4a0-40dc-abd1-7745b44915c0",
"name": "获取Apollo公司ID",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1120,
176
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "3fc379b1-8a06-4679-ae22-a8cfd96aea27",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1024,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2989f2c4-72d2-44c7-9a7b-14602ce3d50d",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c1e3b29e-6fe6-422a-83be-0b5f503ff295",
"name": "每X分钟运行一次",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1344,
176
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7c282ce1-a55f-462b-8e8e-e750e93e56c4",
"name": "定义搜索设置",
"type": "n8n-nodes-base.set",
"position": [
-896,
96
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "51c50d90-3255-4ad4-9df8-ae363c30d578",
"name": "构建搜索过滤器",
"type": "n8n-nodes-base.code",
"position": [
-672,
96
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8a6c4aa8-efd6-42d7-94ce-4f0bb6ca1bf6",
"name": "在Apollo中搜索人员",
"type": "n8n-nodes-base.httpRequest",
"position": [
-448,
96
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2735375c-b77d-4731-a8cd-039650a0bbdf",
"name": "检查是否找到任何人员",
"type": "n8n-nodes-base.if",
"position": [
-224,
96
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "09c1ff30-dc21-458c-bf4a-cda5a8eface1",
"name": "逐个处理每个人员",
"type": "n8n-nodes-base.splitOut",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "74f3c36c-8061-4340-841b-80c254b3b19e",
"name": "获取人员联系方式",
"type": "n8n-nodes-base.httpRequest",
"position": [
224,
0
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "beedf603-a9ec-426d-bf06-eebfbe4038bb",
"name": "将人员保存到Google表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
448,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "33396597-906e-4f3f-8eb7-1d5a2ea844aa",
"name": "标记公司为已处理",
"type": "n8n-nodes-base.googleSheets",
"position": [
672,
0
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "10da57e6-5e86-4be4-900c-41e18b334c8d",
"name": "标记公司为已处理（未找到人员）",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
192
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "1b0d5877-2481-4b1b-9045-5bc956fd82e2",
"name": "下次运行前暂停",
"type": "n8n-nodes-base.wait",
"position": [
224,
272
],
"webhookId": "51474388-57cf-4e38-a767-8f8196e84cc6",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "cd1b1771-084b-4dd5-91ce-c9a318869bbf",
"name": "标题转换器",
"type": "n8n-nodes-base.code",
"position": [
-1264,
-240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3514a5b1-f374-478d-9870-06002bd80e1b",
"name": "捕获工作流错误",
"type": "n8n-nodes-base.errorTrigger",
"position": [
-960,
-240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c283f810-85d4-4438-9112-767f1772b21f",
"name": "格式化错误消息",
"type": "n8n-nodes-base.code",
"position": [
-736,
-240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d7999a31-37be-4d14-a43c-73a9c200dd67",
"name": "发送警报到Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
-512,
-240
],
"webhookId": "13c616bf-a3ad-4035-998a-1dfe6021b89f",
"parameters": {},
"typeVersion": 1
},
{
"id": "d3336603-7afa-4a15-ac87-87a62fc77651",
"name": "接收潜在客户（第1组）",
"type": "n8n-nodes-base.webhook",
"position": [
176,
-256
],
"webhookId": "0910622f-082b-4c49-a682-ad6690d249bb",
"parameters": {},
"typeVersion": 2
},
{
"id": "ccbcb046-3ceb-496d-9765-89c80dd9a598",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3751fc7a-da17-479e-a6f6-2d9b5cf62b9c",
"name": "保存潜在客户电话到表格",
"type": "n8n-nodes-base.googleSheets",
"maxTries": 2,
"position": [
400,
-256
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.6,
"alwaysOutputData": true,
"waitBetweenTries": 5000
},
{
"id": "250e4cf4-97b9-44fa-823e-78aae48afc2e",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1376,
528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7649e4f9-3b3c-4115-acc3-35395c073e11",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-736,
528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9d37d548-98a2-46e9-8de3-98532e943773",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "edeaac58-c1d9-4efe-aea2-bf45eb1204e4",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
368,
528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ad71ed51-0f46-4c6a-9ce5-aa98b2b21c07",
"name": "通知：成功",
"type": "n8n-nodes-base.telegram",
"position": [
608,
-256
],
"webhookId": "0bc118e2-6b60-4a22-8eb3-038f2aa0c643",
"parameters": {},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e5c2654d-6642-455b-bfbf-acbd8a2ed455",
"connections": {
"Run Every X Minutes": {
"main": [
[
{
"node": "Get Apollo Company ID",
"type": "main",
"index": 0
}
]
]
},
"Build Search Filters": {
"main": [
[
{
"node": "Search People in Apollo",
"type": "main",
"index": 0
}
]
]
},
"Catch Workflow Error": {
"main": [
[
{
"node": "Format Error Message",
"type": "main",
"index": 0
}
]
]
},
"Format Error Message": {
"main": [
[
{
"node": "Send Alert to Telegram",
"type": "main",
"index": 0
}
]
]
},
"Get Apollo Company ID": {
"main": [
[
{
"node": "Define Search Settings",
"type": "main",
"index": 0
}
]
]
},
"Pause Before Next Run": {
"main": [
[
{
"node": "Get Apollo Company ID",
"type": "main",
"index": 0
}
]
]
},
"Define Search Settings": {
"main": [
[
{
"node": "Build Search Filters",
"type": "main",
"index": 0
}
]
]
},
"Receive Lead (Group 1)": {
"main": [
[
{
"node": "Save Lead Phone to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Search People in Apollo": {
"main": [
[
{
"node": "Check if Any People Found",
"type": "main",
"index": 0
}
]
]
},
"Save Lead Phone to Sheet": {
"main": [
[
{
"node": "Notify: Success",
"type": "main",
"index": 0
}
]
]
},
"Check if Any People Found": {
"main": [
[
{
"node": "Process Each Person One by One",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark Company as Processed (No Person Found)",
"type": "main",
"index": 0
}
]
]
},
"Get Person Contact Details": {
"main": [
[
{
"node": "Save Person to Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Save Person to Google Sheet": {
"main": [
[
{
"node": "Mark Company as Processed",
"type": "main",
"index": 0
}
]
]
},
"Process Each Person One by One": {
"main": [
[
{
"node": "Get Person Contact Details",
"type": "main",
"index": 0
}
]
]
},
"Mark Company as Processed (No Person Found)": {
"main": [
[
{
"node": "Pause Before Next Run",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动化Leadfeeder和Apollo.io数据收集
线索丰富管道：从Leadfeeder到Apollo再到Google Sheets
If
Set
Code
+9
23 节点Khairul Muhtadin
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
1. 播放列表详情设置机器人副本
使用 Suno、GPT-4、Runway 和 Creatomate 创建 AI 生成的 YouTube 音乐播放列表
If
Set
Code
+22
203 节点Joseph
内容创作
合并
使用Suno API、Claude和Telegram机器人创建完整的20首YouTube播放列表
If
Set
Code
+17
150 节点Joseph
内容创作
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
基于 AI、社交媒体和 WhatsApp 链接的自动化本地商业线索生成器
使用 AI、社交媒体和 WhatsApp 链接自动生成本地商业线索
If
Code
Limit
+9
29 节点Budi SJ
潜在客户开发
