Want to extract Amazon ratings and reviews straight into your spreadsheet?
Below are the selectors to use within your =IMPORTFROMWEB( ) function; just pick them up directly in our Amazon Reviews scraper template or use them by yourself in your own spreadsheet.
=IMPORTFROMWEB("Amazon review page url", "review_rating, review_title, review_body")
=IMPORTFROMWEB(A2,B1:C1)
ImportFromWeb works with most of Amazon markets, including 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)
Recently, Amazon has imposed a restriction that prevents users from accessing more than the first 10 pages of product reviews. It means that the default sorting allows you to access only 100 reviews.
Although direct access is limited, there’s a clever workaround. Amazon lets users filter reviews by criteria like star ratings, helpfulness, or recency. Each filtered view can show up to 100 reviews, offering a way to gather a more extensive dataset.
Reviews selectors
| Selector | Description |
|---|---|
| review_rating | Collects the rating |
| review_title | Collects the review title |
| review_body | Collects the review itself as written by the customer |
| review_link | Collects the customer’s review dedicated page |
| review_profile_name | Collects the customer profile’s name |
| review_context | Collects the review date |
Q&A selectors
| Selector | Description |
|---|---|
| questions | Extracts the questions |
| selected_answers | Extracts the default answer to each question |
| profile_name | Collects the name of the profiles who asked the question |
| votes_count | Extracts the number of votes |
| answers_count | Scrapes the number of answers |
| selected_answers_date | Collects the date of the default answer |