Amazon data selectors (search page)

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
asinCollects each product ASIN
titleCollects each product title
priceCollects each product price
ratingCollects average rating for each product listed
times_evaluatedCollects number of reviews collected for each product listed
link*Collects the URL of each product listed
featured_image_sourceCollects the main image source for each product listed

*link: please note that it pulls out the path only, meaning that to get the product URL, you have to add the domain (e.g. amazon.com)