Google My Business Star Rating Scraper

Collect and monitor Google My Business ratings from Google Maps, in bulk.

In today’s digital age, online reviews and ratings play a crucial role in shaping a company’s reputation and influencing consumer decisions. Ratings on Google Maps places are crucial for businesses as they provide valuable insights into customer satisfaction and reputation.

With our ready-to-use solution, you can extract and monitor this valuable data, gaining insights into customer satisfaction and feedback.

Identify top-performing businesses, track competitors, and benchmark your own ratings against industry standards. Understand customer sentiments, pinpoint areas of improvement, and make data-driven decisions to enhance your brand’s reputation.

Using the ImportFromWeb add-on and the function it adds to Google Sheets, you can extract Google Maps Places ratings in bulk without technical knowledge!

What you get?

With =IMPORTFROMWEB(), you extract business ratings from Google Maps with the following data points:

ratings
number of reviews

See all available Google Maps data selectors

Step by step

Start with a template

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.

Input the Google Maps places URLs

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

Copy the Google Maps Places URLs to your spreadsheet (make sure it respects the following format: https://www.google.com/maps/place/xxxxxxxx)

Input the Google Maps selectors

Data selectors describe the specific content you want to import from Google Maps Places.

In this case, you’ll need the name, ratings, and reviews_count. You can find the full list in our Google Maps selectors glossary.

This is what your spreadsheet should look like: