The Scenario
A YouTube strategist working with an agency client has been asked to pitch a content strategy overhaul. The research phase starts with understanding what the competitor is publishing — not a sample, the whole thing. The competitor's channel has roughly 180 videos, a mix of regular uploads, Shorts, and a handful of live recordings. The strategist needs every video ID categorised by type in an Excel workbook so the analysis can show the client exactly what content mix their competitor is running and how it has shifted over time. There is no official way to export this from YouTube. The strategist has an hour before the strategy session with the client.
The bad version:
- Scroll through the competitor's YouTube channel, manually copying video IDs into the workbook. Stop at row 40 because scrolling and copying is not viable at this scale.
- Find a Chrome extension that claims to export YouTube playlists — try it on the channel's "Videos" page. It times out after 50 results.
- Start researching the YouTube Data API. Discover it requires API key setup and quota management. The client session is in 45 minutes.
The content strategy session happens either with data or without it. Right now, it is looking like without.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. Specify the channel handle or URL and SheetXAI will use its built-in Supadata integration to fetch every video from the channel — categorised by type — and write the full inventory into the workbook.
Get all video IDs from the YouTube channel URL in cell A1 using Supadata and write regular videos, Shorts, and live streams into three separate tabs in this Excel workbook
What You Get
- Three separate worksheets — one for regular videos, one for Shorts, one for live streams — each populated with video IDs.
- A complete inventory of the channel's content, not a sampled or paginated subset.
- The content type breakdown already structured and ready to reference in the strategy session.
- No manual scrolling, no browser extension, no API key setup.
What If the Data Is Not Quite Ready
You need video titles alongside the IDs to make the inventory readable
A list of IDs alone is not useful in a client presentation.
Get all videos from the YouTube channel URL in cell A1 using Supadata — write video ID, title, and type (video, short, or live) into columns A, B, and C of the main sheet
You want to compare two competitor channels side by side
The client's brief covers two direct competitors and the strategist needs both inventories before the session.
Get all video IDs and titles from the YouTube channel URL in cell A1 using Supadata and write them into the sheet named 'Competitor A' — then do the same for the channel URL in cell B1 and write results into the sheet named 'Competitor B'
You want the content type breakdown summarised at the top of the workbook
The client presentation needs a summary slide with the total counts for each content type.
Get all videos from the YouTube channel URL in cell A1 using Supadata, write them into columns A and B with type in column B, then write the count of regular videos in cell D1, the count of Shorts in D2, and the count of live streams in D3
You want a sanity check against the channel's displayed video count
YouTube shows a total video count on the channel page. You want to verify the inventory is complete.
Get all videos from the YouTube channel URL in cell A1 using Supadata, write video IDs and types into columns A and B, write the total row count in cell D1, and add a note in cell D2 if that count is more than 5 below the expected count you enter in cell E1
The pattern: baking the completeness check into the data fetch means you catch a partial result before showing it to the client.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, put the competitor's channel URL into cell A1, and ask it to pull the full content inventory in one operation. Pair it with the spoke on pulling YouTube video metadata to add view counts and upload dates to the inventory.