Generate scored B2B leads from Google Maps websites to Google Sheets

by Jannik Hiller ✓ · 283 views · created 2025-12-18 · Lead Generation

What this workflow does

This workflow has 25 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Loop over queries (Loop Over Items (Split in Batches)): loops over the items in batches
2. Search Google Maps with query (HTTP Request): calls an HTTP API (POST)
3. Check for Next Page Token (Code): runs custom JavaScript code
4. Has Next Page? (If): checks a condition and branches into true / false
5. Extract Places Data (Edit Fields (Set)): sets 7 fields: name, address, rating…
6. Split Out: splits a list into separate items
7. Filter: keeps only the items that match a condition
8. Check if Website Exists (If): checks a condition and branches into true / false
9. Merge: merges the data from its input branches
10. Fetch Website HTML (HTTP Request): calls an HTTP API

…plus 14 more steps. See the full node list below.

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (14)

• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Manual Triggern8n-nodes-base.manualTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge
• Split Outn8n-nodes-base.splitOut
• Filtern8n-nodes-base.filter
• Google Sheetsn8n-nodes-base.googleSheets
• Remove Duplicatesn8n-nodes-base.removeDuplicates
• Sortn8n-nodes-base.sort
• Limitn8n-nodes-base.limit
• Aggregaten8n-nodes-base.aggregate

From the author

This n8n workflow is a sophisticated B2B Lead Generation Scraper. It automates the entire journey from discovering businesses on Google Maps to extracting, scoring, and saving high-quality contact emails. Here is a breakdown of the workflow stages: Stage 1:…

View the original on n8n.io → Check your own copy