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 worksheet. 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 workbook 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 workbook, 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 Excel workbook. It reads your ASIN list, connects to Jungle Scout, and writes sales estimates for every row.
I have 40 ASINs in column A of my Excel sheet. Pull the monthly sales estimate from Jungle Scout for each and write it into column B, then add a calculated monthly revenue column in C using price from column D times sales estimate.
SheetXAI reads each ASIN, calls Jungle Scout's sales estimator, fills column B with monthly unit estimates, and calculates estimated monthly revenue in column C 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.
- Column C with calculated monthly revenue (column B multiplied by column D price).
- ASINs that return no estimate flagged in column E so nothing goes undetected.
- Consistent numeric formatting across all forty rows so you can sort immediately by estimated volume or revenue.
What If the Data Is Not Quite Ready
I want to see the revenue calculation but some price cells are empty
For each ASIN in column A of my Product Candidates worksheet, fetch the Jungle Scout monthly sales estimate and write into column B. Calculate revenue in column C as column B times column D only where column D is not empty — leave column C blank for any row with no price.
Some ASINs in my list are parent ASINs with multiple variants
For each ASIN in column A of my Product Candidates worksheet, 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 worksheet and write into column B. Then sort the worksheet 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 worksheet, 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. 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 workbook ready for the sourcing decision.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook 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.