Want to extract Amazon products lists straight into your spreadsheet?
You can see below the selectors to use within your =IMPORTFROMWEB( ) function; just pick them up directly in our Amazon Search scraper template or use them by yourself in your own spreadsheet.
=IMPORTFROMWEB("Amazon search url", "title, price")
=IMPORTFROMWEB(A2,B1:C1)
Please note that 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)
Those are the selectors to use to extract the “organic” results
| Selector | Description |
|---|---|
| asin | Collects each product ASIN |
| title | Collects each product title |
| price | Collects each product price (price_currency to get the currency only / price_text to get the value together with the currency) |
| rating | Collects average rating for each product listed |
| reviews_count | Collects number of reviews collected for each product listed |
| has_deal | Indicates whether the product has a current deal |
| coupon | Indicates whether the product has a coupon and the value of this coupon |
| badge | Indicates “best sellers”, “Amazon’s choice” and “Amazon exclusive” ASINs |
| link | Collects the URL of each product listed |
| featured_image_source | Collects the main image source for each product listed |
| number_of_results* | Returns the number of results from your search |
*number_of_results: The following selector shouldn’t be mixed with the previous selectors and must be used individually.
Additional selectors for sponsored products
Please note that “sponsored” selectors can not be combined with the “organic” selectors
| Selector | Description |
|---|---|
| sponsored_asin | Extracts the ASINs of the sponsored products |
| sponsored_title | Collects sponsored product titles |
| sponsored_price | Collects prices of the sponsored products |
| sponsored_rating | Collects ratings of the sponsored products |
| sponsored_times_evaluated | Extracts the number of reviews for each sponsored product |
| sponsored_link | Collects links of the sponsored products |
| sponsored_featured_image_source | Extracts the featured Image’s link of the sponsored products |