Collaborate with Gemini in Google Sheets

With Gemini in Google Sheets, you can:

• Create tables.
• Create formulas.
• Generate data analysis and insights (Currently only available via Gemini Alpha and Workspace Labs programs).
• Build charts and graphs (Currently only available via Gemini Alpha and Workspace Labs programs).
• Summarize your emails and files from Drive and Gmail.

Feature availability

• This feature is available to users on work or school accounts through a Gemini for Google Workspace add-on, and to users on personal accounts through Google One AI Premium. Learn about Gemini features and plans.
• This feature is also available as part of our early access testing program, Google Workspace Labs.
• Learn about supported languages for Gemini for Google Workspace.

Get started with Gemini in Sheets

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
3. In the side panel, select a suggested prompt or write your own prompt.

   Select a suggestion

   1. Select from the list of suggestions.
      • To get more options, select More suggestions.
   2. At the bottom, in the prompt box, replace the example text with the information you want.
   3. Press Enter.

   Enter a prompt in Gemini

   1. At the bottom, in the prompt box, enter a prompt.
   2. Press Enter.
4. Optional: To remove your history, click More options Clear history.

Tip: To avoid losing your history, insert generated output in the spreadsheet. You lose your conversation history when:

• You reload your browser.
• You close and reopen the spreadsheet.
• Your computer goes offline.

Explore Gemini in Sheets

Action	Description
Ask Gemini	Open Gemini.
More options	Clear your recent Gemini history and ask for more suggestions.
Expand	Make Gemini larger.
Collapse	Return Gemini to its original size.
Close	Close Gemini.
Clear history	Remove all generated text and images you did not insert into the document yet.
More suggestions	Find more suggestions from Gemini.
More image suggestions	Find more suggestions of images from Gemini.
Insert	Insert generated text into your spreadsheet.
Insert image	Insert a generated image into your spreadsheet.
Copy	Copy a suggestion.
Retry	Generate a different response from Gemini.
Retry with Google Search	Search on Google for more information about your question or request.
View more	View more of the response from Gemini.
View less	Minimize the response from Gemini.
Good suggestion	Give positive feedback about a response from Gemini.
Bad suggestion	Report an issue with a response from Gemini.
Show code	Show code used to generate the output.
Hide code	Hide code used to generate the output.

Things to ask Gemini in Sheets

Summarize spreadsheet with Gemini

When you open a spreadsheet that has data, in the side panel, you’ll find a summary of your spreadsheet.

You can:

• To show the whole summary of the suggested content, click View more.
• To send feedback about the suggested text, click Good suggestion or Bad suggestion .

You can also ask Gemini to:

• Understand your spreadsheet better. Examples of prompt:
  • “Summarize this spreadsheet.”
  • “Explain this spreadsheet like I'm 5 years old.”

Create tables with Gemini

You can use Gemini to create tables in Sheets.

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
3. In the side panel, select a prompt or create your own. Examples of prompt:
   • “Create a table for a full day team event.”
   • “Create a trip plan for a vacation in a national park.”
   • “Create a social media tracker for marketing.”
4. Press Enter.
5. (Optional):
   • To add the table to your spreadsheet, click Insert .
   • To see a different version, click Retry .
   • To refine before inserting a table, you can add follow-up prompts. Examples of prompt:
     • “Add another 5 rows of different activities.”
     • “Add details on cost.”
   • To send feedback about the suggested table, click Good suggestion or Bad suggestion .

Create formulas with Gemini

You can use Gemini to generate formulas in Sheets.

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
   1. You can also start from any cell and enter =.
   2. Then use a shortcut:
      • For Windows and Chrome OS: Ctrl + Alt + g
      • For Mac OS: ⌘ + Ctrl + g
3. In the side panel, create your own prompt using references from your sheet, or generic cell names. Examples of prompts:
   • “Create a formula that divides goals by games.”
   • “Create a formula to find cell C1 in range D:G and output value in column G.”
4. (Optional):
   • To add the formula to your spreadsheet, click the cell you’d like to insert this formula, click Insert .
   • To see a different version, click Retry .
   • To send feedback about the suggested table, click Good suggestion or Bad suggestion .

Tip: To get the best results when generating formulas, make sure your cursor is placed in a cell within the range of data you want to use

Generate data analysis & insights with Gemini

Important: This feature is currently only available via Gemini Alpha and Workspace Labs program.

You can use Gemini to answer questions about the data in your sheet.

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
3. In the side panel, create your own prompt with references from your sheet or generic cell names. Examples of prompts:
   • "Identify trends in this table."
   • "How can I show regression and prediction of this data?"
   • "What analysis can you help me perform with this sheet?"
   • "Help me understand month-to-month food prices."

Build charts & graphs with Gemini

Important: This feature is currently only available via Gemini Alpha and Workspace Labs programs.

You can use Gemini to generate charts and graphs.

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
3. In the side panel, create your own prompt with references from your sheet or generic cell names. Examples of prompts:
   • "Create a chart with date on the x-axis and total on the y-axis."
   • "Make a line chart."
   • "Create a graph that shows the percentage of expenses on the total stipend after tax."
   • "Make a chart analyzing my expenses for the month."

Tip: Generated charts are static images and aren't editable charts in Sheets.

Summarize your Drive files with Gemini

You can use Gemini to reference files from your Drive to generate responses in Sheets.

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
3. In the side panel, ask Gemini to use your Drive files to generate text.
   • Example: “What are the main points of: Meeting Notes: Core Team sync.”
4. To check which files were used, below the response, click Expand Sources.
5. (Optional):
   • To add the text to your spreadsheet, click Insert .
   • To view an another version, click Retry .
   • To send feedback about the suggested text, click Good suggestion or Bad suggestion .

Summarize your Gmail emails with Gemini

You can use Gemini to reference emails you sent to generate responses.

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Gemini in Sheets side panel .
3. In the side panel, provide your prompt asking Gemini to reference Gmail email(s).
   • Example: “Catch me up on the latest Monthly Review emails.”
4. To check which files were used, below the response, click Expand Sources.
5. (Optional):
   • To add the text to your spreadsheet, click Insert .
   • To generate a new suggestion, click Retry .
   • To send feedback about the suggested text, click Good suggestion or Bad suggestion .

Get help with Google Sheets

• “Teach me how to use conditional formatting with a color scale.”
• “How can I remove duplicates?”

Get answers from the web

Important: To get answers from the web, make sure to include phrases like “Use Google Search” or “Using web search” in your prompt.

• “Write a paragraph describing the weather today in Mountain View, California using web search.”
• “Help me write a paragraph explaining if lightning can strike the same place twice using only information from the web.”

Give feedback on generated output

Gemini for Google Workspace is constantly learning and may not be able to support your request.

If you get a suggestion that’s inaccurate or that you feel is unsafe, you can let us know by submitting feedback.

1. Below the generated text, click Good suggestion or Bad suggestion .
2. If you click Bad suggestion , you can select the issue you find and enter additional feedback.
3. Click Submit.

To provide general feedback on this feature, at the top, go to Help Help Sheets improve.

To report a legal issue, create a request.

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.
• Your conversations with Gemini in Sheets are not saved to Gemini Apps Activity. When you delete your Gemini in Sheets conversation history, it doesn't delete any information that is saved to your Gemini Apps Activity. Learn how to delete your Gemini Apps Activity.

Related resources

• Collaborate with Gemini in Google Docs
• Collaborate with Gemini in Google Slides
• Collaborate with Gemini in Gmail
• Collaborate with Gemini in Google Drive