来自Google_Maps_Serper的解析器-v1-db
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 12 个节点。主要使用 Set, SplitOut, HttpRequest, GoogleSheets, ConvertToFile 等节点。 使用Serper从Google地图搜索生成商业列表到Sheets或Excel
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "pconmtAjMPl4ooUf",
"name": "来自Google_Maps_Serper的解析器-v1-db",
"nodes": [
{
"id": "38314052-0cbc-4318-86d6-abb004f7c465",
"name": "分离Serper",
"type": "n8n-nodes-base.splitOut",
"position": [
880,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b7c20549-8491-45e8-a643-73ad3b6887bc",
"name": "提取Serper地图",
"type": "n8n-nodes-base.httpRequest",
"position": [
660,
200
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "cee18d18-51b6-4298-be61-eb9291b062b1",
"name": "准备数据",
"type": "n8n-nodes-base.set",
"position": [
1320,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "dc776d9b-eea2-4d82-bd51-9d6094d08091",
"name": "提取数据",
"type": "n8n-nodes-base.set",
"position": [
1100,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e5040427-4763-4225-99a5-96c2d647a78a",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
0,
200
],
"webhookId": "301e7333-b35c-4b03-bf76-12d679e2db80",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "611ce212-5791-4f52-8fa7-0ac3d3e6a02c",
"name": "初始化",
"type": "n8n-nodes-base.set",
"position": [
440,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "369dc928-35f9-446c-9cbe-b5ea7ef2664f",
"name": "变量聊天",
"type": "n8n-nodes-base.set",
"position": [
220,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e97bd437-e30f-436c-820d-a281b75e5656",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2df25edf-0e1e-44d0-9b8e-f2cbeff3f64b",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9aa7cdcf-6e45-40c7-8abe-e132b44339b1",
"name": "获取XLSX格式数据",
"type": "n8n-nodes-base.convertToFile",
"position": [
1540,
0
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "67217615-f365-4a18-a28e-2d3b2ab6a933",
"name": "在Sheets中更新插入数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
200
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "7a2fff63-6a4e-4c9c-9813-9ba60491069b",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "21a31df6-324e-4d32-a910-a65ef5f4cc80",
"connections": {
"Prepare Data": {
"main": [
[
{
"node": "Get Data in XLSX",
"type": "main",
"index": 0
},
{
"node": "Upsert Data in Sheets",
"type": "main",
"index": 0
}
]
]
},
"Initialization": {
"main": [
[
{
"node": "Extract Serper Map",
"type": "main",
"index": 0
}
]
]
},
"Variables Chat": {
"main": [
[
{
"node": "Initialization",
"type": "main",
"index": 0
}
]
]
},
"Extract Data ": {
"main": [
[
{
"node": "Prepare Data",
"type": "main",
"index": 0
}
]
]
},
"Split Out Serper": {
"main": [
[
{
"node": "Extract Data ",
"type": "main",
"index": 0
}
]
]
},
"Extract Serper Map": {
"main": [
[
{
"node": "Split Out Serper",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Variables Chat",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Google Maps SerpAPI 解析器 v1 数据库
通过 SerpAPI 从 Google Maps 抓取企业数据并导出到表格和 Excel
Set
Split Out
Serp Api
+4
12 节点Andrew
潜在客户开发
基于公司ID的Apollo数据丰富
使用Apollo、Google Sheets和Telegram基于公司ID丰富采购联系人
If
Set
Code
+9
27 节点Khaisa Studio
潜在客户开发
从Google地图提取商业邮箱到Google表格用于潜在客户生成
从Google地图提取商业邮箱到Google表格用于潜在客户生成
Code
Wait
Filter
+7
19 节点Noman Mohammad
潜在客户开发
ELV网站邮箱提取
使用EmailListVerify API从网站提取邮箱地址并存储到Google Sheets
If
Set
Code
+6
20 节点EmailListVerify
潜在客户开发
自动化Leadfeeder和Apollo.io数据收集
线索丰富管道：从Leadfeeder到Apollo再到Google Sheets
If
Set
Code
+9
23 节点Khairul Muhtadin
潜在客户开发
使用OpenAI gpt-image-1和AI字幕创建并发布Instagram轮播图
从Google Sheets使用GPT-Image-1和AI字幕自动生成Instagram轮播图
If
Set
Code
+12
32 节点Jorge Martínez
多模态 AI
