If your Google account offers Gemini in Sheets, you can select your expense range, describe what you want in plain words, and get back a summary, a suggested formula or a draft table. Treat every answer as a draft. Check its numbers against a plain formula such as SUM or SUMIFS before you rely on them.
What do you need to check first?
Availability depends on your Google account type, plan and region, and the buttons and names change as features are updated. Look for a Gemini or Ask Gemini icon in the Sheets toolbar. If you do not see one, the rest of this article still helps, because the plain formulas near the end do the same jobs and work in every Sheet.
Get your sheet ready
An assistant reads your sheet roughly as you do, so tidy data matters more than clever prompts.
- One header row with clear names such as Date, Merchant, Category, Amount.
- One row per expense, with no merged cells or blank spacer rows.
- Dates as real dates and amounts as numbers, not text with a rupee sign.
- Debits as positive amounts, or a separate Type column that says whether each row is spending or income.
- No account numbers, card numbers or phone numbers in the range you point it at.
Three useful ways to ask
Summarise a range
Select A1 to D400 and ask: "Summarise spending by category for October 2026 and list the three largest merchants. Show the rows you used." Asking for the rows is the key phrase. It forces the answer to be traceable.
Ask for a formula, not an answer
"Write a formula that sums Amount where Category is Food and the date is in October 2026." This is often safer than asking for the number, because you can inspect the formula and it keeps working when you add rows.
Explain a formula you inherited
Paste a formula and ask what it does and where it might break. This is a strong use because you can test the explanation against your own data.
How do you verify what it gives you?
Build one plain check beside every summary. For the Food example, with categories in column C, dates in column A and amounts in column D:
- =SUMIFS($D$2:$D$400, $C$2:$C$400, "Food", $A$2:$A$400, ">="&DATE(2026,10,1), $A$2:$A$400, "<"&DATE(2026,11,1))
- =COUNTIFS($C$2:$C$400, "Food", $A$2:$A$400, ">="&DATE(2026,10,1), $A$2:$A$400, "<"&DATE(2026,11,1))
The first gives the total and the second counts the rows. If Gemini says ₹9,400 across 18 transactions, both of your formulas should say the same. If they do not, the summary is wrong, and you now know where to look.
What limits should you expect with big sheets?
- Long ranges may be sampled or truncated, so a summary may cover only part of your data without saying so.
- Answers can differ when you ask the same question twice.
- Messy text, such as merchant names written five different ways, produces split totals.
- Anything involving many steps, like matching refunds to purchases, is better done by formulas you can see.
When should you fall back to plain formulas?
Use the assistant to draft, and use formulas to decide. A single category-by-merchant table is a good example. This QUERY returns each category with its total, from headers in row 1:
- =QUERY($A$1:$D$400, "select C, sum(D) group by C label sum(D) 'Total'", 1)
It recalculates whenever the data changes and has no guessing in it. For the same reason, keep totals that will go to your family, landlord or accountant in formulas.
When a sheet stops being enough
If you spend an evening each month pasting statement rows and fixing categories before any summary can start, that is the point to look at a tracker. SpendixAI imports bank and card statements as PDF, CSV or Excel, lets you review rows before saving, and offers ready-made reports and a CSV download. It is not necessary for a sheet that is working well for you.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

