The Scenario
Six weeks into the analytics taxonomy cleanup project, a data analyst is stuck at the first step: getting the full list of PostHog saved insights into a workbook. PostHog has 55 of them. The UI paginates and doesn't include an export button. The analyst tried screenshotting the list and typing it up. She got through 20, then stopped when she realized the "creator" column wasn't visible from the list view — she'd need to click into each insight individually to find it. That's 55 individual clicks before the actual review work can begin.
The bad version:
- Click through PostHog's insights list page by page, open each insight to find creator and creation date (not shown in list view), copy name, type, tags, creator, and date into a workbook row
- Reach insight 31 and notice the "type" field is labeled differently across insights based on when they were created — "Trends" vs. "Trend" — so the type column is already inconsistent
- Finish the workbook across three sessions spanning two days, share it, and get a message that five insights marked as "unused" are embedded in live dashboards
55 insights, manually inventoried, takes two days and still produces errors. It's the wrong approach.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls PostHog's insights endpoint — handling all pagination — and writes every insight's details into your workbook in one operation.
List all saved insights in the PostHog project and write insight name, type, tags, creator, and created date into columns A through E.
What You Get
- Every saved insight appears as a row — no page limit, no clicking per insight
- Insight type is returned consistently from the API across all rows
- Creator and creation date are included without clicking into each insight
What If the Data Is Not Quite Ready
You want to flag insights with no tags
List all PostHog saved insights and write name, type, creator, and created date into columns A through D. In column E, write "No tags" for any insight where the tags field is empty.
You need to create insights from a definition workbook
Create a PostHog custom insight for each row in the 'Insights To Create' worksheet — name in column A, insight query JSON in column B — and write returned insight ID and short_id into columns C and D.
You want only funnel insights
Fetch all PostHog saved insights where type is "FunnelsQuery" and write insight name, short_id, creator, and created date into columns A through D of the 'Funnel Inventory' worksheet.
Full taxonomy audit with duplication detection
List all PostHog saved insights and write name, type, tags, creator, created date, and last modified date into columns A through F. In column G, mark any insight whose name is identical to another in the list as "Duplicate name - review." In column H, mark insights with no tags and no modification in the last 90 days as "Candidate for deletion." Write totals for each flag category at the bottom.
Complete inventory plus governance signals — one prompt.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, ask it to pull your full PostHog insights inventory, and hand it to the team the same morning. Also see: Export PostHog Dashboard Collaborators Into an Excel workbook for Access Audit and the PostHog hub.