Gemini in Google Sheets: Uses for Accountants 2026

Use Gemini in Google Sheets for formulas, summaries and clean-up on a practice workbook, and learn what it can read before you open a client file with it.

Published
Updated

Gemini in Google Sheets can write formulas, build tables and answer questions about a spreadsheet from the Ask Gemini side panel.

What Gemini Does in Google Sheets

Use Gemini to explain a movement, summarise a table or build a pivot table on a separate tab. For an edit, review the range in the proposed action before you apply it.

  1. Open a spreadsheet in Google Sheets on a computer. For a first test, put the amounts 80 and 120 in B2:B3 of a blank sheet.
  2. Select Ask Gemini at the top right. Ask it to write a formula for B4 that totals B2:B3 and to explain what the formula reads.
  3. Select B4 and choose Insert after checking the formula’s range. Check that B4 shows 200 and the original values in B2:B3 are unchanged.

You can direct Gemini to a particular range. If your Workspace settings allow it, Gemini can find relevant Drive files you haven’t opened. It can only use files your account has permission to view.

Enable Gemini in a Practice Workspace

Google lists the Sheets assistant in Business Standard, Business Plus, Enterprise Standard and Enterprise Plus. Those editions include the side panel and the in-cell AI function.

Google lists Gemini features in Gmail for Starter editions. Its comparison lists the Sheets assistant from Standard upwards for Business and Enterprise. See Google’s Workspace feature comparison.

On Enterprise Standard and Enterprise Plus, an administrator with the Gemini Settings privilege can switch the group of apps that includes Sheets on or off for staff.

  1. In the Google Admin console, open Generative AI and choose Gemini for Workspace.
  2. Select Feature access. Choose the organisational unit or configuration group if the setting applies to only some staff.
  3. Edit the setting for Drive, Docs, Sheets, Slides, Forms, Drawings and Vids. Choose On or Off, then save. This changes Gemini access for all seven apps together.
  4. Check from an affected staff account. On an eligible plan with smart features enabled, a Google Sheet shows Ask Gemini when the feature is on.

On Business Standard or Business Plus, sign in to the Google Admin console as a super administrator. Open Account, then Account settings, then Smart features for Google Workspace.

Choose Set a default and select whether Workspace smart features start on or off. This default applies across Workspace and staff can override it. See Google’s smart features settings.

If Ask Gemini is missing, check the account, edition and Workspace smart features. If the file is still an Excel workbook, convert a copy first. See Google’s service access settings.

Gemini With Excel Files

Gemini can read Excel data in a converted Google Sheet or analyse an Excel workbook attached to the separate Gemini app. Choose based on whether you need to edit the sheet or analyse a copy.

Open the Excel workbook from Drive and choose File > Save as Google Sheets. Drive keeps the original Excel workbook and creates a new Google Sheet. Check formulas and totals in the copy. See Google’s Excel conversion instructions.

Attach an eligible Excel file in the Gemini web app to analyse it without converting it. The app works from the attachment and leaves the original workbook unchanged. See Google’s Gemini file upload instructions.

Google lists no first-party Gemini add-in for Excel. To work inside Excel, use the guides to Copilot in Excel, Claude for Excel or ChatGPT for Excel.

Client Sheets and What Gemini Can Read

Gemini in Sheets uses your prompt and relevant sheet content. Depending on your Workspace settings, it can also draw on material your account is already allowed to view.

Turning off the side panel in one app can still leave those files accessible to Gemini from another app.

Under the Google Workspace service terms, Google needs the customer’s permission or instruction to use customer data to train the models behind Gemini in Workspace.

Where side panel history is available, it can keep prompts and replies across sessions. Google says admins can automatically delete inactive conversations or keep them indefinitely.

The separate Gemini app has its own history settings. See Google’s Workspace privacy hub.

The Tax Practitioners Board says registered tax practitioners need the client’s permission to disclose information about their affairs to a third party, unless a legal duty requires disclosure.

Using a work account still leaves the practice responsible for any disclosure. See the TPB’s AI and confidentiality guidance.

Review access on the client’s Drive folder before using Gemini. Check named people and groups, access inherited from the parent folder and whether anyone with the link can open it.

Use a separate practice copy with tax file numbers (TFNs) and bank details removed. Replace names and other identifiers that could reveal the client. For formula help, column names and invented rows are usually enough.

Tax Genie removes every TFN from a client’s form before AI reviews the answers.

Accounting Tasks and Prompts for Gemini in Sheets

Use these prompts in the side panel with fictional practice data. Give Gemini the relevant range and use separate columns or tabs for proposed results.

Categorise a Transaction Export

Use Transactions!A2:C60. Column A is the transaction date, B is the bank description and C is the amount. Put suggested categories in a separate column. Use only Bank Fees, Software and Review. Use Review when the description is ambiguous.

Check a bank fee against the description and mark an unfamiliar merchant for review. Compare row counts and total amounts with the export to catch any dropped transaction.

Summarise Spend by Supplier

Use Spend!A2:C70. Column A is supplier code, B is invoice reference and C is the signed amount. Build a pivot table on a new tab that adds column C by supplier code. Include credits as negative amounts.

If one supplier has invoices of $200 and $50 with a $30 credit, its net spend is $220. Reconcile the pivot table’s grand total to the sum of column C.

Look Up an Account Label

On the Review tab, use the code in A2 to find an exact match in Accounts!A2:A50. Return the label from Accounts!B2:B50. Show Review if the code is missing. Give me a formula for B2.

One possible formula is =XLOOKUP(A2,Accounts!$A$2:$A$50,Accounts!$B$2:$B$50,"Review",0). In a sample where A120 maps to Rent, it must return Rent. An unknown code must return Review. Check for duplicate codes before filling the formula down.

Draft a Line on a Movement

Read Movement!A2:C12. A is the account label, B is the prior period and C is the current period. Draft one sentence for the largest absolute change. Give the amount and direction. Use only the figures provided.

Recalculate the movement from the source columns. A rise from $2,000 to $2,300 is $300 or 15%. Check that the sentence gives the direction correctly and leaves the cause open unless you supplied evidence.

Check Gemini’s Formulas and Summaries

Keep the original sheet unchanged. In the working copy, test each formula against a row with a known answer and an exception, such as a missing account code or a credit.

Compare summary totals and row counts with the source export. For a converted workbook, check the links and formulas you rely on before trusting its totals.

The practitioner responsible for the work decides the account coding and tax treatment and checks every figure that goes to a client. Keep the source and the copy that shows how you verified the result.

One client form. One finished return.

Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.

See how Tax Genie works

Made for Australian accounting firms

Tax GenieSee how Tax Genie works