The Scenario
You are a product analyst. The data governance review with engineering is Friday. Your Amplitude project has 80 user properties accumulated over three years. Some were set up by the original engineering team and have no documentation. Some are redundant. Some may no longer be populated.
You need to pull the full user property list — name, type, description, and whether it is a default or custom property — into a Google Sheet before Friday, so the team can audit, annotate, and decide what to clean up.
The slow version:
- Open Amplitude, navigate to User Properties in the Data tab
- Page through the list manually, there is no obvious "export all properties" button
- Copy-paste names and descriptions row by row into a sheet
- Fill in type and default/custom status manually because the export does not include those cleanly
- Three hours in, you have covered 40 of the 80 properties and engineering needs the sheet now.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to Amplitude's User Properties API and writes the full property list into your sheet in one pass.
Open the SheetXAI sidebar and type:
List all user properties from Amplitude and write property name, type, description, and whether it is a default or custom property into columns A–D. Add a header row.
SheetXAI calls the Amplitude Data API, pulls all 80 user properties, and writes the structured table. The governance review has its input document by Thursday morning.
What You Get
A complete user property table with four columns:
- Column A — user property name (all 80, one per row)
- Column B — property type (string, number, boolean, array, etc.)
- Column C — property description from Amplitude's data dictionary
- Column D — whether it is a default Amplitude property or a custom property your team created
Every user property in the project is represented, including ones that have not been documented in years. Blank descriptions in column C are findings, not gaps to fill in later.
What If the Data Is Not Quite Ready
Property documentation audits are valuable precisely because the data is messy. SheetXAI handles the enrichment in the same prompt.
When you want to flag properties with no description
Missing descriptions are the first thing engineering should be asked to fix.
List all user properties from Amplitude and write name, type, description, and default/custom status into columns A–D. In column E, write "UNDOCUMENTED" for any property where the description is blank. Write the total count of undocumented properties into cell G1.
When you want to separate default properties from custom ones for easier review
The default properties are Amplitude-managed and do not need documentation review. You only want the custom ones.
Pull the complete Amplitude user property list. Filter to custom properties only (exclude default Amplitude properties). Write name, type, and description into columns A–C. Sort by name ascending.
When you want to cross-reference which properties have no recent data
A property that has not been populated for 90 days is a candidate for deprecation.
List all user properties from Amplitude and write name, type, description, and default/custom status into columns A–D. Pull each property's last-seen date (most recent date a value was set) and add it to column E. Flag any property not seen in the last 90 days with "STALE" in column F.
When you need the full list, missing-description flags, stale flags, and a summary count all in one pass
The governance review template requires the property table and a summary header.
Pull the complete Amplitude user property list and write name, type, description, and default/custom status into columns A–D. In column E, flag any property where description is blank as "UNDOCUMENTED". Pull last-seen date into column F and flag any property not seen in 90 days as "STALE" in column G. Write a summary in cell I1: total properties, total undocumented, total stale.
The pattern: the full audit — list, enrichment, flagging, and summary — happens in one prompt. You walk into the governance review with an actionable document instead of a half-finished copy-paste job.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull the full Amplitude user property list with whatever enrichment and flagging the review requires. The Amplitude integration is included in every plan. For related workflows, see how to export the event taxonomy for audit or the Amplitude in Google Sheets overview.