The Scenario
You are a developer who just joined a new project. The product is built on Contentful and the codebase references a dozen content types. Your first task is to understand the data model before you can write the new API queries.
You need every content type, every field name, every field type, and the required flags, all in an Excel workbook.
The bad version of your first week:
- You open Contentful, navigate to Content model, and start reading field definitions into the workbook by hand
- Around type six you realize the field types use internal Contentful names, not the display names you assumed
- You go back and correct the earlier rows
- By type twelve your workbook has inconsistent column formatting and three types duplicated
- You spend a full day documenting a schema that should have taken an hour, and the workbook is still wrong in places.
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 content type API and writes the full schema into the workbook, field by field.
Open the SheetXAI sidebar and type:
Get all content types from the Contentful master environment and write the content type ID, display name, and list of field names with their types and required flags into this workbook. Use one row per field, with the content type ID and display name repeated for each field row.
SheetXAI calls Contentful, reads every content type and every field definition, and writes the full schema to the workbook in a consistent structure.
What You Get
A complete Contentful content type data dictionary in the workbook:
- Column A — content type ID
- Column B — display name
- Column C — field name
- Column D — field type (Symbol, RichText, Integer, Link, etc.)
- Column E — required flag (true/false)
One row per field. Filter by content type, sort by field type, or pivot to see the distribution across the whole schema. Excel's table features work directly on this output.
What If the Data Is Not Quite Ready
Schema documentation tasks often need more than a raw dump.
When you only need the schema for one content type
Get the content type schema for the product content type in Contentful master. Write the field name, field type, required flag, and any validation rules to this workbook.
When you need to compare the schema against codebase field names
Get all field names for the article content type from Contentful master and write them to column A of a tab called Schema. Then compare column A against the field names listed in the Queries tab column A. Write any field name that is in Schema but not in Queries to a tab called Schema Drift.
When you need to flag deprecated fields
Get all content types from Contentful master with field ID, display name, field type, and required flag. Flag any field where the field ID starts with "deprecated" in a new column called Status.
When you need the full schema export plus a summary of field type distribution in one pass
Get all content types from Contentful master. Write the full field schema to a tab called Schema Detail with one row per field, including type ID, display name, field name, field type, and required flag. Then add a Summary tab that counts how many fields of each type exist across all content types.
The pattern: describe the documentation artifact you need and SheetXAI builds it from the live Contentful schema.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to export the full Contentful content type schema. The Contentful integration is included in every SheetXAI plan. For related workflows, see how to export the full content inventory or the Contentful in Excel overview.