A monthly budget in Google Sheets that fills itself
A Google Sheets budget that fills itself from your bank alerts: spending by category against what you plan, without typing in purchases.
Ask your AI assistant:
“TrackerHacker my budget”
How it works
- In Claude, ChatGPT or Gemini, type TrackerHacker my budget.
- The first time, your assistant asks you to connect TrackerHacker. Sign in with Google and tap Allow. That's your sign-up too: there's no separate account to make.
- Your assistant makes the sheet in your own Google Drive (the ready-made Transactions sheet) and tells you what's left to do.
- Your bank's card alerts, forwarded to your TrackerHacker address with a Gmail filter. Each purchase becomes a row, and the budget tab adds them up by category.
- From then on TrackerHacker fills the sheet by itself, day and night, even when your assistant isn't open. Ask your assistant about it any time.
The sheet's columns
- Date: The day it happened, in your timezone.
- Merchant / Description: Who was paid or paid you, e.g. Trader Joe's
- Amount: -12.50 for money out, 12.50 for money in
- Currency: ISO code such as USD; blank means your usual currency.
- Account: Which card or account it was, e.g. "Visa 1234".
- Category: A spending category. Open text: each sheet template sets its own list of categories.
- Type: debit: money out; credit: money in; transfer: between your own accounts.
- Transaction status: planned: money you mean to spend, added ahead; pending: the bank hasn't settled it yet; posted: settled. Blank means posted.
- Bank reference: The bank's id for the transaction, when the message has one. The same on its pending and posted alerts, so a later alert updates the row.
Good to know
- You set what you plan to spend on each category in the sheet. It's your sheet, so you can change the formulas too.
- Ask your assistant "am I over budget?" and it answers from the sheet.
- Prefer 50/30/20? Ask for that and the sheet splits needs, wants and savings instead.
- Fixed rules called hacks write each row, not AI guesses, so the same email always makes the same row.
- TrackerHacker keeps none of your mail: each message is read once, and the rows live only in your own sheet.
- Free to start, with every personal feature.