使用Apify、Apollo.io和Google Gemini自动化LinkedIn职位AI驱动潜在客户生成
高级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 47 个节点。主要使用 If, Code, Limit, Merge, Filter 等节点。 自动化LinkedIn职位潜在客户生成：Apify、Apollo.io和Google Gemini
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (47)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "dlD6SUK9oCIFJwnm",
"meta": {
"instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787"
},
"name": "使用Apify、Apollo.io和Google Gemini自动化LinkedIn职位AI驱动潜在客户生成",
"tags": [],
"nodes": [
{
"id": "8630674f-19fd-4471-bd43-737412d6347f",
"name": "使用电子邮件更新表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3240,
800
],
"parameters": {},
"typeVersion": 4
},
{
"id": "806d3d32-9e0a-4cad-8e19-bae4c417ab36",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2620,
1160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "94151275-6e3b-4495-b398-9d111bb2289d",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
3180,
1160
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "81c3ca9c-55b2-41e4-9d0b-4ffc0ed379f8",
"name": "点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-120,
-60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9cf01e72-852f-44ac-9883-3dc39c9d9cc3",
"name": "移除重复项",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
-80,
280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "20c1afe5-540e-49e4-9e83-b7a916d448bc",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
1160,
900
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "7f0c020b-bf03-4895-bd25-c998b83dae00",
"name": "过滤器",
"type": "n8n-nodes-base.filter",
"position": [
2200,
800
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "1a35f3f2-e67a-4ebf-93b9-fe36c4c8cd62",
"name": "运行LinkedIn职位爬虫",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
260,
-120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a7fa6416-90c8-4275-9298-6aded3beec30",
"name": "获取数据集项",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
780,
-60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0e7a3134-1db1-44aa-b6c6-998a2bbacebc",
"name": "检查公司规模<250",
"type": "n8n-nodes-base.if",
"position": [
1280,
0
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c9b289e6-8f08-4da2-8aab-7abdac7dca21",
"name": "移除HR相关行业",
"type": "n8n-nodes-base.if",
"position": [
300,
280
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "7a6bd015-0dd1-4ec2-a515-bb6e218089b6",
"name": "准备最终公司详情",
"type": "n8n-nodes-base.code",
"position": [
800,
280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "00250ec9-9737-42f7-928c-393f67aa9c19",
"name": "检查域名存在性",
"type": "n8n-nodes-base.if",
"position": [
-100,
600
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "e2b3331b-cb7a-475a-be41-6837f2cc9600",
"name": "Apollo获取目标人员",
"type": "n8n-nodes-base.httpRequest",
"position": [
-480,
1100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "126a3643-00aa-4a77-b5be-01ee5be93662",
"name": "Apollo邮箱查找器",
"type": "n8n-nodes-base.httpRequest",
"position": [
200,
1440
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "314e0e89-d143-46f3-bfad-92855e8011b3",
"name": "清理邮箱详情",
"type": "n8n-nodes-base.code",
"position": [
700,
1440
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5147652f-bea9-4229-9d61-7440a49091e6",
"name": "构建人员完整详情结构",
"type": "n8n-nodes-base.code",
"position": [
1500,
680
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3415addd-0178-48dd-93f8-dce004a813b2",
"name": "将潜在客户添加到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1720,
340
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "2791b514-013e-4790-909c-224c5a956010",
"name": "获取潜在客户数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
2180,
340
],
"parameters": {},
"typeVersion": 4
},
{
"id": "1217a1e0-7500-4096-bd0b-e297915fa07a",
"name": "验证邮箱ID和邮件内容",
"type": "n8n-nodes-base.if",
"position": [
2840,
360
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "193d64df-1620-483b-9d40-f2213abd8ca2",
"name": "潜在客户邮件生成器",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2720,
800
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "e4a8257e-3ac5-457c-b532-45c9562d52b5",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220,
-240
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "833c88b7-7e3f-473e-9af8-395b7e52ca18",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-380
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "bebf0e9b-59aa-4812-829e-80bfb1570abb",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-320
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "dcbae0ae-a00a-41ed-9de1-86af53a4fafd",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
-260
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "8e9f9ef3-c337-4946-8580-8f6bd743e00c",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
280
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "787f23b2-442b-4f5c-92ba-33f9bd4e46ca",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
160
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "bfc23da9-7cf8-46c1-9eaf-c34a4a73a975",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
780,
160
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "265d444d-3be7-4804-99d7-ad4bfcfa3aef",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
520
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "dd6de884-1337-43a9-a8a9-4bb1fc24a774",
"name": "限制公司搜索",
"type": "n8n-nodes-base.limit",
"position": [
560,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a8199109-9ff9-4db3-8d16-f0825dd2d00d",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
540
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "dbebed2f-6bce-4a74-a384-935ab4fa3e61",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
1040
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "f1b83c90-c61a-45c5-bc1a-5a4c571d66ec",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
880
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "d3505a43-7ce0-42eb-a651-50ab327c410f",
"name": "清理人员详情",
"type": "n8n-nodes-base.code",
"position": [
-80,
1140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "63df7909-ad91-4fd2-b2fb-59534936c8d0",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
1620
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "b4a1b819-dce6-494c-b2ef-abca0d64ce20",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
1620
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "9c14c4ed-ceb7-4129-b7ac-9fd086e5abdf",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
1080
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "f5351875-3c1a-40e2-a6c6-91ca404c2f29",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
1460,
840
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "8457354c-ff73-422c-9a9d-19bb28bac639",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
1620,
140
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "a6066fcf-1300-4208-b590-48eb5e7cef13",
"name": "便签 16",
"type": "n8n-nodes-base.stickyNote",
"position": [
2100,
120
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "5c5e5b8b-df95-4614-bed1-67841375cc51",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
2760,
140
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "4e88598a-9c75-4e8c-b8a3-b2d24017fb9a",
"name": "便签18",
"type": "n8n-nodes-base.stickyNote",
"position": [
2100,
940
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "04c41608-7bf5-491d-8724-21007ddb07f9",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
2640,
600
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "5db8d8dc-36cc-48a5-a03a-b9c45a72bef7",
"name": "便签20",
"type": "n8n-nodes-base.stickyNote",
"position": [
2480,
1300
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "3e2c99bb-ce79-4b13-940b-d4f2677a537a",
"name": "便签21",
"type": "n8n-nodes-base.stickyNote",
"position": [
3140,
600
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "ccacf685-d7f7-489b-9b27-f05f2424aea6",
"name": "便签22",
"type": "n8n-nodes-base.stickyNote",
"position": [
3100,
1320
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "836730d3-b35d-4352-b7b1-6975b321013a",
"name": "便签23",
"type": "n8n-nodes-base.stickyNote",
"position": [
3560,
980
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "64e0795b-1115-48f0-8505-6eb27fd11ec6",
"connections": {
"Merge": {
"main": [
[
{
"node": "Structuring Complete Details of Person",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Lead Email Generator",
"type": "main",
"index": 0
}
]
]
},
"Get dataset Items": {
"main": [
[
{
"node": "Checks Company Size < 250",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicates": {
"main": [
[
{
"node": "Removes HR Related Industry",
"type": "main",
"index": 0
}
]
]
},
"Apollo Email Finder": {
"main": [
[
{
"node": "Sanitising Email Details",
"type": "main",
"index": 0
}
]
]
},
"Fetching Leads Data": {
"main": [
[
{
"node": "Validates Email Id and Email Content",
"type": "main",
"index": 0
}
]
]
},
"Lead Email Generator": {
"main": [
[
{
"node": "Update Sheet with Email",
"type": "main",
"index": 0
}
]
]
},
"Adding Leads to Sheets": {
"main": [
[
{
"node": "Fetching Leads Data",
"type": "main",
"index": 0
}
]
]
},
"Limit Companies Search": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
},
{
"node": "Apollo Get Targeted Personnel",
"type": "main",
"index": 0
}
]
]
},
"Checks Domain Existence": {
"main": [
[
{
"node": "Limit Companies Search",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Lead Email Generator",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Sanitising Email Details": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Lead Email Generator",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Checks Company Size < 250": {
"main": [
[
{
"node": "Remove Duplicates",
"type": "main",
"index": 0
}
]
]
},
"Sanitising Person Details": {
"main": [
[
{
"node": "Apollo Email Finder",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Removes HR Related Industry": {
"main": [
[
{
"node": "Prepare Final Company Details",
"type": "main",
"index": 0
}
]
]
},
"Run the LinkedIn Job Scraper": {
"main": [
[
{
"node": "Get dataset Items",
"type": "main",
"index": 0
}
]
]
},
"Apollo Get Targeted Personnel": {
"main": [
[
{
"node": "Sanitising Person Details",
"type": "main",
"index": 0
}
]
]
},
"Prepare Final Company Details": {
"main": [
[
{
"node": "Checks Domain Existence",
"type": "main",
"index": 0
}
]
]
},
"Validates Email Id and Email Content": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Run the LinkedIn Job Scraper",
"type": "main",
"index": 0
}
]
]
},
"Structuring Complete Details of Person": {
"main": [
[
{
"node": "Adding Leads to Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用LinkedIn职位信号、Apify、Apollo.io和Google Gemini自动化销售拓展
基于LinkedIn职位信号使用Apify和Google Gemini生成个性化销售拓展
If
Code
Limit
+11
47 节点Intuz
使用Apify、Google Gemini和Sheets实时自动化Upwork提案生成
使用Apify、Google Gemini和Sheets自动化AI Upwork提案生成
If
Set
Gmail
+8
25 节点Intuz
潜在客户开发
CB资助公司及信息丰富
自动化潜在客户生成与邮件外联：Apify、Apollo.io、GPT-4和Google Sheets
If
Code
Merge
+8
32 节点Intuz
潜在客户开发
实时自动化 LinkedIn 档案研究与 AI 外联（使用 Apify、Gemini 和 Sheets）
使用 Apify、Gemini 和 Sheets 自动化 LinkedIn 档案研究与邮件外联
If
Limit
Google Sheets
+6
20 节点Intuz
潜在客户开发
实时 - 使用Gemini和Creatomate自动化病毒式AI视频制作与发布
使用Gemini和Creatomate自动化AI视频创作与多平台发布
Set
Code
Wait
+15
47 节点Intuz
内容创作
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
工作流信息
难度等级
高级
节点数量47
分类2
节点类型14
作者
Intuz
@intuzWorkflow automation can help automate your routine activities and help saves $$$, as well as hours of time. As a boutique tech consulting company, Intuz help businesses with custom AI/ML, AI Workflow Automations, and software development. Automate your business workflow for: Sales Marketing Accounting Finance Operations E-Commerce Customer Support Admin & Backoffice Logistics & Supply Chain
外部链接
在 n8n.io 查看 →
分享此工作流