The Scenario
You're a content strategist and the editorial director just asked for a list of every Spotlightr video that references the keyword "onboarding" — video ID, name, and group — so you can plan a content refresh across the product education library. The account has hundreds of videos. Spotlightr's dashboard has a search bar. It does not have an export button.
The bad version:
- Type "onboarding" into Spotlightr's search bar. Get a results list.
- Click into the first result, note the video ID from the URL, note the title, note the group from the breadcrumb, switch to your sheet, type in all three values.
- Click back, click the second result, repeat.
- After twenty minutes you have eight rows and have been clicking back and forth long enough that you're no longer confident you captured the group name correctly for results four through six.
The refresh plan is due Friday. This is Tuesday. You're supposed to be planning, not transcribing search results.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the keyword from a cell, runs the Spotlightr search, and writes the results — ID, title, group — directly into the sheet.
Search Spotlightr for all content matching the keyword in cell A1 and write the results (video ID, title, group) into this sheet starting at row 3.
What You Get
- Every Spotlightr video matching the keyword in cell A1 returned and written into the sheet starting at row 3.
- Video ID in column A, title in column B, group name in column C.
- No duplicates — if the same video appears in multiple search result pages, it appears once in the sheet.
- If the search returns zero results, a single note in row 3 indicates that rather than leaving the sheet blank.
What If the Data Is Not Quite Ready
You need to search for multiple keywords and keep the results separate
The refresh covers three topic areas: "onboarding," "billing," and "integrations." You want each keyword's results in its own tab.
Run a Spotlightr search for each keyword in column A of this sheet. Write the results for each keyword into a separate tab named after the keyword — columns: video ID, title, group.
The search returns too many results and you only want videos from specific groups
The "onboarding" search returns 80 videos but you only care about the ones in the "Customer Success" and "Product Walkthroughs" groups.
Search Spotlightr for the keyword in cell A1 and write results into this sheet starting at row 3 — but only include videos whose group name is "Customer Success" or "Product Walkthroughs."
You want the search results plus the play count for each video
To prioritize the refresh, you need to know which "onboarding" videos are actually being watched and which can be deprioritized.
Search Spotlightr for the keyword in cell A1 and write video ID, title, and group into columns A–C starting at row 3. Then for each result, fetch the total play count from Spotlightr analytics and write it into column D.
You want a single pass that searches, fetches play counts, and adds a refresh priority tag
High-play videos above 200 plays get "Priority Refresh," low-play videos below 50 get "Archive Candidate," everything else gets "Standard Review."
Search Spotlightr for the keyword in cell A1. Write video ID, title, group, and total plays into columns A–D. In column E, write "Priority Refresh" if plays exceed 200, "Archive Candidate" if plays are below 50, and "Standard Review" otherwise.
One prompt builds the complete content audit in a format the editorial director can actually use.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, type your search keyword into cell A1, and ask SheetXAI to search Spotlightr and write the results into the sheet. See also: Export Top Spotlightr Videos to a Google Sheet and the Spotlightr hub.