# Scrape Google Maps data by URL into Google Sheets: name, phone, address, rating
This automation template automatically extracts up-to-date place data from Google Maps — including names, phones, addresses, ratings, and websites — based on predefined search URLs and saves it in structured format to Google Sheets. It’s ideal for gathering location data without using the official Google Maps API, reducing costs and enabling scalable operations.
## Who it´s for
- Marketers conducting local competitor analysis
- Agencies managing databases of locations and sales points
- Developers seeking cheaper alternatives to the Google Maps API
- Business owners verifying their map presence and details
- Analysts working with geodata and reviews
## What the automation does
- Triggers hourly via cron or manually on demand
- Reads search URLs from a Google Sheet (e.g., ´restaurants in Berlin @52.5,13.4´)
- Extracts keywords and geo-coordinates for SerpAPI queries
- Fetches paginated Google Maps results via SerpAPI
- Aggregates, cleans, and deduplicates entries
- Writes structured place data (name, phone, address, rating, etc.) into a results sheet
- Updates status in source sheet: ✅ on success, ❌ on error
## What´s included
- Ready-to-use n8n workflow
- Trigger logic (cron schedule and manual execution)
- Integrations with Google Sheets, SerpAPI, and Google Maps via HTTP and JavaScript nodes
- Basic text instructions for setup and adaptation
## Requirements for setup
- n8n account with workflow editing access
- Valid SerpAPI API key
- Google Sheets access (via Google Sheets API)
- Source sheet with search URLs
- Target sheet for storing scraped place data
## Benefits and outcomes
- Saves hours of manual data collection from Google Maps
- Enables regular monitoring of listing changes
- Supports lead generation and competitive intelligence without costly APIs
- Automatic error detection via status flags
- Centralized storage of geodata in Google Sheets
- Transparent processing: cleaning, deduplication, structuring
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet