The Scenario
Three months ago, someone on the platform team set up a Fillout database with a handful of tables. Since then, the database has grown — more tables, renamed fields, new field types. Now the data engineering team needs a data dictionary: every database, table, field name, and field type, documented in a Google Sheet so it can be included in the technical specs for the next integration project.
There's no "export schema" button in Fillout.
The bad version:
- Open each Fillout database in the UI, click into each table, and read field names and types from the field settings panel
- Type each one into the sheet manually — database name, table name, field name, field type — for every field in every table
- Miss a field because it wasn't visible in the scroll, and discover the gap when the integration engineer asks about a field that's not in the dictionary
A platform with a dozen tables and thirty fields takes the better part of an afternoon this way.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the Fillout API to enumerate databases and their schemas, then writes the full data dictionary into the sheet with no manual typing.
List all my Fillout databases, fetch the schema for each table in each database, and write database name, table name, field name, and field type into this sheet starting at row 2, with those four labels as column headers in row 1
What You Get
- Row 1 with headers: Database Name, Table Name, Field Name, Field Type
- One row per field in the schema — every database, every table, every field enumerated
- Field types as returned by the Fillout API (text, number, date, select, etc.)
- The sheet sorted by database name and then table name, making it scannable
What If the Data Is Not Quite Ready
You only need the schema for one specific database, not all of them
Pull the full schema for my Fillout database 'CRM' and write each table and its field definitions into this sheet — one row per field with columns for table name, field name, and field type
You want a column that flags which fields are required vs. optional
List all my Fillout databases, fetch the schema for each, and write database name, table name, field name, field type, and whether the field is required (Yes/No) into this sheet — one row per field
The schema will be shared with a team that doesn't know Fillout — add descriptions
Fetch the schema for my Fillout database 'CRM', write table name, field name, and field type into this sheet, and in a fourth column write a plain-English description of what each field type means (e.g., 'select' → 'Single choice from a predefined list', 'text' → 'Free-form text entry')
Full audit in one shot: schema export, duplicate field detection, and summary counts
List all my Fillout databases, fetch schemas for all tables, write the full data dictionary to this sheet, highlight in column E any field name that appears in more than one table, and add a summary section at the bottom with the total count of databases, tables, and fields
The pattern: schema export and analysis happen in the same prompt — you're not pulling the data first and analyzing it in a second pass.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet for your data dictionary, then ask it to pull the full Fillout schema into the sheet. When the schema changes next quarter, run the same prompt again. The spoke on provisioning a Fillout database from a schema sheet covers the reverse direction — and the hub overview lays out all four methods.