n8n Google Maps Lead Scraper w/ SearchAPI & Hunter to Sheets

Scrape Google Maps leads and push them straight into Google Sheets—with SearchApi.io and optional Hunter email enrichment

This n8n workflow automatically pulls live Google Maps business listings using SearchApi.io, deduplicates results by place ID, optionally finds high-confidence email addresses with Hunter.io, and appends everything to a Google Sheets spreadsheet (including ratings and a direct Maps link).

What this workflow does

• Runs on demand or on a weekly schedule so you can keep your lead pipeline current without manual searching.
• Builds Google Maps search queries by combining your configured business categories and locations, then paginates each combination.
• Scrapes live Google Maps results through SearchApi.io for each query and page.
• Flattens listings into one lead per business, deduplicating entries by place_id and deriving a website domain when available.
• Optionally enriches with email via Hunter.io (Domain Search) and attaches the highest-confidence email to each lead.
• Appends leads to Google Sheets with mapped fields such as business, category, location, type, address, phone, website, email, rating, reviews, maps_url, and place_id.

Use cases

• Build and refresh a local lead list for sales and outreach campaigns.
• Generate prospecting data for agencies targeting specific categories and locations.
• Maintain a structured CRM-like worksheet in Google Sheets by running the workflow weekly.

Technical details

• Nodes / stack: set, code, hunter, sticky note, google sheets, manual trigger
• SearchApi.io integration: uses @searchapi/n8n-nodes-searchapi and your SearchApi API credential to scrape Google Maps results.
• Hunter.io integration (optional): Domain Search to find and attach the best-confidence email per business domain.
• Google Sheets: requires a header row matching the workflow fields (business, category, location, type, address, phone, website, email, rating, reviews, maps_url, place_id).

Get the workflow to turn Google Maps visibility into an organized, export-ready lead sheet—complete with ratings, review counts, and enrichment-ready contact data.