The Scenario
You're three weeks into a dashboard rebuild and you've just discovered that nobody documented the Keen IO schema.
Not a single tab. Not a Notion page. Nothing. You have 40-plus event collections, each with a different set of properties, and the only way anyone knows what's in them is by running API queries one at a time and reading the output.
Your dashboard infrastructure team needs a complete property registry — collection name, property name, inferred type, one row per property — before they can start mapping data to new visualization components. Without it, every chart spec is a guess.
The bad version:
- Open the Keen IO docs, find the schema endpoint, write a cURL command for each collection, and paste the JSON outputs somewhere you can read them.
- Parse the nested property arrays by hand — each collection returns properties as a key-value object inside a "properties" key that varies in depth depending on the collection.
- Paste the property names and inferred types into the workbook manually, one collection at a time, for 43 collections.
The dashboard team is waiting on you. You're also supposed to be reviewing the new charting library. Nobody hired you to maintain documentation that should have existed three years ago — but here you are.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and connects to Keen IO directly, so you can ask it to pull schema data the same way you'd ask a colleague — and it handles the API calls, the JSON flattening, and the row writing for you.
Open your schema registry worksheet and try this:
Fetch the schema for every event collection in my Keen IO project and write one row per property to this sheet with columns for collection name, property name, and inferred type. Start at row 2 with headers in row 1.
What You Get
- Row 1 headers: Collection Name (A), Property Name (B), Inferred Type (C)
- One row per property across all collections — 40 collections with an average of 12 properties each means roughly 480 rows written automatically
- Inferred types pulled directly from Keen IO's schema API — strings, numbers, booleans, lists surfaced as-is
- If a collection returns an error or has no properties, SheetXAI notes it in column D so nothing silently disappears from the registry
What If the Data Is Not Quite Ready
The collection list is wrong — you only want collections prefixed with "prod_"
Fetch the schema for every event collection in my Keen IO project whose name starts with "prod_" and write one row per property to this sheet with columns for collection name, property name, and inferred type.
Some collections have nested properties — you need a flat dot-notation name
Fetch the schema for every event collection in my Keen IO project. For nested properties, write the full path as dot notation (e.g. "user.plan_type") in column B. Write one row per leaf property with collection name in column A and inferred type in column C.
You want the registry filtered to only numeric and boolean properties
Fetch the schema for every event collection in my Keen IO project. Write only properties with an inferred type of "num" or "bool" to this sheet — one row per property with collection name, property name, and inferred type. Skip string properties.
Full kill chain: pull, filter, flag, and write a coverage summary
Fetch the schema for every event collection in my Keen IO project. Write all properties to Sheet1 (collection, property name, inferred type). On Sheet2, write a summary table showing how many properties each collection has, and flag any collection with fewer than 5 properties in column C as "Sparse—Review". Then add a total property count in cell D2 of Sheet2.
The pattern is to combine the data pull, the conditional logic, and the writeback into a single ask rather than running them as separate steps.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull your Keen IO schema registry in one shot. If you're also auditing cached datasets, check out the cached dataset audit spoke or the full Keen IO overview.