Collaborate with Gemini in Google Sheets (Workspace Labs)

This feature is rolling out gradually and may not be available to you yet.

This article refers to Google Workspace Labs, which is a trusted tester program for users to try new AI features. Workspace Labs is currently available to trusted testers in English and may not be available in your country.

In Google Sheets, you can ask Gemini to help you:

• Create tables
• Create formulas
• Summarize your files from Drive and emails from Gmail

Important: This feature is currently available on desktop.

Use the Gemini in Sheets side panel

1. On your computer, open a spreadsheet from Google Sheets.
2. At the top right, click Ask Gemini .
3. To make the side panel bigger, click Expand .
   • To go back to its original size, click Collapse .
4. At the bottom of the panel, you can select from suggested prompts or write your own.
5. From the generated content, you can:
   • To show all of the suggested content, click View more .
   • To show less, click View less .
   • To generate new content, click Retry .
   • To add the suggested content to the spreadsheet, click Insert .
     • Before clicking Insert, place your cursor where you want the content to be inserted in your spreadsheet.
   • To refine the generated content, write a new prompt
6. To close the panel, click Close .

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 a column for 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 .
3. In the side panel, create your own prompt using references from your sheet, or generic cell names. Examples of prompt:
   • “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

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 .

Give feedback on generated output

Gemini for Google Workspace is constantly learning and may not be able to support your request. Because feedback may be human readable, please do not submit data that contains personal, confidential, or sensitive information.

If you get a suggestion that’s inaccurate or that you feel is unsafe, you can submit feedback. Your feedback can help improve AI-assisted Workspace features and broader Google efforts in AI.

1. At the bottom right of the generated text, click Good suggestion or Bad suggestion .
2. If you select Bad suggestion , you can select the issue you found and enter additional feedback.
   • Optional:
     • To review data that’ll be attached with your feedback, at the bottom, select the data. 
     • If you don’t want to include the data with your feedback, to help us improve the product experience, uncheck the box next to “Attach collected data to your feedback.”
3. Click Next.
4. Review additional context that you can share with your feedback. If you don’t want to include the additional context with your feedback, uncheck the box next to “Additional context.”
5. 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.

Clear history with the Gemini in Sheets side panel

To remove all generated text or images that you haven’t imported to the spreadsheet, clear your Gemini history.

You can clear your conversation history on the side panel at any time. To clear the conversation history:

1. At the top right of the Gemini in Sheets side panel, click Clear history .
2. In the pop-up window, click Clear.

You’ll also lose your conversation history:

• If you refresh your browser.
• If you close and reopen the spreadsheet.
• If your computer goes offline.

Tip: To avoid losing your history, import generated output in the spreadsheet.

Turn off the Gemini in Sheets side panel

To turn off any of the features on Google Workspace Labs, you must exit Workspace Labs. If you exit, you’ll permanently lose access to all Workspace Labs features, and you won’t be able to rejoin Workspace Labs. Learn more about how to exit Workspace Labs.

Learn about Workspace Labs feature suggestions

• Workspace Labs feature suggestions don’t represent Google’s views, and should not be attributed to Google.
• Don’t rely on Workspace Labs features as medical, legal, financial, or other professional advice.
• Workspace Labs features may suggest inaccurate or inappropriate information. Your feedback makes Workspace Labs more helpful and safe.
• Don’t include personal, confidential, or sensitive information in your prompts.
• Google uses Workspace Labs data and metrics to provide, improve, and develop products, services, and machine learning technologies across Google.
• Your Workspace Labs Data may also be read, rated, annotated, and reviewed by human reviewers. Importantly, where Google uses Google-selected input (as described in the Privacy Notice) to generate output, Google will aggregate and/or pseudonymize that content and resulting output before it is viewed by human reviewers, unless it is specifically provided as part of your feedback to Google.
• Generated images are for use only within Google Sheets.
• Workspace Labs generated images are designed to bring your imagination to life in Sheets, and may not represent real world situations.

How Workspace Labs data in Google Sheets is collected

When you use the Gemini in Sheets side panel, Google uses and stores the following data:

• Prompts you enter or select
• Generated content
• Google Workspace content that you have access to that is referenced to generate content (both Google-selected input and user-provided input).
• Your feedback on the Gemini in Sheets side panel.

To understand how this data will be used, review the Google Workspace Labs Privacy Notice and Terms of Service.

Related resources

• Get started with Workspace Labs
• Collaborate with Gemini in Google Docs
• Collaborate with Gemini in Google Slides
• Collaborate with Gemini in Google Drive
• Collaborate with Gemini in Gmail