Amazon
WebToSheets makes it simple to pull specific data from any Amazon product page, including the name, price, rating, images and more.
lightbulb
There's no need to write this by hand. For convenience, you may open the sidebar's Formula
Builder, pick Amazon, and paste the product's ASIN.
Supported URLs
- Page type: product detail pages, such as
/dp/<ASIN>(or/gp/product/<ASIN>). - Domains: all Amazon marketplaces, including
amazon.com,amazon.co.uk,amazon.de,amazon.fr,amazon.co.jp, and so on.
Here is a valid Amazon product URL for the AirPods Pro (ASIN B0D1XD1ZV3):
https://www.amazon.com/dp/B0D1XD1ZV3
info
Note that the Amazon extractor only targets product pages. For search or category pages, you may fall back to
generic selectors or XPath instead.
Selectors
WebToSheets provides the following selectors for any Amazon product page:
| Field | Selector | Example value |
|---|---|---|
| Product name Product name/title |
name
|
Apple AirPods Pro (2nd gen) |
| Price Product price (numeric value only) |
pricing
|
249.00 |
| Currency Currency symbol from pricing |
currency
|
USD |
| Brand Brand name (cleaned from "Visit the X Store" format) |
brand
|
Apple |
| Rating Customer reviews rating |
reviews_rating
|
4.6 |
| Number of reviews Total number of reviews |
reviews_count
|
8432 |
| Image URL Product image URL. Use image/2 for the second image, etc. |
image
+ /N
|
https://m.media-amazon.com/images/… |
| ASIN Amazon Standard Identification Number |
asin
|
B0D1XD1ZV3 |
| Model number Item model number |
model
|
MTJV3AM/A |
| Release date Product release date (formatted as Y-m-d) |
release_date
|
2022-09-07 |
| Description Full product description |
description
|
Active Noise Cancellation… |
| Brand store link Link to the brand store |
brand_store_link
|
https://www.amazon.com/stores/Apple |
Example
To track a product's name, price and rating, you may pass each selector to the =SCRAPE() formula:
=SCRAPE("https://www.amazon.com/dp/B0D1XD1ZV3", "name,pricing,reviews_rating")As you can see, WebToSheets returns the AirPods Pro name, price and rating across three cells:
A
B
C
1
|
Apple AirPods Pro (2nd gen)
249.00
4.6
fx
Still stuck?
We usually reply within 24 hours on business days.