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

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 spreadsheet.

How it works

1. Creates a new Google Sheets spreadsheet with a “Leads” tab when you run the manual setup trigger.
2. Triggers when a user submits the “Find local business leads” n8n form with a niche, location, and optional max results.
3. Builds a Google Maps search query from the form inputs and reads existing rows from the target Google Sheet for deduplication.
4. Uses ScraperAPI’s Google Maps Search to fetch metadata for the query, then extracts the results-page URL and fetches the autoparsed Google Maps results.
5. Parses the returned businesses into lead fields (for example name, phone, address, website, rating, coordinates, and a Google Maps link) and filters by the minimum rating setting.
6. Removes businesses already present in the sheet (matched by name + address), caps the batch to the requested maximum, and appends the new leads to Google Sheets.

Setup

1. Add Google Sheets credentials in n8n and select the target Spreadsheet ID and Sheet name in both the “Read Existing Leads” and “Append Leads to Sheet” steps.
2. Add your ScraperAPI credential (API key) for the ScraperAPI nodes.
3. Run the manual “Create Leads Spreadsheet” step once if you want n8n to create a new spreadsheet, then copy its document ID into the read/append steps.
4. Use the form trigger’s production webhook URL (generated by n8n) and share it with users who should submit lead searches.