Apify Google Maps Scraper for n8n: Leads to Google Sheets

Turn Google Maps leads into a Google Sheets list—automatically

This n8n workflow uses the Apify Google Maps Scraper Orchestrator to scrape Google Maps business listings for plumber-related search terms in Seine-Saint-Denis (France), then appends the results to Google Sheets with business name, phone, and website.

What this workflow does

• Runs on-demand: start it by clicking “Execute workflow” in n8n.
• Launches the Apify actor: the workflow runs the Apify Google Maps Scraper Orchestrator to search Google Maps in France for these terms: “plombier”, “chauffagiste”, and “plombier chauffagiste” around Seine-Saint-Denis.
• Collects scraped places data: it outputs each listing item from Apify, including the title, phone, website, and search-term metadata.
• Writes results to Google Sheets: for every scraped business, it appends a new row containing the search term, business name, phone number, and website.

Use cases

• Building a local lead list for plumbing and heating services targeting Seine-Saint-Denis.
• Refreshing contact data in Google Sheets for sales, outreach, or CRM import workflows.
• Testing and iterating on Google Maps scraping for specific French keywords and regions before expanding to more locations.

Technical details

• Trigger: Manual trigger (execute on demand).
• Apify integration: apifyn8n-nodes-apify using an Apify API token credential to run the Google Maps Scraper Orchestrator actor.
• Google Sheets: uses Google Sheets credentials (service account or OAuth) with edit access to append rows.
• Configuration: update the Apify actor input (search terms, locationQuery, and limits) and confirm the Google Sheets document ID, tab, and column mappings match your sheet.