Andrew This workflow corresponds to n8n.io template #7542 — 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": "pconmtAjMPl4ooUf",
"name": "Parser_from_Google_Maps_Serper-v1-db",
"nodes": [
{
"id": "38314052-0cbc-4318-86d6-abb004f7c465",
"name": "Split Out Serper",
"type": "n8n-nodes-base.splitOut",
"position": [
880,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b7c20549-8491-45e8-a643-73ad3b6887bc",
"name": "Extract Serper Map",
"type": "n8n-nodes-base.httpRequest",
"position": [
660,
200
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "cee18d18-51b6-4298-be61-eb9291b062b1",
"name": "Prepare Data",
"type": "n8n-nodes-base.set",
"position": [
1320,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "dc776d9b-eea2-4d82-bd51-9d6094d08091",
"name": "Extract Data ",
"type": "n8n-nodes-base.set",
"position": [
1100,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e5040427-4763-4225-99a5-96c2d647a78a",
"name": "When chat message received",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
0,
200
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "611ce212-5791-4f52-8fa7-0ac3d3e6a02c",
"name": "Initialization",
"type": "n8n-nodes-base.set",
"position": [
440,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "369dc928-35f9-446c-9cbe-b5ea7ef2664f",
"name": "Variables Chat",
"type": "n8n-nodes-base.set",
"position": [
220,
200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e97bd437-e30f-436c-820d-a281b75e5656",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2df25edf-0e1e-44d0-9b8e-f2cbeff3f64b",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9aa7cdcf-6e45-40c7-8abe-e132b44339b1",
"name": "Get Data in XLSX",
"type": "n8n-nodes-base.convertToFile",
"position": [
1540,
0
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "67217615-f365-4a18-a28e-2d3b2ab6a933",
"name": "Upsert Data in Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
200
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "7a2fff63-6a4e-4c9c-9813-9ba60491069b",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"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
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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 for further use.
Source: https://n8n.io/workflows/7542/ — 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
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.
jobs. Uses chatTrigger, httpRequest, googleSheets. Chat trigger; 9 nodes.
My workflow 2. Uses httpRequest, googleSheets, chatTrigger. Chat trigger; 8 nodes.
template-demo-chatgpt-image-1-with-drive-and-sheet copy. Uses manualTrigger, httpRequest, googleDrive, splitOut. Event-driven trigger; 16 nodes.