Amazon data selectors (reviews / Q&A)
Want to extract Amazon ratings and reviews straight into your spreadsheet?
Below are the selectors to use within your =AMAPULSE( ) function; just pick them up directly in our Amazon Reviews scraper template or use them by yourself in your own spreadsheet.
=AMAPULSE("Amazon review page url", "review_rating, review_title, review_body")
=AMAPULSE(A2,B1:C1)
Amapulse 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), Belgium (.com.be), Poland (.pl), Sweden (.se), Turkey (.com.tr), India (.in), Saudi Arabia (.sa), UAE (.ae), Japan (.jp), Australia (com.au), Singapore (.sg)
You want to scrape in another language than English ? We made a special FAQ there.
Amazon has recently implemented new barriers to prevent bots from accessing product reviews. It is now required to be logged in to access reviews. Since Amapulse is fetching pages as an incognito user, it is not possible at the moment to extract reviews.
Our team keeps exploring new methods and alternatives.
Reviews selectors
| Data selector | Description |
|---|---|
| review_rating | Outputs the rating |
| review_title | Outputs the review title |
| review_body | Outputs the review itself as written by the customer |
| review_link | Outputs the customer’s review dedicated page |
| review_profile_name | Outputs the customer profile’s name |
| review_context | Outputs the review date |
Q&A selectors
| Data 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 |