Scrape Google Maps Places to Google Sheets

How It Works

This workflow turns one search phrase into a ready-to-use leads sheet. You enter a city, a query, and how many places to collect; n8n creates a new Google Sheets spreadsheet, runs Apify’s Google Maps Scraper, and writes one row per place with name, rating, reviews, category, address, website, and the Google Maps URL. The free Apify plan is enough to run it.

Setup Steps

1. Connect Apify: Open the Scrape Google Maps with Apify node and connect your Apify account with OAuth2. The workflow calls the compass/crawler-google-places Actor on the free plan.
2. Connect Google Sheets: Open the Create the spreadsheet node and sign in with Google. The Add places to the sheet node reuses the same credential.
3. Configure the search: In the Search settings node, set city, query, and maxPlaces.
4. Run the workflow: Click Execute workflow, then open spreadsheetUrl from the Create the spreadsheet node output to view your results.

Automation Workflow

Manual Trigger → Search Settings (city, query, maxPlaces)
                      ↓
        Create Google Sheets spreadsheet (Places tab)
                      ↓
        Apify Google Maps Scraper (compass/crawler-google-places)
                      ↓
        Append rows to Google Sheets (name, rating, reviews, category, address, website, URL)

Benefits

• Zero API setup: Skips the Google Places API, its billing, and the per-request quota by routing through Apify’s Actor.
• Free tier friendly: Runs end to end on the free Apify plan for small batches.
• Clean output: Writes one row per place with ratings, reviews, address, website, category, and the Google Maps URL ready for filtering and sorting.
• Easy to rerun: Change the city, query, or maxPlaces values and execute again to build a new sheet.
• Portable base: Swap the Google Maps Actor for any other Apify Store Actor to scrape a different source into the same sheet shape.

Use Cases

• Build a prospect list of restaurants, gyms, or clinics in a target city for outbound sales.
• Research competitors in a specific neighborhood and benchmark their ratings and review counts.
• Collect site survey data for a store rollout, including addresses and existing business categories.
• Feed a local SEO audit by pulling every business ranking for a service term in a city.
• Seed a CRM import with location, contact website, and review signals before enrichment.