The Scenario
You manage a YouTube channel for a brand with 30 playlists accumulated over five years. Leadership has decided to restructure the channel — archive some playlists, merge others, rename the public-facing ones for consistency. Before anyone touches anything, they want a complete audit: every playlist name, its privacy setting, its item count, its description. In a spreadsheet. This week.
The bad version:
- Go to YouTube Studio, click Playlists, start reading the list
- YouTube Studio shows you playlist names and item counts but not privacy settings or descriptions without clicking into each playlist
- Click into playlist 1, read the description, note the privacy setting, go back, click into playlist 2
- After playlist 8, you've lost your place in the list because the interface re-sorted when you navigated back
Thirty playlists. Each requiring a separate click-in to get the full data. And leadership wants the audit by the end of the week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It pulls the full playlist list from the YouTube API in one call, including metadata that isn't visible in YouTube Studio's default view.
List all playlists on my YouTube channel and write them into this sheet with columns for playlist ID, title, description, privacy status, and video count
What You Get
- One row per playlist — all 30 of them
- Column A: playlist ID
- Column B: playlist title
- Column C: playlist description
- Column D: privacy status (public, unlisted, or private)
- Column E: video count
What If the Data Is Not Quite Ready
You also need the published date for each playlist
List all playlists on my YouTube channel and write playlist ID, title, description, privacy status, video count, and published date into this sheet
You want to flag playlists with fewer than 5 videos as candidates for archiving
List all playlists on my YouTube channel — write playlist ID, title, privacy status, and video count into this sheet — then add a column flagging any playlist with fewer than 5 videos as "Archive candidate"
You want to compare current playlist names against a naming convention in a second tab
List all playlists on my YouTube channel into Sheet1 with playlist ID, title, and privacy status — then in Sheet2, compare each title against the naming convention list in column A and flag any playlist whose title does not start with one of the approved prefixes
You want the full audit plus a restructuring recommendation inline
List all playlists on my YouTube channel — write playlist ID, title, description, privacy status, and video count into this sheet — then add a recommendation column: "Archive" for playlists with 0 videos, "Review" for private playlists with more than 10 videos, and "Keep" for everything else
Audit and action plan in one sheet, in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet — ask SheetXAI to export all your channel playlists with full metadata before your restructuring call. See also exporting playlist items or the YouTube hub.