Amazon Reviews Scraper

Extract and analyze Amazon product reviews directly with Google Sheets.

Amazon reviews are a treasure trove of information, offering crucial feedback on product quality, performance, and user experiences. 

Whether you’re a seller looking to monitor product feedback and respond to customer reviews or a researcher seeking valuable consumer insights, our Amazon Reviews Scraper empowers you with the tools to leverage this wealth of information.

With our no-code scraping solution, you can effortlessly gather and analyze this data, gaining valuable market intelligence and a deep understanding of customer sentiment. Identify trends, patterns, and common pain points to make data-driven decisions, optimize your product offerings, and enhance your brand reputation.

Discover strengths and weaknesses, identify opportunities for improvement, and refine your marketing strategies.

Using the ImportFromWeb add-on and the function it adds to Google Sheets, you can extract Amazon Reviews data in bulk without technical knowledge!

What you get?

With =IMPORTFROMWEB(), you extract the following data points from Amazon reviews pages: 

  • profile name
  • rating
  • review title
  • review body
  • date of the review

See all available Amazon reviews data points

Step by step
or

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 ASIN reviews page URL

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

Copy the URL from the Amazon reviews page to your spreadsheet:

Input ASIN reviews page URL

Input the reviews page selectors

Data selectors describe the specific content you want to import from the Amazon reviews page . 

Pick the selectors you are interested in from our Amazon reviews selectors glossary and add them to your spreadsheet. For example, you may be interested in the review_rating, review_title, and review_body.

This is what your spreadsheet should look like:

Input data selectors

Write the =IMPORTFROMWEB() function and extract reviews

Just add this formula: =IMPORTFROMWEB(A1,B1:D1)
Within seconds, you’ll get the first page of reviews.

Write IMPORTFROMWEB() function

Add the URLs for additional pages

If the product has multiple reviews pages, copy the links to subsequent pages to your spreadsheet. 

In the formula’s first parameter, select all the cells containing the URLs: 
=IMPORTFROMWEB(A1:A3,B1:D1)

Add URLs for additional reviews pages

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

Frequently Asked Questions

How to scrape in a specific language on Amazon?

Most of the time, the =IMPORTFROMWEB() function extracts the content of the ASINs in the default language of the Amazon store.

But sometimes, the language of the page loaded by ImportFromWeb isn’t right. For example, you’ll get the content in English for an amazon.de product, instead of being in German.

Luckily, you can force the language using the “language” parameter, as follow:

The new generated URL will look like: https://www.amazon.de/dp/B07NQ6R7R1?language=de_DE

And this is the URL you have to input into your =IMPORTFROMWEB() function!