The Scenario
You're the creative ops coordinator for a brand that's been running Snapchat ads for two years. The Snapchat ad account has accumulated 200-plus video and image assets, many of them from campaigns that ended six months ago. Your agency wants to archive anything that's been inactive or unused so the creative library is manageable before the next campaign build. The problem: there's no bulk export from the Media Library in Ads Manager.
The bad version:
- Click through the Media Library in Ads Manager — there's pagination, and assets only show in batches of 20.
- Copy each asset's ID, name, type, and status manually into a sheet. Ten at a time. For 200+ assets.
- Halfway through, realize that "Approved" and "Active" mean different things in Snapchat's media taxonomy and you don't actually know which status maps to "in use."
This task should take ten minutes. It's going to take an afternoon if you do it by hand.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that can query the Snapchat Marketing API and pull your entire media library into the sheet in one call.
List all media assets in Snapchat ad account abc123 and write media ID, name, type, and status into columns A through D of the Media Audit tab
What You Get
- One row per media asset, all pages fetched — no 20-at-a-time batching
- Column A: media ID
- Column B: asset name as uploaded
- Column C: type — IMAGE or VIDEO
- Column D: status as returned by the API (Active, Approved, etc.)
- Everything you need to filter, sort, and flag candidates for archiving
What If the Data Is Not Quite Ready
You want to include the upload date so you can filter by recency
List all media assets in Snapchat ad account abc123 and write media ID, name, type, status, and upload date into columns A through E of the Media Audit tab, formatting the date as YYYY-MM-DD
You only want to see video assets, not images
Fetch all media files from Snapchat ad account abc123 where type is VIDEO and write media ID, name, and status into columns A through C
You want to cross-reference against active ads to find unused assets
List all media assets from Snapchat ad account abc123 — media ID in column A, name in B, type in C, status in D — then check each media ID against the active ads in the account and write In Use in column E for any asset currently referenced by an active ad, and Unused in column E for those that aren't
Full archival prep: all assets, age flag, and a prioritized cut list
Fetch all media from Snapchat ad account abc123 — media ID in A, name in B, type in C, status in D, upload date in E — then write Archive Candidate in column F for any asset uploaded more than 6 months ago that has status Approved but no active ad reference
The sheet becomes the briefing doc for what to archive, built in one pass.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you're using for the creative library cleanup, then ask it to export all media assets from your Snapchat ad account. Related: analyzing ad creative performance, and the hub overview for all Snapchat workflows.