Scrape Google Maps to Google Sheets with Apify in n8n

Scrape Google Maps results into Google Sheets—automatically with Apify inside n8n

Need a list of Google Maps places for a city and keyword? This n8n workflow uses Apify’s Google Maps Scraper to collect matching places and writes the results directly into a new Google Sheets spreadsheet—ready for analysis, outreach, or research.

What this workflow does

• Starts on manual execution (you click Execute workflow).
• Sets search parameters: city, query, and maxPlaces.
• Creates a new Google Sheets spreadsheet with a “Places” tab named after your search.
• Runs the Apify Google Maps Scraper actor to scrape places that match your query in the specified city.
• Appends one row per place to the “Places” tab, including: name, rating, reviews, category, address, website, and the Google Maps link.

Use cases

• Build a lead list for a specific neighborhood (e.g., “dentists” in a city) with ratings and review counts.
• Quickly gather market research data by pulling consistent Google Maps place details into Sheets.
• Refresh sources for directory-style datasets by increasing maxPlaces and rerunning on demand.

Technical details

• Apify integration: Connect your Apify account (the free plan is enough to run the Google Maps Scraper Actor: compass/crawler-google-places).
• n8n nodes: Manual Trigger, Set, Sticky Note, Google Sheets, and Apify node (apifyn8n-nodes-apify via Apify).
• Output: The workflow returns spreadsheetUrl so you can open the generated sheet and view results.

Requirements & customization

• Apify account + Google account with access to Google Sheets.
• Customize by raising maxPlaces, adding a Schedule Trigger for weekly refresh, or swapping in another actor from the Apify Store.