The Scenario
You run product sourcing for a private-label brand. Your sourcing team flagged forty ASIN candidates last week — products you could potentially white-label — and they're sitting in column A of your Product Candidates sheet. Before you spend money getting samples, you need monthly sales estimates for each one so you can rank them by revenue potential and cut the list to the top ten.
The data is available through Jungle Scout's sales estimator. Getting it into the sheet for all forty is the problem.
The bad version:
- Open the Jungle Scout sales estimator, paste in the first ASIN, note the estimated monthly units, switch to the sheet, type it into column B.
- Do that forty times.
- Realize at ASIN thirty-one that the estimator returned units for the whole subcategory on two of them because you accidentally searched by keyword instead of ASIN, and those numbers are dramatically overstated.
- Go back and correct those rows.
There's a sourcing decision worth real money sitting behind this data. The forty manual lookups are what's standing between you and making it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your ASIN list, connects to Jungle Scout, and writes sales estimates for every row.
For each ASIN in column A of my Product Candidates sheet, fetch the Jungle Scout sales estimate and write the estimated monthly units sold into column B.
SheetXAI reads each ASIN, calls Jungle Scout's sales estimator, and fills column B with monthly unit estimates across all forty rows in one operation.
What You Get
- Column B populated with Jungle Scout monthly unit sales estimates for each ASIN in column A.
- ASINs that return no estimate (delisted products, restricted categories) flagged in column C so nothing goes undetected.
- Consistent numeric formatting across all forty rows so you can sort immediately by estimated volume.
- The operation covers the full list — not a row-by-row process you have to supervise.
What If the Data Is Not Quite Ready
I want estimated revenue, not just units, and I have prices in column D
For each ASIN in column A of my Product Candidates sheet, fetch the Jungle Scout monthly sales estimate and write it into column B. Then calculate estimated monthly revenue in column C as the value in column B multiplied by the price in column D.
Some ASINs in my list are parent ASINs with multiple variants
For each ASIN in column A of my Product Candidates sheet, fetch the Jungle Scout sales estimate. If an ASIN is a parent with multiple variants, use the combined estimate across all variants and note "parent ASIN" in column C.
I want to rank the candidates and cut to the top 10 after enriching
Fetch Jungle Scout monthly sales estimates for each ASIN in column A of my Product Candidates sheet and write into column B. Then sort the sheet by column B descending and highlight the top 10 rows in green.
Kill-chain: enrich, calculate, rank, and flag below-threshold candidates
For each ASIN in column A of my Product Candidates sheet, fetch the Jungle Scout monthly sales estimate into column B. Multiply by the price in column D to get estimated monthly revenue in column E. Then add a column F labeled "Viable" — mark "YES" if estimated revenue exceeds $5000 per month and "NO" if not. Sort by column E descending.
One prompt returns a ranked, scored, filtered sheet ready for the sourcing decision.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your ASIN candidates in column A, then ask it to pull Jungle Scout sales estimates for the full list and add a revenue calculation. See also the spoke on querying the product database for filtered listings, or return to the Jungle Scout overview.