SheetMagicSheetMagic

Free Google Maps Scraper: Business Leads into Google Sheets

Type a kind of business and a place, and we pull the matching Google Maps listings with phone, website, rating and address. You see up to 5 results here; install SheetMagic free to get every result in Google Sheets.

Try

Results show here on the page, not in your inbox. Your email caps free runs per person. We send one email asking you to confirm it; nothing else comes unless you click it. Privacy policy

Free. Up to 5 results, in up to about a minute.

Your results

Run a search above. The rows land in this sheet.

RowNameCategoryAddressPhoneWebsiteEmailRatingReviewsPlace IDLatitudeLongitudeGoogle Maps URLSearch
1
2
3
4
5

Install SheetMagic to get every result in Google Sheets

The same scraper runs from a formula in your sheet and writes every row there. The free plan includes 100 one-time scraping credits.

Free Google Maps scraper for Google Sheets, in short

To scrape Google Maps into Google Sheets for free, install the SheetMagic add-on and type =GMAPS("dentists in Austin, TX") in a cell. It writes the matching places, with name, category, address, phone, website and rating, to a Google Maps Results tab. The free plan includes 100 one-time scraping credits, and you can try a search on this page first.

13 columns for every result

Each result is one row, with these columns in this order. Fields the source does not show stay blank.

  1. Name
  2. Category
  3. Address
  4. Phone
  5. Website
  6. Email
  7. Rating
  8. Reviews
  9. Place ID
  10. Latitude
  11. Longitude
  12. Google Maps URL
  13. Search

From this page to your sheet

  1. 1. Try it on this page

    Type a kind of business and a place, add your email and press run. You see up to 5 matching listings in a table, with no install needed.

  2. 2. Install SheetMagic for free

    Add SheetMagic from the Google Workspace Marketplace and click Activate. No card and no separate account. The free plan includes 100 one-time scraping credits.

  3. 3. Get every result in Google Sheets

    Type =GMAPS("plumbers in Leeds") in any cell, or put one search per row in column A and drag =GMAPS(A2) down. The places each search finds land on a Google Maps Results tab in the same spreadsheet.

Who uses it, and for what

Agencies building local lead lists

You sell websites or ads to local businesses. Search a trade and a city, sort by rating and keep the listings with a phone and no website, and you have a call list.

Sales teams mapping a territory

You cover five cities. Put one search per city in a column and drag GMAPS down. The businesses for every city land on one results tab with their address and phone, ready to assign.

Founders sizing a local market

Before opening a studio or a shop, count the competitors nearby, read their ratings and review counts, and see which areas have few options.

The same thing, inside Google Sheets

GMAPS takes a plain search, the same words you would type into Google Maps, and writes the matching places with name, category, address, phone, website and rating to a Google Maps Results tab. Each call returns up to 20 places; set the optional start argument to 20, 40 and so on for the next page. Use =GMAPS(A2) and drag it down to run a column of searches.

=GMAPS("dentists in Austin, TX")
Type it in any cell once SheetMagic is installed.

Other ways to do it

Copy and paste by hand
Free, but you open each listing and copy the phone and website one at a time. Fine for ten places, slow for a hundred.
IMPORTXML in Google Sheets
Free, but Google Maps builds its pages with JavaScript, so IMPORTXML usually comes back empty or breaks when the page changes.
The official Google Maps API
Reliable and documented, but you need a Google Cloud project, an API key, billing set up and code to write the results into a sheet.
SheetMagic GMAPS
A plain search in a formula, with results written straight into Google Sheets. Uses scraping credits, and only shows what the public listing shows.

Questions

Is this Google Maps scraper free?
Yes. Running it on this page is free and shows up to 5 results. To get every result in Google Sheets, install SheetMagic for free. The free plan includes 100 one-time scraping credits, and scrapes you run in Sheets use those credits.
How many results can I get?
This page shows up to 5 results per run, and each email gets a small number of runs per day. In Google Sheets, each GMAPS formula returns up to 20 places per page; set its start argument to 20, 40 and so on to read the next pages. Each scrape uses scraping credits.
What data do I get for each business?
On this page: name, category, address, phone, website, email when one is found, rating, review count, Google place ID, latitude, longitude, the Google Maps link and the search that found it. GMAPS in Sheets returns the name, category, address, phone, website, rating, review count, place ID and coordinates, plus details such as opening hours when the listing has them.
How do I get Google Maps results into Google Sheets?
Install SheetMagic from the Google Workspace Marketplace and click Activate. Then type =GMAPS("plumbers in Leeds") in any cell, or put one search per row in column A and drag =GMAPS(A2) down. The places land on a Google Maps Results tab in the same spreadsheet.
Why are some phone numbers or websites missing?
The scraper only returns what the public Google Maps listing shows. Many small businesses never add a website or email to their listing, so those cells stay empty rather than being guessed.
Is scraping Google Maps allowed?
The scraper reads public listing details that anyone can see in a browser. How you use the data is up to you and is regulated: contact laws such as CAN-SPAM and GDPR apply to the outreach you send. Check the rules where you and your recipients are.
Why do you ask for my email?
Each run reads live pages, so the email lets us limit runs per person and stop abuse. We may also send you SheetMagic emails, and you can unsubscribe from any of them. Your results show on this page as soon as the run finishes.
All free tools

Free plan

100scraping credits, one time

Run the full Google Maps scraper in Google Sheets.

Install SheetMagic from the Google Workspace Marketplace. No card, no separate account, and no deadline on the free allowance.