G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
Loading setup wizard...
Back to Lead generation system: Google Maps to email scraper with Google Sheets export

Set Up: Lead generation system: Google Maps to email scraper with Google Sheets export

This workflow searches Google Maps for businesses by location and industry, visits each business website to extract email addresses using pattern recognition, then compiles and exports clean lead data to Google Sheets with automatic duplicate removal.

What This Automation Does
1

Read search queries from Google Sheets

Retrieves target search terms like location and business type combinations from the configured Google Sheets document.

2

Scrape Google Maps business listings

Performs HTTP requests to Google Maps search URLs and extracts business listing data including website URLs from search results.

3

Filter and clean website URLs

Uses JavaScript regex patterns to remove irrelevant domains and extract valid business website URLs for processing.

4

Visit business websites to extract emails

Processes each website individually with rate limiting and error handling to scrape HTML content and identify email addresses.

5

Apply email pattern recognition

Uses advanced regex patterns to extract valid email addresses from website content including contact and administrative emails.

6

Clean and export lead data

Removes duplicates, filters invalid entries, and exports the final organized email list to the designated Google Sheets tab.

Prerequisites

  • Google Sheets account with document access
  • Google Sheets configured with searches and emails tabs
  • Google Sheets API credentials for n8n integration
  • Stable internet connection for web scraping

Services Used

Google Sheets

Services with alternatives — you can swap them in the next step.