Real Agent Cases

Build a weekly budget tracker in Google Sheets with Gemini

Posted
by Krishi Chowdhary (TechRadar)
Last checked
Method:
How we verify

Evidence: Article or interviewA newsletter, journalist or interview account of what happened.

Context: Prompt guide: a shared prompt, not a record of a completed task.

Beginner-friendlyNo logins, payments or coding needed. Low risk: paste the prompt and you should get something useful.

Outcome

A TechRadar guide shows how to prompt Gemini in Google Sheets to create a budget table with Category, Budgeted Amount, Actual Amount and Difference columns, then add a subtraction formula and conditional formatting so it updates as expenses are logged. It notes Gemini in Sheets needs a paid Google plan.

Agent

Gemini

Prompt Original prompt

Exact prompt as published in the source.

I want to create a budget tracker. Create a table with four columns: Category, Budgeted Amount, Actual Amount, and Difference.
Optional stronger version

Our rewrite with extra checks. The poster didn't test it.

Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to.

Goal: Build a simple weekly budget tracker that updates itself as I log spending.

Fill in before running:
- My spending categories: [LIST]
- Weekly budget per category: [AMOUNTS]
- Spreadsheet app: [Google Sheets / Excel]

Rules:
- Create a main table: Category, Budgeted, Actual, Difference, with a working formula for Difference.
- Create a separate log table (date, category, amount, note) that feeds Actual automatically.
- Add color highlighting for over-budget categories.
- Explain how to start a new week.
- If a site asks for a login, a CAPTCHA or payment details, stop and hand control back to me.
- Ask for my OK before you pay, book, send, submit or cancel anything.
- Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify.
- Test the sheet with two sample expenses and confirm the totals before I start using it.

Output: Step-by-step instructions and formulas I can paste.

You'll know it worked when: when I log an expense, the category's Actual and Difference update by themselves.

Before you finish: re-read my goal and constraints, check your answer against each one, and list anything you assumed or couldn't confirm.

Source

https://www.techradar.com/ai-platforms-assistants/i-used-gemini-in-google-sheets-to-create-a-weekly-budget-that-updates-itself-heres-how

Related cases

  • Turn a messy weekly brain dump into a Google Calendar import file with GeminiEvidence: Article or interview

    An Android Police writer plans the week each Sunday by writing out meetings, errands, bills and appointments in plain language and asking Gemini for a CSV to import into Google Calendar. The writer double-checks everything before importing, and says Gemini sometimes outputs plain text instead of a downloadable file, which they save as .csv themselves.

    Gemini · Personal · Source date:

  • Pick a new area, build a moving checklist and budget, and plan the interior with ChatGPT and GeminiRecreated promptEvidence: Described by poster

    A product manager says a friend moving house used ChatGPT to rank areas by commute, local shops and safety before choosing a place, then Gemini to build a moving checklist and rough budget in Google Sheets, then ChatGPT image generation for interior design ideas. The friend, who doesn't work in tech, said it was easier than expected.

    ChatGPT, Gemini · Personal · Source date:

  • Stop spam events landing in Google Calendar with Gemini's step-by-step fixRecreated promptEvidence: Described by posterBeginner-friendly

    A poster shared the fix Gemini gave them for spam invites showing up in Google Calendar: change 'Add invitations to my calendar' from everyone to only known senders or only after responding, and turn off automatically adding events from Gmail.

    Gemini · Personal · Source date: