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)
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 |