Google Maps Scraper

Scrape business data from Google Maps directly into your spreadsheet with our Google Maps Scraper – built to create lead lists, researching competitors, or analyzing local business ecosystems.

Start collecting business data from Google Maps immediately with our pre-built, free Google Maps scraper template on Google Sheets.

Get started with our ready-to-use template

Our plug-and-play template lets you extract structured data from Google Maps listings or search results:

🏠Business name to identify the company
📍Full address for locating or mapping the business
📞 Phone number to contact the business directly
🌐 Website URL for visiting the official site
🏷️ Category to understand the business type or industry
🕒 Timezone to adjust data by local time
🔗 Google Maps URL to access the business fiche in one click
🗺️ Location for filtering by region
📌 GPS coordinates to use in mapping or routing tools

…or design your own Google Maps Scraper

Need something more specific? Our Google Maps Scraper can be fully customized to match your exact data extraction needs.

Step by step

First of all, make sure you have installed the ImportFromWeb add-on from the Google Workspace Marketplace.

Then, just follow these easy steps:

Open a new Google Sheets and activate ImportFromWeb

To activate the add-on, go to Extensions > ImportFromWeb > Activate add-on.

Activate ImportFromWeb add-on

Input the Maps Search URL

ImportFromWeb requires 2 parameters: a URL and one or more data selectors*.

Copy the URL from your Google Maps Search to your spreadsheet (please note that URL must me formatted that way: https://www.google.com/maps/place/xxxx or https://www.google.com/maps/search/xxxx)

Input Google Maps search URL

Input the data selectors

Data selectors describe the specific content you want to import from your search.

Pick the selectors you are interested in from our Google Maps selectors glossary and add them to your spreadsheet. For example, you may be interested in the name, address_1, address_2, and phone_number.

This is what your spreadsheet should look like:

Input Google Maps selectors

Write the =IMPORTFROMWEB() function and extract Google Maps data

Just add this formula: =IMPORTFROMWEB(A1,A3:D3)

Within seconds, you’ll get the data for all the businesses from your Maps search.

Write IMPORTFROMWEB() function

*Emails are not directly available via Google Maps.

However, we’ve made a ready-to-use template to collect emails from the website associated to the Google My Business account.

Extract local business data at scale with Google Maps Scraper

Google Maps is one of the most powerful sources of local business data available online. Whether you’re building a prospecting list, conducting competitive research, or creating your own local business database, our Google Maps Scraper makes the process effortless.

Instead of copying and pasting data manually or using unreliable scraping tools, our solution lets you extract business information from Google Maps using a simple formula in Google Sheets. Just enter your target query or location, and the data flows straight into your spreadsheet – clean, structured, and ready to use.

With this tool, you can:

  • Build highly targeted B2B lead lists
  • Analyze the local competition for any business or chain
  • Create directories of businesses by location and category
  • Explore commercial activity in a specific geographic area
  • Map out competitors, suppliers, or partners across cities or countries
  • Collect up-to-date business data for research, reporting, or outreach

We’ve designed an easy-to-use template to extract Google Maps data.
Make sure you have installed and activated ImportFromWeb in your Google Sheets.

Who is it for?

  • B2B companies looking to generate location-based leads
    To build targeted prospect lists from Google Maps without manual work
  • Marketing teams and agencies automating local prospecting
    To collect business data at scale and feed outreach or CRM tools
  • Freelancers and consultants conducting local market research
    To analyze competitors, map business density, or segment regions
  • Retail brands and store chains tracking their network or competition
    To monitor store presence, evaluate expansion opportunities, or benchmark nearby players
  • Startups building products with location-based business data
    To integrate fresh Google Maps data into apps, platforms, or analytics pipelines
  • Researchers, journalists, or students gathering open business data
    To extract structured information for academic, editorial, or investigative projects

Frequently Asked Questions

Can I extract emails from Google Maps using IMPORTFROMWEB?

No, Google My Business pages or profiles on Google Maps do not typically contain email addresses. Consequently, IMPORTFROMWEB does not directly facilitate email extraction from Google Maps.

However, there are two alternative methods available:

  1. Using IMPORTFROMWEB: once you have extracted the domain name from Google Maps (with the “website” selctor), you can build another ImportFromWeb formula with the “emails” generic selector: =IMPORTFROMWEB("https://www.example.com", "emails")
  2. Using IMPORTFROMGOOGLE with a Boolean Search: input a boolean search to potentially find email addresses. For example: =IMPORTFROMGOOGLE("your query @gmail.com", "emails")

We’ve also made a ready-to-use template to collect emails from the website associated to the Google My Business account.

How many results can I scrape from Google Maps using IMPORTFROMWEB?

The maximum number of results that IMPORTFROMWEB can retrieve from Google Maps is determined by Google, typically around ±200 results. Unfortunately, this limit is set by Google and cannot be altered.

However, there are some best practices that can be employed to retrieve more data for a particular area: by zooming in on the map and generating a new URL for a smaller region, you can potentially retrieve more data for that specific area.