The Scenario
The brand refresh is scheduled for next month and the brand manager has handed you the first task: figure out what's actually in the DotSimple media library before anything gets replaced. There are 800 files in there — images, videos, thumbnails — uploaded across eighteen months by four different people. Nobody knows if there are duplicates. Nobody knows which ones are still in use. You need a workbook with every file before you can answer any of those questions.
The bad version:
- Open the DotSimple media library, scroll through tiles view, and try to record file names and URLs into an Excel workbook manually.
- Realize the library loads in batches of 50 and you have to scroll to load more, losing count of where you were.
- Spend two hours building an incomplete inventory, then hand it to the brand team with a disclaimer that it might be missing files from before 2024.
An 800-file audit isn't a task you do by hand. The brand team needs the full picture, not an approximation with caveats.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to DotSimple through its built-in integration and can walk the entire media library — all 800 files — and write the results into a worksheet in one pass.
Pull the complete DotSimple media library and paste each file's ID, name, thumbnail URL, and created date into the "Asset Audit" Excel tab.
What You Get
- The "Asset Audit" worksheet populated with one row per file.
- Columns: File ID, Name, Thumbnail URL, Created Date — in the order you asked.
- All 800 files returned, not just the first page.
- If a file is missing a field, that cell is blank but the row is still included.
What If the Data Is Not Quite Ready
I need to flag duplicates by file name
Pull the complete DotSimple media library and write file ID, name, thumbnail URL, and created date into the "Asset Audit" worksheet. Then add a "Duplicate Name" column — mark "Yes" if another row has the same file name, "No" otherwise.
I only want images, not videos
Pull all media files from my DotSimple workspace where type is "image" and write file ID, name, thumbnail URL, and created date into the "Image Inventory" worksheet.
I need files sorted by created date, oldest first
Pull the complete DotSimple media library and write file ID, name, thumbnail URL, and created date into the "Asset Audit" worksheet, sorted by created date ascending so oldest files appear at the top.
Full dedup + filter + flag + export in one shot
Pull all media files from my DotSimple workspace. Filter to images only. Flag any file name that appears more than once with "Duplicate" in a new column. Sort by created date ascending. Write the result into the "Brand Refresh Audit" worksheet with columns: File ID, Name, Thumbnail URL, Created Date, Duplicate Flag.
The pattern: combine the filter, the flag, and the sort in a single prompt instead of exporting first and processing after.
Try It
If you're preparing for a brand refresh or a media library cleanup, Get the 7-day free trial of SheetXAI and open an Excel workbook connected to your DotSimple workspace, then ask it to pull your full media inventory in one shot. See also how to pull email performance data or return to the DotSimple integration hub.