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
- 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.
- In Search terms, type what you'd type in Google Maps:
plumber,electrician. - 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. - Set Max places per search (60 is the default, up to 300) and click Start.
- 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 (
websiteempty): prospects for web designers and agencies. -
Few reviews (
review_countunder 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
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")
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": truein the same run. The tool reads each business's home page and up to 4 contact or about pages and addsprimary_email,emails,website_phones,social_profilesand 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_urlanddomain. 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)
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.
Top comments (0)