The Scenario
You are a procurement manager. The sourcing spreadsheet has 25 ASINs in column A — products your team buys regularly. You need to know every third-party seller currently offering each product on Amazon: their price, shipping cost, condition, and whether they hold the Buy Box. This data will determine which suppliers make the approved vendor list this quarter.
Your category manager needs the table by end of week. The review meeting is Friday morning.
The bad version:
- Open Amazon, navigate to ASIN 1's offers page, manually read off each seller row, enter price and shipping and condition and Buy Box status into the sheet
- Navigate to ASIN 2, repeat — but Amazon's offers page has infinite scroll so you're not sure if you got every seller or just the first visible set
- Hit ASIN 11 on Thursday afternoon and realize you still have 14 left and the data from ASIN 1 may already be stale
The issue is not that the task is hard. It is that 25 ASINs times however many sellers per ASIN is a volume problem that manual entry cannot solve at a pace that makes the data useful.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your ASIN column, hits each Amazon offers page through Scrape.do's residential proxy — bypassing the bot detection that blocks direct requests — and writes every seller row into the sheet beneath the matching ASIN.
For each ASIN in column A, fetch all Amazon seller offers using Scrape.do and write seller name, price, shipping cost, condition, and Buy Box status into rows beneath each ASIN.
What You Get
- A seller block appears beneath each ASIN, with one row per seller offer
- Columns include: seller name, offer price (numeric), shipping cost, condition, and Buy Box status (yes/no)
- ASINs with no third-party offers get a single row noting "No third-party sellers"
- ASINs where the scrape returns an error get an error label so you know which ones to retry
What If the Data Is Not Quite Ready
You only want offers in "New" condition
For each ASIN in column A, fetch all Amazon seller offers using Scrape.do. Write only the offers where condition is "New" into a block of rows beneath each ASIN, including seller name, price, shipping, and Buy Box status.
You want a flat table instead of ASIN blocks
For each ASIN in column A, fetch all Amazon seller offers using Scrape.do and write the results into the Offers sheet as flat rows. Each row should include: ASIN, seller name, offer price, shipping cost, condition, and Buy Box status. Use row 1 as the header.
You want to flag the cheapest total price per ASIN
For each ASIN in column A, fetch all Amazon seller offers using Scrape.do. Write seller name, price, and shipping into rows beneath each ASIN. Add a column that calculates total cost (price plus shipping) and mark the row with the lowest total cost as "Best offer".
Full pipeline in one pass
Clean column A: trim whitespace and uppercase each ASIN. For each ASIN, fetch all Amazon seller offers using Scrape.do — new condition only. Write the results into the Offers sheet as flat rows: ASIN, seller name, price, shipping, total cost, Buy Box status. Highlight the row with the lowest total cost per ASIN in column G.
Cleanup, scraping, filtering, and the lowest-cost flag all in one ask.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your ASIN list, then ask it to pull all seller offers and populate your sourcing table. See also the spoke on enriching ASINs with product detail data, or the hub overview for all Scrape.do workflows.