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 a complete list of every content type in the master environment: type ID, display name, and all field names with their types. The team told you the schema lives in Contentful and the closest thing to documentation is in a Google Sheet someone started six months ago and never finished.
The bad version of your first week:
- You open Contentful, navigate to Content model
- You click into the first content type, read the fields, and start typing them into the sheet
- You move to the next content type and repeat
- Around type six you realize the field types use Contentful's internal names, not the display names you assumed
- You go back and correct the earlier rows
- By type twelve your sheet has inconsistent column formatting and three types you accidentally duplicated
- You spend a full day documenting a schema that should have taken an hour, and the sheet 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 spreadsheet that calls Contentful's content type API and writes the full schema into the sheet, 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 sheet. 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 sheet in a consistent structure. One row per field, all 12 content types, all fields covered.
What You Get
A complete Contentful content type data dictionary in the sheet:
- Column A — content type ID (e.g.,
blogPost,product,author) - Column B — display name (e.g., "Blog Post," "Product," "Author")
- Column C — field name (e.g.,
title,price,category) - Column D — field type (e.g., Symbol, RichText, Integer, Link)
- Column E — required flag (true/false)
One row per field means you can filter by content type, sort by field type, or pivot to see how many RichText fields are across the whole schema. The data dictionary is ready to share with the team as soon as it is written.
If you want the validations column too—max length, allowed values—add that to the prompt and SheetXAI includes it.
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
You are building the query for the product type and only need its fields right now.
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 sheet.
When you need to compare the schema against the codebase field names
Your GraphQL queries use field names that may be stale. You want to see which schema field names differ from what is in the queries file.
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
The tech lead said some fields are deprecated but still in the schema. They have a deprecated prefix in their field ID.
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
The architecture review needs both the detailed schema and a count of field types across all content types.
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: you describe the documentation artifact you need—raw dump, comparison, summary—and SheetXAI builds it from the live Contentful schema.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, 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 Google Sheets overview.