The Scenario
You track YouTube trending videos every month for a market research client in the gaming industry. The deliverable is a structured dataset of the top 50 trending videos in the US Gaming category — titles, channels, view counts, publish dates — ready for the client's analyst to filter and chart. You're supposed to have it over by Monday morning.
The bad version:
- Open YouTube, click Explore, find the Trending tab, switch to the Gaming category
- Start copying video titles into a sheet by hand — YouTube's trending page loads dynamically so you can't select all and paste
- After 20 videos, the page refreshes because you took too long between clicks, and the ranking shifts
- End up with 38 entries, three of which are duplicates because the page reloaded mid-copy, and the client's analyst has to clean it before it's usable
Fifty videos. Monthly cadence. And the next one is due in four weeks.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls the YouTube Data API to pull the current most-popular videos for any region and category, and writes the results into structured columns.
Fetch the current most popular YouTube videos in the US for the Gaming category and write the top 50 into this sheet with video ID, title, channel name, view count, and published date
What You Get
- 50 rows, one per trending video
- Column A: YouTube video ID
- Column B: video title
- Column C: channel name
- Column D: view count at pull time
- Column E: published date in YYYY-MM-DD format
- Results ordered by YouTube's current trending rank
What If the Data Is Not Quite Ready
The client also wants the like count and comment count alongside view count
Fetch the current most popular YouTube videos in the US for the Gaming category — write the top 50 into this sheet with video ID, title, channel name, view count, like count, comment count, and published date
You need trending data for three regions: US, UK, and CA
Fetch the current top 25 trending YouTube videos for the Gaming category in each of these regions: US, UK, and CA — write all results into this sheet with a Region column, followed by video ID, title, channel name, and view count
You want to flag videos that have been trending for more than 7 days based on publish date
Fetch the current top 50 trending YouTube Gaming videos in the US — write video ID, title, channel name, view count, and published date into this sheet — then add a column flagging any video published more than 7 days ago as "Evergreen Trending"
You want a month-over-month view comparing this month's trending list to last month's tab
Compare the video IDs in this month's trending results (pull the current top 50 Gaming trending in US) against the video IDs in the PreviousMonth tab — flag videos that appear in both as "Recurring", new entries as "New", and videos that dropped off as "Exited" in a summary tab
One prompt. Full trending dataset plus the competitive delta built in.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet — ask SheetXAI to pull the current top 50 trending Gaming videos for the US and you'll have a structured dataset in under a minute. See also searching YouTube by keyword or the YouTube hub.