Zain Khan This workflow corresponds to n8n.io template #7406 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request 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": "ff051d83-dcf5-4e13-aa1b-41135faf15bb",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "59f44e58-7ab9-4a80-b711-fd34e4083537",
"name": "Get row(s) in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
208,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "906b48a5-ff75-428f-8243-a8bbe8a0cbad",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
416,
0
],
"parameters": {},
"typeVersion": 3
},
{
"id": "1b482f8e-29f8-41a1-b870-dc97d13ffe08",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
1200,
-16
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4954cf6b-dda4-4460-ad2a-88b51a6109be",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
672,
16
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "0ef2867c-e0a9-48e8-89cd-56a2ac8a008c",
"name": "Extract Pages",
"type": "n8n-nodes-base.code",
"position": [
1568,
256
],
"parameters": {},
"typeVersion": 2
},
{
"id": "338ff85f-63c0-4deb-ae44-604b2ebb0291",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
1728,
256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1d75610e-8688-42ba-bd11-58dc2dca4325",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1920,
256
],
"parameters": {},
"typeVersion": 3
},
{
"id": "d0522de8-735e-4a83-b529-96d8c1778a9e",
"name": "Fetch internal page",
"type": "n8n-nodes-base.httpRequest",
"position": [
2160,
272
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "cd4c9a29-f3ff-437e-af28-0f1e6172f9cf",
"name": "Extract Email",
"type": "n8n-nodes-base.code",
"position": [
2352,
272
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f9548421-ca03-4b92-8ac9-7e7ef7d2406a",
"name": "Email Found Internal",
"type": "n8n-nodes-base.if",
"position": [
2528,
272
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "2511c228-6e53-4635-a1e5-3d403b05263f",
"name": "Email Found",
"type": "n8n-nodes-base.if",
"position": [
1360,
-16
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "8068be74-5cfa-47fb-b640-7b4c4973562e",
"name": "Email Updated",
"type": "n8n-nodes-base.googleSheets",
"position": [
1792,
16
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "f2a39554-0384-4140-9b92-141508b351aa",
"name": "Email Updated Internal",
"type": "n8n-nodes-base.googleSheets",
"position": [
2800,
320
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "cbccf908-d9f5-450d-8362-e3d950663c2d",
"name": "Email Not Found",
"type": "n8n-nodes-base.googleSheets",
"position": [
2256,
576
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "49272a4b-1e30-4f46-bbae-c1f9948b42db",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
976,
0
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f1ad5d41-a4a8-4ae0-be83-d2e6c070cac2",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e2b3631b-ccd6-4b54-9cd5-1c603ff4b37f",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-864,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"If": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
],
[
{
"node": "Email Not Found",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Email Found",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Email Found": {
"main": [
[
{
"node": "Email Updated",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract Pages",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
],
[
{
"node": "Email Not Found",
"type": "main",
"index": 0
}
]
]
},
"Email Updated": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Extract Email": {
"main": [
[
{
"node": "Email Found Internal",
"type": "main",
"index": 0
}
]
]
},
"Extract Pages": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Email Not Found": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "Email Not Found",
"type": "main",
"index": 0
}
],
[
{
"node": "Fetch internal page",
"type": "main",
"index": 0
}
]
]
},
"Fetch internal page": {
"main": [
[
{
"node": "Extract Email",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Email Found Internal": {
"main": [
[
{
"node": "Email Updated Internal",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Email Updated Internal": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Categories: Lead Generation, Web Scraping, Business Automation
Source: https://n8n.io/workflows/7406/ — 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 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
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
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
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
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