With Gemini in Google Sheets, you can:
- Create tables.
- Create formulas.
- Generate data analysis and insights.
- Build charts and graphs.
- Summarize your emails and files from Drive and Gmail.
Feature availability
- This feature requires an eligible Google Workspace or Google One AI Premium subscription. Learn about Gemini features and plans.
- Learn about supported languages for Gemini for Google Workspace.
Get started with Gemini in Sheets
- On your computer, open a spreadsheet from Google Sheets.
- At the top right, click Ask Gemini
.
- In the side panel, select a suggested prompt or write your own prompt.
- 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
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.
- Below the generated text, click Good suggestion
or Bad suggestion
.
- If you click Bad suggestion
, you can select the issue you find and enter additional feedback.
- 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.