The Scenario
You manage reporting for a media agency and the monthly performance deck is due at noon. You have 120 YouTube video IDs spread across three client channels — all in column A of your tracking sheet. The columns to the right are blank. Views, likes, comments, publish dates: all of it needs to be in by the time the deck hits the client's inbox.
The bad version:
- Open YouTube Studio, search for the first video ID, find the metrics on the overview page, write them down, switch back to the sheet, type them in
- Repeat for video 2. Then video 3. Realize at video 14 that YouTube Studio's session timed out.
- Get through 30 videos before running out of time, decide to estimate the rest from last month's numbers, and spend the meeting explaining the gap
The deck is going to the client's VP of Marketing. Estimated numbers won't survive that room.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads your data and talks to YouTube for you. Open the SheetXAI sidebar, connect the YouTube integration, and paste in your prompt.
Pull stats for all video IDs in column A into this sheet — fill columns B through F with title, view count, like count, comment count, and published date using YouTube batch video details
What You Get
- Column B: video title as it appears on YouTube
- Column C: total view count at time of pull
- Column D: like count
- Column E: comment count
- Column F: published date in YYYY-MM-DD format
- Any invalid or deleted video ID gets a note in column G flagging it for review
What If the Data Is Not Quite Ready
Some video IDs have trailing spaces or are formatted as numbers
Pull stats for all video IDs in column A — trim whitespace and treat numeric-looking values as strings before fetching — fill columns B through F with title, view count, like count, comment count, and published date
The sheet has a mix of full YouTube URLs and bare video IDs
For each value in column A, extract the 11-character video ID from the URL if needed, then fetch view count, like count, comment count, and published date into columns B through E
Stats are needed for three separate client tabs in the same workbook
For each tab named Client-A, Client-B, and Client-C, pull YouTube stats for all video IDs in column A and fill columns B through F with title, view count, like count, comment count, and published date on each tab
The client also wants a calculated engagement rate added inline
Pull stats for all video IDs in column A into columns B through F — title, views, likes, comments, published date — then add a column G with engagement rate calculated as (likes + comments) divided by views, formatted as a percentage, and flag any videos with engagement rate below 1% in column H
The pattern: pull the raw stats and run the derived calculation in the same prompt. You don't touch a formula.
Try It
Get the 7-day free trial of SheetXAI and open your video tracking sheet — paste a column of video IDs and ask SheetXAI to fill in the performance data. Then link to the sibling article on enriching competitor channel stats or the YouTube hub overview.