The Scenario
You are a digital asset manager. A storage cleanup is scheduled for next Friday. Before anyone deletes anything, you need a complete list of every asset in the Contentful master environment: file name, content type, URL, and upload date.
The goal is to find duplicates and unused media in an Excel workbook.
The bad version of this week:
- You open Contentful, click Assets, and start scrolling
- Contentful loads 20 assets at a time
- You export the page as a CSV, get 20 rows, go to the next page, export again
- After an hour you have 12 CSV files covering about 240 of the 800 assets
- You paste them into the workbook and find the columns are in different orders in different exports
- You give up on the URL column and tell the team to skip the deduplication step.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls Contentful's asset API, handles pagination, and writes every asset into the workbook in a consistent structure.
Open the SheetXAI sidebar and type:
List all assets in the Contentful master environment and write the asset ID, file name, content type, file URL, and created date into this workbook, starting in row 2 with headers in row 1.
SheetXAI calls Contentful, pages through all 800 assets, and writes every one into the workbook with consistent column headers.
What You Get
A complete Contentful asset inventory in the workbook:
- Column A — asset ID
- Column B — file name
- Column C — content type (image/jpeg, video/mp4, application/pdf, etc.)
- Column D — file URL
- Column E — created date
All 800 assets, not just the first 20. Pagination is handled automatically.
What If the Data Is Not Quite Ready
Asset inventories from active Contentful spaces come with complications.
When you only need image assets
Get all image assets from the Contentful master environment and write the title, file URL, file size in bytes, and created date to this workbook.
When you want to flag potential duplicates
List all assets in the Contentful master environment with asset ID, file name, URL, and created date. In a column next to file name, write "Duplicate" for any file name that appears more than once. Write "Unique" for the rest.
When you need to filter by upload date range
List all Contentful assets created after January 1, 2025. Write the asset ID, file name, content type, and URL to this workbook.
When you need the full deduplication and orphan-check in one pass
List all assets in Contentful master with asset ID, file name, content type, URL, and created date. Flag duplicates where the file name appears more than once. Then check whether each asset URL appears in any published blogPost or article entry body. If it does not, mark it as Orphaned in a separate column. Write everything to this workbook.
The pattern: describe the audit you need and SheetXAI builds it. No CSV juggling, one clean workbook.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull your full Contentful asset inventory. The Contentful integration is included in every SheetXAI plan. For related workflows, see how to export the full entry inventory or the Contentful in Excel overview.