The step-by-step workflow and the full prompt from my Reel. Open a blank sheet, ask Gemini to build it as a canvas, and get an input table, a monthly dashboard, charts, budget tracking and savings in seconds. Then make it yours.
Family Finance Dashboard
Real-time household financial overview, budget health & wealth tracking
Income vs expenses, January to April
| Month | Income | Expenses | Net |
|---|
Where the money went, largest first
Total spent $6,867
A preview with the same numbers as the Reel. Hover or tab through the monthly bars for the values. Your canvas is built from your own sheet, so it will look a little different.
Sheets canvas is a paid Gemini feature. Check these first so you don't get stuck at step 2.
A Google AI Pro or Ultra plan on your personal Google account. Google AI Pro is the plan that used to be called Google One AI Premium. At work or school, it comes with Google Workspace Business or Enterprise (Standard and Plus) or the AI Pro for Education add-on.
Write your prompt in English. Sheets canvas only works in English for now. You can still use Rupiah and your own category names.
Use a computer. The Gemini side panel in Sheets is easiest on a laptop or desktop browser.
Plans and names change. Check the current Google AI plans at one.google.com, or ask your Workspace admin.
Go to sheets.new. It opens a blank spreadsheet straight away. Or open Google Sheets and click Blank spreadsheet.
Name the file right away, for example Family Finance Dashboard. It makes it easy to find later and to share with your partner.
Click the Gemini button (the ✦ spark) at the top right of your sheet. The Gemini panel opens on the right. Choose Help me create a spreadsheet, the option marked Canvas.
This is the exact prompt from the Reel. Check that Canvas is switched on in the prompt box, paste it, and send.
It answers the five things Gemini needs to know. Use the same pattern for any dashboard.
a family finance dashboard in Google Sheets
a clean modern design
, canvas style
an input table for income and expenses
monthly dashboard with charts, budget tracking, savings, and category breakdown
easy to use
, because the whole family will touch it
The short prompt is great for a first try. The full prompt tells Gemini your currency, your people, your categories and your savings target, so the first version is much closer to what your family needs. Fill these in and the prompts below update as you type. Anything left blank stays as a highlighted placeholder you can edit in Gemini.
The step most people skip
In seconds, Gemini builds the input sheet, the formulas, the charts and the canvas dashboard. The canvas stays in sync with the sheet underneath, so new transactions show up on the dashboard. Before you trust it with real money, test it.
If something is off, don't start over. Tell Gemini what you saw, for example: Total expenses didn't change when I added a row in Transactions. Fix the formulas so they include new rows.
You don't need a perfect first prompt. Keep asking Gemini for changes in the same panel. These are the ones I'd use first. They use your details from the form above.
No. Sheets canvas needs a paid plan (see Before you start). Without one, you can paste the full prompt into the free Gemini app at gemini.google.com and ask for step-by-step instructions and formulas to build the same dashboard yourself.
Not yet. Sheets canvas only works in English for now, so write the prompt in English. Your category names and the Rupiah currency are fine.
Yes. The canvas stays in sync with the sheet underneath. That's exactly what the 2-minute test in step 4 checks.
No, and that's fine. Gemini builds a fresh design each time. Use the follow-up prompts to change anything you don't like.
Yes. Keep the five parts of the prompt (what, look, input, output, who) and change the content: a small business sales tracker, a class attendance sheet, a content calendar.