Google Maps SerpAPI 解析器 v1 数据库
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 12 个节点。主要使用 Set, SplitOut, SerpApi, GoogleSheets, ConvertToFile 等节点。 通过 SerpAPI 从 Google Maps 抓取企业数据并导出到表格和 Excel
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "8jCWm4FpTJI0GDz1",
"name": "Parser_from_Google_Maps_SerpAPI-v1-db",
"nodes": [
{
"id": "74f7bcf9-bf18-4b0e-b6fc-9e948a7adeed",
"name": "拆分 SerpAPI",
"type": "n8n-nodes-base.splitOut",
"position": [
880,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fbc3f49e-c1dd-41f3-a375-d62f52411e63",
"name": "提取 SerpAPI 地图",
"type": "n8n-nodes-serpapi.serpApi",
"position": [
660,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "36733a03-4bcc-4636-a871-d662c76688c1",
"name": "准备数据",
"type": "n8n-nodes-base.set",
"position": [
1320,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "6d77a571-70f2-4d7f-b6fe-2bb801cf789e",
"name": "提取数据",
"type": "n8n-nodes-base.set",
"position": [
1100,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "31927df8-99db-4247-998b-4c76a99b3aad",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
0,
200
],
"webhookId": "182139f3-e81b-4d8a-91cd-4ee7a5474f88",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "a5af6a97-abcc-43b1-9aae-ecf27ccd208f",
"name": "初始化",
"type": "n8n-nodes-base.set",
"position": [
440,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1c8ae9e0-a48e-4cbd-bd4e-b983b9d89dcc",
"name": "变量聊天",
"type": "n8n-nodes-base.set",
"position": [
220,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "8cdbccb7-ccaf-46eb-8501-94f295f5dbae",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ec839b1c-e78a-4214-8d40-81b882420dff",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8d198e95-0df9-4445-9cb5-a0ad1642217e",
"name": "获取 XLSX 数据",
"type": "n8n-nodes-base.convertToFile",
"position": [
1540,
0
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "29627301-e3c7-43c8-a571-c12966383cc6",
"name": "在 Sheets 中更新插入数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
200
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "aa759324-fb4b-45a7-88f2-691ed63aabb8",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "b59ba7bd-9eb6-4152-a8ab-709b07ffcce0",
"connections": {
"Prepare Data": {
"main": [
[
{
"node": "Get Data in XLSX",
"type": "main",
"index": 0
}
]
]
},
"Extract Data ": {
"main": [
[
{
"node": "Prepare Data",
"type": "main",
"index": 0
}
]
]
},
"Initialization": {
"main": [
[
{
"node": "Extract SerpAPI Map",
"type": "main",
"index": 0
}
]
]
},
"Variables Chat": {
"main": [
[
{
"node": "Initialization",
"type": "main",
"index": 0
}
]
]
},
"Split Out SerpAPI": {
"main": [
[
{
"node": "Extract Data ",
"type": "main",
"index": 0
}
]
]
},
"Extract SerpAPI Map": {
"main": [
[
{
"node": "Split Out SerpAPI",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Variables Chat",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
来自Google_Maps_Serper的解析器-v1-db
使用Serper从Google地图搜索生成商业列表到Sheets或Excel
Set
Split Out
Http Request
+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
