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

Automatically scrapes Google Maps for business listings, extracts email addresses from websites, and exports leads to Google Sheets.

workflowlead_generation

by Nick Saraevon n8n

Nodes

Triggers

Platform

n8n

Tech Stack

Google Sheets

How It Works

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.

Read search queries from Google Sheets

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

Scrape Google Maps business listings

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

Filter and clean website URLs

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

Visit business websites to extract emails

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

Attached Files

workflow.json