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

  1. 1st of each quarter, 9:00
  2. Google Sheets: read survey scores
  3. Calculate NPS for the last 3 months
  4. Any answers?
  5. Summarise the comment themes
  6. Google Sheets: add a dashboard row
  7. Email the report

All templates