Summarise and analyse responses with Gemini in Google Forms

Feature availability:

• This feature requires an eligible Google Workspace or Google AI plan. Learn how to get started with Google Workspace with Gemini.
• This feature is also available through our trusted tester programme, Google Workspace Experiments.
• Learn about supported languages for Google Workspace with Gemini.

You can use Gemini to summarise the responses to open text questions in your Google Forms.

Use Gemini to summarise responses

Important:

• You can find generated summaries once there are 3 to 200 responses.
• You can't generate summaries for quiz responses.

To find the summary to a question's responses:

1. On your computer, open a form in Google Forms.
2. At the top, click Responses.
   • In the summary block, summaries for each text question are generated automatically.
3. Optional:
   • To generate a new response summary, click Retry.
   • To copy the summary, click Copy.

Tips:

• If you get new responses while the summary is open, click Refresh with latest responses to refresh the summary.
• The generated summaries aren't saved. You can copy or generate them again.
• Summaries won't be generated for direct questions, like names and addresses.

Generate and refine themes from responses

With Gemini, you can identify, group and analyse common themes from Google Forms text responses in Google Sheets.

Important:

• This feature works best with 8 to 200 responses.
• If your form has more than 200 responses, the theme generation option will become unavailable. The button will appear greyed out and the system will display an error message.
• Themes are generated with AI functions in Google Sheets; learn about AI function limits here.

1. On your computer, open a form in Google Forms.
2. At the top, click Responses.
3. To generate themes for a text question, scroll to the text question.
4. Below the question's summary, click See theme percentages .
5. To modify themes, click Modify themes.
   • To add a theme, click Add .
   • To delete a theme, next to the name, click Delete category .

6. To get a more detailed analysis, click See theme percentages .
   • The system will open a new Google Sheet that includes:
     • A pie chart that visually represents the distribution of themes.
     • A summary response theme count that shows how many responses are associated with each theme.
   • If you encounter an error, click Refresh and generate in the Sheets side panel.

Tip: If the number of responses is fewer than or equal to 8 or over 500, the summary will be shown but the button will be greyed out.

Get actionable insights from responses

You can use actionable insights to help you understand key takeaways and insights, as well as to recommend next steps based on responses to all question types.

Important:

• The feature isn't available for forms when you turn on 'Quiz settings'.
• Your form must have a minimum of 12 responses and 3 questions.
• This feature isn't available if the form has a linked sheet that you do not have access to.

1. On your computer, open a form in Google Forms.
2. At the top, click Responses.
3. On the Responses tab, locate the Actionable insights section.
4. Click Generate insights.
5. To review the generated insights, click Analysis steps . The generated insights consist of several takeaways and recommendations, like:
   • Executive synthesis
   • Advanced analysis and correlations
   • Recommended next steps

Optional: Below the generated insight:

• To provide feedback, select Good suggestion or Bad suggestion . A pop-up screen will appear with information that you can share with your feedback about 'Prompt' and 'Output'.
• To generate new insights, click Retry .

Give feedback on this feature

• To provide feedback on the generated input of this feature, click and follow the prompts.
• To provide general feedback on this feature, at the top, go to Help Help Docs improve.
• To report a legal issue, learn how to report content for legal reasons.

Learn about Gemini feature suggestions

• Gemini feature suggestions don't represent Google's views and should not be attributed to Google.
• Don't rely on Gemini features as medical, legal, financial or other professional advice.
• Gemini features may suggest inaccurate or inappropriate information. Your feedback makes Gemini more helpful and safe.
• Enterprise end users can submit feedback about their experience using this feature. End users are informed before they submit feedback that the feedback data shouldn't contain personal, sensitive or confidential information.

Related resources

• Get started with Google Workspace with Gemini
• How to use Google Forms
• Edit your form