The Scenario
You're preparing a competitive strategy presentation for next week's leadership review, and your category director has asked a specific question: for the five keywords that define the bamboo cutting board niche, which brands own the most search real estate, and by how much?
You have the five keywords in column A of your SOV sheet. Jungle Scout has the share-of-voice data. What you're about to do by hand is look up each keyword, read off the top brand and its percentage, switch to the sheet, type it in, and do that five times while the presentation deck waits.
The bad version:
- Search the first keyword in Jungle Scout, navigate to the share-of-voice view, read the top brand name and percentage.
- Switch to the sheet, type the brand name into column B, type the percentage into column C.
- Do this for five keywords.
- Realize the brand name format from Jungle Scout doesn't match the brand names in the rest of your deck, and spend another twenty minutes normalizing them.
This is two hours of work that produces a table any executive will read in forty-five seconds.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your keyword list, pulls Jungle Scout share-of-voice data, and writes the results into the columns you specify.
Fetch share-of-voice data from Jungle Scout for each keyword in column A of my SOV sheet and write the top brand name and its share percentage into columns B and C.
SheetXAI reads each keyword, pulls the Jungle Scout share-of-voice breakdown, and writes the dominant brand and its percentage into columns B and C across all five rows.
What You Get
- Column B with the top brand name for each keyword's share-of-voice data.
- Column C with that brand's share percentage, formatted as a decimal (e.g., 0.34 for 34%).
- Consistent brand name formatting across all rows — no capitalization inconsistencies from manual transcription.
- If a keyword has no clear dominant brand, the entry reflects that rather than silently leaving a blank.
What If the Data Is Not Quite Ready
I want the top 3 brands per keyword, not just the top one
For the keywords in column A of my SOV sheet, fetch Jungle Scout share-of-voice data and write the top 3 brands and their percentages into columns B through G — brand 1 in B, its share in C, brand 2 in D, its share in E, brand 3 in F, its share in G.
The percentages are coming back as decimals but I need them as whole percentages
Fetch share-of-voice data from Jungle Scout for each keyword in column A of my SOV sheet. Write the top brand into column B and its share percentage into column C formatted as a whole number percentage (e.g., 34, not 0.34).
I want to add a concentration label based on the top brand's share
Fetch Jungle Scout share-of-voice data for each keyword in column A. Write top brand into column B and share percentage into column C. Add a column D labeled "Concentration" — write "Dominated" if the top brand holds more than 40%, "Fragmented" if less than 20%, and "Contested" otherwise.
Kill-chain: pull SOV, calculate brand concentration, and flag high-priority attack keywords
For each keyword in column A of my SOV sheet, fetch Jungle Scout share-of-voice data. Write top brand and share into columns B and C. Calculate total top-3 brand concentration in column D. Flag in column E any keyword where no single brand holds more than 25% share — label those "Opportunity" and the rest "Contested." Sort by column D ascending so the most fragmented markets surface first.
Ask for the data pull and the strategic scoring in the same prompt — you get an analysis-ready sheet, not a raw data dump.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your category keywords in column A, then ask it to pull Jungle Scout share-of-voice data and write brand ownership percentages into the sheet. See the related spoke on building a product opportunity brief, or return to the Jungle Scout overview.