抓取 Google Maps 潜在客户并使用 Apify 和 Anymailfinder 查找邮箱
高级
这是一个Miscellaneous, Multimodal AI领域的自动化工作流，包含 20 个节点。主要使用 If, Set, Code, Merge, NocoDb 等节点。 抓取 Google Maps 潜在客户并使用 Apify 和 Anymailfinder 查找邮箱
前置要求
- •可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "eb3cc320bca8046d48c5a85268d37732357adb476937d06e2fa23aaf467734b3"
},
"nodes": [
{
"id": "316ef0ee-8231-4100-a13f-485c1864739b",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-672,
144
],
"webhookId": "b1b7ccf3-0559-40d0-8055-bb96037cffe3",
"parameters": {
"options": {},
"formTitle": "Local Biz Search",
"formFields": {
"values": [
{
"fieldLabel": "query",
"requiredField": true
},
{
"fieldLabel": "city",
"requiredField": true
},
{
"fieldLabel": "country code"
},
{
"fieldLabel": "number"
}
]
}
},
"typeVersion": 2.3
},
{
"id": "35313607-94c3-4a7b-8bf4-f65f618db86e",
"name": "抓取Google Maps",
"type": "n8n-nodes-base.httpRequest",
"position": [
-448,
144
],
"parameters": {
"url": "https://api.apify.com/v2/acts/compass~crawler-google-places/run-sync-get-dataset-items",
"method": "POST",
"options": {},
"jsonBody": "={\n \"city\": \"{{ $json.city }}\",\n \"countryCode\": \"{{ $json['country code'] }}\",\n \"locationQuery\": \"{{ $json.city }}\",\n \"maxCrawledPlacesPerSearch\":{{ $json.number ? $json.number : 99999 }},\n \"searchStringsArray\": [\n \"{{ $json.query }}\"\n ],\n \"skipClosedPlaces\": true\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth"
},
"credentials": {
"httpQueryAuth": {
"id": "EApLIRuvFmHYcA5e",
"name": "Apify S"
}
},
"typeVersion": 4.2
},
{
"id": "9ef55da1-0d8f-4665-b702-ef66af067987",
"name": "获取邮箱",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
416,
240
],
"parameters": {
"url": "https://api.anymailfinder.com/v5.1/find-email/company",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "=domain",
"value": "={{ $json.domain}}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "jvuoNfQ4boThl8nf",
"name": "anymailfinder alexaspalato"
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "7a1cb6ab-20ed-4ba9-acb3-25af2b8ca995",
"name": "提取数据",
"type": "n8n-nodes-base.set",
"position": [
0,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "53d8d9b3-40ac-4a01-ae31-fb6233ba1c53",
"name": "title",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "ecc7c3ee-20f0-43c9-a489-05467e521212",
"name": "address",
"type": "string",
"value": "={{ $json.address }}"
},
{
"id": "ecdea9cb-3ae7-4229-9a5b-d9dbd4ee3b35",
"name": "neighborhood",
"type": "string",
"value": "={{ $json.neighborhood }}"
},
{
"id": "f01a74a8-ff34-458b-900a-18da2ee41091",
"name": "website",
"type": "string",
"value": "={{ $json.website }}"
},
{
"id": "a1416416-e378-45a5-85d4-50eed6a6683c",
"name": "phone",
"type": "string",
"value": "={{ $json.phone }}"
},
{
"id": "6f0980ba-8964-40fd-a4ce-6cbb780bf10d",
"name": "totalScore",
"type": "number",
"value": "={{ $json.totalScore }}"
},
{
"id": "cd70afef-02bf-4bff-a9c3-1270c9c54140",
"name": "subTitle",
"type": "string",
"value": "={{ $json.subTitle }}"
},
{
"id": "4d9f6e00-364f-4da5-a27d-3c3c740da535",
"name": "categories",
"type": "string",
"value": "={{ $json.categories.join(\",\") }}"
},
{
"id": "abcc7074-dd5c-4441-8644-a4ba59844630",
"name": "city",
"type": "string",
"value": "={{ $json.city }}"
},
{
"id": "bba8f41d-a20e-4a50-82e9-25d00b69aef6",
"name": "countryCode",
"type": "string",
"value": "={{ $json.countryCode }}"
},
{
"id": "fb5f656a-a94a-44c9-8bf8-70d64e47102e",
"name": "postalCode",
"type": "string",
"value": "={{ $json.postalCode }}"
},
{
"id": "cbc7560f-2bef-451f-92b6-d1efeb17c49e",
"name": "placeId",
"type": "string",
"value": "={{ $json.placeId }}"
},
{
"id": "5c5945cd-763c-4505-b7b9-ab57f10747ba",
"name": "date",
"type": "string",
"value": "={{ $json.scrapedAt.toDateTime().format('dd/LL/yyyy') }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "547152fc-4375-4239-98ec-7e9df4091297",
"name": "提取邮箱",
"type": "n8n-nodes-base.set",
"position": [
576,
240
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4eadc93e-4897-4467-965e-3d1b59b17739",
"name": "emails",
"type": "string",
"value": "={{ $json.emails.join(\",\") }}"
},
{
"id": "e8ac106b-19f9-4a2c-aab4-25d19a6986c5",
"name": "email_status",
"type": "string",
"value": "={{ $json.email_status }}"
},
{
"id": "50977992-7cca-4e8d-940e-a290ab292390",
"name": "domain",
"type": "string",
"value": "={{ $json.input.domain }}"
},
{
"id": "cce9c672-4cf8-4f98-8a3d-24f49ba2f13a",
"name": "title",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.title }}"
},
{
"id": "ec0c8aff-a80f-4f1c-9760-cfa23f3061f0",
"name": "address",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.address }}"
},
{
"id": "640819a4-ba76-4afd-ba17-9907a5b9992b",
"name": "neighborhood",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.neighborhood }}"
},
{
"id": "ccdc11b2-60fe-4eeb-b4f7-7895c9eeafa3",
"name": "website",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.website }}"
},
{
"id": "5108364b-fd20-4b43-9836-87ba3668b421",
"name": "phone",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.phone }}"
},
{
"id": "207d465f-0a64-4caa-ab1f-fa5baeb797f7",
"name": "totalScore",
"type": "number",
"value": "={{ $('Filter items with domain').item.json.totalScore }}"
},
{
"id": "a3369776-9668-4b6e-8492-7a8422f47d72",
"name": "categories",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.categories }}"
},
{
"id": "005fb833-719c-4f52-afed-3a44ab94d6cf",
"name": "city",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.city }}"
},
{
"id": "d22aa27a-a622-48a7-8e94-45d722904efd",
"name": "countryCode",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.countryCode }}"
},
{
"id": "7ae6c4d8-7fef-4857-a48a-ccc780bafcfa",
"name": "postalCode",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.postalCode }}"
},
{
"id": "1849ec06-87b0-480c-808b-b369dd6470a6",
"name": "date",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.date }}"
},
{
"id": "f88d7e6c-9d87-4994-975f-547a24621cba",
"name": "placeId",
"type": "string",
"value": "={{ $('Filter items with domain').item.json.placeId }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "894a2068-3455-45c9-85ba-6e74d5ae350a",
"name": "清理数据",
"type": "n8n-nodes-base.code",
"position": [
224,
0
],
"parameters": {
"jsCode": "return items.map(item => {\n const j = item.json || {};\n const original = j.website || null;\n\n let website_root = null;\n let domain = null;\n let domain_strategy = 'none';\n\n if (original && typeof original === 'string') {\n let urlStr = original.trim();\n\n // Add protocol if missing\n if (!/^https?:\\/\\//i.test(urlStr)) {\n urlStr = 'https://' + urlStr;\n }\n\n try {\n const urlObj = new URL(urlStr);\n website_root = `${urlObj.protocol}//${urlObj.host}`;\n domain = urlObj.host.toLowerCase();\n domain_strategy = 'site_host';\n } catch (e) {\n // fallback if URL is malformed\n website_root = urlStr.split('?')[0];\n const match = website_root.match(/^https?:\\/\\/([^\\/]+)/i);\n if (match) {\n domain = match[1].toLowerCase();\n domain_strategy = 'site_host_fallback';\n }\n }\n }\n\n // Remove \"www.\" prefix\n if (domain && domain.startsWith('www.')) {\n domain = domain.slice(4);\n }\n\n // Exclude social networks\n const SOCIAL_HOSTS = [\n 'facebook.com', 'instagram.com', 'linktr.ee', 'twitter.com', 'google.com', 'youtube.com'\n ];\n if (domain && SOCIAL_HOSTS.some(h => domain.endsWith(h))) {\n domain = null;\n domain_strategy = 'social';\n }\n\n // Output\n j.website_root = website_root;\n j.domain = domain;\n j.domain_strategy = domain_strategy;\n if (website_root) j.website = website_root;\n\n item.json = j;\n return item;\n});\n\n\n"
},
"typeVersion": 2
},
{
"id": "513cfe88-27ec-4cd1-a10e-772859d392b9",
"name": "避免重复",
"type": "n8n-nodes-base.code",
"position": [
640,
0
],
"parameters": {
"jsCode": "const allPlaceIds = $('Get all the recorded placeIds').all().map(item => item.json.placeId);\nconst scrapedItems = $('Clean Data').all().map(item => item.json);\n\n// keep only items with a new placeId\nconst filtered = scrapedItems.filter(item => item.placeId && !allPlaceIds.includes(item.placeId));\n\n// return each as its own item\nreturn filtered.map(item => ({ json: item }));\n"
},
"executeOnce": true,
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "bcbff4a5-67da-4dae-b630-64067ab8a0e9",
"name": "合并1",
"type": "n8n-nodes-base.merge",
"position": [
736,
416
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "5fe49b72-c966-4c71-8d0e-59f7f8e3c7c4",
"name": "筛选含域名的项目",
"type": "n8n-nodes-base.if",
"position": [
208,
256
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "dc9c506d-8615-4383-9fd4-8e94ed280738",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.domain }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e20270dd-cb66-4e95-b4cb-2bb837d54d92",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-224,
144
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "a826f0ea-ab1c-4ac1-ba71-f9338a276fce",
"name": "获取所有记录的placeId",
"type": "n8n-nodes-base.nocoDb",
"position": [
448,
0
],
"parameters": {
"table": "m8xjj32j1tvty0z",
"options": {
"where": "=(placeId,eq,{{ $json.placeId }})"
},
"operation": "getAll",
"projectId": "p75lcduba1trkxn",
"returnAll": true,
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "XcfeXxqx8zD1546V",
"name": "NocoDB Token account"
}
},
"executeOnce": false,
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "a9e1eeb5-6e95-44fb-bee5-b637446a876b",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
0,
288
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "490232c7-e1c3-43e6-a13c-b7e8ada04272",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.placeId }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "dbeadea9-956c-4e40-b4ce-0ae4103adfad",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-512,
-48
],
"parameters": {
"color": 4,
"height": 352,
"content": "## Apify Google Maps 抓取工具"
},
"typeVersion": 1
},
{
"id": "1ff8f9b0-da34-43b0-ae42-7c1e007bbbc9",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-208
],
"parameters": {
"color": 4,
"height": 352,
"content": "## 移除错误URL并清理扩展名"
},
"typeVersion": 1
},
{
"id": "c2a8e787-73ef-4ad6-8981-5aac3939f14f",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
-208
],
"parameters": {
"color": 4,
"width": 352,
"height": 352,
"content": "## 避免数据库中的重复项"
},
"typeVersion": 1
},
{
"id": "015b723b-8835-4106-88dc-14a877f02758",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
416
],
"parameters": {
"color": 4,
"width": 272,
"height": 240,
"content": "## 如果项目已存在，则转到循环中的下一个"
},
"typeVersion": 1
},
{
"id": "090bd8b5-170f-4362-a3df-0db32d780760",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
400
],
"parameters": {
"color": 4,
"width": 352,
"height": 352,
"content": "## 如果有域名，我们使用anymailfinder搜索邮箱"
},
"typeVersion": 1
},
{
"id": "4d4dd550-c34c-49de-a0f6-ace20643ed06",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
864,
288
],
"parameters": {
"color": 4,
"height": 352,
"content": "## 将项目记录到NocoDB中并转到下一个项目"
},
"typeVersion": 1
},
{
"id": "71e493fe-1023-463f-92cd-62db77fa32de",
"name": "创建行",
"type": "n8n-nodes-base.nocoDb",
"position": [
928,
416
],
"parameters": {
"table": "m8xjj32j1tvty0z",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "title",
"fieldValue": "={{ $json.title }}"
},
{
"fieldName": "website",
"fieldValue": "={{ $json.website }}"
},
{
"fieldName": "phone",
"fieldValue": "={{ $json.phone }}"
},
{
"fieldName": "email",
"fieldValue": "={{ $json.emails }}"
},
{
"fieldName": "email_validation",
"fieldValue": "={{ $json.email_status }}"
},
{
"fieldName": "address",
"fieldValue": "={{ $json.address }}"
},
{
"fieldName": "neighborhood",
"fieldValue": "={{ $json.neighborhood }}"
},
{
"fieldName": "rating",
"fieldValue": "={{ $json.totalScore }}"
},
{
"fieldName": "categories",
"fieldValue": "={{ $('Filter items with domain').item.json.categories }}"
},
{
"fieldName": "city",
"fieldValue": "={{ $('Filter items with domain').item.json.city }}"
},
{
"fieldName": "country",
"fieldValue": "={{ $('Filter items with domain').item.json.countryCode }}"
},
{
"fieldName": "postal code",
"fieldValue": "={{ $('Filter items with domain').item.json.postalCode }}"
},
{
"fieldName": "domain",
"fieldValue": "={{ $('Filter items with domain').item.json.domain }}"
},
{
"fieldName": "placeId",
"fieldValue": "={{ $json.placeId }}"
},
{
"fieldName": "date",
"fieldValue": "={{ $json.date }}"
}
]
},
"operation": "create",
"projectId": "p75lcduba1trkxn",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "XcfeXxqx8zD1546V",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "8fff3b18-234a-44d2-9fae-8672d9259afb",
"name": "### 需要帮助？",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
-352
],
"parameters": {
"content": "## 链接"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "Filter items with domain",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Create a row",
"type": "main",
"index": 0
}
]
]
},
"Clean Data": {
"main": [
[
{
"node": "Get all the recorded placeIds",
"type": "main",
"index": 0
}
]
]
},
"Get Emails": {
"main": [
[
{
"node": "Extract Emails",
"type": "main",
"index": 0
}
]
]
},
"Create a row": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Extract data": {
"main": [
[
{
"node": "Clean Data",
"type": "main",
"index": 0
}
]
]
},
"Extract Emails": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Extract data",
"type": "main",
"index": 0
}
]
]
},
"Avoid duplicates": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Scrape Google Maps",
"type": "main",
"index": 0
}
]
]
},
"Scrape Google Maps": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Filter items with domain": {
"main": [
[
{
"node": "Get Emails",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Get all the recorded placeIds": {
"main": [
[
{
"node": "Avoid duplicates",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 杂项, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
公司邮箱查找器新版本
使用 Serper.dev 和 AnyMailFinder 查找 B2B 决策者邮箱并构建潜在客户数据库
If
Set
Code
+11
33 节点Alexandra Spalato
AI 摘要总结
LinkedIn自动私信潜在客户磁铁
LinkedIn潜在客户生成：基于评论触发的自动私信系统（Unipile & NocoDB）
If
Code
Wait
+8
32 节点Alexandra Spalato
客户培育
PDF 转订单
使用AI将PDF采购订单自动化转换为Adobe Commerce销售订单
If
Set
Code
+19
96 节点JKingma
文档提取
自动化演示预约系统
集成 Outlook 日历和 Zoom 的自动化演示预约系统
If
Set
Code
+6
21 节点AureusR
杂项
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
工作流信息
难度等级
高级
节点数量20
分类2
节点类型9
作者
Alexandra Spalato
@alexaspalatoI'm an AI automation consultant with over a decade of experience in web development. I help businesses streamline their marketing and operations by building custom n8n workflows that save time and boost results. Ready to see what automation can do for your business? Use my link to book your initial consultation.
外部链接
在 n8n.io 查看 →
分享此工作流