The Scenario
Your video production team re-encoded 25 existing course videos — better compression, updated intros, cleaner audio. The re-encoded files are at new Google Drive URLs. Your sheet engineer built the mapping in Excel: column A has existing Spotlightr video IDs, column B has the replacement URLs. Twenty-five rows. Everything is ready. Except each video in Spotlightr still points to the old file.
Updating them one at a time means opening each video in Spotlightr, navigating to source settings, pasting the new URL, and saving. Twenty-five times.
The bad version:
- Open Spotlightr. Find video ID from row 2 in the search. Click into settings. Locate the source URL field. Paste the new URL from column B. Save.
- Go back. Find the next ID. Repeat.
- Fifteen minutes in, realize Spotlightr's search sometimes returns the wrong video first, and you've been clicking into the wrong settings for two rows without noticing.
The new videos need to be live before Monday's cohort kick-off. This was supposed to take an hour.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the video ID and replacement URL from each row, calls the Spotlightr API to update the source, and writes the result back into column C.
Replace the video source for every record in my Excel table — column A is the Spotlightr video ID, column B is the replacement URL.
What You Get
- Each Spotlightr video ID in column A updated to use the replacement URL from column B.
- "Updated" written into column C for every row that succeeds.
- Any row that fails — video ID not found, URL rejected, API error — gets the error message in column C rather than a silent failure.
- The workbook becomes the change log for the production team to verify against.
What If the Data Is Not Quite Ready
Some replacement URLs are Google Drive share links, not direct file links
For each row in this workbook: if column B is a Google Drive share link, convert it to a direct download URL using the file ID. Then update the Spotlightr video in column A to use that direct URL and write "Updated" or the error into column C.
A few rows in column B are blank because the re-encoded file isn't ready yet
For each row in this workbook where column B is not empty, update the Spotlightr video in column A to use the new source URL and write "Updated" into column C. For rows where column B is blank, write "skipped: no URL" into column C.
The mapping is split across two worksheets
For each row in the "Module 1" sheet and the "Module 2" sheet: update the Spotlightr video in column A to use the URL in column B. Write "Updated" or the error into column C of the respective sheet.
You want source URL updates plus a verification pass
For each row in this workbook, update the Spotlightr video in column A to use the new source URL in column B. After each update, verify the video is still accessible via the API. Write "Updated and verified" or the error into column C.
One prompt handles both the update and the confirmation — the production team gets a clean audit trail without a separate QA pass.
Try It
Get the 7-day free trial of SheetXAI and open your Excel source URL mapping workbook with Spotlightr video IDs in column A and replacement URLs in column B. Ask SheetXAI to update every video and write the results back into column C. See also: Bulk Create Spotlightr Videos From an Excel workbook and the Spotlightr hub.