使用Apollo.io和Google表格的自动化LinkedIn潜在客户丰富管道
高级
这是一个Lead Generation, AI Summarization领域的自动化工作流，包含 33 个节点。主要使用 If, Code, Wait, Webhook, SplitOut 等节点。 使用Apollo.io和Google表格的自动化LinkedIn潜在客户丰富管道
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (33)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "67dd1445921862780ac74448aef33eb969db12b9a6ce95248c7ae86a887cb653",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ee7ba99a-a412-4389-af47-e12a8070a9a1",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
2032,
1296
],
"webhookId": "4584ccbb-4256-4da7-a8df-bee1f3b27084",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "d913c122-3f4a-4fa3-aab3-79c6319ac12e",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
2240,
1296
],
"parameters": {},
"typeVersion": 1
},
{
"id": "41a6dc80-fe9e-4cde-b47b-b03ae98feb7f",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2832,
1504
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "0bda86e3-84ab-4b9f-9c74-b871a658bdc6",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2512,
1504
],
"parameters": {},
"typeVersion": 1
},
{
"id": "65af8ed4-cec3-4937-963e-4623473f5b57",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2448,
1296
],
"parameters": {},
"typeVersion": 3
},
{
"id": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
2224,
2016
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ea21290c-588d-443b-b401-d7329063e9bb",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2048,
2016
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"name": "循环遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2720,
2016
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"name": "更新 sheet 中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
3440,
2032
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ed8a4414-e31d-46d7-9ad6-836faee1a3ac",
"name": "计划触发器1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
2672
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6951d857-278a-4633-be22-f06937dacb98",
"name": "遍历项目2",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2752,
2656
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
3648,
2032
],
"webhookId": "e5a3db76-aa67-42c7-8ad1-e916509b7c13",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5127d065-bc43-454c-bc64-02402c23143a",
"name": "等待1",
"type": "n8n-nodes-base.wait",
"position": [
3440,
2656
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "65efcc77-b567-4fff-a2e8-31b8e0e29f4e",
"name": "获取 sheet1 中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
2672
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"name": "更新 sheet1 中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
3648,
2656
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "5a81a696-1155-4fbb-966c-82baec8219fe",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
2496,
2672
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
2432,
2032
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "bfa61ebd-bdf8-4356-8807-579ea74a06cd",
"name": "计划触发器2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
3136
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "a3dfff36-07c3-49c6-b7fb-718638854507",
"name": "等待 2",
"type": "n8n-nodes-base.wait",
"position": [
3712,
3120
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "59e93cf6-cf15-4a92-b344-bac485607e07",
"name": "更新 sheet2 中的行",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
3920,
3120
],
"parameters": {},
"typeVersion": 4.7,
"alwaysOutputData": false
},
{
"id": "098cf0b1-6c13-428a-aedf-53f5a4ace309",
"name": "条件判断2",
"type": "n8n-nodes-base.if",
"position": [
2464,
3136
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69cc889b-3692-412b-9265-8b6ed4df7a49",
"name": "代码",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
2928,
3120
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "37e8ea98-60d5-413e-922d-e5fed98e96ef",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
2528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1ab50ec4-c5f0-4888-8f2c-0b16c518e6ea",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1792,
1856
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9bb1bf69-b5f4-4471-a98e-e4728062391c",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1808,
3072
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"name": "代码1",
"type": "n8n-nodes-base.code",
"position": [
3456,
3120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"name": "遍历项目4",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2704,
3088
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"name": "获取表格中的行3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
3136
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"name": "Linkedin 抓取格式化器",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
2656,
1296
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"name": "存储值",
"type": "n8n-nodes-base.googleSheets",
"position": [
3008,
1296
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"name": "公司名称转域名",
"type": "n8n-nodes-base.httpRequest",
"position": [
3232,
2032
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"name": "人员搜索",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
3024,
2656
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"name": "邮箱查找器",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
3184,
3120
],
"parameters": {},
"typeVersion": 4.2
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"If2": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Email Finder",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Update row in sheet1",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Update row in sheet2",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Email Finder": {
"main": [
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"Store values": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"People Search": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Linkedin Scraped Formater",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "Company Name to Domain",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items2": {
"main": [
[],
[
{
"node": "People Search",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items4": {
"main": [
[],
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Get row(s) in sheet1",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger2": {
"main": [
[
{
"node": "Get row(s) in sheet3",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet1": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet3": {
"main": [
[
{
"node": "If2",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet1": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet2": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Company Name to Domain": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Linkedin Scraped Formater",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Linkedin Scraped Formater",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Linkedin Scraped Formater": {
"main": [
[
{
"node": "Store values",
"type": "main",
"index": 0
}
],
[
{
"node": "Store values",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
AI驱动的谷歌地图商家数据抓取与表格导出
基于AI的谷歌地图商家数据抓取，支持数据丰富化并导出至表格
If
Code
Wait
+13
25 节点Msaid Mohamed el hadi
潜在客户开发
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
第一轮 Telegram 和 LinkedIn 快速通道 AI 招聘助手
AI候选人筛选流程：LinkedIn到Telegram，集成Gemini与Apify
If
Set
Code
+15
55 节点Dean Pike
人力资源
工作流信息
难度等级
高级
节点数量33
分类2
节点类型13
作者
Rahi Uppal
@rahiuppalAI and Automation Consultant with over 1000 hours of experience building, deploying, and solving marketing and sales automation problems. I ship AI products faster by combining business acumen with AI & automation expertise and an engineering mindset. Connect with me on LinkedIn to chat.
外部链接
在 n8n.io 查看 →
分享此工作流