域名外联：自动化潜在客户提取和定向触达
高级
这是一个Sales、AI领域的自动化工作流，包含 31 个节点。主要使用 If、Code、Wait、Gmail、Filter 等节点，结合人工智能技术实现智能自动化。 域名外联：自动化潜在客户提取和定向触达
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (31 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "4786bf0f18c0e8e92c361de5a158cabf4eb0bb3b9c113091b054ff26e359a029",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f7bb1a9e-0f0f-4bec-85d4-539317088cc1",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2540,
1000
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "d1a262cb-8b55-4bda-96bb-182f459caec6",
"name": "移除重复项",
"type": "n8n-nodes-base.removeDuplicates",
"onError": "continueErrorOutput",
"position": [
1740,
-700
],
"parameters": {},
"typeVersion": 1.1,
"alwaysOutputData": true
},
{
"id": "c79c8608-92fa-4bd3-b314-917848c61e5e",
"name": "移除重复项2",
"type": "n8n-nodes-base.removeDuplicates",
"onError": "continueErrorOutput",
"position": [
1460,
60
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "36690a7d-e4e7-4667-808d-2837c5f14015",
"name": "分离输出",
"type": "n8n-nodes-base.splitOut",
"onError": "continueRegularOutput",
"position": [
1000,
0
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "907ab7c1-e4c2-4ba9-9956-c95e3a821fe5",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"onError": "continueErrorOutput",
"position": [
620,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ff9e3e3f-0b39-4743-9e3a-e8d137d5ca23",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
2080,
-540
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": false
},
{
"id": "40b62462-d0de-43fe-8188-2b7738ceff2b",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
2560,
-460
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "5950231f-1309-4f6b-967e-d0279109de51",
"name": "遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
320,
0
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3,
"alwaysOutputData": false
},
{
"id": "2a546eb4-4b59-4195-96e2-b7eba1c3db02",
"name": "等待1",
"type": "n8n-nodes-base.wait",
"position": [
220,
-680
],
"webhookId": "8e37f217-0dfc-4207-8caf-482429db71ee",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f90cadce-6c39-4c06-a8f2-5f6e9dc9b634",
"name": "当点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1280,
-700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "df09b5e3-082b-4bce-8944-08c103b37a87",
"name": "遍历项目4",
"type": "n8n-nodes-base.splitInBatches",
"position": [
160,
880
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5717c401-8c55-4d42-9823-4d0db0f90201",
"name": "使用 Jina.ai 获取网站",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
860,
900
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "c73d880c-ab85-435c-8080-a3ad69f1f5f6",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
1120,
920
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "8c2d984f-7ea0-49e0-83c9-d5a16700a81e",
"name": "Gmail1",
"type": "n8n-nodes-base.gmail",
"position": [
2240,
1000
],
"webhookId": "bb60a806-9295-42f0-af17-ee97d0e07d9a",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "a6521c26-1e78-4c3a-a314-4d5ff16519c6",
"name": "生成电子邮件内容",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1740,
1000
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1fc096aa-703f-435d-b4df-ef1ae82c37ae",
"name": "等待2",
"type": "n8n-nodes-base.wait",
"position": [
3140,
1160
],
"webhookId": "d5ba06e1-56da-489d-9324-745b8e0b0391",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "d054801e-3d52-4233-a74b-e9ef789ce407",
"name": "代码6",
"type": "n8n-nodes-base.code",
"position": [
2860,
1020
],
"parameters": {},
"typeVersion": 2
},
{
"id": "07517064-72cf-4e7a-bf42-5a386fb0a913",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-440,
-960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d1fb586f-f0eb-4dd4-9d9c-0a39444a7502",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
-60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "308a3e5b-c9f8-4415-9dbf-1c8e3ecc81ef",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "40bcfb9c-8627-4e4f-a84b-bc425e0915ff",
"name": "生成查询",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-980,
-700
],
"parameters": {},
"executeOnce": false,
"typeVersion": 1.4,
"alwaysOutputData": true
},
{
"id": "99f29882-f4d4-407c-b89a-9754201b37dc",
"name": "格式化查询",
"type": "n8n-nodes-base.code",
"position": [
-580,
-700
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "3f9f4311-adf5-4487-9f6b-4170b11d7e24",
"name": "遍历查询",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-60,
-700
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f35a8c01-3738-4bc3-9903-6975545253df",
"name": "Gmail 搜索",
"type": "n8n-nodes-base.httpRequest",
"position": [
500,
-680
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "4f99d198-6692-423d-a6c7-cdcb85bc5d9f",
"name": "提取 URL",
"type": "n8n-nodes-base.code",
"position": [
860,
-680
],
"parameters": {},
"typeVersion": 2
},
{
"id": "49b5d048-ae23-416a-812f-f6f3c5a4e3d5",
"name": "过滤 URL",
"type": "n8n-nodes-base.filter",
"onError": "continueRegularOutput",
"position": [
1160,
-680
],
"parameters": {},
"typeVersion": 2.2,
"alwaysOutputData": false
},
{
"id": "49e6a8a7-12a4-4c97-be90-3ea5eac47438",
"name": "如果 URL 不为空",
"type": "n8n-nodes-base.if",
"position": [
1420,
-680
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "7b4b2baf-1375-40a7-bf49-ddbb4a99f413",
"name": "提取域名",
"type": "n8n-nodes-base.code",
"position": [
580,
900
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e86ae6c8-0f12-46f0-afd5-08e7de05f7b6",
"name": "提取电子邮件",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
480,
180
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "1c579280-211b-4c8e-b213-8b54e3f43a1d",
"name": "限制 Markdown",
"type": "n8n-nodes-base.code",
"position": [
1440,
960
],
"parameters": {},
"typeVersion": 2
},
{
"id": "770d1919-68a3-405c-b7cd-faacb15f211e",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1380,
-820
],
"parameters": {},
"typeVersion": 1
}
],
"pinData": {
"When clicking ‘Test workflow’": [
{
"query": "TodayInvestment.com"
}
]
},
"connections": {
"If1": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
],
[
{
"node": "Limit Markdown",
"type": "main",
"index": 0
}
]
]
},
"Code6": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Gmail search",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Gmail1": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Remove Duplicates2",
"type": "main",
"index": 0
}
]
]
},
"Filter urls": {
"main": [
[
{
"node": "If url is not empty",
"type": "main",
"index": 0
}
]
]
},
"Extract Urls": {
"main": [
[
{
"node": "Filter urls",
"type": "main",
"index": 0
}
]
]
},
"Gmail search": {
"main": [
[
{
"node": "Extract Urls",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Code6",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Extract Emails": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Limit Markdown": {
"main": [
[
{
"node": "Generate Email content",
"type": "main",
"index": 0
}
]
]
},
"fomate queries": {
"main": [
[
{
"node": "Loop Over queries",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
],
[
{
"node": "HTTP Request1",
"type": "main",
"index": 0
}
]
]
},
"Generate queries": {
"main": [
[
{
"node": "fomate queries",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract Emails",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items4": {
"main": [
[
{
"node": "Loop Over queries",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract Domain Name",
"type": "main",
"index": 0
}
]
]
},
"Loop Over queries": {
"main": [
[],
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicates": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicates2": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Extract Domain Name": {
"main": [
[
{
"node": "get website with Jina.ai",
"type": "main",
"index": 0
}
]
]
},
"If url is not empty": {
"main": [
[
{
"node": "Remove Duplicates",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over queries",
"type": "main",
"index": 0
}
]
]
},
"Generate Email content": {
"main": [
[
{
"node": "Gmail1",
"type": "main",
"index": 0
}
]
]
},
"get website with Jina.ai": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Generate queries",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Sales、AI等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用AI（GPT-4o）自动化数字产品和SaaS销售
使用AI（GPT-4o）自动化数字产品和SaaS销售
If
Code
Wait
+14
34 节点Badr
Sales
AI个性化多产品邮件营销
基于SMTP轮换的AI个性化多产品邮件营销（GPT-4o/o3-mini）
If
Code
Wait
+16
41 节点Badr
Sales
智能邮件触达序列 - AI驱动且可定制
智能邮件触达序列 - AI驱动且可定制
If
Set
Code
+8
68 节点Badr
Sales
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成（未完成）
If
Set
Code
+9
37 节点Matthieu
Sales
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
Other
API架构提取器
API架构提取器
If
Set
Code
+22
88 节点Polina Medvedieva
Engineering
