The Scenario
A learning and development coordinator at a professional services firm has been handed an update request: the internal training catalogue needs to reflect the current state of the company's YouTube training playlist. The playlist has 45 videos. The catalogue lives in an Excel workbook that was last updated eight months ago and is visibly stale — several video titles have changed, a few have been removed, and a handful of new ones were added without being recorded in the sheet. The L&D coordinator needs the current list of video IDs, titles, and types — regular video or Short — by end of week so the catalogue can go out to the new onboarding cohort.
The bad version:
- Open the YouTube playlist. Click the first video, note the title and video ID. Switch to Excel. Paste. Switch back to YouTube.
- Discover that video IDs are not displayed anywhere on the standard watch page. Find a browser extension that shows them. Install it. Use it for the first five videos, then the extension stops working on Private browsing.
- After an hour and a half, have 20 rows entered. Give up on getting all 45 done today.
The onboarding cohort starts Monday. The catalogue update is needed before Friday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the playlist URL you provide and, through its built-in Supadata integration, fetches every video in the playlist with its metadata and writes it into the workbook in one operation.
Get all videos from YouTube playlist [URL] using Supadata — write video ID, title, and type (video or short) into columns A, B, and C of this Excel sheet
What You Get
- Column A: video ID for every video in the playlist.
- Column B: video title.
- Column C: content type — video or short — for each entry.
- All 45 videos included, in playlist order.
- Output ready to send to HR and managers without a reformatting pass.
What If the Data Is Not Quite Ready
You want duration included so the catalogue can show estimated watch time
The onboarding programme uses time estimates to help new hires plan their first week.
Get all videos from YouTube playlist [URL] using Supadata — write video ID into column A, title into column B, type into column C, and duration in minutes into column D
You need to compare the current playlist against the previous catalogue version
The old catalogue is in columns F through H and you want to surface what has changed.
Get all videos from YouTube playlist [URL] using Supadata — write video ID into column A and title into column B — then compare column A against the video IDs in column F and write 'New' in column C for any video ID in column A that is not in column F, and write 'Removed' in column C for any ID in column F that is not in column A
You want to categorise videos by topic based on title keywords
The catalogue groups training content by category: Leadership, Operations, Compliance, Other.
Get all videos from YouTube playlist [URL] using Supadata, write video ID into column A and title into column B, then categorise each video in column C: 'Leadership' if the title contains 'leadership' or 'management', 'Compliance' if it contains 'compliance' or 'policy', 'Operations' if it contains 'process' or 'operations', otherwise 'Other'
You want the full catalogue and a count of Shorts vs regular videos
The L&D lead wants to know how much short-form content is in the training programme.
Get all videos from YouTube playlist [URL] using Supadata, write video ID into column A, title into column B, and type into column C — then write the total video count in cell E1, the count of Shorts in cell E2, and the count of regular videos in cell E3
The pattern: pulling the content type breakdown alongside the inventory means the L&D report writes itself.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, specify the YouTube playlist URL, and ask it to pull the full playlist catalogue in one operation. For a full channel inventory rather than a single playlist, look at the spoke on exporting a YouTube channel video inventory.