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 workbook by hand.
- Fetch the next page, do it again.
- Repeat until you have all assets listed, then manually sort the workbook 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 workbook 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 Excel workbook. It retrieves the full list of source assets from your Shotstack account and writes each asset's details into the workbook — including IDs, URLs, statuses, and creation dates.
Retrieve all ingested sources from my Shotstack account and populate my Excel sheet with source ID, file URL, and current status (ready/failed) for each asset
SheetXAI calls Shotstack's list sources endpoint, handles pagination, and writes every asset's source ID, file URL, and status into the workbook.
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.
- 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 source ID, file URL, and status into columns A through C
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 source ID, file URL, and status into columns A through C — then in column D, mark any row whose file 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 source ID, file 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 source ID, file URL, status, and creation date into columns A through D — flag duplicate file URLs with "duplicate" in column E — then below the main list, add a section 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 Excel workbook 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 workbook into Shotstack and the Shotstack overview.