从Apollo到NocoDB的潜在客户生成
高级
这是一个Sales, AI领域的自动化工作流，包含 72 个节点。主要使用 If, Set, Wait, NocoDb, SendInBlue 等节点，结合人工智能技术实现智能自动化。 使用Apollo、GPT-4o评分和Brevo邮件营销自动化B2B潜在客户开发
前置要求
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
使用的节点 (72)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "BVxFpIBewfg8Jwjx",
"meta": {
"instanceId": "6c0a09a47d94a1a73da5dfac616caeedf0377a325eabc675382bec3037bf1127",
"templateId": "3435",
"templateCredsSetupCompleted": true
},
"name": "从 Apollo 到 NocoDB 的潜在客户生成",
"tags": [],
"nodes": [
{
"id": "03eabaeb-ad13-4764-98de-183325e32cbd",
"name": "点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-40,
-40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e7df072c-fba8-4dc2-94ce-ae20a135a633",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
840,
-60
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "3aaa9ea7-0c5d-4ea3-aa10-6cd0125ea91a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0915cea5-746a-4dde-9208-885e08644ae2",
"name": "过滤没有电子邮件的潜在客户",
"type": "n8n-nodes-base.if",
"position": [
560,
-40
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "79c0d44d-461c-47c4-a2c3-bc48819424f5",
"name": "NocoDB",
"type": "n8n-nodes-base.nocoDb",
"position": [
1100,
-60
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2ae8597b-c3cc-4094-ac10-876286a767fd",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
-540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "65f90ea8-fead-4d3a-af5a-087711bd7c89",
"name": "获取数据以准备评分",
"type": "n8n-nodes-base.nocoDb",
"position": [
3080,
680
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "039c6258-d5da-45f1-8bce-5db46535bb19",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
3000,
340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cada3220-ba44-40a2-a376-6c4b085b52ff",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3000,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3f290863-d49b-4bda-8a9e-d60f1acd3431",
"name": "如果未评分",
"type": "n8n-nodes-base.if",
"onError": "continueRegularOutput",
"position": [
3580,
440
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0f157716-a181-45f9-a003-c99fd8fdb7a1",
"name": "添加分数",
"type": "n8n-nodes-base.nocoDb",
"position": [
4220,
480
],
"parameters": {},
"typeVersion": 3
},
{
"id": "61917624-c471-49db-b94e-b3af95d54932",
"name": "Crawl4AI",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
1800,
-500
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "aeaca1d7-47b8-4949-8431-470b9173444c",
"name": "Crawl4AI 解析",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
2080,
-500
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "9b6e2ab7-11c2-4f50-87de-e7c3d1e0d1d2",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
1940,
-240
],
"webhookId": "7b0d36c1-b26b-448b-a9a9-6bff0c03293c",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "a7a0226d-de96-4fde-93d6-26861c27ed4c",
"name": "如果邮件未创建",
"type": "n8n-nodes-base.if",
"position": [
3520,
-80
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "fbf38182-6201-47e9-a144-db168947bdf3",
"name": "添加个性化邮件",
"type": "n8n-nodes-base.nocoDb",
"onError": "continueRegularOutput",
"position": [
4200,
20
],
"parameters": {},
"typeVersion": 3
},
{
"id": "0ef74fde-b88c-417c-850d-9c18a48f2840",
"name": "AI 评分",
"type": "@n8n/n8n-nodes-langchain.openAi",
"onError": "continueRegularOutput",
"position": [
3840,
400
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "f9d4f2c5-2ab7-4393-b697-2e5a72aeb840",
"name": "邮件个性化",
"type": "@n8n/n8n-nodes-langchain.openAi",
"onError": "continueErrorOutput",
"position": [
3800,
-40
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "904fc571-1d57-4281-915e-ba0ab05b6bb5",
"name": "个性化邮件循环",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
4700,
-160
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "01e6de3a-77df-4ef7-aa14-6c75c8e7bc8d",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
4440,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "38732d31-45d9-4446-8c5e-83a753ab9d7a",
"name": "标记为已联系",
"type": "n8n-nodes-base.nocoDb",
"onError": "continueRegularOutput",
"position": [
5980,
60
],
"parameters": {},
"typeVersion": 3
},
{
"id": "0b8ef68a-b4c5-4e6b-969f-a2e18172dae1",
"name": "邮件存在 -> 标记为已联系",
"type": "n8n-nodes-base.nocoDb",
"onError": "continueRegularOutput",
"position": [
5380,
-80
],
"parameters": {},
"typeVersion": 3
},
{
"id": "6622c17f-4372-4dfa-bb6d-f4d5bdd5732d",
"name": "发送邮件",
"type": "n8n-nodes-base.sendInBlue",
"onError": "continueErrorOutput",
"position": [
5700,
-220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ad99aea5-e1d7-42ab-8feb-d31dbb1c131d",
"name": "创建联系人",
"type": "n8n-nodes-base.sendInBlue",
"onError": "continueErrorOutput",
"position": [
5240,
-200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a93dbfed-c320-4775-907f-b14528440a72",
"name": "如果未联系且邮件已创建",
"type": "n8n-nodes-base.if",
"position": [
4960,
-140
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f366ff2c-91c7-4c66-bd38-d767aed98cdd",
"name": "如果待处理",
"type": "n8n-nodes-base.if",
"position": [
2220,
-240
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c8ac0133-0d38-4b51-9b7d-4da170128d99",
"name": "标记为垃圾",
"type": "n8n-nodes-base.nocoDb",
"position": [
5700,
0
],
"parameters": {},
"typeVersion": 3
},
{
"id": "8e0e6f67-edcf-408e-b5f8-3af76151ad57",
"name": "如果不成功",
"type": "n8n-nodes-base.if",
"position": [
2440,
-220
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "42e3f6de-4ec4-46a7-a7f9-c028d27a677b",
"name": "从 Apollo 抓取潜在客户",
"type": "n8n-nodes-base.httpRequest",
"position": [
300,
-40
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "9d3e9f4b-faac-4712-8b3a-7455acf15049",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
-680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "54e6e348-94da-4468-9c7b-c841b9b970d7",
"name": "按电子邮件获取",
"type": "n8n-nodes-base.nocoDb",
"position": [
5160,
-560
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": false
},
{
"id": "1aa6ab44-929d-48f0-b82d-b5cd7900f7ee",
"name": "潜在客户状态 -> 垃圾",
"type": "n8n-nodes-base.nocoDb",
"position": [
5600,
-560
],
"parameters": {},
"typeVersion": 3
},
{
"id": "06d7157e-c32d-4301-bdae-6e1363bf9280",
"name": "在 Brevo 中删除联系人",
"type": "n8n-nodes-base.sendInBlue",
"onError": "continueRegularOutput",
"position": [
4940,
-560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9e9d2e18-7f07-4779-8add-5bab43c23ce9",
"name": "邮件已打开",
"type": "n8n-nodes-base.sendInBlueTrigger",
"disabled": true,
"position": [
4720,
-820
],
"webhookId": "10d24686-a8b9-4a61-b8f7-88c7aebec134",
"parameters": {},
"typeVersion": 1
},
{
"id": "f49e831b-c958-4f7c-a42f-06570f9e589f",
"name": "潜在客户状态 ->",
"type": "n8n-nodes-base.nocoDb",
"position": [
5160,
-820
],
"parameters": {},
"typeVersion": 3
},
{
"id": "3499fc86-5edc-4c28-9e95-dc08b00745d9",
"name": "If Email Opened More Than Once",
"type": "n8n-nodes-base.if",
"position": [
5380,
-820
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f1c092fe-ab2b-4af3-acab-c16eaeea1794",
"name": "Lead Status -> Warm",
"type": "n8n-nodes-base.nocoDb",
"position": [
5600,
-820
],
"parameters": {},
"typeVersion": 3
},
{
"id": "18a47bc2-c7d0-4164-ba12-7b057358343f",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
4620,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "47e16200-8710-405f-baf0-7078d147649f",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
4620,
-900
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b81accf5-26f3-4e5b-8f27-81462cb20bd2",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
5320,
-900
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d6fed6ec-a5fb-4e46-8cc7-90e9e75220d9",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45189b23-8fa7-4993-907a-2475dcdb2d6e",
"name": "Apify Crawl Request",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
2240,
100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "dd026984-588b-4cb0-a59e-81a8b78e26d9",
"name": "Process Apify Crawl",
"type": "n8n-nodes-base.nocoDb",
"onError": "continueRegularOutput",
"position": [
2700,
260
],
"parameters": {},
"typeVersion": 3
},
{
"id": "7ca5e49d-6e9c-4717-a276-906079b69b62",
"name": "Mark as failed_to_process",
"type": "n8n-nodes-base.nocoDb",
"onError": "continueRegularOutput",
"position": [
2400,
220
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c7dd8f36-a045-45d2-9378-264556c1b71f",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "46191283-6f1b-4f80-943c-a70a3a7e40d5",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
780,
-680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fdbe2dd5-9f58-49fa-a583-461f6d2a2131",
"name": "便签 12",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6997b63c-b4a4-4c5e-a60e-4f94b7d0c50c",
"name": "便签 13",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c619c476-d1db-4274-9f69-a7721a69989a",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e6834cb7-8def-419c-9b4a-955225b4a6cd",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
960
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e4e4d68a-4b82-4814-84aa-93507ec03b71",
"name": "便签 16",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "086dadba-e5aa-4878-8db5-db31f133e16d",
"name": "Get Entered Leads From Crawl4AI",
"type": "n8n-nodes-base.nocoDb",
"position": [
1400,
-480
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "17deb25e-ad8e-46d7-aa96-461e0fa68147",
"name": "Get 'Entered' Leads From Apify",
"type": "n8n-nodes-base.nocoDb",
"position": [
1380,
80
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "13d17853-a3f8-4090-9092-e0f5ca3947bf",
"name": "Set Lead Status -> 'processed'",
"type": "n8n-nodes-base.nocoDb",
"onError": "continueRegularOutput",
"position": [
2680,
-220
],
"parameters": {},
"typeVersion": 3
},
{
"id": "0e52decf-7492-46c2-9c93-6f3118da7f87",
"name": "Set Lead Status -> 'failed_to_process'",
"type": "n8n-nodes-base.nocoDb",
"onError": "continueRegularOutput",
"position": [
2680,
-500
],
"parameters": {},
"typeVersion": 3
},
{
"id": "be068a81-5255-4c60-9de1-2c2f2f4e775b",
"name": "Loop over entered leads",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
1640,
80
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "2c3351fc-e75f-4ca7-ae85-1d245ba1b127",
"name": "Loop Over Entered Leads Crawl4AI",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
1400,
-260
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "fb062cba-8e2c-457f-98b8-8cb2365cfab6",
"name": "Fetch processed leads",
"type": "n8n-nodes-base.nocoDb",
"position": [
3060,
-60
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "6a665ba4-9613-48f3-b268-2cca0233c891",
"name": "Loop Over Processed Leads",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
3340,
-200
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "7e71cf7a-46c4-44c7-a573-245af9fb6072",
"name": "Loop Over Leads For Scoring",
"type": "n8n-nodes-base.splitInBatches",
"position": [
3280,
400
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "9000cd35-dc89-4a03-a3b8-d5691d89454e",
"name": "Fetch Leads With Created Emails",
"type": "n8n-nodes-base.nocoDb",
"position": [
4500,
-160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "97ad2f49-dab9-4761-a43a-df21f75885d3",
"name": "Get by user email",
"type": "n8n-nodes-base.nocoDb",
"position": [
4940,
-820
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": false
},
{
"id": "1f259b81-fbfe-4e51-9a84-18d5ee7158d5",
"name": "便签 17",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
-800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "da386568-de62-4de7-9499-8bf476b2d5c3",
"name": "便签 18",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ddd9a21a-bb09-44d2-8df5-8104a41c2e50",
"name": "If organization website exists Crawl4AI",
"type": "n8n-nodes-base.if",
"position": [
1640,
-260
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "4acc6b9c-7767-4f45-8212-404b8a4a845b",
"name": "If organization website exists",
"type": "n8n-nodes-base.if",
"position": [
1880,
140
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0b33cb3d-ca9f-445a-8337-7d6ba7a70834",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
3720,
660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7cd52266-8c9e-48dd-8fbe-6a9718d4a730",
"name": "便签20",
"type": "n8n-nodes-base.stickyNote",
"position": [
3000,
-540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1a67fa60-a90c-4509-a34a-835dbf11f26d",
"name": "便签21",
"type": "n8n-nodes-base.stickyNote",
"position": [
4420,
340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ee6dda9b-2598-468d-9806-318841e51b6b",
"name": "便签22",
"type": "n8n-nodes-base.stickyNote",
"position": [
4620,
-1100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "57d82b63-51c5-45c2-9352-cd7863f39506",
"name": "Email Unwanted",
"type": "n8n-nodes-base.sendInBlueTrigger",
"disabled": true,
"position": [
4720,
-560
],
"webhookId": "f71be43b-84bd-40cb-bfc0-49253bd58a5e",
"parameters": {},
"typeVersion": 1
},
{
"id": "266ac693-20a2-4681-bc9f-9afebbc20cb6",
"name": "便签23",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "c02ac938-5c46-4bc7-9ee9-d5d774ba8fa3",
"connections": {
"Wait": {
"main": [
[
{
"node": "Crawl4AI resolve",
"type": "main",
"index": 0
}
]
]
},
"NocoDB": {
"main": [
[
{
"node": "Get 'Entered' Leads From Apify",
"type": "main",
"index": 0
}
]
]
},
"Crawl4AI": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Ai Scoring": {
"main": [
[
{
"node": "Add a score",
"type": "main",
"index": 0
}
]
]
},
"Email Send": {
"main": [
[
{
"node": "Mark as contacted",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark as Trash",
"type": "main",
"index": 0
}
]
]
},
"If pending": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
],
[
{
"node": "If not success",
"type": "main",
"index": 0
}
]
]
},
"Add a score": {
"main": [
[
{
"node": "Loop Over Leads For Scoring",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "NocoDB",
"type": "main",
"index": 0
}
]
]
},
"Email Opened": {
"main": [
[
{
"node": "Get by user email",
"type": "main",
"index": 0
}
]
]
},
"Get by email": {
"main": [
[
{
"node": "Lead Status -> Trash",
"type": "main",
"index": 0
}
]
]
},
"If not scored": {
"main": [
[
{
"node": "Loop Over Leads For Scoring",
"type": "main",
"index": 0
}
],
[
{
"node": "Ai Scoring",
"type": "main",
"index": 0
}
]
]
},
"Mark as Trash": {
"main": [
[
{
"node": "Personalized Mail Loop",
"type": "main",
"index": 0
}
]
]
},
"Create Contact": {
"main": [
[
{
"node": "Email Send",
"type": "main",
"index": 0
}
],
[
{
"node": "Email Exists -> Mark as Contacted",
"type": "main",
"index": 0
}
]
]
},
"Email Unwanted": {
"main": [
[
{
"node": "Delete Contact In Brevo",
"type": "main",
"index": 0
}
]
]
},
"If not success": {
"main": [
[
{
"node": "Set Lead Status -> 'failed_to_process'",
"type": "main",
"index": 0
}
],
[
{
"node": "Set Lead Status -> 'processed'",
"type": "main",
"index": 0
}
]
]
},
"Crawl4AI resolve": {
"main": [
[
{
"node": "If pending",
"type": "main",
"index": 0
}
],
[
{
"node": "Set Lead Status -> 'failed_to_process'",
"type": "main",
"index": 0
}
]
]
},
"Get by user email": {
"main": [
[
{
"node": "Lead Status -> Email Opened",
"type": "main",
"index": 0
}
]
]
},
"Mark as contacted": {
"main": [
[
{
"node": "Personalized Mail Loop",
"type": "main",
"index": 0
}
]
]
},
"Apify Crawl Request": {
"main": [
[
{
"node": "Process Apify Crawl",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark as failed_to_process",
"type": "main",
"index": 0
}
]
]
},
"If mail not created": {
"main": [
[
{
"node": "Email Personalization",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Processed Leads",
"type": "main",
"index": 0
}
]
]
},
"Process Apify Crawl": {
"main": [
[
{
"node": "Loop over entered leads",
"type": "main",
"index": 0
}
]
]
},
"Add Personalized mail": {
"main": [
[
{
"node": "Loop Over Processed Leads",
"type": "main",
"index": 0
}
]
]
},
"Email Personalization": {
"main": [
[
{
"node": "Add Personalized mail",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Processed Leads",
"type": "main",
"index": 0
}
]
]
},
"Fetch processed leads": {
"main": [
[
{
"node": "Loop Over Processed Leads",
"type": "main",
"index": 0
}
]
]
},
"Personalized Mail Loop": {
"main": [
[],
[
{
"node": "If not contacted and email created",
"type": "main",
"index": 0
}
]
]
},
"Delete Contact In Brevo": {
"main": [
[
{
"node": "Get by email",
"type": "main",
"index": 0
}
]
]
},
"Loop over entered leads": {
"main": [
[
{
"node": "Fetch data to prepare for scoring",
"type": "main",
"index": 0
}
],
[
{
"node": "If organization website exists",
"type": "main",
"index": 0
}
]
]
},
"Scrape Leads From Apollo": {
"main": [
[
{
"node": "Filter leads without email",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Processed Leads": {
"main": [
[
{
"node": "Fetch Leads With Created Emails",
"type": "main",
"index": 0
}
],
[
{
"node": "If mail not created",
"type": "main",
"index": 0
}
]
]
},
"Mark as failed_to_process": {
"main": [
[
{
"node": "Loop over entered leads",
"type": "main",
"index": 0
}
]
]
},
"Filter leads without email": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
],
[]
]
},
"Lead Status -> Email Opened": {
"main": [
[
{
"node": "If Email Opened More Than Once",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Leads For Scoring": {
"main": [
[
{
"node": "Fetch processed leads",
"type": "main",
"index": 0
}
],
[
{
"node": "If not scored",
"type": "main",
"index": 0
}
]
]
},
"Get 'Entered' Leads From Apify": {
"main": [
[
{
"node": "Loop over entered leads",
"type": "main",
"index": 0
}
]
]
},
"If Email Opened More Than Once": {
"main": [
[
{
"node": "Lead Status -> Warm",
"type": "main",
"index": 0
}
]
]
},
"If organization website exists": {
"main": [
[
{
"node": "Apify Crawl Request",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark as failed_to_process",
"type": "main",
"index": 0
}
]
]
},
"Set Lead Status -> 'processed'": {
"main": [
[
{
"node": "Loop Over Entered Leads Crawl4AI",
"type": "main",
"index": 0
}
],
[]
]
},
"Fetch Leads With Created Emails": {
"main": [
[
{
"node": "Personalized Mail Loop",
"type": "main",
"index": 0
}
]
]
},
"Get Entered Leads From Crawl4AI": {
"main": [
[
{
"node": "Loop Over Entered Leads Crawl4AI",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Entered Leads Crawl4AI": {
"main": [
[],
[
{
"node": "If organization website exists Crawl4AI",
"type": "main",
"index": 0
}
]
]
},
"Email Exists -> Mark as Contacted": {
"main": [
[
{
"node": "Personalized Mail Loop",
"type": "main",
"index": 0
}
]
]
},
"Fetch data to prepare for scoring": {
"main": [
[
{
"node": "Loop Over Leads For Scoring",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Scrape Leads From Apollo",
"type": "main",
"index": 0
}
]
]
},
"If not contacted and email created": {
"main": [
[
{
"node": "Create Contact",
"type": "main",
"index": 0
}
],
[
{
"node": "Personalized Mail Loop",
"type": "main",
"index": 0
}
]
]
},
"Set Lead Status -> 'failed_to_process'": {
"main": [
[
{
"node": "Loop Over Entered Leads Crawl4AI",
"type": "main",
"index": 0
}
],
[]
]
},
"If organization website exists Crawl4AI": {
"main": [
[
{
"node": "Crawl4AI",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Entered Leads Crawl4AI",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
搜索 LinkedIn 公司，通过 AI 评分并添加到 Google Sheet CRM
搜索 LinkedIn 公司，通过 AI 评分并添加到 Google Sheet CRM
If
Set
Wait
+7
18 节点Matthieu
销售
智能邮件触达序列 - AI驱动且可定制
智能邮件触达序列 - AI驱动且可定制
If
Set
Code
+8
68 节点Badr
销售
使用AI（GPT-4o）自动化数字产品和SaaS销售
使用AI（GPT-4o）自动化数字产品和SaaS销售
If
Code
Wait
+14
34 节点Badr
销售
AI个性化多产品邮件营销
基于SMTP轮换的AI个性化多产品邮件营销（GPT-4o/o3-mini）
If
Code
Wait
+16
41 节点Badr
销售
电话销售循环
AI驱动电话销售自动化，集成Vapi.ai、GPT-4o和Google Sheets
If
Set
Wait
+8
38 节点Amit Mehta
销售
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
