The Scenario
Your digital marketing director sent a message at 8 AM: she needs the top 20 most-viewed videos from the Spotlightr account before the content strategy meeting at 11. She wants to know which pieces are worth repurposing, which can be retired, and what the completion rates look like. She does not want a screenshot. She wants a workbook.
You have Spotlightr access. You do not have a way to export that data into Excel that doesn't involve clicking through fifteen screens.
The bad version:
- Open Spotlightr Analytics, sort by play count descending, read the top video name and play count, switch to Excel, type it in.
- Go back. Read the second video. Switch back. Type it in.
- After ten minutes you have five rows and you've already transposed two values because you were switching between windows too fast.
The meeting is in three hours. The data is right there in Spotlightr — you just need it somewhere you can actually share and sort.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It talks directly to Spotlightr, fetches the top-performing videos, and writes the results into your workbook — sorted, labeled, and ready.
Export my Spotlightr top-performing videos into this Excel table — include video ID, title, total plays, and playRate, sorted highest plays first.
What You Get
- Video ID written into column A, title into column B, total plays into column C, play rate into column D.
- Results sorted by total plays descending — highest-viewed video in the first data row.
- No duplicates, no missing fields, no pagination gaps.
- The workbook is ready to share or filter the moment SheetXAI finishes.
What If the Data Is Not Quite Ready
You want more fields — group name and completion rate
Fetch the top 25 Spotlightr videos by play count and write video ID, title, group name, total plays, play rate, and completion rate into columns A–F, sorted by plays descending.
You only want videos from a specific project group
Fetch all videos in the "Product Demos" Spotlightr group, sort by play count descending, and write the top 20 into this workbook — columns: video ID, title, plays, completionRate.
You need a second worksheet with the bottom performers too
Fetch all Spotlightr videos and write the top 20 by play count into the "Top Performers" sheet (columns: title, plays, completionRate) and the bottom 20 by play count into the "Low Performers" sheet with the same columns.
You want the export plus a repurpose recommendation in one pass
Fetch the top 20 Spotlightr videos by play count and write title, plays, and completionRate into columns A–C. In column D, write "Repurpose" if plays exceed 500 and completionRate exceeds 0.65, otherwise write "Review."
One prompt, annotated output, meeting-ready in minutes.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook. Ask SheetXAI to pull your top Spotlightr videos by play count and write them into the workbook with the fields you need. See also: Pull Spotlightr Analytics Into an Excel workbook and the Spotlightr hub.