GeminiWorkspaceLevel 2: Context

How Do You Get Formulas and Analysis from Gemini in Sheets?

Click Ask Gemini at the top right of a Sheet, or type = in a cell and press Ctrl+Alt+G on Windows or ChromeOS, or ⌘+Ctrl+G on Mac. Describe the calculation, then click Insert. It can also do analysis and charts, and it can change the sheet directly, with pivot tables, filters and conditional formatting. You need an eligible plan.

Prompt to copy
In this sheet, column [A] is [order date], [C] is [region] and [F] is [revenue], with headers in row 1.

Write a formula for cell [H2] that returns [total revenue for the region in G2, in the last 90 days]. It has to keep working as rows are added.

Explain in one sentence what each part does, and name one situation where it would give a wrong answer.
  1. 1Ask Gemini
  2. 2Open Analysis steps
  3. 3Insert
  4. 4Spot-check by hand
Rule of thumb, not a Google chart: check the method before you trust the number. Analysis steps shows how it was done.

Try it now

  1. 1Open a Sheet, click **Ask Gemini**, and paste the prompt above with your own columns.
  2. 2Read the explanation, click Insert, then choose the cell you named.
  3. 3Next, ask "What changed most month to month, and why might that be?" and open Analysis steps on the answer.
  4. 4You'll know it worked when a row you total by hand matches the formula's result.

Use it when

A formula you can describe but can't remember how to write, a trend or month-over-month question, a quick pivot or a one-off chart for a report. It also suits budget or staffing problems, which Google lists as optimization jobs it can solve.

Skip it when

A number going into a financial filing or a board paper, unless you check it independently. Skip it when you need a chart that stays current as well: Google says a generated chart doesn't update when the source data changes, unless it's built from a BigQuery connected sheet.

Why it works

Gemini in Sheets reads the sheet you have open, so you can talk about your columns by name. Google's help lists the controls to check its work: Analysis steps shows how an analysis was done, Show code shows the code behind the output, Undo reverses the last Gemini action, and Fix appears when you hover over a formula error. Google says it works best with native Google Sheets files, so convert Excel files first with File > Save as Google Sheets.

Example

Say you export a year of orders into a Sheet with date, region, product and revenue columns. Ask Gemini for each region's month-over-month change, and a chart of the top three. Open Analysis steps to confirm it used the right date column. Insert the chart, which lands on a new tab with its data. Remember that this chart won't follow next month's data, so regenerate it or build a normal chart on the live range.

Going further

Ask for sheet actions in plain words: "Freeze the top row, add a dropdown in column D with Open and Closed, and highlight overdue rows." Google lists conditional formatting, pivot tables, dropdowns, checkboxes, filters, sorting, find and replace, and number formats. Proposed actions wait for you to click Apply, and Undo reverses the last one. Connected Sheets lets it query BigQuery, and Google says those queries are read-only, though you need BigQuery access and a Cloud billing project.

Common mistakes

  • Working in an uploaded Excel file. Google says native Sheets files work best, so save it as a Google Sheet first.
  • Leaving results in the panel. Google says reloading or clearing history removes anything you haven't inserted, and these chats aren't saved to Gemini Activity.
  • Sending a report with a generated chart next month without regenerating it. It doesn't update with the data.
  • Using it on a sheet shared outside your company without thinking it through. Google warns that content may be visible to out-of-domain users on that file.

Sources

Checked 6 November 2026. Products change often, so confirm details with the vendor.

Related

Beyond the course