How to Use Canvas in Google Sheets With Gemini (Step by Step)
Google Sheets canvas turns a plain spreadsheet into a live dashboard from one prompt, with no formulas and no charts menu.
Canvas is the newer Sheets surface where you describe what you want and Gemini builds it against
your actual data. This walkthrough starts from a sales spreadsheet, asks for revenue by region,
units sold by product and a shipped versus pending breakdown, and gets a working dashboard back in
seconds. It stays connected to the sheet underneath, so it is not a static image.
What you'll learn:
Three ways to open canvas: the Insert menu, the Tools menu, or the bottom bar icon
How to phrase the prompt so you get the specific cards and charts you want
That the result reads live from your sheet rather than pasting a picture
How to refine it with a second prompt, including switching it to dark mode
Where to find the raw numbers behind any chart, and how to rename the canvas
If canvas is not showing for you, check you are on a native Google Sheet rather than an uploaded
Excel file, and that you have Gemini access.
Subscribe for more practical AI workflows for work.
0:00 The problem with a wall of numbers
0:18 Open canvas from the Insert menu
0:34 The prompt box
0:48 The dashboard it builds
1:11 Refine it with a second prompt
1:21 View the data behind any chart
#GoogleSheets #Gemini #Dashboard #Spreadsheets
Subscribe for more practical AI and productivity tutorials:
/ @lvl99tech