自动化Leadfeeder和Apollo.io数据收集
高级
这是一个Lead Generation、Multimodal AI领域的自动化工作流，包含 23 个节点。主要使用 If、Set、Code、Wait、SplitOut 等节点。 线索丰富管道：从Leadfeeder到Apollo再到Google Sheets
前置要求
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (23 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "cFNi1b3jO3XvSvAn",
"meta": {
"instanceId": "c2650793f644091dc80fb900fe63448ad1f4b774008de9608064d67294f8307c",
"templateCredsSetupCompleted": true
},
"name": "自动化Leadfeeder和Apollo.io数据收集",
"tags": [],
"nodes": [
{
"id": "a2faf2da-24c3-4972-994d-9dabe6feb7a6",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e4218112-f685-4ade-8265-365cf01382f7",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
512
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7ffd56d9-f27d-41e3-95d4-6b3a55bcc1da",
"name": "每日触发器（上午9点）",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
112,
288
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7515cbdd-ef25-45dd-9118-5d8b9eef2569",
"name": "获取Leadfeeder账户ID",
"type": "n8n-nodes-base.httpRequest",
"position": [
352,
288
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3a901947-6a9d-4240-b8e3-80a0e603618b",
"name": "生成分页序列",
"type": "n8n-nodes-base.code",
"position": [
576,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4657e075-050e-4e99-a214-dbb30b5f2221",
"name": "分页控制器",
"type": "n8n-nodes-base.splitInBatches",
"position": [
800,
288
],
"parameters": {},
"typeVersion": 3
},
{
"id": "15f367cc-6031-4440-a13d-952cbc09e245",
"name": "分配当前页码",
"type": "n8n-nodes-base.set",
"position": [
1024,
208
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "86fc67c9-12e5-4dfa-9b63-d49f9059d4e8",
"name": "检索潜在客户数据（Leadfeeder）",
"type": "n8n-nodes-base.httpRequest",
"position": [
1248,
208
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7db9202f-9978-4716-9016-7cf2056b3f07",
"name": "检查最后一页条件",
"type": "n8n-nodes-base.if",
"position": [
1472,
208
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "aebd0481-ac90-4494-bff9-e8d11fc17a30",
"name": "提取潜在客户（最后一页）",
"type": "n8n-nodes-base.splitOut",
"position": [
1696,
96
],
"parameters": {},
"typeVersion": 1
},
{
"id": "230f4943-0fbd-4cde-a22c-f60123b65f74",
"name": "使用Apollo丰富数据（最后一页）",
"type": "n8n-nodes-base.httpRequest",
"position": [
1920,
96
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "791cd99d-59d4-4746-bec5-e59cffe11b28",
"name": "将潜在客户保存到Google Sheets（最后一页）",
"type": "n8n-nodes-base.googleSheets",
"position": [
2144,
96
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "26c5e81a-027a-4466-ba34-ce3580d958ba",
"name": "提取潜在客户（完整页面）",
"type": "n8n-nodes-base.splitOut",
"position": [
1696,
304
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e7f593b8-edb3-4aa4-86d3-3f553457a3ff",
"name": "使用Apollo丰富数据（完整页面）",
"type": "n8n-nodes-base.httpRequest",
"position": [
1920,
304
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "78ccfdc1-8bd7-4425-b270-4322c248d9c5",
"name": "将潜在客户保存到Google Sheets（完整页面）",
"type": "n8n-nodes-base.googleSheets",
"position": [
2144,
304
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "aba38dd5-79eb-41c5-8dda-111fa923ef82",
"name": "速率限制延迟（40秒）",
"type": "n8n-nodes-base.wait",
"position": [
2368,
384
],
"webhookId": "f63348ce-885c-4ba0-bfa2-c14872449c1f",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "9bbd30ee-e365-4e11-a462-8efc1eba2ccb",
"name": "工作流错误监听器",
"type": "n8n-nodes-base.errorTrigger",
"position": [
64,
608
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2fabef88-4742-4f4d-9cb6-85fabd53fc16",
"name": "格式化错误报告",
"type": "n8n-nodes-base.code",
"position": [
288,
608
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6237a74a-7f4b-4277-9e8c-a2b6c964dc31",
"name": "发送警报到Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
496,
608
],
"webhookId": "13c616bf-a3ad-4035-998a-1dfe6021b89f",
"parameters": {},
"typeVersion": 1
},
{
"id": "149e66d0-8679-41d9-958e-b9c6ecf210ec",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
736,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d34dba88-59a0-4efd-83b3-7148579daa86",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9bdf4b3-e4fc-4e56-8e98-eedd2e0951dd",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1728,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0db97b64-7a09-4bfe-a473-80e6429a7e5e",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2192,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "58cc5a2a-d253-43ad-b657-058ed893f2f4",
"connections": {
"Format Error Report": {
"main": [
[
{
"node": "Send Alert to Telegram",
"type": "main",
"index": 0
}
]
]
},
"Daily Trigger (9 AM)": {
"main": [
[
{
"node": "Fetch Leadfeeder Account ID",
"type": "main",
"index": 0
}
]
]
},
"Pagination Controller": {
"main": [
[],
[
{
"node": "Assign Current Page Number",
"type": "main",
"index": 0
}
]
]
},
"Rate Limit Delay (40s)": {
"main": [
[
{
"node": "Pagination Controller",
"type": "main",
"index": 0
}
]
]
},
"Workflow Error Listener": {
"main": [
[
{
"node": "Format Error Report",
"type": "main",
"index": 0
}
]
]
},
"Check Last Page Condition": {
"main": [
[
{
"node": "Extract Leads (Last Page)",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract Leads (Full Page)",
"type": "main",
"index": 0
}
]
]
},
"Extract Leads (Full Page)": {
"main": [
[
{
"node": "Enrich with Apollo (Full Page)",
"type": "main",
"index": 0
}
]
]
},
"Extract Leads (Last Page)": {
"main": [
[
{
"node": "Enrich with Apollo (Last Page)",
"type": "main",
"index": 0
}
]
]
},
"Assign Current Page Number": {
"main": [
[
{
"node": "Retrieve Lead Data (Leadfeeder)",
"type": "main",
"index": 0
}
]
]
},
"Fetch Leadfeeder Account ID": {
"main": [
[
{
"node": "Generate Pagination Sequence",
"type": "main",
"index": 0
}
]
]
},
"Generate Pagination Sequence": {
"main": [
[
{
"node": "Pagination Controller",
"type": "main",
"index": 0
}
]
]
},
"Enrich with Apollo (Full Page)": {
"main": [
[
{
"node": "Save Leads to Google Sheets (Full Page)",
"type": "main",
"index": 0
}
]
]
},
"Enrich with Apollo (Last Page)": {
"main": [
[
{
"node": "Save Leads to Google Sheets (Last Page)",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Lead Data (Leadfeeder)": {
"main": [
[
{
"node": "Check Last Page Condition",
"type": "main",
"index": 0
}
]
]
},
"Save Leads to Google Sheets (Full Page)": {
"main": [
[
{
"node": "Rate Limit Delay (40s)",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Lead Generation、Multimodal AI等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于公司ID的Apollo数据丰富
使用Apollo、Google Sheets和Telegram基于公司ID丰富采购联系人
If
Set
Code
+9
27 节点Khaisa Studio
Lead Generation
使用Google Maps、GPT-4和WhatsApp自动化商业合作伙伴拓展
使用Google Maps、GPT-4和WhatsApp自动化商业合作伙伴拓展
If
Set
Code
+23
64 节点Khairul Muhtadin
AI Chatbot
自动职位列表提取与发布模板
自动职位列表提取与发布模板
If
Set
Code
+14
53 节点Khairul Muhtadin
HR
MetaAds创意洞察研究员v1.4
使用Google Vision和Video Intelligence API分析Meta广告创意
If
Set
Code
+9
32 节点Kirill Khatkevich
Market Research
使用OpenAI gpt-image-1和AI字幕创建并发布Instagram轮播图
从Google Sheets使用GPT-Image-1和AI字幕自动生成Instagram轮播图
If
Set
Code
+12
32 节点Jorge Martínez
Multimodal AI
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
Lead Generation
