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