The Scenario
The product analytics lead's quarterly experiment review is at 9 AM. Her request arrived at 4:30 PM the day before: a single Excel workbook listing all 18 running PostHog experiments — name, feature flag key, status, start date, end date, and primary metric — so the team can decide which tests to extend, which to call, and which to kill. PostHog's UI shows experiments one at a time. There is no export button. She has this request every quarter and every quarter someone spends an hour clicking through the UI to build the sheet by hand.
The bad version:
- Click through each of 18 PostHog experiments, open each one, manually copy name, flag key, status, start date, end date, and primary metric into a workbook row
- Reach experiment 11 and realize "primary metric" appears under different labels for different experiment types, so the metric column is already inconsistent
- Share the workbook, get a reply that three start dates look wrong because you pasted them from a browser showing a different timezone than the team's reporting standard
Eighteen experiments, one click-through at a time, with a 4:30 PM request and a 9 AM meeting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls PostHog's experiments endpoint and writes every experiment's details into a worksheet in one operation — dates, statuses, and metrics included.
List all PostHog experiments in this project and write experiment name, feature flag key, status, start date, and end date into columns A through E.
What You Get
- Every experiment appears as one row — including those past the default UI page limit
- Dates are written as returned by the API in consistent ISO format
- Status values are written exactly as PostHog defines them
What If the Data Is Not Quite Ready
You also need primary metric and variant count
Fetch all running PostHog experiments and write experiment name, feature flag key, primary metric, variant count, and whether a holdout group is assigned into columns A through E of the 'Experiments Audit' worksheet.
You want to flag overdue experiments
List all PostHog experiments and write name, status, start date, and end date into columns A through D. In column E, write "Overdue" for any experiment where end date is before today but status is still 'running'.
You want only experiments with a specific flag prefix
Fetch all PostHog experiments and filter for only those where the feature flag key starts with 'checkout_'. Write experiment name, flag key, status, start date, and primary metric into columns A through E.
Full experiment audit with anomaly detection
Fetch all PostHog experiments. Write name, feature flag key, status, start date, end date, primary metric, and variant count into columns A through G of the 'Q2 Experiment Audit' worksheet. In column H, write: "Overdue" if end date is past today and status is running; "No metric" if primary metric is blank; "Single variant" if variant count is less than 2. Write a summary of flagged rows below the table.
Complete inventory, exception detection, and a pre-built review agenda — one prompt.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook before your next experiment review meeting, ask it to pull the full PostHog experiment list, and have the sheet ready before anyone needs to ask. Related: Export All PostHog Feature Flags Into an Excel workbook for Audit and the PostHog hub.