The Scenario
Your agency is switching DAM platforms. The migration vendor asks for a full inventory of every media asset currently stored in Planly: file names, types, IDs, and upload dates. They need it in a spreadsheet by end of week.
You have four client teams in Planly. Between them, there are something like 500 files — images, videos, GIFs. Nobody knows the exact count.
The bad version:
- Open the Planly media library for Team 1, start scrolling, note file names and types into a sheet by hand.
- Get to page 3 of the media library before realizing Planly paginates and you have no idea how many pages there are.
- Look for an export button. There isn't one. Go back to hand-noting.
- Repeat for Teams 2, 3, and 4.
You're a brand manager. You were supposed to spend this week on the new campaign brief. Instead you're building a file inventory by hand because nobody thought to make this easy.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you're working with, and through its built-in Planly integration it can walk your entire media library — handling pagination automatically — and write every asset into the sheet.
Open a Google Sheet, open the SheetXAI sidebar, and paste this prompt:
List all media files from my Planly team using pagination and write each file's ID, name, media type, and created date into columns A–D of the 'Media Inventory' sheet
What You Get
- Column A: Planly media ID
- Column B: file name
- Column C: media type (image/png, video/mp4, image/gif, etc.)
- Column D: created date (upload date)
- One row per asset, paginated automatically so nothing is cut off at page 1
- Assets across the full team library, not just the first visible page
What If the Data Is Not Quite Ready
You want to filter to only images (no video)
List all media files from my Planly team, filter to media type starting with 'image/', and write media ID (A), file name (B), media type (C), and created date (D) into the 'Media Inventory' sheet
You want to sort by upload date so you can see what's newest
List all media files from my Planly team using pagination, sort by created date descending, and write media ID (A), file name (B), media type (C), and created date (D) into the 'Media Inventory' sheet
You want to include the asset URL so the vendor can access the files directly
List all media files from my Planly team using pagination and write media ID (A), file name (B), media type (C), created date (D), and the asset URL or CDN link (E) into the 'Media Inventory' sheet
Full migration inventory: pull all assets across all teams, deduplicate by file name, add a row count, and flag assets older than 12 months
List all media files across all my Planly teams using pagination, deduplicate by file name keeping the oldest upload, write media ID (A), file name (B), media type (C), team name (D), created date (E) into the 'Media Inventory' sheet — flag any asset with a created date older than 12 months in column F as 'Archive candidate', and write the total asset count into cell H1
The migration vendor gets a clean, deduplicated inventory with archive candidates already flagged — no manual cleanup needed.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with a 'Media Inventory' tab, then ask it to pull every asset from your Planly media library. You can also check out how to bulk import media URLs or read the Planly hub overview.