Parsing companies from Google Maps to Google Sheets
Data Parsing
Task: collect company cards from Google Maps based on a search query and location (e.g., "cafes, restaurants" + city district) — name, rating, number of reviews, website, phone, address, link to the card.
What was done:
— a script in Python + Playwright scrolls through Google Maps results and collects the specified number of new cards per run
— deduplication to avoid pulling the same entries during repeated runs
— direct export to Google Sheets via service account (Google Sheets API) alongside saving to CSV — if the key is not set up, it simply writes to CSV, nothing breaks
— a separate test run on a small sample before the full launch
Stack: Python, Playwright, Google Sheets API, Pandas.
Ready solution for: lead generation (agencies looking for clients in a specific niche/area), competitor analysis, building databases for cold outreach.
#googlemaps #parsing #playwright #leadgen #python #googlesheets
What was done:
— a script in Python + Playwright scrolls through Google Maps results and collects the specified number of new cards per run
— deduplication to avoid pulling the same entries during repeated runs
— direct export to Google Sheets via service account (Google Sheets API) alongside saving to CSV — if the key is not set up, it simply writes to CSV, nothing breaks
— a separate test run on a small sample before the full launch
Stack: Python, Playwright, Google Sheets API, Pandas.
Ready solution for: lead generation (agencies looking for clients in a specific niche/area), competitor analysis, building databases for cold outreach.
#googlemaps #parsing #playwright #leadgen #python #googlesheets