Get the weekly newsletter that makes you better at Google Sheets, Productivity, and Finance.
TL;dr: Google announced on November 11 that a Sheets canvas can now be published as its own standalone link, which means viewers get read-only access to interact with the mini-app, a dashboard, a kanban board, or a calendar, without ever seeing the source spreadsheet underneath it, and the published link has its own audience setting, so you can publish a canvas to your whole organization even if the file itself is shared with a smaller group, and you choose up front whether the published view republishes automatically whenever the source data changes or stays frozen as a static snapshot, which is the decision that matters most, because a live dashboard and a frozen snapshot are two different promises.
The sharing problem this fixes is one every finance team has hit, because until now a canvas was only as shareable as the spreadsheet under it, and sharing the spreadsheet meant sharing the model, the raw data, the workings, and every tab you never intended anyone to see, so the usual answer was to build a second, cleaned-up copy of the file and share that instead, which is how a team ends up maintaining two versions of the same dashboard and wondering which one is current. Publishing the canvas breaks that link, because the viewer sees the mini-app and nothing else, and the source sheet stays private, and the audience setting is separate from the file's sharing, so the group that can open the canvas and the group that can open the file are two different lists, and that separation is the whole point of the feature.
Setting it up is short, and the mechanics are worth knowing before you click anything. You can only publish a canvas you have edit access to, and you do it from the canvas toolbar, where the share icon opens a "Publish canvas" option, and from that same menu you can copy the link, change the audience, or stop publishing at any time, and publishing is currently available in Sheets on the web only. The choice Google gives you at publish time is between automatically republishing the canvas whenever changes are made to the source sheet and publishing a static view based on the current state of the data, and that choice deserves a deliberate answer rather than the default, because a monthly close dashboard that updates itself is exactly what you want, while a board pack that changes under the reader after you sent the link is exactly what you do not want, so pick live for the working dashboard and static for anything that is meant to be a record of a moment.
There are two traps to check before you publish anything that matters, and both of them are the kind of thing that only bites once. The first is that canvas publishing uses the existing Publish to the web capability, so the Drive sharing setting that allows users to publish files on the web applies, and if your admin has that switched off, the publish option will not do what you expect, so check the setting before you promise anyone a link. The second is availability, because this sits behind paid Workspace and AI plans, Business Standard and Plus, Enterprise Standard and Plus, Google AI Pro and Ultra, and the education and expanded access add-ons, and creating and editing canvases is subject to per-user usage limits, so if you are on a free personal account you will not see it, and if you are on a paid plan you should still know the limits exist before you build a workflow around them. The rollout is gradual, with Rapid Release domains starting November 11 and Scheduled Release domains starting December 2, and it can take up to fifteen days for the option to appear, so if you do not see it yet, that is why.
There is also a limit worth stating plainly, because a canvas is a view and not a model, and the two jobs are different. A canvas shows the story, a dashboard with the numbers arranged the way a reader needs them, and it does that well, but it does not show formulas, it does not let a reader audit a calculation, and it does not replace the spreadsheet for anyone who needs to check the work, so when the audience needs to verify rather than just view, share the sheet itself, or share both, with the canvas as the front door and the sheet behind it for the people who are allowed to look. The governance rule that follows from that is simple, which is to decide for each audience whether they need the view or the model, and to publish the canvas when the answer is the view, because that is the case where the old way forced you to overshare.
Setting up your first published canvas takes about fifteen minutes, and the work is mostly deciding what the canvas shows before you publish it. First, make a copy of the template below, because the template itself is read only and your copy is where the work lives. Second, go to the Budget dashboard tab and replace the example rows with your own categories, budgets, and spending so far, and read the remaining and percent used columns, because the canvas you build from this sheet will show exactly what those columns show, and nothing else. Third, build the canvas from the sheet, and check what it displays before you publish, because the canvas is the only thing your viewers will see, so anything you do not want them to see should not be in the canvas data in the first place. Fourth, go to the Publish checklist tab and work through it in order, because the order matters, starting with the audience, then the live versus static choice, then the Drive publish setting, then a test of the link as a viewer, and finally a note of how to stop publishing, because a published link you cannot find how to revoke is a link you should not have sent. Fifth, publish it, and send the canvas link rather than the sheet link, because that is the habit this feature exists to build.
That is the practitioner way to share a dashboard, and it is deliberately boring, because the boring version is the one that keeps the model private and the view current. Share the view, keep the model, and pick live or static before you publish, because the choice you make at publish time is the promise you are making to everyone who opens the link.
Template: template: Canvas-ready shareable budget dashboard (Google Sheets, make a copy to use it)
- Francois
Get the weekly newsletter that makes you better at Google Sheets, Productivity, and Finance.