درحال‌حاضر صفحه درخواستی به زبان شما دردسترس نیست. می‌توانید زبان دیگری را در انتهای صفحه انتخاب کنید یا بااستفاده از ویژگی ترجمه داخلی Google Chrome هر صفحه وبی را فوراً به زبان انتخابی‌تان ترجمه کنید.

Collaborate with Gemini in Google Sheets (Workspace Labs)

With Gemini in Google Sheets, you can:

  • Create tables.
  • Create formulas.
  • Generate data analysis and insights.
  • Build charts and graphs.
  • Summarize your files from Drive and emails from Gmail.

Feature availability

Supported languages

You can use the Gemini in Sheets side panel in some languages. Learn more about language availability.

Get started with Gemini in Sheets

An animation that shows someone asking Gemini in Sheets to create a table to organize metrics across advertising campaigns
  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.
  4. Optional: To remove your history, click More options More and then 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 More

Clear your recent Gemini history and ask for more suggestions.

Expand

Make Gemini larger.

Collapse

Return Gemini to its original size.

Close 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

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 and then Help Sheets improve.

To report a legal issue, create a request.

Turn off Gemini in Sheets

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.
  • 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.
  • 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

7419037437252186201
true
Search Help Center
true
true
true
true
true
35
false
false
Search
Clear search
Close search
Main menu
false