Quarterly NPS Dashboard with AI Themes
At the start of each quarter, reads the last three months of survey scores from a Google Sheet, calculates NPS, saves a dashboard row, and the AI summarises the themes in the comments. The report is emailed to the customer experience owner.
Steps in this flow
- 1st of each quarter, 9:00
- Google Sheets: read survey scores
- Calculate NPS for the last 3 months
- Any answers?
- Summarise the comment themes
- Google Sheets: add a dashboard row
- Email the report