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 and write your function as follows:
=IMPORTFROMWEB("Amazon search url", "title, price")
=IMPORTFROMWEB(A2,B1:C1)
Selector | Description |
asin | Collects each product ASIN |
title | Collects each product title |
price | Collects each product price |
rating | Collects average rating for each product listed |
reviews | Collects number of reviews collected for each product listed |
featured_image_source | Collects the main image source for each product listed |