Build a Personal Budget Sheet From Scratch
For anyone who keeps meaning to start a budget. Tell DuckyHelper your income and the categories you care about. It builds the whole workbook through Google Sheets' own web API, formulas included, then walks you through it on your screen.
“Build me a personal budget in Google Sheets with income, spending by category, savings goals and a dashboard.”
- 01Learn Google Sheets' web API, first time onlyBuilt from Google Sheets' own buttons, forms and requests. Kept on your device and reused next time.
createSpreadsheet(title)addSheet(name)setValues(range, rows)addFormatRule(range, rule)
- 02Create the workbook
- 03Add Income, Spending, Goals and Dashboard tabs
- 04Write the formulas and color the overspends
- 05Walk you through it on your screenIt draws on the sheet to show where each number comes from.
You getA budget that works on day one. A real, working sheet you understand, because it showed you how. Want a savings tab later? One ask.
A run, drawn from this page · early access on Mac
Nothing to send, so it runs straight through.
Nothing in this job sends a message or pays for anything, so it works through to the end and tells you when it's done. If a step ever would, it's built to stop and ask you first.
If it hits a sign-in, you sign in yourself. It's built not to type your passwords or card numbers.
Before you ask it.
What do I say?
Press fn (Ctrl+Shift+Space on Windows and Linux) and ask out loud, in your own words, like "Build me a personal budget in Google Sheets with income, spending by category, savings goals and a dashboard."
Why is the second time faster?
The first time, it writes small JavaScript tools for Google Sheets and builds an API from each site's own buttons, forms and requests. After that it calls them directly, so the job runs in one go instead of click by click. It costs less and breaks less.
Will it send anything without me?
It's built to ask first before it sends a message or pays for anything, and to wait for your yes. It may not recognize every send or payment, so keep an eye on tasks that involve messages or money. It's built not to type your passwords or card numbers: you sign in yourself, and it picks up from there.
Why not just do it by hand?
A good budget sheet takes formulas, tabs and formatting, and most people stop at the column headers.
Can I use this today?
Doing jobs in your apps is in early access on Mac. Talking to DuckyHelper, and having it see your screen and draw on it, works today on Mac, Windows and Linux.
- Early access
“Reorder last week's Instacart groceries, add a dozen eggs, and get it ready for checkout.”
Reorder Last Week's Groceries
See it run
- Early access
“Find the cheapest nonstop from SFO to Boston on Dec 19, back Jan 3, and get it ready to book.”
Find the Best Flight, Up to the Pay Button
See it run
- Early access
“Plan a weekend in Santa Barbara, Nov 22 to 23: a hotel under $250, food and hikes, and a day-by-day plan in Docs.”
Plan a Weekend Away in One Ask
See it run
Do anything
Ask it a question or hand it a job, in any app.
Doing jobs for you is in early access on Mac. Asking works on Mac, Windows and Linux.