To help you get started right away, you can use this free template on Google Sheets.
Get Ratings Breakdown for Each Amazon Variant Instantly
On Amazon, product reviews and ratings are shared across different variants (e.g., colors, sizes, styles). But what if you need to know how each variant actually performs?
Our Amazon Variant Ratings & Reviews Analyzer helps you extract individual rating counts for every variant of a product, giving you a clearer picture of customer sentiment for each option.
Why is this important?
✅ Identify the best and worst-performing variants (e.g., does the blue T-shirt have more 1-star reviews than the black one?)
✅ Understand true demand—which color, size, or style has the most ratings?
✅ Optimize inventory & marketing by focusing on the most popular (or problematic) variants
✅ Monitor customer sentiment per variant to improve product quality and conversions
No coding needed—just copy the template and start analyzing Amazon variants today!
What you get with this Amazon Reviews template?
Just enter the parent ASIN, and our Google Sheets template will:
- Extract all variants linked to the parent product
- Retrieve the exact number of ratings and reviews per variant
- Break down ratings by stars (1⭐, 2⭐, 3⭐, etc.)
- Display total reviews for each variant
See all available Amazon reviews data points
We’ve designed an easy-to-use template so you can try our Amazon Variant Ratings & Reviews Analyzer.
Make sure you have installed and activated ImportFromWeb in your Google Sheets.
More Information
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=en_GB
And this is the URL you have to input into your =IMPORTFROMWEB() function!