The Scenario
You're an FBA consultant onboarding a new client who sells yoga mats. They want to know how competitive the space is — specifically, whether most products in that niche are fulfilled by Amazon or by the seller — because it affects how they should think about pricing, shipping speed positioning, and Buy Box dynamics.
You've done this analysis before. The data lives in Jungle Scout. The problem is you need it in a workbook your client can actually look at, and the last time you built a deliverable like this you spent ninety minutes reformatting a CSV.
The bad version:
- Open Jungle Scout product database, filter to the Sports category, filter to FBM only, export the top 100 results.
- Open the CSV in a new Excel window, copy the columns your client cares about (ASIN, price, monthly sales, reviews), paste into the client workbook.
- Reformat everything — the price column exported as text, the review count column has a comma in it at 1,234, and the ASIN column has a leading apostrophe from the CSV.
- Repeat the whole process for FBA to get the comparison set.
By the time the data is ready, you've spent more time on the file than on the actual consulting insight.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your instructions, queries Jungle Scout's product database with your filters, and writes the results into the workbook directly.
Pull the top 100 products in the yoga mat category from Jungle Scout filtered to FBM sellers and list them in my Excel sheet with ASIN, price, monthly sales, and review count so I can compare against FBA results.
SheetXAI runs the Jungle Scout product database query filtered to FBM, pulls the matching products, and writes the specified fields into the workbook — formatted and ready.
What You Get
- Target worksheet populated with ASIN, price, monthly sales, and review count for FBM products in the yoga mat category.
- Price formatted as currency, review count as a whole number — no post-import cleanup needed.
- Results sorted by monthly sales descending so the highest-volume FBM products appear first.
- Data ready to compare directly against a second query for FBA products.
What If the Data Is Not Quite Ready
I want FBA and FBM results in separate worksheets for direct comparison
Query the Jungle Scout product database for the Sports category filtered to FBA sellers, write top 100 results into a worksheet called FBA Landscape with ASIN, title, price, monthly revenue, and review count. Then run the same query filtered to FBM sellers and write top 100 results into a worksheet called FBM Landscape.
I want to filter to a subcategory rather than the whole Sports category
Query the Jungle Scout product database for yoga mats in the Sports category, filtered to FBM seller type, and write ASIN, title, price, monthly revenue, and review count into my FBM Landscape worksheet.
The client wants average price and revenue for each fulfillment method as a summary
After writing FBA results into the FBA Landscape worksheet and FBM results into the FBM Landscape worksheet, add a Summary worksheet with a table showing average price and average monthly revenue for each fulfillment method side by side.
Kill-chain: query both fulfillment types, write separate worksheets, build the summary, and flag the pricing gap
Query Jungle Scout product database for yoga mats, Sports category. Write FBA results (ASIN, title, price, revenue, reviews) into FBA Landscape worksheet and FBM results into FBM Landscape worksheet. Then create a Summary worksheet comparing average price, average revenue, and total product count by fulfillment type. Add a row highlighting which method commands a higher average price and by what percentage.
One prompt, two query runs, and a client-ready competitive summary.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, then ask it to query the Jungle Scout product database filtered by fulfillment method and write the competitive landscape directly into your workbook. See also the spoke on generating a full product launch brief, or return to the Jungle Scout overview.