Collaborate with Gemini in Google Sheets (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.”

To summarize a spreadsheet, you can use these shortcuts:

• For Mac: Press ⌘ + Ctrl + n
• For Windows: Press Ctrl + Alt + n

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

You can use Gemini to answer questions about the data in your sheet.

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 with references from your sheet or generic cell names. Examples of prompts:
   • "Identify trends in this table."
   • "How can I show regression and prediction of this data?"
   • "What analysis can you help me perform with this sheet?"
   • "Help me understand month-to-month food prices."

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 Gemini .
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: You can't edit generated charts. They're static images unlinked from the data 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.”