Guides › Documents & Data
Turn survey responses into clear themes and actions
Collect answers with Google Forms or Microsoft Forms, then get the main themes, standout quotes and suggested actions from the comments.
When to use it
When a survey or feedback form closes
Step by step
Send responses to a sheet
In Google Forms, open the Responses tab and link it to a Google Sheet. Microsoft Forms can open responses in Excel.
Remove personal details
Make a copy of the sheet and delete columns with names, emails or anything that identifies people.
Ask for themes
Copy the response columns into your AI assistant (or upload the file) with this prompt.
Prompt to copyBelow are [number] responses to a survey about [topic]. For the open-text answers: 1) group them into 5 to 8 themes, with the number of responses in each, 2) give 2 short representative quotes per theme, 3) note any urgent or serious issues separately. For the rating questions, give the average and the spread. Finish with 5 suggested actions ranked by how many people they would help. Base everything on the responses; don't invent quotes. [paste responses]Check the counts
Scan the sheet for a couple of themes to make sure the numbers are roughly right, then share the summary with your team.
What you get
Themes: Parking (31 responses) - 'I circle for 15 minutes every Saturday'. Opening hours (22) - 'Please open before 9'. Friendly staff (40, positive)... Average rating 4.1/5. Action 1: trial an 8:30 opening on weekdays.
Tips
- Run the same prompt each time you repeat the survey so you can compare themes over time.