Scrape business emails from Google Maps to Google Sheets

by Ravi Patel ✓ · 147 views · created 2026-06-16

What this workflow does

This workflow has 18 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

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
3. Execute scraper for query (Execute Sub-workflow): calls another n8n workflow
4. Scrape URLs from results (Code): runs custom JavaScript code
5. Wait: waits 2 seconds
6. Filter: keeps only the items that match a condition
7. Remove Duplicate URLs (Remove Duplicates): removes duplicate items
8. Loop over URLs (Loop Over Items (Split in Batches)): loops over the items in batches
9. Loop over pages (Loop Over Items (Split in Batches)): loops over the items in batches
10. Request web page for URL (HTTP Request): calls an HTTP API

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

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (12)

• Remove Duplicatesn8n-nodes-base.removeDuplicates
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Filtern8n-nodes-base.filter
• Aggregaten8n-nodes-base.aggregate
• Split Outn8n-nodes-base.splitOut
• Google Sheetsn8n-nodes-base.googleSheets
• Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger
• Manual Triggern8n-nodes-base.manualTrigger
• Waitn8n-nodes-base.wait
• Execute Sub-workflown8n-nodes-base.executeWorkflow

From the author

Quick overview This workflow takes a list of Google Maps search queries, extracts candidate business website URLs from the search results, visits each site, scrapes email addresses from the page content, and appends cleaned, deduplicated emails to Google…

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