The Scenario
A digital agency is inheriting a client's Spotlightr account as part of a content migration project. Before anything gets moved, the team needs a complete inventory — every group with its ID, every video with its title, ID, and group assignment — written into a Google Sheet so the migration architect can plan which content goes where and flag anything that's missing from the original brief.
Nobody on the agency team has used this client's Spotlightr account before. They don't know how many groups exist, how many videos, or whether the naming conventions are consistent.
The bad version:
- Open Spotlightr, navigate to Groups, start noting group names and IDs into the sheet. There are sixteen.
- Navigate to Videos, start listing titles, IDs, and groups. There are 140 videos spread across those sixteen groups.
- An hour and a half in, you've captured 80 videos and have no way to verify whether the Spotlightr dashboard is paginating results and you've already missed some.
The migration kickoff is next week. An incomplete inventory means an incomplete migration plan — which means scope creep later.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls the Spotlightr API to list every group and every video in the account and writes a complete catalog into the sheet — no pagination gaps, no manual transcription.
List all Spotlightr groups and all videos in this account and write the results into this sheet: group name and ID in columns A–B, video title, ID, and group in columns D–F.
What You Get
- Every Spotlightr project group written into columns A and B — group name and group ID.
- Every video in the account written into columns D through F — video title, video ID, and the group it belongs to.
- The full account catalog in one sheet, no pagination artifacts, no missing rows.
- If the account has videos not assigned to any group, they appear in column F as "ungrouped" rather than silently absent.
What If the Data Is Not Quite Ready
You need the inventory split across two tabs — one for groups, one for videos
The migration architect wants groups in one tab for the taxonomy review and videos in a separate tab for the content audit.
List all Spotlightr groups and write group name and group ID into the "Groups" tab columns A–B. List all videos and write video title, video ID, and group name into the "Videos" tab columns A–C.
You also need the play count for each video to prioritize migration order
High-traffic videos should migrate first. You want the inventory plus play counts in one pass.
List all Spotlightr videos and write title, video ID, and group into columns A–C. For each video, fetch the total play count from Spotlightr analytics and write it into column D. Sort by play count descending.
Some groups might have no videos assigned
The client may have created empty groups during an organizational pass that never got populated. You want those flagged.
List all Spotlightr groups and write group name and ID into columns A–B. For each group, also write the total number of assigned videos into column C. Write "empty" in column C for any group with zero videos.
You want a single-prompt full audit: groups, videos, play counts, and an inventory summary
List all Spotlightr groups in the "Groups" tab (columns: name, ID, video count). List all videos in the "Videos" tab (columns: title, ID, group name, play count). After both tabs are complete, write a summary into cell A1 of a "Summary" tab: total groups, total videos, total plays across the account.
One prompt gives the migration architect everything they need to scope the project accurately before the kickoff meeting.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet. Ask SheetXAI to export your complete Spotlightr library inventory — all groups and all videos — into the sheet. See also: Export Top Spotlightr Videos to a Google Sheet and the Spotlightr hub.