Collaborate with Gemini in Google Sheets (2024)

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.

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.

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 .

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 .

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 Gemin i.
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.

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 .

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

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