The Scenario
You're a digital archivist at a media company. The company has been on YouTube for 11 years. Someone just asked for a complete inventory of all 350 published videos — titles, IDs, publish dates, view counts — for a licensing audit. They need it in a Google Sheet by end of week.
The bad version:
- Go to YouTube Studio, open the Content tab, start scrolling
- YouTube Studio only loads 30 videos at a time, so scroll and wait, scroll and wait
- After 90 videos, realize the interface is not showing view counts in the list view — you'd have to click each video individually
- Download the CSV export from the Analytics section, discover it only covers the last 28 days and doesn't include video IDs
350 videos. A full licensing audit requires every one of them with accurate IDs and current view counts.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reaches into the YouTube API, retrieves the full uploads playlist for your channel, paginates through every video, and writes the inventory directly into your sheet.
List all uploaded videos on my YouTube channel and write them into this sheet with columns for video ID, title, published date, view count, and duration
What You Get
- One row per published video — all 350 of them
- Column A: YouTube video ID
- Column B: video title
- Column C: published date in YYYY-MM-DD format
- Column D: total view count at time of pull
- Column E: video duration in ISO 8601 format (e.g. PT4M32S)
- Videos listed in upload order, most recent first
What If the Data Is Not Quite Ready
You need duration formatted as minutes and seconds, not ISO 8601
List all uploaded videos on my YouTube channel — write video ID, title, published date, and view count into columns A through D, then convert the duration to mm:ss format and write it into column E
The audit requires only videos published before a specific date
List all uploaded videos on my YouTube channel published before 2023-01-01 and write video ID, title, published date, and view count into this sheet
The inventory needs to include the video description for licensing review
List all uploaded videos on my YouTube channel and write video ID, title, description, published date, view count, and duration into this sheet — one row per video
You want to flag videos with fewer than 1,000 views as candidates for unlisting
List all uploaded videos on my YouTube channel — write video ID, title, published date, and view count into columns A through D — then add a column E flag that says "Review for unlisting" for any video with fewer than 1,000 views
The full inventory plus the flagging logic, in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet — ask SheetXAI to pull the complete video inventory for your channel. Then see bulk-updating video metadata or the YouTube hub.