The Scenario
Your e-commerce team runs a weekly pricing report. The input is an Excel workbook with 80 ASINs in column A. The output is supposed to be a table with current title, price, rating, review count, and best-seller rank for each product. For the past three weeks, a contractor has been pulling this manually from Amazon, and the invoice for that work just landed in your inbox.
The bad version:
- Open Amazon in a browser, search each ASIN, find the product page, read off the fields
- Enter each value by hand into columns B through F for that row
- Repeat 79 more times, then spend an extra 30 minutes fixing prices that pasted with currency symbols and BSR values that carried HTML entities
It is not complicated work. That is exactly what makes it so difficult to keep assigning it to a human.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your ASIN list, talks to Scrape.do's Amazon scraping endpoint — which handles the anti-bot fingerprinting and residential proxy rotation that bare requests cannot — and writes the structured product fields back into your columns.
For each ASIN in column A, fetch the structured Amazon product data using Scrape.do and write the product title, current price, rating, review count, and best-seller rank into columns B through F.
What You Get
- Column B: product title as it appears on the Amazon listing
- Column C: current price (numeric, no currency symbol)
- Column D: average rating (e.g. 4.3)
- Column E: total review count
- Column F: best-seller rank in primary category
- Rows where the ASIN returns no result or a scraping error show an error label in column B
What If the Data Is Not Quite Ready
ASINs have inconsistent formatting — some start with "B0", some have leading spaces
Clean column A first: trim whitespace and uppercase all ASIN values. Then for each ASIN, fetch the Amazon product data via Scrape.do and write title, price, rating, review count, and BSR into columns B through F.
You only want ASINs that are currently marked as in stock
For each ASIN in column A, fetch the Amazon product page using Scrape.do. Write the title, price, rating, review count, and BSR into columns B through F only for products currently shown as in stock. Write "Out of stock" into column B for products that are not available.
You want to compare prices against a target threshold in column G
For each ASIN in column A, fetch the current Amazon price via Scrape.do and write it into column C. Then compare the value in column C against the target price in column G and write "Below target", "At target", or "Above target" into column H.
Full enrichment plus flag in one pass
Clean the ASINs in column A: trim whitespace and uppercase. Then for each ASIN, fetch title, current price, rating, review count, and BSR from Amazon using Scrape.do and write them into columns B through F. If the price in column C is lower than the value in column G, write "Price drop" in column H. Flag any rows where Scrape.do returned an error by writing the error code in column I.
One prompt handles the clean, the enrichment, and the comparison logic — no intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your ASIN list, then ask it to fetch Amazon product data and populate your pricing table. You might also find the spoke on pulling all seller offers useful for sourcing decisions, or the hub overview for all Scrape.do workflows.