The Scenario
A YouTube strategist is preparing a pitch for a new client — a mid-size cookware brand that wants to build a content strategy based on what a top competitor is doing. The first thing the strategist needs is a full inventory of the competitor's YouTube channel: every video ID, the content type (regular video, Short, or live stream), so the pitch can show the client a breakdown of their competitor's content mix. The channel has 200-something videos. There is no manual version of this task that fits in an afternoon.
The bad version:
- Scroll through the YouTube channel page, clicking "Load more" repeatedly.
- Try to find a YouTube Studio export — which only works for channels you own.
- Look for a browser extension that exports channel video lists, find one with a 3-star rating and a last-update date from 2022.
By the time you have something resembling a complete list, you've spent 90 minutes and you're not even sure it's complete.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the channel handle or URL you specify and, through its built-in Supadata integration, fetches every video from the channel — categorised by type — and writes the full inventory into the sheet in one operation.
Fetch all videos from YouTube channel @ChannelHandle using Supadata and write each video ID and type (video, short, or live) into columns A and B of this sheet
What You Get
- Column A filled with video IDs for every video on the channel.
- Column B showing the content type: video, short, or live — for every row.
- The complete channel inventory, not a sampled or paginated subset.
- Data ready to hand to the client in a shared sheet or pivot into a content mix chart.
What If the Data Is Not Quite Ready
You need the video title alongside the ID for the pitch deck
A list of IDs alone is not readable in a client presentation.
Fetch all videos from YouTube channel @ChannelHandle using Supadata, write the video ID into column A, the title into column B, and the type (video, short, or live) into column C
You want to separate the three content types into their own sections
The client wants to see regular videos, Shorts, and live streams counted and grouped separately.
Fetch all videos from YouTube channel @ChannelHandle using Supadata and write regular videos into rows starting at row 2 with their IDs in column A and titles in column B — then after a blank row write Shorts with the same columns, then after another blank row write live streams — put the count of each type in cells D1, D2, and D3
The channel handle is in cell A1 and you want to run this for multiple channels
The pitch covers three competitor channels, all with handles listed in column A.
For each YouTube channel handle in column A, use Supadata to fetch all video IDs and types — write the results for each channel into a separate tab named after the handle
You want the full inventory plus the channel's total video count as a sanity check
Fetch all videos from YouTube channel @ChannelHandle using Supadata, write video IDs and types into columns A and B, and write the total video count into cell D1 — flag in cell D2 if the count in D1 differs from the number of rows returned
The pattern: building in the sanity check in the same prompt means you catch a partial fetch before acting on it.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, specify the competitor's channel handle, and ask it to pull the full content inventory in one operation. Once you have the video list, look at the spoke on pulling YouTube video metadata to enrich it with view counts and upload dates.