n8n Workflow: Google Places Lead Enrichment to Google Sheets

Turn Google Places searches into verified B2B leads in Google Sheets

This n8n workflow searches Google Places for your target niche and location, enriches each business by scraping contact details from its website (optionally respecting robots.txt), and then upserts verified prospect records into Google Sheets—with clear confidence and status reporting.

What this workflow does

• Starts with input via a manual run or a public n8n Form submission (niche, city, country, result limit, scraping depth, and robots.txt preference).
• Builds and paginates a Google Places Text Search query, iterating through results until the configured maximum is reached or a controlled stop condition occurs.
• Creates per-place enrichment jobs for each returned business, including website domain normalization to reduce unsafe requests.
• Optionally checks robots.txt before scraping, based on your preference.
• Scrapes key website data from the homepage and a small set of internal pages (basic or expanded depth), extracting emails, phone numbers, WhatsApp links, social profiles, and selected JSON-LD fields with source URLs.
• Generates verified records with confidence/status labels, keeps only the permanent schema, and deduplicates using Place ID (or normalized domain if Place ID is missing).
• Writes to Google Sheets via upsert and outputs an execution summary (complete, partial, blocked, no website, and controlled errors).

Use cases

• Build a targeted prospect list for outbound sales by niche + location (e.g., “plumbing services in Austin”).
• Enrich trade directories and local business leads into structured Google Sheets for outreach.
• Run repeatable lead research workflows using n8n Forms with adjustable scraping depth.

Technical details

• Target integrations/nodes: Google Places API (Text Search), Google Sheets, and n8n nodes including if, set, code, wait, sticky note, and form trigger.
• Includes input validation/normalization, pagination state handling, website/domain safety checks, optional robots.txt evaluation, and structured upsert deduplication.