Actionable insights, the new Gemini feature in Google Forms, analyzes a form's responses, finds key trends and recommends next steps. It sits on the Responses tab next to two other Gemini tools covered by the same Google help page: automatic summaries of text answers, and themes that group those answers. All three can help eligible users summarize and explore form responses.

How the insights feature works

Google's November 5 announcement says Gemini analyzes the responses by writing and running Python code, so counts, percentages and comparisons come from the actual response data. It also looks for patterns and cross-question correlations, then summarizes the main takeaways and suggests next steps. The help page says the insights draw on responses to all question types, not only text.

The output is organized into sections such as Executive Synthesis, Advanced Analysis & Correlations, and Recommended Next Steps. Google says to select Analysis steps to review the generated insights, and Retry generates a new set.

Running code helps with the arithmetic, not the judgment. Which responses were counted, how answers were grouped and what a pattern means are still Gemini's choices. Google's help page warns that Gemini features may suggest inaccurate or inappropriate information and should not be relied on as professional advice.

Google suggests the feature for event and product feedback, research surveys, and registration or application forms. It helps most when the decision is about a pattern and nobody has time to read every response. For applications, use it for the overall picture, such as who is applying, not to screen individuals.

Three tools with three sets of limits

Google's help page gives each tool its own requirements:

  • Summaries appear automatically for each text question once a form has 3 to 200 responses. They skip direct questions such as names and addresses, do not cover quiz responses and are not saved.
  • Themes start from See theme percentages below a question's summary. Google says they work best with 8 to 200 responses, and the button is grayed out at 8 or fewer.
  • Actionable insights needs at least 12 responses and 3 questions. It is unavailable when Quiz settings is on, or when the form has a linked sheet you do not have access to.

The page gives two upper cutoffs for themes, 200 in one place and 500 in another, so expect themes to be unavailable on large forms. It lists a minimum for actionable insights but, unlike the other two tools, no maximum. Quiz mode is the Make this a quiz switch under the form's Settings, so a quiz gets neither summaries nor actionable insights.

For a more detailed theme analysis, Google says selecting See theme percentages again opens a new Google Sheet with a pie chart and a count of responses for each theme. Themes are generated with the AI function in Google Sheets, which Google says has short-term and long-term generation limits. If the sheet shows an error, select Refresh & Generate in the Sheets side panel; after a long-term limit, Google suggests waiting 24 hours and trying again.

Who gets it and when

Google lists Business Standard and Business Plus among the eligible editions, along with Enterprise Standard and Plus, Education Plus, two education add-ons and consumer Google AI plans, including Pro and Ultra. Business Starter is not on the list. An admin with the Billing management privilege can confirm your edition in the Admin console under Billing, then Subscriptions.

The gradual rollout began November 2 for Rapid Release domains and is scheduled to start November 19 for Scheduled Release domains. Google's gradual rollouts allow up to 15 days for feature visibility, so some Scheduled Release users may not see the feature until early December.

To check your release track, an admin with the Domain settings administrator privilege can open the Admin console, go to Account, then Account settings, then Preferences, and select New features under Release preferences. Google's steps for changing the track continue from there: select Rapid release or Scheduled release, then Save.

Switching tracks for one feature is rarely worth it. Google says Rapid Release cannot be set for a child organizational unit, a group, a secondary domain or a domain alias, so it applies to the whole account, and moving back to Scheduled Release might cost users features they already have.

Check the admin settings first

Google's announcement says users need smart features and personalization turned on to use Gemini in the side panel of Workspace apps. A super administrator sets the default in the Admin console under Account, then Account settings, then Smart features for Google Workspace. The relevant setting is Smart features in Google Workspace, which Google says covers Google Workspace with Gemini.

The choices are Don't set a default experience, which leaves it to each user, or Set a default. Picking Set a default without choosing any options leaves no default in place. Google says changes can take up to 24 hours, and the features start on by default except for domains in the European Economic Area, Japan, Switzerland or the UK.

A default is not a lock. Users can override it in their own settings, and someone who has turned smart features off cannot use the experiences the setting covers. In Gmail on a computer, the switch is under Settings, then See all settings, then the General tab, where Manage Workspace smart feature settings sits under Google Workspace smart features.

Enterprise Standard and Enterprise Plus, along with some education editions, add a per-service control. An admin with the Gemini Settings administrator privilege can go to Generative AI, then Gemini for Workspace, open the Feature access panel and turn Gemini off for everyone, an organizational unit or a configuration group. Google lists Forms in one entry with Drive, Docs, Sheets, Slides, Drawings and Vids, so the switch is not specific to Forms. Business Standard and Business Plus are not among the editions Google lists for that control, so on those plans, rely on the smart features setting and on who can edit each form.

When the insights button is missing

If a form should qualify but you cannot generate insights, open it on a computer, since Google's steps start there, and check the requirements in this order:

  • Rollout timing for your release track, including the 15-day window.
  • Your edition, which must be on Google's list.
  • Smart features in Google Workspace, both the admin default and the user's own switch.
  • At least 12 responses and 3 questions, with Make this a quiz off.
  • Access to the form's linked response sheet.

The linked sheet is the least obvious item. Google says form collaborators automatically get access to a response spreadsheet when it is created, but later permission changes on the form do not carry over. A colleague added to the form afterward may be unable to open the sheet, and therefore unable to generate insights.

Ask the sheet's owner to share it rather than unlinking it. Google says unlinking stops new responses from reaching that spreadsheet, though the data already in it stays.

Decide which responses can go in

Before using the feature with real responses, check whether it is available for your account and whether your organization allows the data in that form to be processed with AI. Keep sensitive or identifiable responses out of an initial trial.

Then look at who can run it. Google's Workspace Learning Center says anyone you invite as a collaborator can edit any part of a form, including its responses and where they are saved. An editor whose own account qualifies may be able to run the Gemini tools on those responses, so review each form's Share list.

Review the response sheet as well, because Google says access to the form and to the linked sheet has to be changed separately. The detailed theme view creates another Google Sheet, so check who that file is shared with too.

Google's Generative AI in Google Workspace Privacy Hub says Gemini does not access Workspace content you do not have permission to access, and that your content is not human reviewed or used for generative AI model training outside your domain without permission. The hub applies only when Gemini is used with a qualifying Workspace edition, so analyze business forms from the business account, not a personal Google AI subscription.

Rating an insight with Good suggestion or Bad suggestion opens a feedback pop-up that can include the prompt and output. The Privacy Hub says those are shared only if their checkboxes stay selected, and that feedback data may be retained for up to 18 months. Google's Forms help page says feedback should not contain personal, sensitive or confidential information, so on sensitive forms, skip the ratings.

Health information needs a firmer rule. Google's Workspace HIPAA page says customers who have not signed a business associate agreement with Google must not use protected health information in Google Workspace, and the agreement is reviewed and accepted from a super administrator account under Account settings, then Legal and compliance. Google's list of HIPAA-supported Workspace services includes Google Drive, which covers Google Forms, and Gemini in Google Workspace, but third-party add-ons are not covered. Being on that list does not make every intake form a good candidate for AI analysis.

Finally, keep the analysis within anything respondents were told about how their answers would be used. A workable starting rule:

  • Good first candidates are event feedback, anonymous service feedback, internal logistics surveys and registration counts.
  • Hold back forms with health, financial or HR details, comments about named people, and anything respondents were told would stay private.

Run a first test you can check

A feedback form with a manageable set of responses makes a good first test. Work through it in this order:

  • Pick a form that meets the requirements above and has nothing sensitive in it.
  • Turn off Accepting responses under Published and save, or note the response count, so the numbers hold still.
  • Read the responses yourself first and note the common themes, plus any lone dissenting view.
  • On the Responses tab, find Actionable Insights, select Generate insights and read the Analysis steps.
  • Select Link to Sheets at the top right of the Responses tab to put every answer in a spreadsheet.
  • Check each count and percentage against that sheet, and note how many responses sit behind each conclusion.
  • Select See theme percentages on a text question and compare the themes and the summary with the original comments.
  • Use Modify themes to add a theme Gemini missed or delete one that does not fit.
  • Check whether the summary or the insights missed the minority view you noted.

How to check a number in the sheet

For a single count, open the linked sheet, choose Data, then Create filter view, and filter by values on the answer in question. Google notes that a plain filter appears for everyone with access to the spreadsheet, while a filter view changes only your view. Once the data is filtered, Sheets shows the number of rows displayed out of the total at the bottom right.

For a claim that connects two questions, filter on one question's answer and read the other question's answers in the rows that remain. A pivot table, under Insert, then Pivot table, can summarize every combination at once, with one question under Rows, the other under Columns and a summary under Values. Google's instructions say that after selecting the Edit button under the pivot table, double-clicking a cell opens a new sheet with that cell's source data. Every percentage you report should come with the count behind it.

Mistakes that are easy to miss

Treating a correlation as a cause is the first. If people who rated scheduling poorly also rated the whole job poorly, that is a reason to read those responses, not proof of why they were unhappy.

Small groups are another. Three out of four is 75 percent, which sounds stronger than it is. A related mistake is forgetting who did not answer: 30 responses from 300 customers describe the 30 who chose to reply, so keep both numbers in view.

Results also go stale. If new responses arrive while a summary is open, select Refresh with latest responses. Google says generated summaries are not saved, so copy any summary or insight you want to keep into a document, along with the date and the response count.

Duplicates and test entries distort small forms. Unless Limit to 1 response is on, under Settings, then Responses, one person can submit more than once, and that setting requires respondents to sign in to a Google Account. Test submissions made while building the form count like any others, so delete them from the Individual view on the Responses tab, keeping in mind that Google says deleting a response cannot be undone. Afterward, compare the form's response count with the rows in the linked sheet.

A rare but serious comment may not make it into a summary or a theme list built around common points. Read the lowest scores and the longest comments yourself. A summary can help someone decide which responses to read first, but a decision about a customer or employee still needs a review of the underlying material.

A worked example

Imagine a twelve-person landscaping company that sends a five-question feedback form to 160 customers after its fall cleanups and gets 40 responses. The questions cover overall satisfaction, arrival within the promised window, crew courtesy, whether the customer would book again, and other comments. The form collects no names or email addresses.

Actionable insights reports an average overall score of 4.1, says customers who rated the arrival window poorly gave much lower overall scores, and recommends confirming arrival windows the day before. The office manager links the form to a sheet and creates a filter view showing only poor arrival-window ratings. The row count at the bottom right shows 6 rows out of 40, and 5 of those 6 customers gave low overall scores, so the pattern is real but rests on six people.

Reading those six rows, she finds four comments about crews arriving hours late, one about a billing mix-up and one blank. The timing explanation is backed by four comments, not six. Elsewhere in the sheet she finds two comments about a damaged sprinkler head, which neither the summary nor the insights mentioned.

Because the form is anonymous, she cannot reply to those two customers. She asks the crew leads to check for sprinkler damage on recent jobs and adds a line to future forms inviting customers to call the office about property damage.

The recommendation is cheap to try, so the office starts confirming arrival windows the day before and will send the same form after the spring cleanups to compare ratings. She saves a note in the sheet with the date, the 40 responses out of 160 customers asked, and what she checked.

Short answers to common follow-up questions

Rapid Release cannot be switched on for one department to try this early. Google allows one release track per account and suggests a separate Workspace account on a separate domain for a test group.

Results can be shared without sharing the raw responses. Write up the takeaways you have checked, and copy charts with the Copy button at the top right of a chart on the Responses tab. Google says a chart pasted into Docs, Slides or Drawings can be updated there as long as you have edit access to that file and the form.

What to do this week

  • Check your edition, release track and smart features default in the Admin console.
  • Decide which forms are off limits for AI analysis.
  • Review each form's editors and who can open its linked sheet.
  • If you handle health information, confirm your agreement status under Legal and compliance.
  • Run one low-stakes feedback form through the test above.
  • Remind staff that a summary points to responses worth reading and does not replace reading them.

Where ALCO can help

ALCO's Google Workspace service covers Gmail, Drive, Calendar and the admin console, and its user training service offers practical technology and security training for your team. For help checking these settings or planning a first test, the ALCO help desk is staffed 24 hours a day, including holidays, and calls are answered by a person.

Sources