Shreya Bhingarkar This workflow corresponds to n8n.io template #15497 — we link there as the canonical source.
This workflow follows the Gmail → Google Drive 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": "88b898c1-9701-454c-8382-31a24062a0f5",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1520,
464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b504d12-dde7-40af-b843-61f6e8dc0957",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2464,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d78501c2-7eff-45d7-a9fe-3566f555f3e8",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3616,
464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3c008763-29f7-4b3d-bddc-30a91c7ea5db",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
560,
1104
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "928ee4ea-56f7-466d-ab80-cce34a44acc7",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1424,
1120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "81c46909-1de0-483c-8954-6bd6cb522fb9",
"name": "Read Niches from Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
864,
256
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ec791f2f-d0fe-4710-a7fb-9e69de99dffc",
"name": "Batch Niches for Processing",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1312,
256
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "366eac85-5637-4675-a73c-61395e136da6",
"name": "Post to Google Maps API",
"type": "n8n-nodes-base.httpRequest",
"position": [
1568,
576
],
"parameters": {},
"typeVersion": 4.3
},
{
"id": "1ae0cb27-86a3-4c43-9f5f-3b8b724dd8a2",
"name": "Process Business Data",
"type": "n8n-nodes-base.code",
"position": [
1776,
576
],
"parameters": {},
"typeVersion": 2
},
{
"id": "abca5fec-0e1e-468d-b0b1-6216c7be5d63",
"name": "Batch Businesses for Processing",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2048,
576
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c2660a59-6545-4094-ace7-d00d259a6901",
"name": "Post to Google Search API",
"type": "n8n-nodes-base.httpRequest",
"position": [
2288,
672
],
"parameters": {},
"typeVersion": 4.3
},
{
"id": "beade3b9-ae5f-471b-8e0f-e9f4769c12f5",
"name": "Extract Contact Information",
"type": "n8n-nodes-base.code",
"position": [
2512,
768
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0422b633-a98b-42b2-8b54-bc60275efc97",
"name": "Batch Process Leads",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2784,
112
],
"parameters": {},
"typeVersion": 3
},
{
"id": "882e8cff-c8ca-4deb-9702-5f7140cf433d",
"name": "Check Contact Info Available",
"type": "n8n-nodes-base.if",
"position": [
3664,
496
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "f222ad1d-3a19-4ced-a9c6-d445d2d3b117",
"name": "Update Master Sheet with Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
4480,
656
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "0acd3d67-a41a-4e32-8de5-de131d9b249e",
"name": "Filter Leads Ready to Send",
"type": "n8n-nodes-base.filter",
"position": [
1024,
1216
],
"parameters": {},
"typeVersion": 2
},
{
"id": "71eeb254-54fe-42b6-bab1-9714adef40bc",
"name": "Batch Leads for Sending",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1232,
1216
],
"parameters": {},
"typeVersion": 3
},
{
"id": "500e0320-11bf-45ff-8649-8b013920f2b9",
"name": "Update Email Sent Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
2336,
1232
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "83334139-0d2b-4810-bc71-43ea1ac931de",
"name": "Scheduled Email Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
608,
1216
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "43e2befb-d483-4462-82dd-04bf7744581d",
"name": "Prepare Email Content",
"type": "n8n-nodes-base.code",
"position": [
1904,
1232
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6a48c0c2-677d-4367-9194-77bf5805ef4e",
"name": "Read Master Sheet Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
816,
1216
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "2e3ce787-ae6b-4342-83e2-ad4c70796dfa",
"name": "Download from Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
1696,
1232
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c836ad6c-887f-4737-80dc-c5c1ffc952a6",
"name": "Send Gmail Email",
"type": "n8n-nodes-base.gmail",
"position": [
2112,
1232
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "92447c86-0835-4fc4-adc1-49c6d7ba13a7",
"name": "Create Outreach Email",
"type": "n8n-nodes-base.code",
"position": [
4048,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8618b7ae-ee16-4bf0-8d1d-e8717f97395d",
"name": "Append to Master Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
4128,
560
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "e81de9f1-fe0a-49ca-98ac-1806025481ab",
"name": "Check Email Presence",
"type": "n8n-nodes-base.if",
"position": [
3136,
128
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "42c39a9c-f7dd-4c02-b783-bd69ab78cda4",
"name": "Random Delay 20-40 Seconds",
"type": "n8n-nodes-base.wait",
"position": [
1472,
1232
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "e43572ea-8294-4adf-ac92-d67b740f0cd7",
"name": "Filter by Website Presence",
"type": "n8n-nodes-base.filter",
"position": [
2512,
112
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "6f71f0d5-f502-4b27-84bb-cc00f0023162",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "011e7649-8f8f-42bb-9139-2134b86f91cd",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
144
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4a530d55-1cd4-47cf-9e47-fecbb0948c6a",
"name": "Filter Pending Niches2",
"type": "n8n-nodes-base.filter",
"position": [
1088,
256
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "f1b58850-3601-49d0-a062-c1304486480d",
"name": "Generate Outreach Messages2",
"type": "n8n-nodes-base.code",
"position": [
3936,
560
],
"parameters": {},
"typeVersion": 2
}
],
"connections": {
"Send Gmail Email": {
"main": [
[
{
"node": "Update Email Sent Status",
"type": "main",
"index": 0
}
]
]
},
"Batch Process Leads": {
"main": [
[],
[
{
"node": "Check Email Presence",
"type": "main",
"index": 0
}
]
]
},
"Check Email Presence": {
"main": [
[
{
"node": "Create Outreach Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Check Contact Info Available",
"type": "main",
"index": 0
}
]
]
},
"Create Outreach Email": {
"main": [
[
{
"node": "Update Master Sheet with Leads",
"type": "main",
"index": 0
}
]
]
},
"Prepare Email Content": {
"main": [
[
{
"node": "Send Gmail Email",
"type": "main",
"index": 0
}
]
]
},
"Process Business Data": {
"main": [
[
{
"node": "Batch Businesses for Processing",
"type": "main",
"index": 0
}
]
]
},
"Append to Master Sheet": {
"main": [
[
{
"node": "Batch Process Leads",
"type": "main",
"index": 0
}
]
]
},
"Filter Pending Niches2": {
"main": [
[
{
"node": "Batch Niches for Processing",
"type": "main",
"index": 0
}
]
]
},
"Read Master Sheet Data": {
"main": [
[
{
"node": "Filter Leads Ready to Send",
"type": "main",
"index": 0
}
]
]
},
"Batch Leads for Sending": {
"main": [
[],
[
{
"node": "Random Delay 20-40 Seconds",
"type": "main",
"index": 0
}
]
]
},
"Post to Google Maps API": {
"main": [
[
{
"node": "Process Business Data",
"type": "main",
"index": 0
}
]
]
},
"Read Niches from Sheets": {
"main": [
[
{
"node": "Filter Pending Niches2",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Email Trigger": {
"main": [
[
{
"node": "Read Master Sheet Data",
"type": "main",
"index": 0
}
]
]
},
"Update Email Sent Status": {
"main": [
[
{
"node": "Batch Leads for Sending",
"type": "main",
"index": 0
}
]
]
},
"Post to Google Search API": {
"main": [
[
{
"node": "Extract Contact Information",
"type": "main",
"index": 0
}
]
]
},
"Download from Google Drive": {
"main": [
[
{
"node": "Prepare Email Content",
"type": "main",
"index": 0
}
]
]
},
"Filter Leads Ready to Send": {
"main": [
[
{
"node": "Batch Leads for Sending",
"type": "main",
"index": 0
}
]
]
},
"Filter by Website Presence": {
"main": [
[
{
"node": "Batch Process Leads",
"type": "main",
"index": 0
}
]
]
},
"Random Delay 20-40 Seconds": {
"main": [
[
{
"node": "Download from Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Batch Niches for Processing": {
"main": [
[],
[
{
"node": "Post to Google Maps API",
"type": "main",
"index": 0
}
]
]
},
"Extract Contact Information": {
"main": [
[
{
"node": "Batch Businesses for Processing",
"type": "main",
"index": 0
}
]
]
},
"Generate Outreach Messages2": {
"main": [
[
{
"node": "Append to Master Sheet",
"type": "main",
"index": 0
}
]
]
},
"Check Contact Info Available": {
"main": [
[
{
"node": "Generate Outreach Messages2",
"type": "main",
"index": 0
}
],
[
{
"node": "Batch Process Leads",
"type": "main",
"index": 0
}
]
]
},
"Update Master Sheet with Leads": {
"main": [
[
{
"node": "Batch Process Leads",
"type": "main",
"index": 0
}
]
]
},
"Batch Businesses for Processing": {
"main": [
[
{
"node": "Filter by Website Presence",
"type": "main",
"index": 0
}
],
[
{
"node": "Post to Google Search API",
"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 template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.
Source: https://n8n.io/workflows/15497/ — 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.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
Gmail, Google Drive, Google Sheets +1
This workflow automatically monitors the SEO health of websites stored in a Google Sheet. It fetches each website’s HTML, analyzes key SEO metrics (title, meta description, H1 count, canonical, robots
Google Sheets, HTTP Request, Gmail +1
Schedule Removeduplicates. Uses scheduleTrigger, crypto, gmail, markdown. Scheduled trigger; 14 nodes.
Crypto, Gmail, Google Sheets +2
Great to keep an eye on and track publicly available documents such as company TOS, government policy or competitor pages. A scheduled trigger is used so we can run everyday to automate this process.
Crypto, Gmail, Google Sheets +2
Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google
Google Sheets, HTTP Request, WhatsApp +1