Collect local business leads from Google Maps with ScraperAPI and Google Sheets

by ScraperAPI ✓ · 97 views · created 2026-07-06 · Lead Generation

What this workflow does

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

How it runs

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

1. Create Leads Spreadsheet (Google Sheets): create (spreadsheet)
2. Configure (Edit Fields (Set)): sets 4 fields: query, countryCode, minRating…
3. Read Existing Leads (Google Sheets): read
4. Build Search Query (Code): runs custom JavaScript code
5. Fetch Maps Metadata via ScraperAPI (Scraper Api): google maps search (sde)
6. Extract Results URL (Code): runs custom JavaScript code
7. Fetch Maps Results via ScraperAPI (Scraper Api): api request
8. Extract Businesses (Code): runs custom JavaScript code
9. Dedupe New Leads (Code): runs custom JavaScript code
10. Append Leads to Sheet (Google Sheets): append

Services it uses

Google SheetsScraperapi Official (community)

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nodes used (6)

• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• n8n Form Triggern8n-nodes-base.formTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Scraper Apin8n-nodes-scraperapi-official.scraperApi

From the author

Quick Overview This workflow collects local business leads from Google Maps using ScraperAPI and stores them in Google Sheets, letting you submit a niche and location via an n8n form and automatically deduplicate and append new businesses to your leads…

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