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.
Your results
Run a search above. The rows land in this sheet.
| Row | Name | Category | Address | Phone | Website | Rating | Reviews | Place ID | Latitude | Longitude | Google Maps URL | Search | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||||||
| 2 | |||||||||||||
| 3 | |||||||||||||
| 4 | |||||||||||||
| 5 | |||||||||||||
| 6 | |||||||||||||
| 7 | |||||||||||||
| 8 |
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.
- Name
- Category
- Address
- Phone
- Website
- Rating
- Reviews
- Place ID
- Latitude
- Longitude
- Google Maps URL
- Search
From this page to your sheet
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. 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. 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")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.
More free scrapers
All free toolsFree 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.
