The Scenario
A YouTube SEO specialist has completed keyword research for a client in the fitness equipment niche. The output is a list of 12 target keywords in column A of an Excel workbook. The next step is competitive analysis: what is currently ranking for each keyword, which channels own those rankings, and how many views the top results are pulling. The specialist needs this data structured and in the workbook before the strategy session with the client tomorrow afternoon. Running 12 separate YouTube searches and manually tabulating the results is an option. It is just not one that leaves any time for the actual analysis.
The bad version:
- Search YouTube for keyword 1, note the top results in a separate document.
- Switch to Excel, paste in the data, label the rows by keyword.
- Repeat for 11 more keywords. Discover view counts are displayed differently depending on when the video was last fetched — some show "2.1M" and some show the full number.
- Spend 20 minutes standardising view count format before the data is usable.
The strategy session is tomorrow. The data should already be done.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the keywords in your sheet and, through its built-in Supadata integration, searches YouTube for each one and writes the top results with metadata into the workbook — in one pass.
Search YouTube for every keyword in column A using Supadata and write the top 10 results for each into this Excel sheet with title, channel, and view count — one query per section
What You Get
- For each keyword: the top 10 YouTube results written in a block, with title in one column, channel in the next, and view count as a raw number.
- Results grouped by keyword with clear section breaks so the workbook is readable.
- View counts as consistent raw numbers across all results — not abbreviated strings.
- All 12 keywords processed in one operation.
What If the Data Is Not Quite Ready
You need a flat table rather than grouped sections
The analysis pivot table requires one row per result with the keyword as a column.
Search YouTube for every keyword in column A using Supadata and write results as a flat table starting in a new sheet — include keyword, rank, title, channel, view count, and video URL, one result per row
You want the top 5 results per keyword instead of 10
The strategy session focuses on the top five positions for each target term.
For each search query in column A, use Supadata to search YouTube and write the top 5 results — title, channel name, and view count — into columns B through D, with a blank row between each keyword's results
You want to flag results from channels the client is already competing against
The client provided a list of three channels they consider direct competitors.
For each keyword in column A, use Supadata to search YouTube for the top 10 results — write title, channel, and view count into columns B through D — then in column E write 'Direct competitor' if the channel in column C matches any of the channels listed in a separate tab named 'Competitors'
You want a compact summary table alongside the full results
For each search query in column A, use Supadata to fetch the top 5 YouTube results — write all results in a detailed block in columns B through D, then write only the top result title and its view count as a summary in columns F and G
The pattern: having the full result set and the compact summary in the same workbook means you can switch between the detailed research view and the client-facing overview without reformatting.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of YouTube keywords and ask it to pull the search results in one operation. For full metadata on the top-ranking videos, look at the spoke on pulling YouTube video metadata in bulk.