The Scenario
Your video production team spent two weeks re-encoding 25 existing course videos — better compression, updated intros, cleaner audio. The re-encoded files are uploaded to new Google Drive URLs. Your sheet engineer built the mapping: column A has the existing Spotlightr video IDs, column B has the replacement URLs. Twenty-five rows. Everything is ready. Except the source URL for each video in Spotlightr still points to the old file.
Updating them one at a time means opening each video in Spotlightr, navigating to the 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 to the search. Find the next ID. Repeat.
- Fifteen minutes in, you realize Spotlightr's search sometimes returns the wrong video first if the ID isn't exact — so you've been clicking into the wrong video settings for two of the rows and hadn't noticed.
The new videos need to be live before next Monday's cohort kick-off. This mapping work was supposed to take an hour, not most of a day.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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.
For each row in this sheet, update the Spotlightr video in column A to use the new source URL in column B and write "Updated" into column C when done.
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 instead of a silent failure.
- The sheet becomes your change log for the production team to verify against.
What If the Data Is Not Quite Ready
Some replacement URLs in column B are Google Drive share links, not direct file links
Spotlightr's source URL field expects a direct file URL. Drive share links need to be converted first.
For each row in this sheet: 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
You don't want those rows to overwrite the existing source URL with a blank. Skip them and flag them.
For each row in this sheet where column B is not empty, update the Spotlightr video in column A to use the new source URL in column B 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 tabs — one for Module 1 videos, one for Module 2
For each row in the "Module 1" tab and the "Module 2" tab: 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 tab.
You want source URL updates plus a verification pass in one prompt
After updating each video, you want to confirm the new source URL is live by checking that the video is still accessible in Spotlightr.
For each row in this sheet, 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 source URL mapping sheet 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 a Google Sheet and the Spotlightr hub.