使用免费邮箱丰富功能自动化Google Maps潜在客户生成至Google Sheets
高级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 18 个节点。主要使用 If, Code, SplitOut, HttpRequest, GoogleSheets 等节点。 使用免费邮箱丰富功能自动化Google Maps潜在客户生成至Google Sheets
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "ff051d83-dcf5-4e13-aa1b-41135faf15bb",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "59f44e58-7ab9-4a80-b711-fd34e4083537",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
208,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "906b48a5-ff75-428f-8243-a8bbe8a0cbad",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
416,
0
],
"parameters": {},
"typeVersion": 3
},
{
"id": "1b482f8e-29f8-41a1-b870-dc97d13ffe08",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
1200,
-16
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4954cf6b-dda4-4460-ad2a-88b51a6109be",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
672,
16
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "0ef2867c-e0a9-48e8-89cd-56a2ac8a008c",
"name": "提取页面",
"type": "n8n-nodes-base.code",
"position": [
1568,
256
],
"parameters": {},
"typeVersion": 2
},
{
"id": "338ff85f-63c0-4deb-ae44-604b2ebb0291",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
1728,
256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1d75610e-8688-42ba-bd11-58dc2dca4325",
"name": "遍历项目 1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1920,
256
],
"parameters": {},
"typeVersion": 3
},
{
"id": "d0522de8-735e-4a83-b529-96d8c1778a9e",
"name": "获取内部页面",
"type": "n8n-nodes-base.httpRequest",
"position": [
2160,
272
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "cd4c9a29-f3ff-437e-af28-0f1e6172f9cf",
"name": "提取邮箱",
"type": "n8n-nodes-base.code",
"position": [
2352,
272
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f9548421-ca03-4b92-8ac9-7e7ef7d2406a",
"name": "内部找到邮箱",
"type": "n8n-nodes-base.if",
"position": [
2528,
272
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "2511c228-6e53-4635-a1e5-3d403b05263f",
"name": "找到邮箱",
"type": "n8n-nodes-base.if",
"position": [
1360,
-16
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "8068be74-5cfa-47fb-b640-7b4c4973562e",
"name": "邮箱已更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
1792,
16
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "f2a39554-0384-4140-9b92-141508b351aa",
"name": "内部邮箱已更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
2800,
320
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "cbccf908-d9f5-450d-8362-e3d950663c2d",
"name": "未找到邮箱",
"type": "n8n-nodes-base.googleSheets",
"position": [
2256,
576
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "49272a4b-1e30-4f46-bbae-c1f9948b42db",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
976,
0
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f1ad5d41-a4a8-4ae0-be83-d2e6c070cac2",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e2b3631b-ccd6-4b54-9cd5-1c603ff4b37f",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-864,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
],
[
{
"node": "Email Not Found",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Email Found",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Email Found": {
"main": [
[
{
"node": "Email Updated",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract Pages",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
],
[
{
"node": "Email Not Found",
"type": "main",
"index": 0
}
]
]
},
"Email Updated": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Extract Email": {
"main": [
[
{
"node": "Email Found Internal",
"type": "main",
"index": 0
}
]
]
},
"Extract Pages": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Email Not Found": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "Email Not Found",
"type": "main",
"index": 0
}
],
[
{
"node": "Fetch internal page",
"type": "main",
"index": 0
}
]
]
},
"Fetch internal page": {
"main": [
[
{
"node": "Extract Email",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Email Found Internal": {
"main": [
[
{
"node": "Email Updated Internal",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Email Updated Internal": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
使用LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
通过LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
If
Code
Limit
+11
47 节点Matthieu
潜在客户开发
CB资助公司及信息丰富
自动化潜在客户生成与邮件外联：Apify、Apollo.io、GPT-4和Google Sheets
If
Code
Merge
+8
32 节点Intuz
潜在客户开发
ELV网站邮箱提取
使用EmailListVerify API从网站提取邮箱地址并存储到Google Sheets
If
Set
Code
+6
20 节点EmailListVerify
潜在客户开发
使用Gemini AI和Elementor为多个客户生成并安排SEO博客文章
使用Gemini AI和Elementor为多个客户生成并安排SEO博客文章
If
N8n
Set
+12
39 节点Zain Khan
内容创作
自动化Leadfeeder和Apollo.io数据收集
线索丰富管道：从Leadfeeder到Apollo再到Google Sheets
If
Set
Code
+9
23 节点Khairul Muhtadin
潜在客户开发
工作流信息
难度等级
高级
节点数量18
分类2
节点类型8
作者
Zain Khan
@zainI partner with businesses to streamline processes and accelerate growth through intelligent AI automation and Web/mobile Development. Leveraging deep expertise in GPT-4, LangChain, and n8n, I develop AI-powered agents and sophisticated LLM pipelines.
外部链接
在 n8n.io 查看 →
分享此工作流