Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Web Scraping & Research

Web Scraping & Research

Scrape Google Maps Data with SerpAPI into Google Sheets

On a schedule or manual run, it pages through Google Maps results with SerpAPI and saves the business data in Google Sheets.

Import it free Sign in to open it

What it does

## Read Me This workflow allows to scrape Google Maps data in an efficient way using SerpAPI. You'll get all data from Gmaps at a cheaper cost than Google Maps API. Add as input, your Google Maps search URL and you'll get a list of places with many data points such as: - phone number - website - rating - reviews - address And much more. Full guide to implement the workflow is here: https://lempire.notion.site/Scrape-Google-Maps-places-with-n8n-b7f1785c3d474e858b7ee61ad4c21136?pvs=4

The steps

  1. When clicking "Execute Workflow"
  2. Extract next start value
  3. Merge all values from SERPAPI
  4. Transform data in the right format
  5. Add rows in Google Sheets
  6. SERPAPI - Scrape Google Maps URL
  7. Remove duplicate items
  8. Split out items
  9. Remove empty values
  10. Google Sheets - Get searches to scrap
  11. Extract keyword and location from URL
  12. Run workflow every hours
  13. Update Status to Success
  14. Update Status to Error

15 steps in total.

Similar automations

Lead Generation & EnrichmentCollect Google Maps Leads by Chat with GPT-4o, Apify and SerpAPI14 stepsWeb Scraping & ResearchScrape Google Maps Places with Apify into Google Sheets5 stepsWeb Scraping & ResearchScrape Google Maps Businesses with Apify into Google Sheets7 stepsWeb Scraping & ResearchScrape Google Maps Phone Numbers with Bright Data8 steps