Idea or playbook

Customer Feedback and Survey Summaries with AI Agents

For: Customer service · Difficulty: Beginner

The problem: You asked customers for feedback, and they told you. Now you've got a spreadsheet full of comments and no time to read them all.

What you end up with: A one-page summary of what customers are saying: the top themes, a few real quotes for each, and a short list of ideas to act on.

What you'll need

Your survey results or feedback comments in a spreadsheet or document, with personal details removed if you can.

Getting set up

Collected survey answers but haven't had time to read them all? Here's how to tackle it, based on each tool's official docs. First, pick a tool. Microsoft says Copilot in Excel can analyze data and pull out insights. Google says Gemini in Sheets can work with your data using plain-English prompts, and Gemini Notebook can turn your own files into insights. Dust lists performance analysis and report drafting among its uses. Next, put all the feedback in one place. Then, remove names, emails, and phone numbers if you can. And last, treat the summary as a starting point. You decide what to change.

Step by step

  1. Give the agent your feedback file.
  2. Ask it to group comments into five to eight themes.
  3. Have it count roughly how many comments fit each theme.
  4. Ask for two or three real quotes per theme, copied exactly.
  5. Have it list a few ideas to act on, based only on the feedback.
  6. Read through some original comments to check the themes feel right.
  7. Share the summary with your team and pick one thing to improve.

A prompt to start with

Copy this prompt, then make it your own. "Here are our customer survey comments. Group them into 5 to 8 themes, with a rough count for each. For each theme, include 2 or 3 quotes copied exactly from the comments. Then list up to 5 ideas to act on, based only on what customers said. Don't include names or contact details. If a comment doesn't fit, put it under 'other.'"

What you'll get

A one-page summary with themes, rough counts, exact quotes, and a short list of ideas.

If something goes wrong

If themes feel too broad, ask it to split the biggest one. If quotes look reworded, remind it to copy them exactly. If counts seem off, spot-check a theme yourself.

Keep in mind

Rough counts are a guide, not exact statistics. Remove personal details before sharing feedback, and be careful about quoting customers publicly without permission.

Sources

Where each fact came from

Heads-up: some links here may become affiliate links down the road. Here's how that works. Right now, no affiliate programs are connected.