The Scenario
Your SaaS company is going live on twelve new client subdomains next Tuesday. The security checklist includes whitelisting every domain in Spotlightr so the embedded videos actually play on the client sites. Your DevOps lead put all twelve domain strings into a Google Sheet yesterday — they're in column A, one per row, ready to go. The go-live is in five days. You need every domain in Spotlightr's whitelist before the deployment window opens.
The Spotlightr domain whitelist is managed in the account settings. One domain at a time.
The bad version:
- Open Spotlightr, navigate to Account Settings, find the Embedding section, click "Add Domain," type the first domain from the sheet, save.
- Go back to the sheet, read the second domain, switch back to Spotlightr settings, click "Add Domain" again, type it, save.
- Twelve domains means twelve round-trips through the settings panel, with the real risk that you mistype one and a client site launches with broken embeds.
The go-live window doesn't move. A typo in one domain means a broken video player on a client site at exactly the wrong moment.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the domain list from column A and calls the Spotlightr API to whitelist each one — then writes the result back into column B so you have a record of what went through.
Add every domain listed in column A of this sheet to Spotlightr as a whitelisted embedding domain and write "Added" or the error message into column B.
What You Get
- Each domain in column A submitted to Spotlightr's embedding whitelist via API.
- "Added" written into column B for every domain that succeeds.
- The exact error message written into column B for any domain that fails — invalid format, already whitelisted, or API error — so you know exactly which ones need attention.
- The sheet becomes your audit log for the go-live checklist.
What If the Data Is Not Quite Ready
Some domains in column A have protocol prefixes that Spotlightr doesn't accept
Your DevOps lead included "https://" at the start of some entries. Spotlightr expects bare domains without the scheme.
For each domain in column A, strip any leading "https://" or "http://" before submitting to Spotlightr's embedding whitelist. Write "Added" or the error into column B.
Some domains are already whitelisted from a previous setup
You don't want duplicates, but you also don't want the operation to stop if Spotlightr returns an "already exists" response.
Add each domain in column A to Spotlightr's embedding whitelist. If a domain is already whitelisted, write "already exists" into column B and continue — do not stop the batch.
The domains are spread across two columns — primary domains in column A and staging subdomains in column B
You need both sets whitelisted before go-live.
Whitelist every domain in column A and every domain in column B of this sheet in Spotlightr. Write the result ("Added," "already exists," or the error) into column C for column A domains and column D for column B domains.
You want the whitelist updated AND a confirmation count written into the sheet header
After all domains are processed, you want to know how many were newly added versus already existing — written into cell D1 for a quick executive summary.
Add every domain in column A to Spotlightr's embedding whitelist and write "Added" or "already exists" or the error into column B. After all rows are processed, write a summary into cell D1: total newly added and total already existing.
You hand the sheet to your DevOps lead. The go-live checklist has a green row.
Try It
Get the 7-day free trial of SheetXAI and open the sheet with your pending Spotlightr embedding domains in column A. Ask SheetXAI to whitelist them all and write the outcome back into column B. See also: Bulk Create Spotlightr Videos From a Google Sheet and the Spotlightr hub.