Build Verified Google Maps Leads with Apify & Google Sheets

Build Verified Google Maps Leads with Apify & Google Sheets

Turn Google Maps search results into a clean, deduplicated lead list—by scraping businesses with Apify, finding emails from their websites, verifying deliverability, and automatically appending or updating records in Google Sheets.

What this workflow does

• Starts manually when you execute the n8n workflow.
• Scrapes Google Maps with Apify using your configured search term, location, result limit, and minimum review count—collecting businesses that have websites.
• Extracts business websites from the Google Maps results, builds a unique list of those websites, and sends them to Apify’s Website Email Finder to extract email addresses.
• Deduplicates discovered emails and then sends them to Apify’s Bulk Email Verifier to check deliverability.
• Joins results—combines Google Maps business data with the found email addresses and verification outcomes, filters duplicates and non-deliverable emails (optionally keeping catch-all results), and formats rows for export.
• Updates Google Sheets by matching on the email address: it appends new rows or updates existing ones.

Use cases

• Generate B2B prospecting lists for local services (e.g., agencies, contractors, clinics) from Google Maps.
• Enrich a sales pipeline with verified emails instead of unvalidated contact scraping.
• Maintain an always-current Google Sheets lead database by re-running searches with updated terms and limits.

Technical details

• n8n nodes: Manual trigger, Set, Code, Sticky note, Google Sheets, and Apify nodes (n8n-nodes-apify).
• Apify integrations: Google Maps Scraper, Website Email Finder, Bulk Email Verifier (requires an Apify API token credential).
• Google Sheets integration: OAuth credential + target spreadsheet/sheet.
• Sheet headers: ensure fields like business, category, email, email_status, phone, website, address, rating, reviews, maps_url, email_source, found_at are present.

Perfect for n8n automation engineers and SaaS operators looking to run a verified Google Maps lead generation workflow with Apify and Google Sheets.