Google Maps 潜在客户：姓名、邮箱、电话，使用 Apify + Airtable + 个性化邮件
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 Set, Wait, Gmail, Airtable, HttpRequest 等节点。 使用 Apify 和 Airtable 抓取 Google Maps 企业潜在客户并发送个性化邮件
前置要求
- •Google 账号和 Gmail API 凭证
- •Airtable API Key
- •可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "RDxVDTX2mj9U1BO2",
"meta": {
"instanceId": "18b0d04ad5030054be4ab49562e84ea4a079ab4cb036003697394140227c7e76",
"templateCredsSetupCompleted": true
},
"name": "Google Maps 潜在客户：姓名、邮箱、电话，使用 Apify + Airtable + 个性化邮件",
"tags": [],
"nodes": [
{
"id": "1a38e723-d45b-4ec1-ae13-1770aab8cfc9",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
272,
-48
],
"webhookId": "b12ac28e-1660-4806-9234-b9ad52259157",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "bc63dc4b-5bbc-4b6e-9886-3b7991c4cb05",
"name": "开始",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-240,
-48
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e303891a-36f4-47d1-a0ff-06ae06a7761b",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
-928
],
"parameters": {
"color": 7,
"width": 336,
"height": 208,
"content": ""
},
"typeVersion": 1
},
{
"id": "94423aac-8826-4f99-9bc5-7fade0182d02",
"name": "APIFY 抓取 GOOGLE MAPS",
"type": "n8n-nodes-base.httpRequest",
"position": [
32,
-48
],
"parameters": {
"url": "YOUR URL ",
"method": "POST",
"options": {},
"jsonBody": "{\n \"area_height\": 10,\n \"area_width\": 10,\n \"emails_only\": true,\n \"gmaps_url\": \"https://www.google.com/maps/search/centres+de+formation+%C3%A0+proximit%C3%A9+de+Amiens/@49.7566146,2.2528038,9.75z?entry=ttu&g_ep=EgoyMDI1MDgxMy4wIKXMDSoASAFQAw%3D%3D\",\n \"max_results\": 200,\n \"search_query\": \"centre de formation\"\n}",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2
},
{
"id": "1239d5a5-8fee-4049-b052-581f0b1558ad",
"name": "清理数据映射",
"type": "n8n-nodes-base.set",
"position": [
544,
-48
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "91a75c6f-35b8-42da-8e6f-7819146738da",
"name": "Société",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "935cde97-255a-48b2-ab31-e4f9e8090370",
"name": "Mail",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "9a97e5ed-d4c6-459a-815c-bfa657325353",
"name": "Téléphone",
"type": "string",
"value": "={{ $json.phone_number }}"
},
{
"id": "72aeb15f-c2e7-4995-94ef-1deda482cdc1",
"name": "Site Web",
"type": "string",
"value": "={{ $json.website_url }}"
},
{
"id": "a3dc6fc2-2a8e-4974-9975-0bd768f776d9",
"name": "Linkedin",
"type": "string",
"value": "={{ $json.linkedin }}"
},
{
"id": "d90903e6-4b18-45ea-b0d0-e836f6996d6e",
"name": "Facebook",
"type": "string",
"value": "={{ $json.facebook }}"
},
{
"id": "d8b054b7-4b4f-446c-8d43-df1f183d7885",
"name": "Ville",
"type": "string",
"value": "={{ $json.city }} "
},
{
"id": "79d3f281-fd47-4bf0-bfeb-5db91af83ea8",
"name": "Catégorie centre formation",
"type": "string",
"value": "={{ $json.google_business_categories }}"
},
{
"id": "41a8eb11-c02a-4e0a-ba35-3985dd42dd08",
"name": "Notes google maps",
"type": "string",
"value": "={{ $json.reviews_number }} avis avec une note de {{ $json.review_score }} / 5 "
},
{
"id": "40c0b0ef-4ad3-4138-9c35-ca5e817574d9",
"name": "Lien Google MAP ",
"type": "string",
"value": "={{ $json.google_maps_url }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2f44f519-83b5-45f5-8c97-572eb0830239",
"name": "AIRTABLE 创建记录",
"type": "n8n-nodes-base.airtable",
"position": [
960,
-48
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appA6eMHOoquiTCeO",
"cachedResultUrl": "https://airtable.com/appA6eMHOoquiTCeO",
"cachedResultName": "GOOGLE MAPS SCRAPT"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZFszM5ubwwSYDK",
"cachedResultUrl": "https://airtable.com/appA6eMHOoquiTCeO/tblZFszM5ubwwSYDK",
"cachedResultName": "Google maps scrapt"
},
"columns": {
"value": {
"Mail": "={{ $json.Mail }}",
"Ville": "={{ $json.Ville }}",
"Facebook": "={{ $json.Facebook }}",
"Linkedin": "={{ $json.Linkedin }}",
"Site Web": "={{ $json['Site Web'] }}",
"Société": "={{ $json['Société'] }}",
"Téléphone": "={{ $json['Téléphone'] }}",
"Lien Google Maps": "={{ $json['Lien Google MAP '] }}",
"Notes google maps": "={{ $json['Notes google maps'] }}",
"Catégorie centre formation": "={{ $json['Catégorie centre formation'] }}"
},
"schema": [
{
"id": "Société",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Société",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mail",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Mail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Téléphone",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Téléphone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Site Web",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Site Web",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkedin",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Facebook",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Facebook",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Ville",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Ville",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Catégorie centre formation",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Catégorie centre formation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes google maps",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Notes google maps",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lien Google Maps",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Lien Google Maps",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "vKZ5Wl43rmNFe0My",
"name": "Airtable Personal Access Token account 3"
}
},
"typeVersion": 2.1
},
{
"id": "118454ed-e384-40fe-b95a-111b71c5c9e7",
"name": "自动发送邮件",
"type": "n8n-nodes-base.gmail",
"position": [
1376,
-48
],
"webhookId": "efa6d8ed-ff7b-4866-9d84-d8f3c3a1fae5",
"parameters": {
"sendTo": "={{ $json.fields.Mail }}",
"message": "=<div style=\"font-family:Arial,Helvetica,sans-serif;font-size:15px;line-height:1.6;color:#111;max-width:620px;margin:0 auto;padding:18px\"> \n <p>Hello {{ $json.fields['Société'] }} team,</p> \n\n <p>I design custom automations for training centers. Goal: <strong>zero repetitive manual tasks</strong>, from registration to invoicing.</p> \n\n <ul style=\"padding-left:18px;margin:10px 0\"> \n <li>Registrations → Airtable + automatic file generation (Drive/PDF).</li> \n <li>Invitations & reminders → scheduled email/SMS.</li> \n <li>Attendance (e.g. EduSign) → automatic export & archiving.</li> \n <li>Invoicing & OPCO files → generation + storage in the right folders.</li> \n <li>Weekly reporting → KPIs sent by email/Slack.</li> \n </ul> \n\n <p style=\"margin-top:12px\"> \n <em>Info:</em> {{ $json.fields['Société'] }} in {{ $json.fields.Ville }} \n — website: <a href=\"{{ $json.fields['Site Web'] }}\" style=\"color:#0b5fff\">{{ $json.fields['Site Web'] }}</a> \n {{ $json.fields['Notes google maps'] ? ('— ' + $json.fields['Notes google maps']) : '' }} \n </p> \n\n <p>Would you be open to a quick <strong>15-min call</strong> (video) where I show you a mini-workflow adapted to {{ $json.fields['Société'] }}?</p> \n\n <p style=\"margin:16px 0\"> \n <a href=\"https://calendly.com/ton-lien/15min\" style=\"background:#0b5fff;color:#fff;text-decoration:none;padding:10px 14px;border-radius:8px;display:inline-block\">Book a slot</a> \n </p> \n\n <p>Talk soon,<br/>Baptiste Fort</p> \n</div>\n",
"options": {},
"subject": "={{ $json.fields['Société'] }}"
},
"credentials": {
"gmailOAuth2": {
"id": "ZQCvZLpPNoHgoJmJ",
"name": "OFFICIEL COMPTE GMAIL"
}
},
"typeVersion": 2.1
},
{
"id": "e7b95129-ab76-48d6-b7ad-f006c4ce38c2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-288,
-336
],
"parameters": {
"height": 464,
"content": "## **步骤 1 – 开始触发器**"
},
"typeVersion": 1
},
{
"id": "53d9dca3-704c-4d6e-9537-b0c2f0432634",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
-768
],
"parameters": {
"color": 2,
"width": 256,
"height": 896,
"content": "## **步骤 2 – 抓取 Google Maps**"
},
"typeVersion": 1
},
{
"id": "0d2bf046-8eae-463e-b3a9-46212f2080a1",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
208,
-336
],
"parameters": {
"color": 3,
"height": 464,
"content": "## 步骤 3 – 等待"
},
"typeVersion": 1
},
{
"id": "cb179395-d2bf-424a-b1a7-6c4df0b3621b",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
-624
],
"parameters": {
"color": 4,
"width": 304,
"height": 752,
"content": "## 步骤 4 – 映射"
},
"typeVersion": 1
},
{
"id": "c852694e-bb9c-4e95-bf48-12da1b5fe71c",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
752,
-1088
],
"parameters": {
"color": 5,
"width": 512,
"height": 1216,
"content": "## 步骤 5 – Airtable 存储"
},
"typeVersion": 1
},
{
"id": "1e09688f-058c-46a7-a96b-a1a645e3de9b",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
-720
],
"parameters": {
"color": 7,
"width": 336,
"height": 848,
"content": "## 步骤 6 – 自动邮件"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"SEND EMAIL AUTOMATIC": [
{
"json": {
"code": 1,
"name": "First item"
}
},
{
"json": {
"code": 2,
"name": "Second item"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "fceb5fdc-0432-44c5-9b74-70d517601074",
"connections": {
"GO": {
"main": [
[
{
"node": "APIFY SCRAPT GOOGLE MAPS",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "CLEAN DATA MAPPING",
"type": "main",
"index": 0
}
]
]
},
"CLEAN DATA MAPPING": {
"main": [
[
{
"node": "AIRTABLE CREATE RECORD",
"type": "main",
"index": 0
}
]
]
},
"AIRTABLE CREATE RECORD": {
"main": [
[
{
"node": "SEND EMAIL AUTOMATIC",
"type": "main",
"index": 0
}
]
]
},
"APIFY SCRAPT GOOGLE MAPS": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
报价请求？Tally发送，Airtable记录，Slack提醒，Gmail致谢。
使用Tally、Airtable、Slack和Gmail自动化报价请求处理
Set
Wait
Gmail
+4
13 节点Baptiste Fort
潜在客户开发
自动化Tally表单处理
使用Gmail回复自动化Tally表单提交到Airtable
Set
Wait
Gmail
+3
11 节点Baptiste Fort
潜在客户开发
自动化Tally表单的Slack通知
自动化Tally表单：使用Airtable存储，通过Slack通知
Set
Wait
Gmail
+3
11 节点Baptiste Fort
潜在客户开发
自动化每日股市报告
使用 Bright Data、GPT-4.1、Airtable 和 Gmail 的自动化每日股市报告
Set
Wait
Switch
+10
27 节点Baptiste Fort
内容创作
销售线索_1
使用 Jina AI 和 OpenAI 代理生成销售线索和个性化外联邮件
Set
Wait
Merge
+8
28 节点FabioInTech
潜在客户开发
销售线索 - Jina 到 Gmail
使用 Jina AI 和 OpenAI 生成并研究销售线索，通过 Gmail 实现邮件自动化
If
Set
Wait
+12
43 节点FabioInTech
客户培育
