Andrew This workflow corresponds to n8n.io template #7541 — we link there as the canonical source.
This workflow follows the Chat Trigger → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "8jCWm4FpTJI0GDz1",
"name": "Parser_from_Google_Maps_SerpAPI-v1-db",
"nodes": [
{
"id": "74f7bcf9-bf18-4b0e-b6fc-9e948a7adeed",
"name": "Split Out SerpAPI",
"type": "n8n-nodes-base.splitOut",
"position": [
880,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fbc3f49e-c1dd-41f3-a375-d62f52411e63",
"name": "Extract SerpAPI Map",
"type": "n8n-nodes-serpapi.serpApi",
"position": [
660,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "36733a03-4bcc-4636-a871-d662c76688c1",
"name": "Prepare Data",
"type": "n8n-nodes-base.set",
"position": [
1320,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "6d77a571-70f2-4d7f-b6fe-2bb801cf789e",
"name": "Extract Data ",
"type": "n8n-nodes-base.set",
"position": [
1100,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "31927df8-99db-4247-998b-4c76a99b3aad",
"name": "When chat message received",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
0,
200
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "a5af6a97-abcc-43b1-9aae-ecf27ccd208f",
"name": "Initialization",
"type": "n8n-nodes-base.set",
"position": [
440,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1c8ae9e0-a48e-4cbd-bd4e-b983b9d89dcc",
"name": "Variables Chat",
"type": "n8n-nodes-base.set",
"position": [
220,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "8cdbccb7-ccaf-46eb-8501-94f295f5dbae",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ec839b1c-e78a-4214-8d40-81b882420dff",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8d198e95-0df9-4445-9cb5-a0ad1642217e",
"name": "Get Data in XLSX",
"type": "n8n-nodes-base.convertToFile",
"position": [
1540,
0
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "29627301-e3c7-43c8-a571-c12966383cc6",
"name": "Upsert Data in Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
200
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "aa759324-fb4b-45a7-88f2-691ed63aabb8",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"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
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Source: https://n8n.io/workflows/7541/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow builds a free lead generation system that scrapes emails from Google Maps listings and exports them directly into Google Sheets. It’s built in n8n using HTTP requests and JavaScript—no p
📺 Full walkthrough video: https://youtu.be/x3PDYon4qKk
This workflow is designed for marketers, researchers, and business owners who need to quickly find and export company data from Google Maps into a structured table format.
📺 Full walkthrough video: https://youtu.be/yjeKYfZP0kU
This workflow is ideal for lead generation agencies, researchers, and small business owners who need to quickly collect and analyze company data from search results and save them into Google Sheets fo