The Scenario
Your brand safety team is running a quarterly account audit and needs to verify which videos your YouTube account has positively rated — likes given, in other words — for a compliance review. Someone pulled 200 video IDs into column A from various sources. The ask: check what rating the account currently has on each one and record it.
The bad version:
- Open the first video ID in a browser, navigate to the video page, look for a visual indicator of whether it's liked — the thumbs up icon may or may not look different depending on browser rendering
- Check a few, realize you can't reliably tell from the UI whether the account gave a like versus no rating
- Look for a YouTube account activity export — the Takeout export does not include per-video ratings in a queryable format
- Give up after 30 videos and mark the rest as "Unknown" in the compliance column, hoping nobody asks follow-up questions
Two hundred video IDs. The compliance review is next Tuesday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It uses the YouTube API's video ratings endpoint to check the authenticated account's rating on each video ID in your sheet.
For each video ID in column A, check my YouTube rating (like, dislike, or none) and write the result into column B
What You Get
- Column B filled with the rating for each video: "like", "dislike", or "none"
- Rows where the video ID is invalid or inaccessible get a note in column C
- Results reflect the current state of the account's ratings at time of pull
What If the Data Is Not Quite Ready
You want to filter the results and only show videos where the account gave a positive rating
For each video ID in column A, check my YouTube rating and write the result into column B — then filter the sheet to show only rows where column B is "like" and sort by video ID
You also need to pull the video title alongside the rating for the compliance report
For each video ID in column A, check my YouTube rating and write it to column B — then fetch the video title and write it to column C so the compliance report has a human-readable row for each entry
The audit requires flagging any liked videos that belong to competitor channels
For each video ID in column A, check my YouTube rating and write it to column B — then for rows where column B is "like", fetch the channel name and write it to column C — flag any row where column C matches a name in the Competitors tab as "Flag for review" in column D
You want to identify videos rated more than 90 days ago that may need re-evaluation
For each video ID in column A, check my YouTube rating and write it to column B — then fetch the published date and write it to column C — flag any video published more than 90 days ago where column B is "like" as "Review rating" in column D
Rating status, publish age, and review flag in one pass.
Try It
Get the 7-day free trial of SheetXAI and open your audit sheet with video IDs in column A — ask SheetXAI to check the account rating on all 200 and your compliance column will be complete before the review. See also exporting channel video inventory or the YouTube hub.