Week 4

Collaborate with Gemini in Google Sheets

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

Important: This feature is currently available on desktop.

Use the Gemini in Sheets side panel

On your computer, open a spreadsheet from Google Sheets.
At the top right, click Ask Gemini .
To make the side panel bigger, click Expand .
- To go back to its original size, click Collapse .
At the bottom of the panel, you can select from suggested prompts or write your own.
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
To close the panel, click Close .

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

You can use Gemini to create tables in Sheets.

On your computer, open a spreadsheet from Google Sheets.
At the top right, click Ask Gemini.
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”
Press Enter.
(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.

You can use Gemini to generate formulas in Sheets.

On your computer, open a spreadsheet from Google Sheets.
At the top right, click Ask Gemini.
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”
(Optional):
- To add the formula to your spreadsheet, click the cell you’d like to insert this formula, click Inser.
- 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.

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

On your computer, open a spreadsheet from Google Sheets.
At the top right, click Ask Gemini.
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.”
To check which files were used, below the response, click Expand > Sources.
(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.

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

On your computer, open a spreadsheet from Google Sheets.
At the top right, click Gemini in Sheets side panel.
In the side panel, provide your prompt asking Gemini to reference Gmail email(s).
- Example: “Catch me up on the latest Monthly Review emails.”
To check which files were used, below the response, click Expand > Sources
(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.

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:

You’ll also lose your conversation history:

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

Back: Home>

Page updated

Report abuse