The Scenario
A learning and development manager has just been asked by the head of HR to update the company's internal course catalogue. The training content lives in a YouTube playlist — 45 videos covering onboarding, compliance, and skills development — and the internal catalogue is a shared Google Sheet. The L&D manager needs video ID, title, duration, and upload date for every video in the playlist so the catalogue can be updated accurately and shared with managers before the new-hire cohort starts. There is no built-in way to export a YouTube playlist into a spreadsheet.
The bad version:
- Open the YouTube playlist, click the first video, copy the title and video ID manually.
- Note the duration from the video player. Format it consistently. Paste into the sheet.
- Return to the playlist. Click the next video. Repeat 44 more times. Realise at video 30 that the upload date is not visible on the watch page in a consistent format.
The catalogue update is needed before the new-hire cohort starts on Monday. That's three days. Manually cataloguing 45 videos is not a Monday-morning plan — it is a weekend plan, and it should not be.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the playlist URL you provide and, through its built-in Supadata integration, fetches every video from the playlist with full metadata and writes it into the sheet in one operation.
Fetch all video IDs from the YouTube playlist URL in cell A1 using Supadata, then for each ID get the title and upload date, and write the full list into this sheet
What You Get
- One row per video, with video ID, title, and upload date written into adjacent columns.
- All 45 videos included — not a sampled or paginated subset.
- Upload dates in a consistent, sortable format rather than the relative "2 years ago" shown on the watch page.
- The catalogue ready to share with managers without a reformatting pass.
What If the Data Is Not Quite Ready
You need duration alongside the other metadata
The internal catalogue shows estimated watch time for each course.
Fetch all video IDs from the YouTube playlist URL in cell A1 using Supadata, then for each ID fetch title, duration, and upload date — write video ID into column A, title into column B, duration in minutes into column C, and upload date into column D
The playlist is large and you want to filter it to only videos uploaded in the last two years
The catalogue only surfaces current content; older training videos have been replaced.
Fetch all videos from the YouTube playlist URL in cell A1 using Supadata — write video ID, title, and upload date into columns A through C, then filter the list to keep only rows where the upload date in column C is in 2024 or 2025 and write the filtered set into columns E through G
You need to categorise videos by topic based on keywords in the title
The catalogue uses categories: Onboarding, Compliance, Skills.
Fetch all videos from the YouTube playlist URL in cell A1 using Supadata — write video ID into column A and title into column B — then classify each video based on keywords in the title: if the title contains 'onboarding' or 'orientation' write 'Onboarding' in column C, if it contains 'compliance' or 'policy' write 'Compliance', otherwise write 'Skills'
You want a single prompt that builds the full catalogue and validates it
Fetch all videos from the YouTube playlist URL in cell A1 using Supadata, write video ID into column A, title into column B, duration in minutes into column C, and upload date into column D — then write the total video count in cell F1 and flag in cell F2 if any video has a title that appears more than once in column B
The pattern: building the uniqueness check into the catalogue pull catches duplicate titles before they confuse new hires looking up course names.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, put the YouTube playlist URL into cell A1, and ask it to pull the full playlist metadata in one operation. If you need to catalogue the full channel rather than a single playlist, look at the spoke on exporting a YouTube channel video inventory.