How to extract Amazon product data with Spidra

When I looked up a Lenovo Idea Tab on Amazon, the product title listed an 11-inch display, 4 GB of memory, 128 GB of storage, a pen, and a folio case. Those details mattered. If I wanted to compare its price with another tablet, I needed to know exactly what the $205.99 included.

I used Spidra’s Amazon product details template to turn the listing into a row I could save to a spreadsheet. The same run also gave me the stock message, customer rating, and number of ratings in JSON. Here’s how to get both formats from a single Amazon product link.

Start with the Amazon listing you want to track

You can use either a product link or an ASIN, the ten-character identifier Amazon assigns to a product. For the Lenovo tablet, the ASIN was B0FGYCJ7NJ. You can spot it in the product link immediately after /dp/:

https://www.amazon.com/dp/B0FGYCJ7NJ

The link I copied from Amazon was longer because it included search parameters. I pasted that full link into Spidra. If you’re collecting several products, copying just the ASIN can make your list easier to read and help you spot duplicates.

Open the Amazon product details template

From the Spidra dashboard, open Templates, select E-commerce, and find Amazon product details under the Amazon section.

There are two similarly named templates here. Amazon search results takes a keyword such as “college tablet” and helps you find listings. Amazon product details takes the listings you’ve already chosen and extracts their details. I already had the Lenovo link, so I used the second one. Open the Amazon product details template.

Figure 1. The Amazon product details template in Spidra’s E-commerce directory.

Add the product link and choose the marketplace

Paste your link into ASINs or product links. For several products, enter one link or ASIN per line. The form accepts up to 50 entries.

Under Marketplace, choose the Amazon site the listing came from. I selected United States (amazon.com) because that was where I found the tablet. On the right, the Output panel previews columns such as title, ASIN, price, currency, list price, and rating. Select Run to populate them.

Figure 2. The Lenovo Idea Tab product link with United States (amazon.com) selected as the marketplace.

Read the result and export it to a spreadsheet

When the run finished, the Table view showed one product. The listing title was too long to fit in the visible cell, but the ASIN, price, and currency were immediately readable.

Figure 3. The completed run showing the Lenovo Idea Tab, ASIN B0FGYCJ7NJ, priced at $205.99 USD

Select CSV to download the result for Excel or Google Sheets. If you plan to check prices again, keep the ASIN and currency beside the price, and add the date you collected it. That way, you can match a later price to the same listing even if the wording of the product title changes.

Switch to JSON to see what the table leaves out of view

The table gave me the price. I switched to JSON to answer two other questions: Was the tablet available when I checked, and how many people had rated it?

The result showed a 4.3 rating from 789 ratings. It also preserved Amazon’s stock message: “Only 16 left in stock - order soon.” Those values describe the listing when the run took place.

Here are the relevant fields from the returned product record:

{
  "asin": "B0FGYCJ7NJ",
  "brand": "Lenovo",
  "price": 205.99,
  "currency": "USD",
  "priceText": "$205.99",
  "listPrice": null,
  "savings": null,
  "coupon": null,
  "availability": "Only 16 left in stock - order soon.",
  "rating": 4.3,
  "ratingsCount": 789
}

Figure 4. The JSON result showing a 4.3 rating from 789 ratings and Amazon’s stock message at the time of the run.

Two details are worth keeping when you reuse this data. First, price is a number you can sort or use in a calculation, while priceText gives you the formatted $205.99 for display. Second, listPrice came back as null. If you’re building a price comparison sheet, leave that cell blank. A zero would imply a price the listing never supplied.

Check the same products again

For a one-time comparison, download the CSV and you’re done. If you want to revisit the same products next week, Save as preset keeps the inputs and marketplace together so you can run the comparison again. If you want scheduled checks, choose Watch for changes. The first check establishes the baseline for later comparisons. Read how Spidra monitors work.

A good first run is two products you’re genuinely choosing between. Paste both ASINs, select the same marketplace, and compare what each price includes. With the Lenovo tablet, the pen and folio case were part of the listing. A cheaper tablet sold without either accessory would be a different comparison. Try the Amazon product details template.