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 |