The Scenario
You work in e-commerce strategy and you've been asked to evaluate the kitchen gadgets category for a potential product launch. Your director wants a ranked list of the top products in that space — filtered to monthly revenue above $5,000 and fewer than 200 reviews — so the team can spot where demand exists but the competitive bar is still low.
Jungle Scout's product database has exactly this. The problem is getting it into the sheet where the rest of your analysis lives.
The bad version:
- Open Jungle Scout's product database, set the category filter, set the revenue floor, set the review ceiling, run the query.
- Export the results as a CSV — if your plan allows it.
- Open the CSV in a separate Excel window, copy the columns you need, paste them into the right sheet, fix the header mismatch, reformat the revenue column because it exported as text.
- Repeat when your director asks you to change the revenue floor from $5,000 to $3,000 and rerun.
The CSV-to-sheet loop is what kills this kind of analysis. You spend more time moving data than thinking about what it means.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet, connects to Jungle Scout's product database, and writes query results directly into the tab you specify.
Query the Jungle Scout product database for the Kitchen category with minimum monthly revenue of $5000 and maximum review count of 200, and write ASIN, title, price, monthly revenue, and review count into my Product Research sheet.
SheetXAI runs the Jungle Scout product database query with your filters, pulls the matching listings, and writes ASIN, title, price, monthly revenue, and review count into the Product Research sheet — column by column, no reformatting needed.
What You Get
- The Product Research sheet populated with filtered listings matching the revenue and review criteria.
- Fields written in separate columns: ASIN in A, title in B, price in C, monthly revenue in D, review count in E.
- Results sorted by monthly revenue descending by default so the highest-opportunity products surface first.
- If the query returns fewer results than expected, a note in the sheet indicating the filter combination returned a limited set.
What If the Data Is Not Quite Ready
I want to filter by subcategory rather than the top-level category
Query the Jungle Scout product database for the Kitchen Gadgets subcategory with monthly revenue above $3000 and fewer than 150 reviews, and write the top 50 results into my Product Research sheet with ASIN, title, price, revenue, and review count.
The price column is coming back unformatted
Query the Jungle Scout product database for the Kitchen category, revenue above $5000, review count below 200, and write results into Product Research. Format the price column as USD currency and the revenue column as whole-dollar amounts with no decimal places.
I want results from two different categories side by side
Query the Jungle Scout product database twice — once for Kitchen with revenue above $5000 and reviews below 200, once for Bakeware with the same filters — and write each result set into a separate tab named Kitchen Opps and Bakeware Opps.
Kill-chain: query, score, and rank in one prompt
Query the Jungle Scout product database for Kitchen with monthly revenue above $5000 and review count below 200. Write ASIN, title, price, monthly revenue, and review count into my Product Research sheet. Then add an Opportunity Score column calculated as monthly revenue divided by review count, formatted to two decimal places, and sort the sheet by Opportunity Score descending.
Ask for the query and the scoring in one instruction, and the output arrives ranked and ready for a decision.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, then ask it to query the Jungle Scout product database with your category and filter criteria written directly in the prompt. See the related spoke on enriching an ASIN list with sales estimates, or return to the Jungle Scout integration overview.