This automation extracts business data from Google Maps based on zip codes + subcategories, removes duplicates, handles API limits with exponential backoff, and automatically stores everything in Google Sheets.

Built for agencies, lead gen businesses, and local marketers who want structured, scalable local data collection.

✅ Fetches zip codes from Google Sheets ✅ Fetches Google Maps subcategories ✅ Loops through each zip + category combination ✅ Calls Google Places API (Text Search) ✅ Extracts detailed business information ✅ Splits places into individual records ✅ Removes duplicate listings ✅ Appends or updates results in Google Sheets ✅ Marks processed zip codes as “scraped” ✅ Handles API rate limits using exponential backoff ✅ Stops automatically if max retries are exceeded

Business Name

Phone Number

Website

Address

Google Rating

Review Count

Place ID

Business Types

GPS Coordinates

Reviews Data

Category Type

All saved cleanly into a structured Google Sheet.

Duplicate prevention via Place ID matching

Status tracking per zip code

Error handling with retry logic

Exponential backoff for API limits

Empty response detection

Controlled batch processing

Retry stop conditions

Lead generation agencies

Local SEO agencies

Cold outreach businesses

Data scraping services

Marketing automation experts

SaaS founders targeting local businesses

n8n automation workflow

Google Places API

Google Sheets integration

Complete n8n workflow file

Email extraction add-on

Social media scraping

Multi-state expansion

CRM integration

Automated outreach sequence

Scheduled recurring scraping

If you want a scalable Google Maps scraping engine that runs automatically and handles limits intelligently