Build a quarterly household budget in Google Sheets with Gemini

WorkedEvidence: Described by posterPosted Apr 22, 2026Last checked Nov 4, 2026

Gemini's Help me organize built Oluwaniyi Raji a quarterly budget in Google Sheets about 70% to 80% done, then formatted it on request.

Source checked Nov 4, 2026
Results shared

How to use this

Tap Copy prompt.
Open Gemini.
Paste it into the message box.
Replace anything in [CAPITAL LETTERS IN BRACKETS] with your own details.
Send it, then read the answer before acting on it.

New to this? What's a prompt?

A prompt is the message you send to the AI tool. Copy the one on this page, put your own details where it asks, and read the answer before you act on it.

Prompt

Improved prompt

Our fuller version of the source's prompt, with fill-in details and rules, or one written to avoid what went wrong. Not tested by the poster.

What the prompt labels mean

Our fuller version of the person's prompt. They didn't use this version, and we haven't tested it.

Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish.

Goal: Build a quarterly household budget table in my spreadsheet that I can fill in and track.

Questions to ask me first:
- Which quarter, and how many months should the sheet cover?
- Which categories do you want under fixed, variable, savings and discretionary?
- Should I leave the amounts empty for you to fill in?

Inputs (fill in or confirm):
- Quarter: [QUARTER AND YEAR]
- Categories: [FIXED / VARIABLE / SAVINGS / DISCRETIONARY ITEMS]
- Columns: planned, actual, variance, notes
- Alert rule: [e.g. highlight rows where actual is more than 10% over planned]
- Currency: [CURRENCY]

Rules:
- Leave the amount cells empty; don't add sample data.
- Calculate variance with formulas, not typed numbers.
- Use currency formatting on money columns and a bold header row.
- Apply the alert rule to new rows too.

Checkpoint: Show me the column layout and category list and wait for my OK before formatting.

If you get stuck: If a formula or rule doesn't work, tell me which cells are affected instead of hiding the problem.

Verify before you finish: Enter a test amount in one row and confirm the variance and highlight work.

Output: A formatted budget table with formulas and the alert rule in place.

Done when: I can type in my numbers and see variances and overspending flagged automatically.

Customize this prompt

Answer these questions and we'll put your answers into the prompt for you. You can leave any of them empty.

Quarter

Categories

Alert rule

Currency

Your prompt

Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish.

Goal: Build a quarterly household budget table in my spreadsheet that I can fill in and track.

Questions to ask me first:
- Which quarter, and how many months should the sheet cover?
- Which categories do you want under fixed, variable, savings and discretionary?
- Should I leave the amounts empty for you to fill in?

Inputs (fill in or confirm):
- Quarter: [QUARTER AND YEAR]
- Categories: [FIXED / VARIABLE / SAVINGS / DISCRETIONARY ITEMS]
- Columns: planned, actual, variance, notes
- Alert rule: [e.g. highlight rows where actual is more than 10% over planned]
- Currency: [CURRENCY]

Rules:
- Leave the amount cells empty; don't add sample data.
- Calculate variance with formulas, not typed numbers.
- Use currency formatting on money columns and a bold header row.
- Apply the alert rule to new rows too.

Checkpoint: Show me the column layout and category list and wait for my OK before formatting.

If you get stuck: If a formula or rule doesn't work, tell me which cells are affected instead of hiding the problem.

Verify before you finish: Enter a test amount in one row and confirm the variance and highlight work.

Output: A formatted budget table with formulas and the alert rule in place.

Done when: I can type in my numbers and see variances and overspending flagged automatically.

Scroll to see the whole prompt. Your answers show in green.

4 blanks are still empty: Quarter; Categories; Alert rule; Currency. They'll stay in brackets in your prompt, so the chat tool may ask you about them.

What you type stays in this browser tab. We don't send it or save it, and it's gone when you leave the page. If you use a "Try this in" button, your answers go to that tool as part of the prompt.

Try this in:

ChatGPT Gemini Used in source Grok Claude

This prompt has blanks to fill in, like [QUARTER AND YEAR]. We'll copy it instead of filling it in, so you can edit it before you send.

Opens in a new tab. We don't see what you send.

These links are only a shortcut. We're not affiliated with OpenAI, Google, Anthropic or xAI, and your results may not match the source.

The prompt they actually used

The exact prompt from the source.

Quarterly household budget with categories for fixed expenses, variable expenses, savings, and discretionary spending, plus columns for planned, actual, variance, and notes.

AI tool

Gemini

Outcome

Oluwaniyi Raji of Android Police used Gemini's "Help me organize" feature inside Google Sheets to build a quarterly household budget with fixed, variable, savings and discretionary categories and columns for planned, actual, variance and notes. Gemini created a ready-to-use table within seconds that Raji judged 70% to 80% of the way there. Follow-up prompts added alternating row colors, a bold header and currency formatting, and a red highlight on any row where actual spending beat the plan by more than 10%, scoped to the right columns. Raji ran the same prompt through Copilot, which needed more cleanup, and Claude and ChatGPT, where copying results back into Sheets wiped out the time savings. The downsides: the Gemini sidebar makes the sheet cramped on a 13-inch laptop, it fills in sample data unless told to leave cells empty, and Raji wouldn't trust it for high-stakes numbers.

Evidence: Described by posterThe person describes what happened in words, without screenshots or video.

Source

Posted: Apr 22, 2026 by Oluwaniyi Raji (Android Police)
Last checked: Nov 4, 2026
Method:: How we verify

https://www.androidpolice.com/secret-gemini-integration-in-google-sheets-means-never-manually-format-a-budget/

Context: Original prompt: quoted in the article; follow-up prompts handled formatting and the 10% highlight. Improved prompt: our fuller version, not tested. Android Police earns affiliate commissions.