Akram Kadri This workflow corresponds to n8n.io template #3827 — we link there as the canonical source.
This workflow follows the Execute Workflow 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 →
{
"name": "Overpass Lead Generation System",
"tags": [],
"nodes": [
{
"id": "b5dd8c2a-5b6a-4a20-b8a5-cb0d1898303d",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3960,
940
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1e325bd0-e026-4992-9038-a6746e6c51bd",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
700,
440
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "03dfb6c7-c649-4b32-9048-7f16a991a0ae",
"name": "No Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"position": [
1360,
720
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a102f606-baa8-4908-8d61-6fd5d4c5d692",
"name": "When Executed by Another Workflow",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
1140,
460
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "ba30c077-0825-4be6-ad89-e58ef42da27a",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
280,
200
],
"parameters": {},
"typeVersion": 3
},
{
"id": "3d4f898e-1b8b-4941-82f9-48aa17ea7dce",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "959b5298-e132-40ed-bc5f-01b578a42475",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"disabled": true,
"position": [
680,
260
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "eae223c6-6f34-4725-955e-29a26f15da60",
"name": "Execute Workflow",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueRegularOutput",
"position": [
480,
440
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.2,
"waitBetweenTries": 3000
},
{
"id": "9544d301-f368-4e76-9ea4-dbfa75feea5f",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2120,
1160
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5e954b1c-cc3c-407a-9a9e-abadec52607c",
"name": "Filter Away Items With No Contact Info",
"type": "n8n-nodes-base.filter",
"position": [
3700,
740
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "451f0cf9-d782-45c4-a7b0-c3f3ef3e5069",
"name": "Append Items (No Website and/not Email)",
"type": "n8n-nodes-base.merge",
"position": [
2560,
720
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "64b2b09b-56b5-4159-aece-49c4e46ff6a9",
"name": "Merge Items with HTML",
"type": "n8n-nodes-base.merge",
"position": [
2800,
1000
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "6b1f46f6-8a0b-4cb8-a46c-fcc246d676f6",
"name": "Get Website HTML",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
2300,
1240
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "24e2a603-d0ec-45fd-ac18-98c9608b6373",
"name": "Append Items",
"type": "n8n-nodes-base.merge",
"position": [
3420,
740
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "31ce2bbb-ded7-4fff-b4ab-b0f83286552e",
"name": "Clean Emails",
"type": "n8n-nodes-base.code",
"position": [
3200,
1000
],
"parameters": {},
"typeVersion": 2
},
{
"id": "691468a9-fe82-44e6-8635-209065639e4c",
"name": "Scrape HomePage",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
3020,
1000
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4eca9096-fdfe-4291-ac60-a866882ebe8c",
"name": "Has Email?",
"type": "n8n-nodes-base.if",
"position": [
2080,
800
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "89ad6c56-e65d-4b55-8f2e-8cfb579bfde3",
"name": "Has No Website?",
"type": "n8n-nodes-base.if",
"position": [
1880,
720
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "e1864929-f1ba-4edf-a345-a6515063c943",
"name": "Organize Data",
"type": "n8n-nodes-base.code",
"position": [
1660,
720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a328313b-df35-493f-bda2-b53f3a2a4e1b",
"name": "Set Output Fields",
"type": "n8n-nodes-base.set",
"position": [
2180,
440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "31b445f6-eabf-4d7d-b1da-0659eef50c81",
"name": "Extract List",
"type": "n8n-nodes-base.set",
"position": [
1600,
440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "6c84c83d-d9dd-4f53-af63-ea577bcc9915",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
740
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "2f2b7822-a17f-4935-ab09-9c5575876f3a",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
1880,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c94f73a0-a049-4482-a072-7d1abc5d7579",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
1360,
460
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "946c8416-15b4-4cd3-a763-566db23ef71d",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
20,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "08a1d715-cf68-417d-9245-db4cda09e5be",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fac295bd-c9c2-4c77-a495-893854cfe4b2",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"disabled": true,
"position": [
1220,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "b7f49248-62e5-4dc4-93d7-646fe7658777",
"connections": {
"Wait": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Set Output Fields",
"type": "main",
"index": 0
}
]
]
},
"Has Email?": {
"main": [
[
{
"node": "Append Items (No Website and/not Email)",
"type": "main",
"index": 1
}
],
[
{
"node": "Merge Items with HTML",
"type": "main",
"index": 0
},
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Append Items": {
"main": [
[
{
"node": "Filter Away Items With No Contact Info",
"type": "main",
"index": 0
}
]
]
},
"Clean Emails": {
"main": [
[
{
"node": "Append Items",
"type": "main",
"index": 1
}
]
]
},
"Extract List": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Extract List",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Organize Data": {
"main": [
[
{
"node": "Has No Website?",
"type": "main",
"index": 0
}
]
]
},
"Has No Website?": {
"main": [
[
{
"node": "Append Items (No Website and/not Email)",
"type": "main",
"index": 0
}
],
[
{
"node": "Has Email?",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Merge Items with HTML",
"type": "main",
"index": 1
}
],
[
{
"node": "Get Website HTML",
"type": "main",
"index": 0
}
]
]
},
"Scrape HomePage": {
"main": [
[
{
"node": "Clean Emails",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Get Website HTML": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "Execute Workflow",
"type": "main",
"index": 0
}
]
]
},
"Set Output Fields": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Merge Items with HTML": {
"main": [
[
{
"node": "Scrape HomePage",
"type": "main",
"index": 0
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Filter Away Items With No Contact Info": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Append Items (No Website and/not Email)": {
"main": [
[
{
"node": "Append Items",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This n8n lead generation workflow template is designed for business owners, marketers, sales professionals, and entrepreneurs who need to generate targeted business leads without paying for expensive APIs or third-party services. The template leverages the free Overpass API…
Source: https://n8n.io/workflows/3827/ — 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 leverages n8n to perform automated Google Maps API queries and manage data efficiently in Google Sheets. It's designed to extract specific location data based on a given list of ZIP code
Execute Workflow Trigger, Stop And Error, HTTP Request +1
This n8n workflow automates the process of finding ecommerce seller leads, enriching them with product and business details, discovering company websites, and extracting contact information such as em
Google Sheets, N8N Nodes Mrscraper, HTTP Request
This template is for B2B sales teams, SDRs, growth marketers, and founders who maintain a spreadsheet of prospects and need verified contact details -- emails and mobile numbers -- without manual rese
Google Sheets, HTTP Request
This workflow finds local businesses from Google Maps and automatically enriches them with emails, social profiles, AI summaries, and personalized outreach messages — all saved to Google Sheets. Searc
HTTP Request, Google Sheets
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