What launched

On 10 August, Google began rolling out Sheets Canvas, a Gemini feature that sits on top of a normal spreadsheet and builds an interactive view of it — a dashboard, a status board, a roster, a seating chart — from a plain-English description. No formulas, no pivot tables, no wrestling with conditional formatting rules. You describe what you want to see, and Canvas builds it, staying in sync with your raw data as it changes.

It's live now for Rapid Release Google Workspace domains and for Google AI Pro and Ultra personal accounts. If your workplace runs Scheduled Release, it lands by the end of August. It's available on Business and Enterprise Standard or Plus Workspace plans, and currently works in English only.

Why this is worth ten minutes

Most people who build trackers in Sheets aren't spreadsheet experts. You copy a template, hack together a few formulas, and spend far too long getting the colour-coding to work. Canvas skips all of that. It reads your existing columns, asks nothing of your formula skills, and produces something you'd normally need a template — or a colleague who's good with Sheets — to build.

How to open it

Open any Google Sheet in a Workspace account with access. Look for the Canvas option in the toolbar or side panel (Google is rolling this out gradually, so the exact location may shift over the coming weeks). Click in, and you'll get a prompt box where you describe the view you want in plain English.

Three uses worth trying first

A project tracker. If you're running a spreadsheet of tasks with owners and due dates, ask Canvas to group them by status and flag anything overdue. What used to be a scroll-and-squint exercise becomes a proper status board.

A budget or spend dashboard. Feed it a spend sheet and ask for a summary showing spend by category against budget, with anything over threshold highlighted. Useful for a monthly finance check without building a chart from scratch.

A roster or booking view. Juggling a team roster, meeting room bookings, or an event RSVP list in rows and columns is hard to read at a glance. Ask Canvas for a calendar-style or grid layout instead.

I have a spreadsheet with these columns: [list your actual columns, e.g. Task, Owner, Status, Due Date]. Build me a Canvas view that: - Groups rows by [the field you want to group by, e.g. Status or Owner] - Colour-codes anything [overdue / over budget / marked urgent] - Shows a count or total at the top of each group Keep my original data tab exactly as it is — this should be a view sitting on top of it, not a change to the raw data.

What it's good at, and what it isn't

Canvas is a visualisation layer. It reads and displays what's already in your sheet — it doesn't check your data for errors, and it won't catch a wrong date or a typo in a status column. If your raw data is messy, the dashboard built on top of it will be messy too, just better dressed. Keep doing your normal data-entry checks; Canvas just makes the result easier to read once the underlying numbers are right.

It also updates live. Change a cell in your source data, and the Canvas view reflects it without you rebuilding anything. That's the actual time-saver here — a dashboard you don't have to maintain by hand every week.

💡 This week's prompt

Pick one spreadsheet you already check by eye every week — a tracker, a roster, a budget — and try building a Canvas view of it with the prompt above. If Canvas hasn't reached your account yet, save this guide and try it the week it lands. This is one of those features that pays for itself the first time you use it.

One thing to check before you rely on it

Because Canvas is new and still rolling out, exact menu locations and available layout options may shift over the coming weeks as Google refines it. If something in this guide doesn't quite match what you see, that's expected — the core idea (describe the view, get a live dashboard) will stay the same even as the interface settles.