Google Maps Lead Scraper with Apify to Google Sheets (n8n)

Turn Google Maps searches into ready-to-use leads in Google Sheets (via Apify + n8n)

This n8n workflow scrapes Google Maps business listings that have websites using Apify’s Google Maps Scraper, enriches each website with emails and phone numbers using Apify’s Contact Details Scraper, then appends the merged lead rows to Google Sheets—all on demand.

What this workflow does

• Runs on demand (manual trigger) so you can generate leads whenever you need them.
• Lets you define your search term, target location, max places to crawl, and an Apify spend cap.
• Uses Apify’s Google Maps Scraper to collect businesses matching your criteria that have a website.
• De-duplicates websites/domains and sends unique domains to Apify’s Contact Details Scraper.
• Extracts emails, phone numbers, contact URLs, and social profiles for those websites, then merges the results back to the original Google Maps business data by matching on website domain.
• Appends the combined lead information into your chosen Google Sheets worksheet.

Use cases

• Build a targeted lead list for local services (e.g., “plumber” in a city) and export it to Google Sheets.
• Enrich Google Maps results for outreach campaigns with contact details (email/phone) for sales or partnerships.
• Use in SaaS/operator workflows to refresh lead databases on a schedule or ad hoc demand.

Technical details

• n8n nodes/tools: Manual Trigger, Set, Code, Sticky Note, Google Sheets, and Apify nodes (apify/apify-nodes via n8n-nodes-apify).
• Apify integration:
  • Google Maps Scraper (billed per place)
  • Contact Details Scraper (billed only for websites where an email or phone is found; ~$3 per 1,000)
• Setup: Add an Apify API token credential to both Apify nodes, add Google Sheets credentials, select the spreadsheet/worksheet, then update search parameters (term, location, maxPlaces, maxCostUsd).

Generate clean, enriched Google Maps leads quickly—without manual copying—using Apify + Google Sheets through n8n.