The Scenario
You are a content strategist. The content audit is due by end of week. Your job is to figure out which entries in the Contentful master environment are outdated, orphaned, or duplicated before the site migration.
You need a complete list in an Excel workbook: every entry, its content type, its title, and its publication status.
The bad version of this week:
- You ask the Contentful space admin to export the entries
- She runs a CDA query, gets back JSON, exports it to a CSV
- The CSV has no readable headers and timestamps in epoch milliseconds
- You spend two hours cleaning it in the workbook before you can even start the audit
- The export only includes published entries, not drafts
- You submit the audit report with no visibility into 30% of the entries in the environment.
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 API and writes the full inventory directly into the workbook, in a format you can work with immediately.
Open the SheetXAI sidebar and type:
List all entries in the Contentful master environment and write the entry ID, content type, title, and publication status into this workbook, starting in row 2 with headers in row 1. Include both published and draft entries.
SheetXAI calls Contentful, handles pagination, and writes every entry into the workbook. Published entries, drafts, and archived entries all show up with their status in column D.
What You Get
A complete Contentful entry inventory in the workbook:
- Column A — entry ID
- Column B — content type
- Column C — title
- Column D — publication status (Published, Draft, Archived)
- Headers in row 1 — ready to filter and pivot in Excel
Draft and archived entries are included, not just published ones.
What If the Data Is Not Quite Ready
Content inventories from large Contentful spaces come with their own complications.
When you only want entries of one content type
Get all entries of content type article from the Contentful master environment. Write the entry ID, title, author, and publication status to this workbook.
When you need the last-updated date for staleness analysis
List all entries in Contentful master and write the entry ID, content type, title, publication status, and last-updated date to this workbook. In a new column, mark any entry where the last-updated date is more than 180 days ago as "Stale."
When you need to cross-reference against a tracking tab
Pull all entry IDs from Contentful master and write them to a new tab called CMS Actual. Compare that list against the entry IDs in the Tracking tab column A. For any ID in Tracking that is not in CMS Actual, write it to a tab called Missing Entries.
When you need the full audit including content, staleness, and type distribution in one pass
List all Contentful master entries with entry ID, content type, title, publication status, and last-updated date. Write them to a tab called Full Inventory. Mark entries older than 180 days as Stale. Then add a Summary tab with a count of entries per content type, broken out by publication status.
The pattern: describe the audit you need and SheetXAI builds it directly in the workbook.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull your full Contentful entry inventory. The Contentful integration is included in every SheetXAI plan. For related workflows, see how to export the asset inventory or the Contentful in Excel overview.