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 Funded Companies & Enrichment",
"tags": [],
"nodes": [
{
"id": "f2504ef0-8458-46c6-9816-0258404752da",
"name": "When clicking ‘Execute workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1660,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2c8e08d1-cf17-4a75-ae44-5ffa8d8da861",
"name": "Run an Actor",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
-1220,
680
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0b75e57c-d4aa-4dd7-b9da-22096b93082d",
"name": "Get dataset items",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
-780,
660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d7748505-cf02-43bc-8c26-e5ce17728335",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
1180,
1140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3b082405-c1c2-4372-959f-cfecae090642",
"name": "Apollo - Get Company Details",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1320,
1380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3fe3b835-d09a-4390-85d2-08627f91521a",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
720,
1340
],
"parameters": {},
"typeVersion": 2
},
{
"id": "acfae4be-9ccd-4a69-9350-da9c4a75e3f4",
"name": "Get Email",
"type": "n8n-nodes-base.httpRequest",
"position": [
440,
820
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "53b2536e-1250-4adc-84cd-fa9c788c9e6e",
"name": "Apollo - Get User",
"type": "n8n-nodes-base.httpRequest",
"position": [
-760,
1380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3fdf95ad-c64f-4498-86d6-af8392cfdaa1",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
160,
1640
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "5b5b807b-aa77-4574-b5a8-ee3f364daeb8",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
-200,
840
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fa4b43de-f7f9-4d80-b3dd-77edbf0c63b2",
"name": "Get row(s) in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2320,
1080
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "af218570-e707-4447-b156-b45cd0e4d904",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
2780,
1060
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69abd956-6f0d-4be4-a515-3d17b63bdc85",
"name": "No Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"position": [
3340,
1220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0e77fe58-69c4-4256-adb1-d68a38161c69",
"name": "Message a model",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
3320,
840
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "937f0554-0d59-4c09-ae16-a04dc9988779",
"name": "Update row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
4040,
1140
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "80bad05a-ecc2-4527-ad29-4fcd9826950a",
"name": "Append or update row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1800,
1100
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "9b8c0620-1ed3-49db-a1c9-c6b640b67512",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1740,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7bd61df1-ad56-4507-8807-967fa98b6479",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1320,
340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "00c86e8d-1564-4f54-b7cc-d8a2aa305f74",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-900,
340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e9ddee77-9282-4f66-a7fc-32dd1acf13cb",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
1020
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7e3c86e0-2ef5-4cdc-8584-58cc01b3cf38",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "af647a84-677a-4912-98a8-daf504337cef",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "137a82c4-3d2c-44b7-a118-00753065f90c",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
300,
580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9e0ffc63-30dd-43a9-bdfa-39eb5ea18942",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
1400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b713e67f-db31-4007-9169-17a780c7fde8",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
620,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "82989a4f-5442-40a1-a72f-bb3a928fd69c",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "abe48428-0004-42ef-985c-671fd4a4b7d3",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1680,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "520c24d2-44d4-4cf5-b33d-cbcb4bb33123",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2200,
820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c018d50c-de9d-4d51-86f3-b180c66f5909",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
2680,
780
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "12fc8c2a-3d48-4eaa-904a-c2eef1a06ec2",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
3280,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "22211539-ad4e-4dc2-ac44-ee3fd101b0c0",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
3920,
820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "50bed6ba-c33a-4538-8c1b-9da913b25368",
"name": "Sticky Note15",
"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": {
"af218570-e707-4447-b156-b45cd0e4d904": {
"main": [
[
{
"node": "0e77fe58-69c4-4256-adb1-d68a38161c69",
"type": "main",
"index": 0
}
],
[
{
"node": "69abd956-6f0d-4be4-a515-3d17b63bdc85",
"type": "main",
"index": 0
}
]
]
},
"d7748505-cf02-43bc-8c26-e5ce17728335": {
"main": [
[
{
"node": "80bad05a-ecc2-4527-ad29-4fcd9826950a",
"type": "main",
"index": 0
}
]
]
},
"3fe3b835-d09a-4390-85d2-08627f91521a": {
"main": [
[
{
"node": "d7748505-cf02-43bc-8c26-e5ce17728335",
"type": "main",
"index": 0
}
]
]
},
"3fdf95ad-c64f-4498-86d6-af8392cfdaa1": {
"main": [
[
{
"node": "3fe3b835-d09a-4390-85d2-08627f91521a",
"type": "main",
"index": 0
}
]
]
},
"acfae4be-9ccd-4a69-9350-da9c4a75e3f4": {
"main": [
[
{
"node": "3fdf95ad-c64f-4498-86d6-af8392cfdaa1",
"type": "main",
"index": 1
}
]
]
},
"5b5b807b-aa77-4574-b5a8-ee3f364daeb8": {
"main": [
[
{
"node": "acfae4be-9ccd-4a69-9350-da9c4a75e3f4",
"type": "main",
"index": 0
}
]
]
},
"2c8e08d1-cf17-4a75-ae44-5ffa8d8da861": {
"main": [
[
{
"node": "0b75e57c-d4aa-4dd7-b9da-22096b93082d",
"type": "main",
"index": 0
}
]
]
},
"0e77fe58-69c4-4256-adb1-d68a38161c69": {
"main": [
[
{
"node": "937f0554-0d59-4c09-ae16-a04dc9988779",
"type": "main",
"index": 0
}
]
]
},
"53b2536e-1250-4adc-84cd-fa9c788c9e6e": {
"main": [
[
{
"node": "5b5b807b-aa77-4574-b5a8-ee3f364daeb8",
"type": "main",
"index": 0
},
{
"node": "3fdf95ad-c64f-4498-86d6-af8392cfdaa1",
"type": "main",
"index": 0
}
]
]
},
"0b75e57c-d4aa-4dd7-b9da-22096b93082d": {
"main": [
[
{
"node": "3b082405-c1c2-4372-959f-cfecae090642",
"type": "main",
"index": 0
}
]
]
},
"fa4b43de-f7f9-4d80-b3dd-77edbf0c63b2": {
"main": [
[
{
"node": "af218570-e707-4447-b156-b45cd0e4d904",
"type": "main",
"index": 0
}
]
]
},
"3b082405-c1c2-4372-959f-cfecae090642": {
"main": [
[
{
"node": "53b2536e-1250-4adc-84cd-fa9c788c9e6e",
"type": "main",
"index": 0
}
]
]
},
"80bad05a-ecc2-4527-ad29-4fcd9826950a": {
"main": [
[
{
"node": "fa4b43de-f7f9-4d80-b3dd-77edbf0c63b2",
"type": "main",
"index": 0
}
]
]
},
"f2504ef0-8458-46c6-9816-0258404752da": {
"main": [
[
{
"node": "2c8e08d1-cf17-4a75-ae44-5ffa8d8da861",
"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
+
If
Code
Limit
47 节点Intuz
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+
If
Set
Code
141 节点Ezema Kingsley Chibuzo
潜在客户开发
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+
If
Code
Limit
51 节点Matthieu
潜在客户开发
使用LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
通过LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
If
Code
Limit
+
If
Code
Limit
47 节点Matthieu
潜在客户开发
使用EmailListVerify API从网站提取邮箱地址并存储到Google
使用EmailListVerify API从网站提取邮箱地址并存储到Google Sheets
If
Set
Code
+
If
Set
Code
20 节点EmailListVerify
潜在客户开发
使用Apify、Google Gemini和Sheets实时自动化Upwork提案生成
使用Apify、Google Gemini和Sheets自动化AI Upwork提案生成
If
Set
Gmail
+
If
Set
Gmail
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 查看 →
分享此工作流