The Scenario
The customer success manager sent the request on a Monday: export all NPS survey responses from the last quarter — respondent distinct_id, score, and comment text — into a Google Sheet so she can segment promoters (9-10), passives (7-8), and detractors (0-6) and hand the detractor list to the CSM team for follow-up calls. PostHog shows 300 responses. The UI lets you view them one at a time. There's no export button.
The bad version:
- Scroll through 300 NPS survey responses in PostHog's UI one by one, manually copy the distinct_id, score, and comment into a spreadsheet row for each
- Reach response 150 and realize that PostHog truncates long comment text in the list view — you've been copying incomplete comments for responses with more than 80 characters of feedback
- Finish the export after two and a half hours, hand it to the CSM team, and immediately get a message that the detractor segment has only 40 rows when there should be closer to 60 — you missed some during the manual transcription
Three hundred responses, manually transcribed, with a teammate waiting. This is what people do when they don't know there's a better way.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads PostHog's survey responses endpoint and writes every response — with full comment text — into your sheet in one operation.
Export all responses to PostHog survey ID survey_xyz and write respondent distinct_id, submission date, NPS score, and comment text into columns A through D of the 'NPS Responses' sheet.
What You Get
- All 300 responses appear as rows — distinct_id, submission date, score, and full comment text
- No comment truncation — PostHog returns the full text via API even when the UI clips it
- The sheet is immediately ready for segmentation by score range
What If the Data Is Not Quite Ready
You want automatic promoter/passive/detractor segmentation
Export all responses to PostHog survey ID survey_xyz and write distinct_id, submission date, NPS score, and comment text into columns A through D. In column E, write 'Promoter' for scores 9-10, 'Passive' for 7-8, and 'Detractor' for 0-6.
You only want responses from the last quarter
Export PostHog survey responses for survey ID survey_xyz where submission date is between 2026-01-01 and 2026-03-31. Write distinct_id, submission date, score, and comment into columns A through D of the 'Q1 NPS' sheet.
You want to cross-reference respondents with plan tier from another tab
Export PostHog survey responses for survey ID survey_xyz into columns A (distinct_id), B (score), C (comment). Then join against the 'Users' tab (distinct_id in column A, plan tier in column B) and write each respondent's plan tier into column D. Write 'Unknown' for respondents not found in the Users tab.
Full NPS export with segmentation and CRM-ready hand-off format
Export all responses to PostHog survey survey_xyz. Write distinct_id, submission date, score, comment text, and NPS segment (Promoter/Passive/Detractor) into columns A through E of the 'NPS Export' sheet. Then create a second tab named 'Detractors' containing only the rows where segment is 'Detractor', sorted by submission date descending. Add a column F in 'Detractors' with the text 'Needs follow-up call'.
One prompt produces both the full export and the CSM action list.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, ask it to pull your PostHog NPS survey responses, and have the segmented list ready for the CSM team before their standup. Also see: Export PostHog Event Definitions Into a Google Sheet for Governance and the PostHog hub.