The Scenario
The content ops team finished their quarterly audit three days ago. The verdict: 60 videos in the Spotlightr library are outdated — old product demos for features that no longer exist, training modules for a process that was retired, and a handful of duplicates that nobody caught during a rushed upload sprint. Every obsolete video ID is in a Google Sheet, column A, with "DELETE" in column B.
Sixty videos. One at a time through the Spotlightr dashboard.
The bad version:
- Open Spotlightr, search for the first video ID from the sheet, click into the video settings, find the delete option, confirm.
- Go back to the search, paste the next ID, click into settings, delete, confirm.
- After thirty minutes you've deleted eleven videos, lost your place in the sheet twice, and accidentally deleted a video you meant to keep because the IDs start to blur together by the twentieth one.
The audit is done. The cleanup should not take longer than the audit did.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the video IDs and status flags from your sheet, calls the Spotlightr API to delete each one, and writes the outcome back into the sheet — all from one prompt.
Delete every Spotlightr video whose ID is in column A of this sheet where column B says DELETE.
What You Get
- Every row where column B is "DELETE" gets its video removed from Spotlightr via API call.
- Successful deletions get "Deleted" written back into column C.
- Any video ID that returns an error — not found, already deleted, access denied — gets the error message written into column C instead, so nothing disappears silently.
- Rows where column B is not "DELETE" are left untouched.
What If the Data Is Not Quite Ready
Some IDs in the sheet have already been deleted from a previous cleanup run
You want to skip IDs that no longer exist in Spotlightr rather than let them generate errors that clutter your status column.
Delete every Spotlightr video in column A where column B says DELETE. If the API returns a 404 for an ID, write "already deleted" into column C and continue — do not stop the batch.
The sheet has a mix of "DELETE" and "ARCHIVE" flags and you only want to act on one
The audit tagged some videos for deletion and some for archiving, but you're only doing the deletion pass today.
Delete every Spotlightr video in column A where column B says exactly DELETE (case-sensitive). Leave rows where column B says ARCHIVE completely untouched.
The video IDs are spread across multiple tabs, one per department
Finance, HR, and Product each have their own audit tab in the workbook, each with the same column structure. You need all three processed in one operation.
For each of the tabs named "Finance," "HR," and "Product," delete every Spotlightr video in column A where column B says DELETE. Write the result ("Deleted" or the error) into column C of each respective tab.
You want to delete, then pull the updated library count into cell A1 as confirmation
After the deletions run, you want a quick sanity check — how many videos are left in the Spotlightr account total — written back into the sheet.
Delete every Spotlightr video in column A where column B says DELETE and write the outcome into column C. When all deletions are complete, fetch the total remaining video count from Spotlightr and write it into cell A1.
One prompt handles the cleanup and the confirmation — you can see immediately how many videos remain without opening the dashboard.
Try It
Get the 7-day free trial of SheetXAI and open your audit sheet with Spotlightr video IDs in column A and deletion flags in column B. Ask SheetXAI to delete every flagged row and write the results back. See also: Bulk Create Spotlightr Videos From a Google Sheet and the Spotlightr hub.