The Scenario
It's Thursday afternoon and the weekly video performance report is due to the marketing team by end of day. You have a Google Sheet with 30 Spotlightr video IDs in column A — the same sheet you've used for four weeks running. Columns B through F are supposed to show loads, plays, play rate, completion rate, and share count for the current week. Right now they're blank.
The data exists in Spotlightr. Getting it into the sheet is where things fall apart.
The bad version:
- Open the Spotlightr dashboard, click into the first video, screenshot or note the analytics values, switch back to the sheet, paste them into row 2.
- Repeat for video 2. And video 3. Thirty times.
- Realize halfway through that Spotlightr's dashboard shows lifetime metrics by default, not this week's data, and you've been copying the wrong numbers for the last eight videos.
You're supposed to be analyzing this data, not transcribing it. The reporting is supposed to tell you something — and right now it's just consuming your afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the video IDs in your sheet, calls the Spotlightr analytics API for each one, and writes the results back into the right columns — all from a single prompt.
For each video ID in column A of this sheet, fetch the Spotlightr metrics — loads, plays, playRate, completionRate, shares — and write the results into columns B through F.
What You Get
- Spotlightr analytics fetched for every video ID in column A.
- Loads written into column B, plays into column C, playRate into column D, completionRate into column E, shares into column F.
- Rows where a video ID returns no data (deleted videos, IDs with no views yet) get a blank rather than an error, so the sheet stays clean.
- The whole operation runs in one pass — you don't click through a single dashboard screen.
What If the Data Is Not Quite Ready
Some video IDs in column A have been deleted from Spotlightr
You don't know which ones are stale. You want valid rows filled in and deleted-video rows flagged so you can remove them from the tracking sheet.
For each video ID in column A, fetch Spotlightr analytics and write loads, plays, playRate, completionRate into columns B–E. If the API returns a 404 or "not found" for a video ID, write "deleted" into column B and leave C–E blank for that row.
You need a rolling 7-day window, not lifetime totals
Spotlightr's analytics API supports date-range parameters. You want this week's numbers, not all-time.
For each video ID in column A, fetch Spotlightr analytics for the date range in cells H1 (start) and I1 (end) and write loads, plays, playRate, completionRate into columns B–E.
The video IDs are spread across two tabs
Your sheet has a "Product Demos" tab and a "Onboarding Videos" tab, each with video IDs in column A. You need both pulled in one prompt.
Fetch Spotlightr analytics for every video ID in column A of the "Product Demos" tab and the "Onboarding Videos" tab — write loads, plays, playRate, completionRate into columns B–E of each respective tab.
You want analytics plus a performance tier label written in one pass
After writing the raw metrics, you want a column that flags videos as "High," "Medium," or "Low" based on whether the completion rate exceeds 60%, is between 30% and 60%, or is below 30%.
For each video ID in column A, fetch Spotlightr analytics and write loads, plays, playRate, completionRate into columns B–E. Then write a performance tier into column F: "High" if completionRate is above 0.60, "Medium" if between 0.30 and 0.60, "Low" if below 0.30.
Combining the fetch and the classification in one prompt means the report is complete the moment SheetXAI finishes — no second pass needed.
Try It
Get the 7-day free trial of SheetXAI and open your video tracking sheet with Spotlightr IDs in column A. Ask SheetXAI to pull this week's metrics for every ID and write them back into the adjacent columns. See also: Export Top Spotlightr Videos to a Google Sheet and the Spotlightr hub.