Earlier this year we introduced Sheets canvas, which uses Gemini to turn spreadsheet data into interactive mini-apps like dashboards, kanban boards, and calendars. Starting today, you can publish a Sheets canvas directly to its own link, granting others read-only access to interact with the mini-app without sharing the full source spreadsheet. The published link is separate from the spreadsheet URL and 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.
For example: You can only publish a Sheets canvas that you have edit access to. To publish, click the icon in the canvas toolbar, then click the “Publish canvas” option. A user can also choose between automatically republishing the canvas whenever changes are made to the source sheet or publishing a static view based on the current state of the data. From the same icon, you can copy the link, change the audience, or stop publishing at any time. Publishing is currently available in Sheets on the web.
Publishing a Sheets canvas from the icon in the canvas toolbar, then opening the published link from an account without access to the spreadsheet
Note: Creating and editing Sheets canvases is subject to per-user usage limits. See the Help Center for more information.