DEV Community

Aurelix Solutions
Aurelix Solutions

Posted on Edited on Originally published at dev.to

Export Google Maps results to Excel, for many cities at once (phones, websites, owners)

Google Maps shows you every plumber in town, but it has no "download" button. Copying listings into a spreadsheet by hand works for ten businesses; it doesn't work for every plumber, electrician and roofer in five cities.

This guide exports Google Maps search results straight into an Excel file: one row per business, with phone, website, rating, review count, address and opening hours. There's a no-code path (a few clicks, then a download) and a Python path that writes a ready-to-filter .xlsx with one tab per city. At the end, an optional step adds the owners and managers each business names on its own website.

Disclosure: I'm Aurelix, and I built the Google Maps Business Scraper used below. It's a paid tool, priced per business returned (prices below).

Path 1: no code, straight to Excel

  1. Open the Google Maps Business Scraper and open it in the Apify console. You need an Apify account; the monthly credit on Apify's free plan covers a first test.
  2. In Search terms, type what you'd type in Google Maps: plumber, electrician.
  3. In Locations, add the cities: Calgary AB, Edmonton AB, Austin, TX. Each search term runs in each location, so this is 2 × 3 = 6 searches.
  4. Set Max places per search (60 is the default, up to 300) and click Start.
  5. When the run finishes, open the Output tab, click Export, pick Excel and download. CSV and JSON are there too.

To have every run land in Google Sheets instead, add Apify's Google Sheets integration to the tool (the Integrations tab) and point it at a sheet.

What's in each row

The columns you'll use most:

Column Example
name Priority Plumbing & Drains
category Plumber
phone_display +1 647-247-2275
website https://priorityplumbing.ca/
rating, review_count 4.8, 1955
street, city, region, postal_code the address, already split
google_maps_url a link to the listing
search_term, search_location which search found it

Every row also has phone in E.164 format, all of Google's categories for the place, hours by day, latitude, longitude, timezone, place_id and up to 3 short review_snippets that Google shows on the listing.

Two quick filters once it's in Excel:

  • No website (website empty): prospects for web designers and agencies.
  • Few reviews (review_count under 20): businesses that may want help with reviews or local marketing.

Path 2: Python, one Excel tab per city

pip install apify-client pandas openpyxl
Enter fullscreen mode Exit fullscreen mode
import os

import pandas as pd
from apify_client import ApifyClient

client = ApifyClient(os.environ["APIFY_TOKEN"])
run = client.actor("aurelix/google-maps-scraper").call(run_input={
    "searchTerms": ["plumber", "electrician"],
    "locations": ["Calgary AB", "Edmonton AB", "Austin, TX"],
    "maxResultsPerSearch": 100,
})
places = pd.DataFrame(client.dataset(run["defaultDatasetId"]).iterate_items())

cols = ["name", "category", "phone_display", "website", "rating", "review_count",
        "street", "city", "region", "postal_code", "google_maps_url", "search_term"]

with pd.ExcelWriter("google_maps_leads.xlsx") as xl:
    places[cols].to_excel(xl, sheet_name="All", index=False)
    for loc, group in places.groupby("search_location"):
        group[cols].to_excel(xl, sheet_name=loc[:31].replace("/", "-"), index=False)

print(len(places), "businesses,", places["website"].isna().sum(), "without a website")
Enter fullscreen mode Exit fullscreen mode

Open google_maps_leads.xlsx and you have an "All" tab plus one tab per city. A business is returned once per run even when two searches find it.

Optional: emails and the people behind the business

Google Maps doesn't show emails. Two ways to add contacts, both reading only what the business publishes on its own website:

  • Emails, phones and social links: set "enrichWebsiteContacts": true in the same run. The tool reads each business's home page and up to 4 contact or about pages and adds primary_email, emails, website_phones, social_profiles and the staff the site names with a job title (people). It's charged only for places where something was found.
  • Owners, founders and managers: send the websites to Decision Maker Finder, which returns each person the company names on its own site with name, title, seniority, work_email, linkedin_url and domain. It never guesses email patterns.
from urllib.parse import urlparse

def domain(url):
    host = urlparse(url if "//" in url else "https://" + url).netloc.lower()
    return host.removeprefix("www.")

places["domain"] = places["website"].dropna().map(domain)
run = client.actor("aurelix/decision-maker-finder").call(run_input={
    "domains": sorted(places["domain"].dropna().unique()),
    "seniorities": ["founder_owner", "c_suite"],
    "maxPeoplePerCompany": 3,
})
people = pd.DataFrame(client.dataset(run["defaultDatasetId"]).iterate_items())

leads = places.merge(people[["domain", "name", "title", "work_email"]].rename(
    columns={"name": "person", "title": "person_title"}), on="domain", how="left")
leads.to_excel("google_maps_leads_with_owners.xlsx", index=False)
Enter fullscreen mode Exit fullscreen mode

Many small local businesses don't list their team, so expect a person on only part of the list; companies without a matching person aren't charged.

Only new businesses, every week, with a Slack message

Add "incremental": true and a stateKey such as "alberta-trades", save the input as a task and schedule it weekly in the Apify console. Places returned before are skipped and not charged, so each run's Excel export holds only businesses new to your list. Paste a Slack incoming-webhook URL into slackWebhookUrl and each run posts a short digest with the count and the top 10. "New" means new to your list: an established business that appears in Google's results for the first time also counts.

Limits

  • Up to 300 places per search term and location, in Google's order. For more coverage, split a big city into neighbourhoods or use narrower terms ("emergency plumber", "drain cleaning").
  • Rating, website and hours are empty when the business has none on Google Maps.
  • No full review history; only the average rating, review count and up to 3 snippets.

Price

Google Maps Business Scraper: $0.85 per 1,000 places ($0.75 on paid Apify plans), plus $0.001 per run. Website contacts, when turned on: $1.50 per 1,000 places where something was found ($1.05 on paid plans). Decision Maker Finder: $0.90 per 1,000 people returned, plus $0.002 per run.

Try it: Google Maps Business Scraper on the Apify Store

Top comments (0)