The Scenario
You do product research for an e-commerce brand. Column A of your Excel sheet has 30 category search terms — things like "ceramic cookware set" and "stainless steel water bottle." The product team asked you to pull the top 10 Amazon results per term — ASIN, product title, price, and star rating — to build a competitive pricing benchmark before the next quarterly assortment review.
You've been doing this by pasting search terms into Amazon's search bar one at a time, scrolling through results, and copying fields into the sheet manually. You're on term six. You have 24 left and a meeting tomorrow.
The bad version:
- Search Amazon for term one, record the top 10 ASINs, titles, prices, and ratings row by row into the sheet
- Repeat 29 times while keeping track of which rows belong to which search term
- Go back to fix three rows where the price came back as a range and you only captured one end
Your assortment review isn't just internal — it's going to the buying team who will use it to make actual purchasing decisions. Incomplete data doesn't help them decide anything.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your list of search terms, understands what you're building, and through its built-in Search API integration it queries Amazon for each term and writes the structured product listing data back in a consistent format.
For each search term in column A, search Amazon using Search API and write the top 10 results — ASIN, product title, price, and star rating — into rows below each term header in columns B, C, D, and E.
What You Get
- 10 Amazon product listings per search term organized below each term's header row, with ASIN, title, price, and rating in columns B through E
- Price values written as returned by the API, either as a fixed price or a range
- Star ratings written as numeric values so you can sort or filter the competitive set immediately
What If the Data Is Not Quite Ready
Some terms in column A are duplicates or near-duplicates that would return redundant results
Deduplicate the search terms in column A, treating any two terms that differ only by spacing or capitalization as the same — then for each unique term, search Amazon using Search API and write the top 10 results with ASIN, title, price, and rating into rows below each term header in columns B through E.
You want to pull only results below a certain price point
For each search term in column A, search Amazon using Search API, retrieve the top 20 results with ASIN, title, price, and rating, filter to only those where the price is below $50, and write the remaining results into rows below each term header in columns B through E — up to 10 per term.
Your sheet has a "Brand Exclusions" tab and you want to strip competitor brand names from the results before writing them
For each search term in column A, search Amazon using Search API and retrieve the top 15 results — ASIN, title, price, and rating — remove any result whose title contains a brand name from the "Brand Exclusions" tab, then write the remaining top 10 into rows below each term header in columns B through E.
You want to pull the full Amazon result set, calculate the median price per term, and flag your own ASINs if they appear — all in one shot
For each search term in column A, search Amazon using Search API and retrieve the top 20 results with ASIN, title, price, and rating, write them into rows below the term header in columns B through E, then add a "Median Price" cell in column F next to the term header, and mark column G on any row where the ASIN matches a value in the "Our ASINs" tab.
That kind of compound prompt turns what used to be three separate analysis steps into a single operation.
Try It
Get the 7-day free trial of SheetXAI and open your product research sheet with search terms in column A, then ask it to pull top Amazon listings for each term using Search API. If you're also tracking Google Shopping prices for the same products, the Google Shopping price intelligence spoke is the companion workflow.