CB资助公司及信息丰富
高级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 32 个节点。主要使用 If, Code, Merge, SplitOut, HttpRequest 等节点。 自动化潜在客户生成与邮件外联：Apify、Apollo.io、GPT-4和Google Sheets
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "sHrDKk218lrR9EuJ",
"meta": {
"instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787"
},
"name": "CB 资助公司及信息丰富",
"tags": [],
"nodes": [
{
"id": "f2504ef0-8458-46c6-9816-0258404752da",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1660,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2c8e08d1-cf17-4a75-ae44-5ffa8d8da861",
"name": "运行执行器",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
-1220,
680
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0b75e57c-d4aa-4dd7-b9da-22096b93082d",
"name": "获取数据集项",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
-780,
660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d7748505-cf02-43bc-8c26-e5ce17728335",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
1180,
1140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3b082405-c1c2-4372-959f-cfecae090642",
"name": "Apollo - 获取公司详情",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1320,
1380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3fe3b835-d09a-4390-85d2-08627f91521a",
"name": "代码1",
"type": "n8n-nodes-base.code",
"position": [
720,
1340
],
"parameters": {},
"typeVersion": 2
},
{
"id": "acfae4be-9ccd-4a69-9350-da9c4a75e3f4",
"name": "获取邮箱",
"type": "n8n-nodes-base.httpRequest",
"position": [
440,
820
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "53b2536e-1250-4adc-84cd-fa9c788c9e6e",
"name": "Apollo - 获取用户",
"type": "n8n-nodes-base.httpRequest",
"position": [
-760,
1380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3fdf95ad-c64f-4498-86d6-af8392cfdaa1",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
160,
1640
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "5b5b807b-aa77-4574-b5a8-ee3f364daeb8",
"name": "分离输出",
"type": "n8n-nodes-base.splitOut",
"position": [
-200,
840
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fa4b43de-f7f9-4d80-b3dd-77edbf0c63b2",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
2320,
1080
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "af218570-e707-4447-b156-b45cd0e4d904",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
2780,
1060
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69abd956-6f0d-4be4-a515-3d17b63bdc85",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
3340,
1220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0e77fe58-69c4-4256-adb1-d68a38161c69",
"name": "向模型发送消息",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
3320,
840
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "937f0554-0d59-4c09-ae16-a04dc9988779",
"name": "在工作表中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
4040,
1140
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "80bad05a-ecc2-4527-ad29-4fcd9826950a",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1800,
1100
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "9b8c0620-1ed3-49db-a1c9-c6b640b67512",
"name": "便签说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1740,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7bd61df1-ad56-4507-8807-967fa98b6479",
"name": "便签说明1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1320,
340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "00c86e8d-1564-4f54-b7cc-d8a2aa305f74",
"name": "便签说明2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-900,
340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e9ddee77-9282-4f66-a7fc-32dd1acf13cb",
"name": "便签说明3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
1020
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7e3c86e0-2ef5-4cdc-8584-58cc01b3cf38",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "af647a84-677a-4912-98a8-daf504337cef",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "137a82c4-3d2c-44b7-a118-00753065f90c",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
300,
580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9e0ffc63-30dd-43a9-bdfa-39eb5ea18942",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
1400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b713e67f-db31-4007-9169-17a780c7fde8",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
620,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "82989a4f-5442-40a1-a72f-bb3a928fd69c",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "abe48428-0004-42ef-985c-671fd4a4b7d3",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1680,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "520c24d2-44d4-4cf5-b33d-cbcb4bb33123",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2200,
820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c018d50c-de9d-4d51-86f3-b180c66f5909",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
2680,
780
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "12fc8c2a-3d48-4eaa-904a-c2eef1a06ec2",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
3280,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "22211539-ad4e-4dc2-ac44-ee3fd101b0c0",
"name": "便签 14",
"type": "n8n-nodes-base.stickyNote",
"position": [
3920,
820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "50bed6ba-c33a-4538-8c1b-9da913b25368",
"name": "便签 15",
"type": "n8n-nodes-base.stickyNote",
"position": [
3500,
1420
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "3ae843f3-ca7e-41db-83c4-2f7f3c61f3ba",
"connections": {
"If": {
"main": [
[
{
"node": "Message a model",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"Get Email": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Get Email",
"type": "main",
"index": 0
}
]
]
},
"Run an Actor": {
"main": [
[
{
"node": "Get dataset items",
"type": "main",
"index": 0
}
]
]
},
"Message a model": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Apollo - Get User": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Get dataset items": {
"main": [
[
{
"node": "Apollo - Get Company Details",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Apollo - Get Company Details": {
"main": [
[
{
"node": "Apollo - Get User",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Run an Actor",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Apify、Apollo.io和Google Gemini自动化LinkedIn职位AI驱动潜在客户生成
自动化LinkedIn职位潜在客户生成：Apify、Apollo.io和Google Gemini
If
Code
Limit
+11
47 节点Intuz
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
使用LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
通过LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
If
Code
Limit
+11
47 节点Matthieu
潜在客户开发
ELV网站邮箱提取
使用EmailListVerify API从网站提取邮箱地址并存储到Google Sheets
If
Set
Code
+6
20 节点EmailListVerify
潜在客户开发
使用Apify、Google Gemini和Sheets实时自动化Upwork提案生成
使用Apify、Google Gemini和Sheets自动化AI Upwork提案生成
If
Set
Gmail
+8
25 节点Intuz
潜在客户开发
工作流信息
难度等级
高级
节点数量32
分类2
节点类型11
作者
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 查看 →
分享此工作流