AI潜在客户挖掘智能体
高级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 20 个节点。主要使用 If, Set, Wait, Gmail, Filter 等节点。 使用Apify、AI和Gmail的自动化潜在客户生成与冷邮件发送
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
- •Google Gemini API Key
使用的节点 (20)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "c8SrVtTq7YyxoLlO",
"meta": {
"instanceId": "061ca141d020a6e1355b8c7fe05f92a699e37e92079ad2e150a506ee8bbe9e11"
},
"name": "AI 潜在客户挖掘智能体",
"tags": [],
"nodes": [
{
"id": "49a75edf-736f-4054-aea8-8a24c159f27b",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
64,
96
],
"webhookId": "2ef0c938-f117-4f6c-840a-b2dc35a615b3",
"parameters": {
"options": {
"buttonLabel": "GO 🚀",
"appendAttribution": false
},
"formTitle": "Lead Machine",
"formFields": {
"values": [
{
"fieldLabel": "Business Type",
"placeholder": "e.g. Plumber",
"requiredField": true
},
{
"fieldLabel": "Location",
"placeholder": "e.g. Rome, Italy",
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Lead Number",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Email Style",
"fieldOptions": {
"values": [
{
"option": "Friendly"
},
{
"option": "Professional"
},
{
"option": "Simple"
}
]
}
}
]
},
"formDescription": "Provide the Info Below"
},
"typeVersion": 2.2
},
{
"id": "2294be1e-b7e7-437a-ba31-322bf4c7065f",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
320,
96
],
"parameters": {
"url": "=Apify_Actor_Endpoint_URL",
"options": {},
"jsonBody": "={\n \"includeWebResults\": false,\n \"language\": \"en\",\n \"locationQuery\": \"{{ $json.Location }}\",\n \"maxCrawledPlacesPerSearch\": {{ $json['Lead Number'] }},\n \"maxImages\": 0,\n \"maximumLeadsEnrichmentRecords\": 0,\n \"scrapeContacts\": false,\n \"scrapeDirectories\": false,\n \"scrapeImageAuthors\": false,\n \"scrapePlaceDetailPage\": false,\n \"scrapeReviewsPersonalData\": true,\n \"scrapeTableReservationProvider\": false,\n \"searchStringsArray\": [\n \"{{ $json['Business Type'] }}\"\n ],\n \"skipClosedPlaces\": false\n}",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2
},
{
"id": "51ab8621-f27b-435e-8621-2237df7b16d8",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"color": 3,
"width": 752,
"height": 336,
"content": "# 业务数据"
},
"typeVersion": 1
},
{
"id": "571cd0ce-4578-4e7a-8a92-647ef4662d3b",
"name": "信息提取器",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
-64,
448
],
"parameters": {
"text": "=Website: {{ $json.website }}",
"options": {},
"attributes": {
"attributes": [
{
"name": "Email Address",
"required": true,
"description": "=find out the best only one email address from the website after scraping the website. The mail address have to be in ideal format."
}
]
}
},
"typeVersion": 1.2
},
{
"id": "0d5da717-af00-429f-91aa-cf09402341e0",
"name": "Google Gemini聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
32,
592
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "f1cc441c-8138-4038-a5bf-b243f830d2ea",
"name": "过滤器",
"type": "n8n-nodes-base.filter",
"position": [
576,
96
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0906e21a-0958-433e-b400-8694915ef3c9",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.website }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e3f168e5-4330-4ee7-ba4e-52df7d58f120",
"name": "在表格中追加行",
"type": "n8n-nodes-base.googleSheets",
"position": [
640,
432
],
"parameters": {
"columns": {
"value": {
"Address": "={{ $('Filter').item.json.address }}",
"Website": "={{ $('Filter').item.json.website }}",
"Category": "={{ $('Filter').item.json.categoryName }}",
"Company Name": "={{ $('Filter').item.json.title }}",
"Email Address": "={{ $json.output['Email Address'] }}",
"Phone Nummber": "={{ $('Filter').item.json.phoneUnformatted }}"
},
"schema": [
{
"id": "Company Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Nummber",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone Nummber",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Cold Mail Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Cold Mail Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SEND Time",
"type": "string",
"display": true,
"required": false,
"displayName": "SEND Time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LmOvSzCOAlrgxQg5r77eVkyJWw3V0VDUAWgkoHWql1Y/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1LmOvSzCOAlrgxQg5r77eVkyJWw3V0VDUAWgkoHWql1Y",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LmOvSzCOAlrgxQg5r77eVkyJWw3V0VDUAWgkoHWql1Y/edit?usp=drivesdk",
"cachedResultName": "n8n Test"
}
},
"typeVersion": 4.6
},
{
"id": "0a3d98f3-2446-4491-9e86-f97759765b4a",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
352,
448
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0601f2d2-2522-471e-9e11-29498a47e19a",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.output['Email Address'] }}",
"rightValue": "@"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "fd369959-451a-4e86-b988-4e233a5e2904",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
640,
608
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b9fea00f-fdef-4e75-82b3-283ef4ecb651",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
368
],
"parameters": {
"color": 4,
"width": 1136,
"height": 368,
"content": "# 获取邮箱地址"
},
"typeVersion": 1
},
{
"id": "87b79200-12c4-43a9-97c8-72727e73bf11",
"name": "发送消息",
"type": "n8n-nodes-base.gmail",
"onError": "continueRegularOutput",
"maxTries": 2,
"position": [
992,
864
],
"webhookId": "9ce15ceb-1aeb-4dd7-b269-f981f431c05f",
"parameters": {
"sendTo": "={{ $json['Email Address'] }}",
"message": "={{ $('Information Extractor1').item.json.output['Mail Body'] }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $('Information Extractor1').item.json.output['Mail Subject'] }}",
"emailType": "text"
},
"executeOnce": false,
"retryOnFail": false,
"typeVersion": 2.1
},
{
"id": "db871413-4d1c-4d9f-be82-f5b938baa7b1",
"name": "信息提取器1",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
352,
864
],
"parameters": {
"text": "=You are a perfect cold mail generator for a Digital Marketing Agency named Upward Engine.\n\nHere's the Information about the Recipient:\n\nCompany Name: {{ $('Loop Over Items').item.json['Company Name'] }}\nBusiness Type: {{ $('Loop Over Items').item.json.Category }}\n\nEmail Style / Email Tune : {{ $json['Email Style'] }}\n\nThe Email style is given just to understand how the mail will be.\n\nInstructions:\n\n1. Always start with giving a greting to the Company like Hi Company Name,\n2. Always use We not I.\n3. Mail have to be professional, Clean and to the point\n4. At last give a Signeture Like:\n [Your Name]\n [Your Company/Agency Name]",
"options": {},
"attributes": {
"attributes": [
{
"name": "Mail Subject",
"required": true,
"description": "Eye catchy mail Subject for the cold mail"
},
{
"name": "Mail Body",
"required": true,
"description": "=body message of the mail, a perfect and clear cold mail."
}
]
}
},
"typeVersion": 1.2
},
{
"id": "325cc956-c3b8-4222-bdd6-0712d9061f99",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
448,
992
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"typeVersion": 1.2
},
{
"id": "8b727879-86bf-411e-a0b0-7cf4e55be0e5",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1248,
864
],
"parameters": {
"columns": {
"value": {
"SEND Time": "={{ $('Edit Fields1').item.json['Send Time'] }}",
"Email Address": "={{ $('Edit Fields1').item.json['Email Address'] }}",
"Cold Mail Status": "✅"
},
"schema": [
{
"id": "Company Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Nummber",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone Nummber",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Cold Mail Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Cold Mail Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SEND Time",
"type": "string",
"display": true,
"required": false,
"displayName": "SEND Time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email Address"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LmOvSzCOAlrgxQg5r77eVkyJWw3V0VDUAWgkoHWql1Y/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1LmOvSzCOAlrgxQg5r77eVkyJWw3V0VDUAWgkoHWql1Y",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LmOvSzCOAlrgxQg5r77eVkyJWw3V0VDUAWgkoHWql1Y/edit?usp=drivesdk",
"cachedResultName": "n8n Test"
}
},
"typeVersion": 4.6
},
{
"id": "3dbfe1e8-1033-4d6c-b8c7-144341fe579e",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-656,
768
],
"parameters": {
"color": 5,
"width": 2096,
"height": 448,
"content": "# 邮件发送"
},
"typeVersion": 1
},
{
"id": "57178d65-593e-44c9-91f5-b2b917b0a3cc",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
768,
864
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "8ab73a5e-6659-4615-9f03-a1b3dacaa42e",
"name": "Send Time",
"type": "string",
"value": "={{$now.toFormat(\"MM-dd-yyyy (h:mm a)\")}}"
},
{
"id": "a102af99-f990-4f54-aa19-96a4c8002a9b",
"name": "Email Address",
"type": "string",
"value": "={{ $('Wait').item.json['Email Address'] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3e2a864f-9077-43a4-8b35-32a64201c03a",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueRegularOutput",
"position": [
-400,
848
],
"parameters": {
"options": {}
},
"notesInFlow": false,
"typeVersion": 3
},
{
"id": "f13527f0-7873-4dd7-8c1a-c56d227fa171",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
32,
864
],
"webhookId": "a8a457d5-f88d-451c-ac51-1af17c8435b0",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "9fbb652b-57aa-44fd-b40d-6a09b5792848",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1712,
-16
],
"parameters": {
"width": 480,
"height": 464,
"content": "## 从这里开始：分步 YouTube 教程 :star:"
},
"typeVersion": 1
},
{
"id": "fdb08105-efcd-4e48-ba07-86aab936a2ef",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1696,
544
],
"parameters": {
"width": 1200,
"height": 672,
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "004cb861-1063-4df9-81c8-972afc2160d3",
"connections": {
"If": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Information Extractor1",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Information Extractor",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Send a message": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Information Extractor1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Information Extractor1": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Information Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动化本地线索查找与冷邮件发送
使用 Apify、AI 和 Gmail 自动查找本地线索并发送冷邮件
If
Set
Wait
+10
18 节点Meak
内容创作
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用 Bright Data 抓取 Google 地图并生成 AI 外联消息用于潜在客户开发
使用 Bright Data 抓取 Google 地图并生成 AI 外联消息用于潜在客户开发
If
Set
Wait
+15
36 节点Solomon
潜在客户开发
AI发票助手
AI发票代理
Set
Gmail
Filter
+8
13 节点Rakin Jakaria
发票处理
自动化潜在客户生成与冷邮件工作流（AI + Telegram + Google Sheets 跟踪）
使用OpenAI、Apify、Gmail和Telegram的自动化B2B潜在客户生成与冷邮件
If
Set
Wait
+10
22 节点Adem Tasin
