The Scenario
You manage sales enablement for a SaaS company. Your team has ten product demo videos in Spotlightr, each gated behind a lead capture form. Prospects watch, fill out the form, and Spotlightr records who watched what and how far they got. Every Monday you're supposed to pull that per-viewer data and hand it to the sales reps so they can prioritize follow-up calls based on who actually finished a demo versus who dropped off at the 20% mark.
The video IDs are already in your Google Sheet. What you don't have is the per-view records — and Spotlightr's dashboard shows them one video at a time.
The bad version:
- Open Spotlightr, click into the first video, navigate to the Views tab, look at the viewer list, write down the viewer IDs and their watch percentages, switch to the sheet, type them in.
- Go back to Spotlightr. Second video. Same sequence.
- After forty minutes you've covered three videos and the data for video one is already formatted differently than video two because you forgot which column you were using.
Sales reps are asking for the list. The data exists. Getting it out of Spotlightr and into a shape the team can act on is the entire problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the video IDs from your sheet, pulls the per-view records from Spotlightr for each one, and writes everything into a dedicated tab — formatted, labeled, and ready for the sales team.
For each video ID in column A, fetch all view records from Spotlightr and paste them into a new tab called "Views" with columns: videoId, viewerId, watchedPercent, completed.
What You Get
- A "Views" tab created in your sheet with one row per view record across all video IDs.
- Columns: videoId (from column A), viewerId as returned by Spotlightr, watchedPercent as a decimal, and completed as true or false.
- If a video ID has no view records yet, it's skipped rather than adding a blank row.
- The tab is overwritten each time you run the prompt, so Monday's list is always fresh.
What If the Data Is Not Quite Ready
You want the viewer's email address rather than just the viewer ID
Spotlightr's lead capture stores the email if the viewer submitted the form. You want that surfaced alongside the viewer ID.
For each video ID in column A, fetch all Spotlightr view records including viewer email if available. Write videoId, viewerEmail, watchedPercent, and completed into a "Views" tab — leave viewerEmail blank for anonymous views.
You only want completed views for the sales team's priority list
Reps only follow up on viewers who finished the demo. Partial views are noise.
For each video ID in column A, fetch all Spotlightr view records where completed is true and write videoId, viewerEmail, and watchedPercent into the "Completed Views" tab.
The video IDs are split across two tabs — demos and webinars
You track product demos in the "Demos" tab and webinar recordings in the "Webinars" tab, each with video IDs in column A. You need view records for both pulled into a single output tab.
Fetch all Spotlightr view records for every video ID in column A of the "Demos" tab and the "Webinars" tab. Write all records into a single "All Views" tab with columns: source (Demos or Webinars), videoId, viewerEmail, watchedPercent, completed.
You want the view records plus a follow-up priority score in one pass
After pulling the data, you want a column that scores each viewer: 3 for completed, 2 for watchedPercent above 0.50, 1 for below 0.50 — so reps can sort by priority without interpreting the raw percentages.
For each video ID in column A, fetch all Spotlightr view records and write videoId, viewerEmail, watchedPercent, completed into the "Views" tab. Add a "Priority" column: 3 if completed is true, 2 if watchedPercent is above 0.5 and completed is false, 1 otherwise.
The reps get a ranked list. The entire thing runs before your second cup of coffee.
Try It
Get the 7-day free trial of SheetXAI and open your demo tracking sheet with Spotlightr video IDs in column A. Ask SheetXAI to pull all per-viewer watch records and write them into a new tab, ready for the sales team to sort and act on. See also: Pull Spotlightr Analytics Into a Google Sheet and the Spotlightr hub.