The Scenario
The quarterly experiment review is scheduled for 9 AM tomorrow. Your product analytics lead needs a single sheet showing 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. She sent a Slack message at 4:30 PM asking for the spreadsheet by EOD. The PostHog UI shows experiments one at a time. There is no built-in export button.
The bad version:
- Click through each of the 18 experiments in PostHog, manually copy the name, flag key, status, start date, end date, and primary metric into a spreadsheet row
- Reach experiment 11 and realize "primary metric" means different things across tests — some use conversion rate, some use average value — and the field label in the UI changes based on metric type, so you've been copying inconsistently
- Finish the sheet, share it, get a reply that the start dates look wrong because PostHog displayed them in your browser's local timezone and you pasted them without converting
Eighteen experiments, manually transcribed, with a 4:30 PM ask and a 5:30 PM EOD target. That math doesn't work if you're clicking through a UI.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads PostHog's experiments endpoint and writes every experiment's details into your sheet in one call — 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 (running, complete, draft) 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' sheet.
You want to flag experiments running past their planned end date
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 to export only experiments with a specific feature 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 tagging in one pass
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' sheet. 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 experiments below the table.
Complete experiment inventory with exception detection — one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet before your next experiment review meeting, then ask it to pull the full experiment list from PostHog. Related: Export All PostHog Feature Flags Into a Google Sheet for Audit and the PostHog hub.