The Scenario
The content ops team finished their quarterly audit three days ago. The verdict: 60 videos in the Spotlightr library are outdated. Every obsolete video ID is in an Excel workbook, 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 workbook, 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 workbook twice, and accidentally deleted a video you meant to keep because the IDs start to blur together.
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 Excel workbook. It reads the video IDs and status flags, calls the Spotlightr API to delete each flagged video, and writes the outcome back into the workbook.
Remove all video IDs listed in the "To Archive" column of my Excel sheet from Spotlightr — write "Deleted" into the Status column for each one that succeeds.
What You Get
- Every row where the flag column says "DELETE" gets its video removed from Spotlightr.
- "Deleted" written into the Status column for every row that succeeds.
- The exact error message written into the Status column for any row that fails — not found, already deleted, or API error — so nothing disappears silently.
- Rows not flagged for deletion are left completely untouched.
What If the Data Is Not Quite Ready
Some IDs have already been deleted from a previous cleanup run
Delete every Spotlightr video in column A where column B says DELETE. If the API returns a 404, write "already deleted" into column C and continue — do not stop the batch.
The workbook has a mix of "DELETE" and "ARCHIVE" flags and you only want to act on one
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 worksheets — one per department
For each of the sheets named "Finance," "HR," and "Product," delete every Spotlightr video in column A where column B says DELETE. Write the result into column C of each respective sheet.
You want to delete, then pull the updated library count as confirmation
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 — the audit trail is in the workbook.
Try It
Get the 7-day free trial of SheetXAI and open your Excel audit workbook 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 an Excel workbook and the Spotlightr hub.