How to Use Canvas in Google Sheets With Gemini (Step by Step), by Lvl 99 TechSkillz on YouTube. 2 min 11 s.
- Video length
- 2 min 11 s
- Time to do it
- 10 minutes
- Difficulty
- Easy
- Steps
- 8
What you need
Steps
Open your data in a native Google Sheet. If you uploaded an Excel file, convert it to a Google Sheet first, or Canvas may not appear.
Open Canvas one of three ways: click Insert in the menu and pick Canvas, use the Tools menu, or click the Canvas icon in the bottom bar.
Type your request into the prompt box. Name the exact cards and charts you want, for example revenue by region, units sold by product and shipped versus pending.
Send the prompt and wait a few seconds. Gemini builds a dashboard against your sheet and shows the finished cards and charts.
Look over the result and check that each card shows the measure and grouping you asked for. The numbers read live from your sheet, not from a pasted image.
Send a second prompt to change it, such as adding a card, switching the chart type or turning on dark mode.
Click a chart to see the raw numbers behind it. This shows exactly which rows feed the total.
Rename the canvas so you can find it again, then close it and keep editing your sheet as normal.
Tips and common mistakes
Be specific in the prompt: list each card and chart you want instead of asking for a general dashboard.
Canvas only works on native Google Sheets, so convert uploaded Excel files before you start.
Edit the data in your sheet and the canvas updates, so there is nothing to refresh by hand.
If the first result is close but not right, send another prompt rather than starting over.
Questions
Why is Canvas missing from my Google Sheets?
Check that you are in a native Google Sheet rather than an uploaded Excel file, and that your account has Gemini access in Sheets. If both are fine, look for it under Insert or Tools.
Do I need to know formulas or chart settings?
No. You describe the result in plain words and Gemini builds the cards and charts for you.
Does the dashboard update when my data changes?
Yes. The canvas reads from the sheet underneath, so changes to your rows flow through to the cards and charts.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
