Summarize Customer Feedback Responses with Gemini in Google Forms
For Franchise Owner-Operator (Service Business)s ·
What This Does
After a job, you send customers a short feedback form. A month later you have a pile of written answers and no time to read them all. Gemini in Google Forms can summarize the answers to each open text question and group them into themes. You get the gist in minutes. Before you act on any theme, read the raw answers behind it.
Before You Start
- A Google Form with at least one open text question, such as "What could we do better?"
- Enough responses. Google's help page says summaries appear once there are 3 to 200 responses, and theme generation works best with 8 to 200 responses
- Your plan includes Gemini in Forms. Google's page says it requires an eligible Google Workspace or Google AI plan. Plan details are at workspace.google.com
Data caution. Build the form so it does not ask for a name, phone number or address unless you truly need it. Tell customers in the form's description how you will use their answers. Free-text answers sometimes include personal details anyway, so read them before you share a summary outside your business. Check your Google account's Gemini settings for whether content is kept or used to improve models, and ask your franchisor if the brand has its own customer survey rules.
Steps
1. Open the responses
- On your computer, open your form in Google Forms.
- At the top, click Responses.
- In the summary block, summaries for each text question are generated automatically.
Google's page says summaries are not generated for direct questions such as names and addresses, and not for quiz responses.
2. Read and copy the summary
Read the summary under each text question. To copy it, click Copy. To get a new version, click Retry. If new responses arrive while you have the summary open, click Refresh with latest responses.
Google's page says the generated summaries are not saved. Copy one into your own notes if you want to keep it.
3. Look at themes in Sheets
- Scroll to a text question.
- Below the question's summary, click See theme percentages.
- To change the themes, click Modify themes. Then click Add to add a theme or Delete category next to a name to remove one.
Google's page says the system then opens a new Google Sheet with a pie chart and a count of how many responses fall under each theme. If you see an error in the Sheets side panel, click Refresh & Generate. If you have more than 200 responses, the page says the theme option becomes unavailable.
4. Read the raw responses behind each theme
This step matters most. For each theme you plan to act on:
- Go back to the Responses tab and read the actual answers that fit the theme.
- Check that the theme describes what customers said, not what the summary guessed.
- Pick out anything the summary smoothed over, such as one very specific complaint.
Real Example
Scenario: You send a form to every customer after a visit from [Your Brand] (invented). There are 24 responses to "What could we do better?"
What you do: Open Responses and read the summary. Then click See theme percentages and look at the Sheet it creates.
What you get: A short summary, a few themes with counts, and a pie chart. Suppose one theme is about arrival times. You open the 24 raw answers, find those that mention timing, and read them one by one before you change anything.
Tips
- Ask one open question per topic. "What could we do better?" gets more usable answers than "Any comments?"
- A summary tells you what to look at. It does not tell you what to do. Deciding about a refund, credit or staff conversation stays with you.
- Do not paste customer answers into a different chatbot. Work inside the form and its Sheet.
- Keep a dated copy of each month's summary in your own notes.
Tool interfaces change. If a button has moved, look for similar AI options in the same menu area.