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