Ayis Saliaris Fasseas This workflow corresponds to n8n.io template #11707 — we link there as the canonical source.
This workflow follows the Form 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 →
{
"nodes": [
{
"id": "639000ce-f6c5-41ab-a593-907c2b6008c4",
"name": "Text Search Page 2",
"type": "n8n-nodes-base.httpRequest",
"position": [
704,
272
],
"parameters": {
"url": "https://maps.googleapis.com/maps/api/place/textsearch/json",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "pagetoken",
"value": "={{ $json.next_page_token }}"
},
{
"name": "key",
"value": "<YOUR KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "f4368da1-c340-4753-800b-a7dec5821882",
"name": "Text Search Page 1",
"type": "n8n-nodes-base.httpRequest",
"position": [
704,
80
],
"parameters": {
"url": "https://maps.googleapis.com/maps/api/place/textsearch/json",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "query",
"value": "={{ $json.Query }}"
},
{
"name": "key",
"value": "<YOUR KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "c29c09a1-ca61-44d7-8c45-df0addc6d0e5",
"name": "Text Search Page 3",
"type": "n8n-nodes-base.httpRequest",
"position": [
704,
464
],
"parameters": {
"url": "https://maps.googleapis.com/maps/api/place/textsearch/json",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "pagetoken",
"value": "={{ $json.next_page_token }}"
},
{
"name": "key",
"value": "<YOUR KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "b1d0e24f-4fc3-4271-a705-b4bec3e85834",
"name": "Get Place Details",
"type": "n8n-nodes-base.httpRequest",
"position": [
1504,
272
],
"parameters": {
"url": "https://maps.googleapis.com/maps/api/place/details/json",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "place_id",
"value": "={{ $json.place_id }}"
},
{
"name": "fields",
"value": "name,formatted_phone_number,website,formatted_address"
},
{
"name": "key",
"value": "<YOUR KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "20d694c8-a729-4ec9-9f36-b7bca1b34052",
"name": "Wait 5s (1)",
"type": "n8n-nodes-base.wait",
"position": [
464,
272
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "a42f166a-1297-4d65-8059-4f940744562f",
"name": "Wait 5s (2)",
"type": "n8n-nodes-base.wait",
"position": [
464,
464
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "0687a2d7-c1c2-410c-b72a-0ecba38c5d05",
"name": "Has Next Page? (Page 3)",
"type": "n8n-nodes-base.if",
"position": [
240,
464
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "edd655eb-d1f5-486f-b120-91b822cc1021",
"operator": {
"type": "string",
"operation": "exists"
},
"leftValue": "={{ $json.next_page_token }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b01aee55-ca4a-4c59-97c5-5287cd7359d7",
"name": "Has Next Page? (Page 2)",
"type": "n8n-nodes-base.if",
"position": [
240,
272
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e59c4f7a-dee0-4b3f-b9c5-9833f3fdea1d",
"operator": {
"type": "string",
"operation": "exists"
},
"leftValue": "={{ $json.next_page_token }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "78546956-7aef-4833-8e60-90f7a0ccefb9",
"name": "Merge All Pages",
"type": "n8n-nodes-base.merge",
"position": [
992,
256
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3.2
},
{
"id": "221d1f7f-245e-45ef-80e7-8c91c0ebe7ff",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
16
],
"parameters": {
"color": 7,
"width": 528,
"height": 640,
"content": "## Find and merge results"
},
"typeVersion": 1
},
{
"id": "333884c1-5dd8-45a8-a18a-45c3daebb7da",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1184,
16
],
"parameters": {
"color": 7,
"width": 512,
"height": 640,
"content": "## Split out results and find places' details"
},
"typeVersion": 1
},
{
"id": "1879c67b-70d0-4e23-ac24-9f0a8075a9c4",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1712,
16
],
"parameters": {
"color": 7,
"width": 512,
"height": 640,
"content": "## Format output and upload to Google Sheet"
},
"typeVersion": 1
},
{
"id": "53f9e7ae-d822-4d06-ae69-5508582765e6",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
144,
16
],
"parameters": {
"color": 7,
"width": 480,
"height": 640,
"content": "## Check if Google Maps next page exists (Wait nodes for API call quota)"
},
"typeVersion": 1
},
{
"id": "642387ad-57ae-4452-9c35-4c451c1e9f3d",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
-352
],
"parameters": {
"color": 7,
"width": 208,
"height": 192,
"content": "## Form Trigger"
},
"typeVersion": 1
},
{
"id": "8bf00721-e5af-4525-898d-de316de48c41",
"name": "Submit Search Query",
"type": "n8n-nodes-base.formTrigger",
"position": [
400,
-304
],
"parameters": {
"options": {},
"formTitle": "Enter your Query",
"formFields": {
"values": [
{
"fieldLabel": "Query",
"placeholder": "Ex. Accountants London",
"requiredField": true
}
]
},
"formDescription": "Enter Industry + Location"
},
"typeVersion": 2.3
},
{
"id": "111b2fe9-59f5-4b0e-9f9e-3e3eef5fb44d",
"name": "Split out the Results",
"type": "n8n-nodes-base.splitOut",
"position": [
1280,
272
],
"parameters": {
"options": {},
"fieldToSplitOut": "results"
},
"typeVersion": 1
},
{
"id": "dce85a88-9dd6-4c1c-8c9d-19dd3740c0ba",
"name": "Format the Output for Google Sheets",
"type": "n8n-nodes-base.code",
"position": [
1808,
272
],
"parameters": {
"jsCode": "return $input.all().map(item => {\n const data = item.json.result || {};\n let phone = data.formatted_phone_number || null;\n\n return {\n json: {\n companyName: data.name || null,\n number: phone,\n address: data.formatted_address || null,\n website: data.website || null\n }\n };\n});"
},
"typeVersion": 2
},
{
"id": "cb484a57-209c-4402-a876-a732b4c4c90a",
"name": "Append rows in the Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2016,
272
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "Company Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Sent?",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email Sent?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "1st Follow Up Sent?",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "1st Follow Up Sent?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "2nd Follow Up Sent?",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "2nd Follow Up Sent?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Replied?",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Replied?",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 761417546,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/178cjDnXdsPPFJCQ9oyw6yCpEYdvvS39sotD4nZFeoEs/edit#gid=761417546",
"cachedResultName": "Results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "178cjDnXdsPPFJCQ9oyw6yCpEYdvvS39sotD4nZFeoEs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/178cjDnXdsPPFJCQ9oyw6yCpEYdvvS39sotD4nZFeoEs/edit?usp=drivesdk",
"cachedResultName": "Runwise Lead List"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "462ba5ac-48c9-44a5-9927-4d80023977c2",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-768,
-480
],
"parameters": {
"width": 896,
"height": 880,
"content": "## How it works\n1. A form trigger accepts an Industry + Location query (e.g. Accountants London).\n2. Text Search Page 1 calls Google Places Text Search to return results and a next_page_token.\n3. Conditional checks + 5s wait nodes fetch page 2 and page 3 when a next page exists.\n4. All pages are merged, split into individual place results, and each place_id is passed to Place Details.\n5. Place Details returns name, formatted_phone_number, website, formatted_address.\n6. Results are formatted and appended to a Google Sheet.\n## Setup steps\n- Enable Google Cloud project billing and Places API (Text Search + Details).\n- Create an API key and add it to the three Text Search and Place Details HTTP request nodes (<YOUR KEY>).\n- Add Google Sheets OAuth credentials to the Google Sheets node.\n- Create a Google Sheet with columns: Company Name, Phone Number, Website, Address\n- Update the Google Sheets node documentId and sheetName to your spreadsheet.\n- Import/paste this workflow into n8n and test with a small query.\n## Customization\n- Edit Place Details fields to retrieve more/less info (address_components, opening_hours, etc.).\n- Adjust the number of pages fetched (workflow currently supports up to 3 pages).\n- Alter output mapping in the code node to add/remove columns or change column order.\n- Add further nodes after the sheet (e.g., email scraper/ sender, CRM integration, enrichment API)\n## Use cases\n- B2B lead generation for targeted industries and locations.\n- Building outreach lists for sales teams and agencies.\n- Enriching CRM with phone, website, and address data from Google Places.\n- Rapid market mapping for local competitors, vendors, or partners.\n## Troubleshooting tips\n- No results / invalid API key: verify API key is correct, not restricted incorrectly, and Places API is enabled.\n- next_page_token not working: the token can take a couple of seconds to activate. Keep the 5s wait nodes; if still failing, increase to ~10s+\n- Quota / billing errors: confirm billing is enabled on the Google Cloud project and check your Places API quota.\n- Missing phone/website: not all places provide all fields; fallback handling is already included (nulls).\n- Duplicates in Sheets: run tests on small queries and inspect the Merge/Split logic; add a dedupe step before appending if needed.\n- Place Details rate limits: if you plan high volume, throttle requests or add longer waits to avoid quota/rate-limit errors.\n- Permissions / OAuth: ensure the Google Sheets OAuth user has edit access to the target spreadsheet."
},
"typeVersion": 1
}
],
"connections": {
"Wait 5s (1)": {
"main": [
[
{
"node": "Text Search Page 2",
"type": "main",
"index": 0
}
]
]
},
"Wait 5s (2)": {
"main": [
[
{
"node": "Text Search Page 3",
"type": "main",
"index": 0
}
]
]
},
"Merge All Pages": {
"main": [
[
{
"node": "Split out the Results",
"type": "main",
"index": 0
}
]
]
},
"Get Place Details": {
"main": [
[
{
"node": "Format the Output for Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Text Search Page 1": {
"main": [
[
{
"node": "Has Next Page? (Page 2)",
"type": "main",
"index": 0
},
{
"node": "Merge All Pages",
"type": "main",
"index": 0
}
]
]
},
"Text Search Page 2": {
"main": [
[
{
"node": "Has Next Page? (Page 3)",
"type": "main",
"index": 0
},
{
"node": "Merge All Pages",
"type": "main",
"index": 1
}
]
]
},
"Text Search Page 3": {
"main": [
[
{
"node": "Merge All Pages",
"type": "main",
"index": 2
}
]
]
},
"Submit Search Query": {
"main": [
[
{
"node": "Text Search Page 1",
"type": "main",
"index": 0
}
]
]
},
"Split out the Results": {
"main": [
[
{
"node": "Get Place Details",
"type": "main",
"index": 0
}
]
]
},
"Has Next Page? (Page 2)": {
"main": [
[
{
"node": "Wait 5s (1)",
"type": "main",
"index": 0
}
]
]
},
"Has Next Page? (Page 3)": {
"main": [
[
{
"node": "Wait 5s (2)",
"type": "main",
"index": 0
}
]
]
},
"Append rows in the Google Sheet": {
"main": [
[]
]
},
"Format the Output for Google Sheets": {
"main": [
[
{
"node": "Append rows in the Google Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
How it works A form trigger accepts an Industry + Location query (e.g. Accountants London). Text Search Page 1 calls Google Places Text Search to return results and a nextpagetoken. Conditional checks + 5s wait nodes fetch page 2 and page 3 when a next page exists. All pages are…
Source: https://n8n.io/workflows/11707/ — 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 repository contains an SLA-based lead routing workflow built in n8n, designed to ensure fast lead response, fair sales distribution, and controlled escalation without relying on a full CRM system
Form Trigger, Google Sheets, Slack +1
This workflow collects business leads from Google Maps by geocoding a user-provided city, searching across a small coordinate grid with Places Nearby Search pagination, and writing enriched business d
Form Trigger, HTTP Request, Google Sheets
Agencies, sales teams, and service businesses who want to instantly qualify inbound leads with an AI-powered phone call — no manual follow-up needed.
Form Trigger, Google Sheets, HTTP Request
This n8n template automates lead generation by scraping Google Maps using the Olostep API. It extracts business names, locations, websites, phone numbers, and decision-maker names (CEO, Founder, etc.)
Form Trigger, HTTP Request, Google Sheets
This workflow is a powerful B2B Lead Generation engine designed specifically for SDRs (Sales Development Representatives). It automates the entire process of finding, enriching, and qualifying prospec
Form Trigger, HTTP Request, Google Sheets