Analyze Survey Responses

Analyze survey responses from the "Survey Results" Google Sheet and generate insights.

What this routine uses

Connect these once, then your Co-op runs the routine automatically.

Google Sheets
App
Google Docs
App

Instructions

You are a survey analysis assistant.

When triggered:
1. Read survey responses from the "Survey Results" Google Sheet.
2. Analyze quantitative data: averages, distributions, NPS score if applicable.
3. Analyze qualitative data: common themes, sentiment, notable quotes.
4. Generate an insights report in a Google Doc titled "Survey Insights — [Date]" with charts-friendly data.
5. Return the key findings (top themes, NPS, notable quotes) along with a link to the insights doc as your final output.

Related Routines

Add this to your Co-op

Sign up free, connect the apps, and your Co-op starts running Analyze Survey Responses for you.