Gemini in Google Sheets can summarise a follow-up tab, build a table and draft a commission formula on an eligible plan. Open Ask Gemini to work in the side panel, or use =AI() to put a text response in a cell. Practise on invented rows before you use it on brokerage records.
What Gemini Can Do in Google Sheets
Google Sheets has built-in Gemini features on eligible accounts. The Gemini side panel can answer questions about a tab, build a table or suggest a formula for the cell you select. For example, ask it for a follow-up table with columns for client reference, next action and status.
The AI function produces text in a cell. Type =AI("prompt", range) and replace range with the cells you want it to use. Google Sheets also accepts =Gemini(). Select the cell and choose Generate and Insert. For sums you’ll use to reconcile commissions, have the side panel draft a regular Sheets formula and check the result against the source rows.
How to Switch on Gemini in Sheets
To use the Gemini side panel and AI function at work, sign in with an eligible Google Workspace account and open a native Google Sheets file. Google’s feature list by edition includes both tools on Business Standard, Business Plus, Enterprise Standard and Enterprise Plus. Business Starter includes Gemini in Gmail, while the two Sheets features require a higher edition.
Workspace Business plans are priced per user. Enterprise pricing goes through Google Sales. For a personal Google account in Australia, Google AI Pro and Ultra include Gemini in Sheets as part of the Google One subscription. Google’s feature list includes the AI function on those two personal plans.
- In a desktop browser, open a native Google Sheets file with your work account. If the file is still an Excel workbook, use File and Save as Google Sheets to create a Sheets copy.
- Select Ask Gemini at the top right. If you work on a managed account and the button is missing, check your edition and turn on Workspace smart features if your brokerage permits it.
- On an edition with the admin controls, an administrator can open Generative AI, then Gemini for Workspace and Feature access. Check that Gemini is on for the Drive and Docs group of apps, which includes Sheets, and for the staff who need it.
- To confirm both features work, try a prompt in the side panel and an
=AI()prompt in a blank cell using sample text. If Sheets says the AI function is unavailable, check your account language and Workspace settings.
Use Gemini on a Broker Spreadsheet
Use the side panel to draft a commission formula and the AI function to summarise text in a follow-up tab. The rows below are invented. Put the headers in row 1 and the four records in rows 2 to 5.
| Client reference | Lender | Trail received | Follow-up status | Next action |
|---|---|---|---|---|
| Demo 101 | Example Bank | 180 | Due | Call about the rate review |
| Demo 102 | Sample Mutual | 140 | Waiting | Wait for the lender’s reply |
| Demo 103 | Example Bank | 220 | Due | Request the latest statement |
| Demo 104 | Sample Mutual | 160 | Done | File the call note |
- In G2, enter
=AI("Summarise the due follow-ups. Give the client reference and next action for each due row.", A2:E5). Select G2 and choose Generate and Insert. The result must include Demo 101 and Demo 103. If it includes Demo 102 or Demo 104, check the status column and tighten the prompt before using the summary. - Put
Example Bankin H2 andSample Mutualin H3. Open Ask Gemini and request a formula that sums the trail in C2:C5 for the lender in H2, using B2:B5 for the lender names. Ask it to fix the source ranges so you can fill the formula down. - Check the suggestion before inserting it in I2. A working formula is
=SUMIF($B$2:$B$5,H2,$C$2:$C$5). Fill it down to I3. Check that Example Bank shows $400 and Sample Mutual shows $300, then check that $700 matches the total of column C for those four rows.
For a live reconciliation, compare the inputs with the aggregator’s statement as well. A formula can add up the sheet correctly even when a settlement is missing from the source rows.
Google Sheets AI Compared With Excel AI
Keep Gemini in Google Sheets if your brokerage already shares native Sheets in Drive and mainly needs formula drafts or short follow-up summaries. The =AI() function can place the written follow-up summary next to its source rows.
Use Copilot in Excel if your original records are Excel workbooks and the team already manages them in OneDrive or SharePoint. Copilot can help build formulas and analyse workbook data on an eligible Microsoft 365 subscription. Keep the existing workbook where staff can use and verify its formulas, especially if it feeds other spreadsheets.
Keep Client Data Controlled
Keep live client records in the brokerage’s approved Workspace account and give access only to the staff who need it. In Share, set General access to Restricted. Give staff Viewer access for reading, Commenter access for feedback or Editor access when they update the register. Review named users and groups along with any access the file inherits from its parent folder.
Google’s Workspace Privacy Hub says it won’t use customer data from qualifying Workspace editions to train its Workspace generative AI models without the customer’s permission or instruction. Gemini still processes sheet data to answer prompts.
In the Google Admin console, open Generative AI, choose Gemini for Workspace and select Workspace Intelligence. This setting lets an administrator choose which Workspace services Gemini actively searches. Turning off Drive and Docs stops that search. Gemini can still use the sheet you have open or a file you name in your prompt.
Use a separate sample sheet for prompts that need only a status or a total. Leave out client names, contact details and loan documents. Before sharing an AI-generated summary, check both its contents and who can open the destination file. The Gemini safety guide explains which data settings to check for work and personal accounts.


