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)
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), 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.
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 |
| bought_in_past_month | Number of units sold in past month |
| badge | Indicates “Best sellers”, “Amazon’s choice” and “Amazon exclusive” ASINs |
| has_deal | Indicates whether the product has a Limited time deal badge (Lightning Deal) |
| coupon | Indicates whether the product has a coupon and the value of this coupon |
| normal_delivery | Indicates the standard delivery date (non-prime delivery date) |
| fastest_delivery | Indicates the fastest delivery date (prime delivery date) |
| 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 |