The Scenario
A product manager has an Excel workbook with 12 natural-language product questions in column A — questions like "what is the 7-day retention for users who complete onboarding?" and "how many users activated the new dashboard feature in the last 30 days?" She wants PostHog AI insights generated for each one automatically and the short_ids written back so she can link them from the quarterly review deck. The alternative is opening PostHog 12 times, typing each question manually, waiting for generation, and copying the short_id by hand.
The bad version:
- Navigate to PostHog insights, click "New insight," select "AI insight," type question 1, wait, copy insight name and short_id, paste into the workbook — repeat 11 more times
- Reach question 7 and realize PostHog generated a FunnelsQuery for a question that warranted a RetentionQuery — you accept it, but the linked insight won't answer what the deck claims
- Finish all 12, check the workbook, discover you copied the same short_id for questions 4 and 5 because two PostHog tabs were open
Twelve questions, twelve UI round-trips, one error in the deck because of a wrong tab.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the questions from column A, submits each to PostHog's AI insight endpoint, and writes the returned insight name, ID, and query type back into the workbook.
For each question in column A of the 'Analytics Questions' worksheet, create a PostHog AI insight using the question as the query and write the returned insight name and short_id into columns B and C.
What You Get
- PostHog generates one AI insight per question in column A
- Columns B and C receive the insight name and short_id for each row
- The short_id links directly to the generated insight in your PostHog project
What If the Data Is Not Quite Ready
You also want the query type
For each question in column A, create a PostHog AI insight and write the insight name, short_id, and generated query type (TrendsQuery, FunnelsQuery, or RetentionQuery) into columns B, C, and D.
You want to skip blank rows
Read questions from column A. Skip rows where column A is empty. For all other rows, create a PostHog AI insight and write insight name and short_id into columns B and C.
You want results grouped by query type
Create PostHog AI insights for each question in column A. Write insight name, short_id, and query type into columns B through D. Then create a second worksheet named 'By Type' grouping results by query type — one section per type — with each insight's name and short_id listed underneath.
Full batch generation with validation and deck links
For each question in column A, create a PostHog AI insight. Write insight name, short_id, and query type into columns B through D. In column E, flag any insight where the query type does not seem to match the question intent. Then create a 'Deck Links' worksheet with two columns: question text and a PostHog URL as https://us.posthog.com/insights/[short_id].
All insights generated, query types reviewed, deck links built — one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you've been drafting product questions, ask it to generate PostHog AI insights for each one, and have short_ids ready to link from the review deck before the meeting. Also see: Export All PostHog Saved Insights Into an Excel workbook and the PostHog hub.