The Scenario
You are a data engineer who just joined a company. Your first week task: document the main Airtable base, called Operations Hub, before you build any pipelines on top of it.
The base has 8 tables. You need a data dictionary showing every table, every field name, every field type, and any description attached to the field. You need this in a Google Sheet so the rest of the team can annotate it and the BI lead can use it to spec the warehouse schema.
What documenting this manually looks like:
- You open Airtable, click the first table, click the field editor for each field
- You copy the field name, field type, and description (if any) into a sheet row by row
- Eight tables, forty-plus fields per table on average — you spend most of Wednesday doing this
- You miss three fields because they were hidden in the view you were browsing
- The BI lead sends back a Slack saying two tables are missing from the dictionary.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI calls the Airtable metadata API, reads the full schema of every table, and writes it into the sheet, including hidden fields.
Open the SheetXAI sidebar and type:
Get the full schema of my Airtable base 'Operations Hub' and write each table name, field name, and field type as a row in this sheet. Add a header row with columns: Table, Field Name, Field Type, Description. Include hidden fields.
SheetXAI calls the Airtable API's base schema endpoint, reads all 8 tables and every field in each, and writes the data dictionary into the sheet with one row per field.
What You Get
A complete data dictionary in the sheet:
- One row per field — table name, field name, field type, description
- All 8 tables covered — nothing skipped, nothing missed because of view filters
- Hidden fields included — the API returns all fields regardless of view visibility
- Field types in Airtable's own vocabulary — singleLineText, multipleRecordLinks, date, singleSelect, etc.
The whole thing takes as long as it takes the API to respond. Not a Wednesday afternoon.
Once the dictionary is in the sheet, you can sort by field type to find all date fields, filter to a specific table, or add annotation columns for the BI lead to fill in.
What If the Data Is Not Quite Ready
Schema documentation has its own wrinkles. SheetXAI handles them in the same prompt.
When the base ID is not the friendly name but a cryptic string in a URL
You have the Airtable URL open but you are not sure which part is the base ID.
The Airtable base URL is in cell A1. Extract the base ID from that URL and use it to fetch the full schema of the base. Write each table, field name, and field type as a row in this sheet.
When you want the dictionary organized by table with a blank separator row between tables
Flat rows work for filtering but the BI lead wants it visually grouped.
Get the schema of my Airtable 'Operations Hub' base. Write the data dictionary with a blank row between each table, and bold the table name in the first row of each table's section.
When you want to compare two bases to find schema differences
You have a staging base and a production base and need to know which fields differ.
Get the full schema of my Airtable base 'Operations Hub (Staging)' and write it into the Staging tab. Get the full schema of 'Operations Hub (Production)' and write it into the Production tab. In the Diff tab, list any field that exists in one base but not the other, and any field where the field type differs between the two.
When you want the schema plus a sample of actual record values for each field
The BI lead wants to know not just the field type but what values are actually in the table.
Get the schema of my Airtable 'Operations Hub' base. Write the data dictionary into this sheet. Then for each text and single-select field, pull up to 5 distinct sample values from the first 100 records in that table and add them as a comma-separated list in a Sample Values column.
The pattern: one prompt to the Airtable metadata API gives you what would take half a day of clicking through field editors.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask SheetXAI to pull the schema from any Airtable base you have access to. The Airtable integration is included in every SheetXAI plan. See also how to export filtered Airtable records into a sheet or the Airtable in Google Sheets overview.