The Scenario
You are three months into managing your company's Shotstack account and nobody has any idea what is actually in it. The previous ops lead ingested a bunch of raw assets for a campaign that shipped in January, and those files are still sitting in the account — probably. Someone also mentioned there might be duplicates from a botched ingest run. Your media budget review is next Tuesday and you need a clean inventory before then.
The bad version:
- Authenticate to the Shotstack API, call the list sources endpoint, get back a paginated JSON response, copy the first page of assets into a spreadsheet by hand.
- Fetch the next page, do it again.
- Repeat until you have all assets listed, then manually sort the sheet by status to find the ones marked "failed" or "processing" that never finished.
- Try to figure out which assets are duplicates by eyeballing the source URLs.
The source list has more entries than you expected. You are going to be building this spreadsheet by hand for the next two hours, and the budget review is Tuesday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It retrieves the full list of source assets from your Shotstack account and writes each asset's details into the sheet — including IDs, URLs, statuses, and creation dates.
List all Shotstack source assets and write each asset's ID, source URL, status, and creation date into columns A through D of my sheet
SheetXAI calls Shotstack's list sources endpoint, handles pagination, and writes every asset's ID, source URL, status, and creation date into columns A through D.
What You Get
- Column A: Shotstack asset ID for every ingested source.
- Column B: the original source URL that was ingested.
- Column C: current status — "ready", "failed", "importing", or other Shotstack status values.
- Column D: creation date for each asset.
- All pages of results, not just the first 25.
What If the Data Is Not Quite Ready
You only want to see assets that are not in a "ready" state
The account has 200 assets and you only care about the ones that failed or are stuck.
List all Shotstack source assets where status is not "ready" and write each asset's ID, source URL, status, and creation date into columns A through D
You want to flag duplicate source URLs
The botched ingest run submitted some URLs twice and you need to identify which ones.
List all Shotstack source assets and write ID, source URL, status, and creation date into columns A through D — then in column E, mark any row whose source URL appears more than once in column B with "duplicate"
You want to filter to assets created before a specific date
The January campaign assets should all be from before February 1st. You want to see only those.
List all Shotstack source assets created before 2026-02-01 and write their ID, source URL, status, and creation date into columns A through D
Pull the full inventory, flag duplicates, separate failed assets, and add a summary
List all Shotstack source assets and write ID, source URL, status, and creation date into columns A through D — flag duplicate source URLs with "duplicate" in column E — then below the main list, add a section starting at a blank row with a count of total assets, count of "ready" assets, count of "failed" assets, and count of duplicates
The kind of audit that used to take a morning now takes a single prompt, and the output is already in the format your budget review actually needs.
Try It
Open a blank Google Sheet and Get the 7-day free trial of SheetXAI and ask it to pull your full Shotstack source asset inventory. When the list is in, ask it to flag the failed ones or the duplicates. See also: Ingest remote media files from your sheet into Shotstack and the Shotstack overview.