Extract Amazon reviews into Google Sheets

We have built an Amazon Reviews scraper in Google Sheets that enables you to collect both ratings and reviews from customers without any coding knowledge or complex software to download.

You can extract for every single review of a given product the customer profile, the rating, the review title, the review itself and the date of evaluation ! All you need is the ImportFromWeb add-on in Google Sheets and you’re ready to start importing these powerful Amazon data into our approachable template.

With this kind of product research at your constant disposal, you can easily monitor customers opinions on your products’ range or perform sentiment analysis.

And all with just a basic knowledge of Google Sheets.

Let’s dive into our solution to scrape Amazon reviews!

How does it work?

It uses the ImportFromWeb add-on that we built.

ImportFromWeb provides a simple function to extract data from any websites. You just need to specify the urls of the pages you want to load and tell ImportFromWeb about the location of the elements you want to extract from those pages.

1. Install the ImportFromWeb add-on

ImportFromWeb is the add-on that collects the data. Simply install it from the Google Workspace Marketplace. You can try it for free, we offer you 1,000 requests (no credit card required!)

2. Make a copy of the Amazon Reviews Scraper template

Make a simple copy of the template to manipulate it with the products that you wish to scrape from Amazon

3. Activate the ImportFromWeb add-on

Easy step too! In your template copy, activate the add-on through your Google sheets menu: Extensions >> ImportFromWeb >> Activate add-on

From there, open the second tab of the template (“⭐️AMAZON REVIEWS EXTRACTOR”) and start scraping! All you need to do is look for the reviews detailed page of the Amazon products and paste them into the template.

4. Input the Reviews page URL

First, click on the “ratings” at the top of the page:

It will drive you to the Reviews section of the page:

Go at the end of the list and click on the “See all reviews” link

You land on the Reviews detailed page where you access all customers reviews. The URL of that page looks like this: https://www.amazon.com/Philips-Automatic-Espresso-Machine-LatteGo/product-reviews/B07VFY4MXM

Now, just follow these 2 easy steps:

1. Take the URL of the page and paste it in the template

2. Specify the number of reviews you want to extract and that’s it!

The Reviews scraper loads all the reviews with their associated content, i.e. the title, the body, the link, the customer’s profile…

To make better use of this template and our ImportFromWeb tool, here are a few other tips to ensure that your web scraping experience is giving you full access to valuable Amazon data.

Tip #1: Scrape Amazon reviews from multiple markets

Don’t let geography limit you. With ImportFromWeb, you can query Amazon reviews within its different markets. 

  • US (.com)
  • Canada (.ca)
  • Mexico (.com.mx)
  • Brazil (.com.br)
  • UK (.co.uk)
  • France (.fr)
  • Germany(.de)
  • Netherlands (.nl)
  • Spain (.es)
  • Italy (.it)
  • Turkey (.com.tr)
  • India (.in)
  • Saudi Arabia (.sa)
  • UAE (.ae)
  • Japan (.jp)
  • Australia (.com.au)
  • Singapore (.sg)

Nothing complex to achieve it. The reviews URL you get from your Amazon store makes it all.

Tip #2: Make the most of the Amazon reviews

Amazon offers you some useful filters and sorting options to visualize the reviews.

You’re only interested in 1 star reviews to detect what’s wrong with your product? You want to get the most recent reviews first?

Use the filters and sorting inside the Amazon page and then copy/paste the URL. The table you’ll get into Google Sheets will be made accordingly.

Tip #3: Use it anywhere

You don’t need to use this template to extract Amazon reviews. It’s very easy to use the IMPORTFROMWEB function wherever you like.

  • Input your Amazon reviews urls, each one in a different cell
  • Use the IMPORTFROMWEB function

Any question?

If you feel stuck on anything at all, reach out to our team. We’d love to help you better understand our tools and templates so that you can achieve your desired results.