The Scenario
A social media analyst at a media agency inherited a Google Sheet from a colleague who left last month. The sheet has 15 competitor YouTube channel handles in column A — part of a benchmarking study the previous analyst started. The study is supposed to feed a competitive slide deck for a client presentation in four days. The analyst needs subscriber count, total video count, and total view count for each channel. The previous analyst left notes but no data.
The bad version:
- Search each channel on YouTube, navigate to the About tab, note the subscriber count manually. Subscriber counts are rounded on the public-facing page — "1.2M" is not a number you can put in a bar chart.
- Try to find an accurate count through a third-party tool. Enter the first channel URL. The tool requires registration. Register. Get an email. Confirm. Enter the URL again. Get data for one channel.
- Repeat this for 14 more channels, each with a slightly different URL format that breaks the tool's parser on four of them.
The slide deck presentation is in four days. The data collection phase was supposed to take one afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the channel handles in your sheet and, through its built-in Supadata integration, fetches channel-level metadata for each one and writes the structured results into adjacent columns — in one operation.
For each YouTube channel handle or URL 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
What You Get
- Column B: the channel's display name.
- Column C: subscriber count as a raw number — not a rounded abbreviation.
- Column D: total video count.
- Column E: total lifetime view count.
- All 15 rows populated in one pass, with consistent numeric formatting across all cells.
What If the Data Is Not Quite Ready
Column A has a mix of channel handles and full channel URLs
The previous analyst used different formats across different rows.
For each entry in column A — whether it is a channel handle, a channel URL, or a channel ID — use Supadata to fetch channel metadata and write channel name, subscriber count, total video count, and total views into columns B through E
You want the data sorted by subscriber count before presenting it
The slide deck needs channels ranked from largest to smallest.
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 — then sort all rows by column C descending
Some channel handles may have changed since the list was built
YouTube channels sometimes change their handle after a rebrand.
For each YouTube channel handle in column A, use Supadata to fetch channel metadata and write channel name, subscriber count, and total views into columns B through D — if a channel is not found, write 'Handle not found' in column B and flag the row in column E
You want to calculate average views per video as part of the same fetch
The client presentation includes a views-per-video efficiency metric.
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 into column D as 'Avg views per video' — sort by column D descending
The pattern: computing the derived metric in the same prompt means the analysis is in the sheet by the time you open the slide template.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of YouTube channel handles and ask it to pull the channel benchmarking data in one operation. To go deeper on any individual channel, look at the spoke on exporting a YouTube channel video inventory.