This workflow automates the process of scraping business data from Google Maps using SerpAPI and organizes the results directly into Google Sheets.
It’s a cost-effective alternative to the official Google Maps API, allowing you to extract detailed place information such as contact details, ratings, and addresses from any Google Maps search URL.
The workflow runs either manually or on a scheduled interval, fetching results from Google Maps, handling pagination, cleaning duplicates, and storing the final dataset in a structured format inside Google Sheets.
✨ Features
- 🔄 Automated Google Maps Scraping via SerpAPI.
- 🗂 Google Sheets Integration: Fetch search URLs and store results in a spreadsheet.
- 📍 Data Enrichment: Collects business details like phone, website, rating, reviews, address, hours, price, and more.
- 🔁 Pagination Handling: Iterates through multiple results pages automatically.
- 🧹 Smart Data Cleaning: Removes empty values and duplicate entries.
- ✅ Status Tracking: Updates Google Sheets with “Success” or “Error” for each processed URL.
- ⏱ Flexible Triggers: Run manually or on a scheduled interval (e.g., hourly).
