The Scenario
A social media analyst at an agency has taken over a benchmarking project from a colleague who left mid-engagement. The Excel workbook contains 15 competitor YouTube channel handles in column A. The client brief calls for subscriber count, total video count, and total views for each channel — data that was supposed to be collected two weeks ago. The new analyst has the handles, the template, and a client check-in call tomorrow morning. What the workbook does not have is any data.
The bad version:
- Search each channel on YouTube, navigate to the About tab, note the subscriber count. The number displays as "1.4M" — not a usable figure for a chart.
- Try a YouTube analytics lookup tool. Some channels are not found. Some return outdated cached data.
- After an hour, have clean data for 8 of 15 channels, inconsistent data for 4, and nothing for 3.
The client check-in is tomorrow. A half-complete dataset is not the same as a benchmarking report.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the channel handles in your sheet and, through its built-in Supadata integration, fetches structured channel metadata for each one and writes it into adjacent columns — in one operation.
Fetch Supadata channel metadata for every YouTube channel URL in column A and write subscriber count and total view count into columns B and C of this Excel sheet — sort by subscriber count descending
What You Get
- Column B: subscriber count as a raw number, not an abbreviated display value.
- Column C: total lifetime view count.
- All 15 rows populated in one pass, sorted by subscriber count from largest to smallest.
- Data ready to drop into the benchmarking chart template before the client call.
What If the Data Is Not Quite Ready
You need channel name and total video count alongside the subscriber data
The client slide template has four columns: name, subscribers, videos, total views.
For each YouTube channel handle in column A, use Supadata to fetch channel metadata and write channel name, subscriber count, total video count, and total views into columns B through E
Some handles in the list may have been rebranded or no longer exist
Channel handles change when creators rebrand. The list is four months old.
For each YouTube channel handle in column A, use Supadata to fetch channel metadata and write channel name and subscriber count into columns B and C — if a channel is not found, write 'Handle not found' in column B and flag the row in column D
You want to calculate average views per video as an efficiency metric
The client wants to benchmark content efficiency, not just raw subscriber count.
For each YouTube channel handle in column A, use Supadata to fetch total view count and total video count — write them into columns B and C, then divide column B by column C and write the result rounded to the nearest whole number into column D as 'Avg views per video' — sort by column D descending
You want the full benchmark table plus a summary row at the bottom
The client presentation closes with a market-average row showing the median subscriber count across all 15 channels.
For each YouTube channel handle in column A, use Supadata to fetch subscriber count and total views — write them into columns B and C — then in the first empty row below the data write 'Median' in column A, the median subscriber count in column B, and the median total views in column C
The pattern: building the summary statistics into the same data pull means the presentation slide is assembled when the data collection is done.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of YouTube channel handles and ask it to pull the benchmarking data in one operation. To drill into any individual channel's content mix, look at the spoke on exporting a YouTube channel video inventory.