📊 Scrape Google Maps places to Google Sheets with Apify
⚡ 86 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Quick overview
This workflow takes a city and search query, scrapes matching Google Maps places using Apify’s Google Maps Scraper, and writes the results (name, rating, reviews, category, address, website, and link) into a newly created Google Sheets spreadsheet.
How it works
- Starts when you manually execute the workflow.
- Sets the search parameters (city, query, and maximum number of places to collect).
- Creates a new Google Sheets spreadsheet with a “Places” tab named after the search.
- Runs the Apify Google Maps Scraper actor to collect places matching the query in the specified city.
- Appends one row per place to Google Sheets with key details including rating, reviews, address, website, category, and Google Maps URL.
Setup
- Open Scrape Google Maps with Apify and connect your Apify account with OAuth2. A free Apify account is enough to run the Google Maps Scraper Actor (compass/crawler-google-places).
- Open Create the spreadsheet and sign in with Google. Add places to the sheet reuses the same Google Sheets credential.
- In Search settings, set city, query, and maxPlaces.
- Click Execute workflow, then open spreadsheetUrl in the output of Create the spreadsheet to see your results.
Requirements
- An Apify account (the free plan works).
- A Google account with access to Google Sheets.
Customization
- Raise maxPlaces for longer lists.
- Add a Schedule Trigger to refresh the sheet every week.
- Swap in any other Actor from Apify Store.
🔗 Nodes Used
Google Sheets
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File