Skip to main content
Blog
Back to Blog

Publish a Google Sheets canvas dashboard without exposing the sheet

On November 11, 2026, Google began rolling out a way to publish a Sheets canvas, the dashboards and boards Gemini builds on top of a spreadsheet, to its own read-only link without sharing the spreadsheet. Scheduled Release domains get it from December 2. For a founder, that is a quick way to give investors a metrics dashboard, a pilot customer a status board or the public a roadmap. This guide covers who can use it, the data catch Google's help page states plainly, a share-only setup, the audience and update choices, and starter prompts you can copy. It is useful without a Soloop account and is not a statement from Google.

The short answer

A published canvas is a separate link with its own audience. Viewers can use the dashboard but cannot open the spreadsheet by default. They are not limited to what the dashboard shows, though: Google's help page says "The underlying data is sent directly to the browser, so viewers may be able to access it."

So build the canvas on a tab that holds only what every viewer may see, ideally in a separate share-only spreadsheet. Publish it to the narrowest audience that works, use a static snapshot for investor numbers and automatic updates for live boards, and stop publishing when the relationship ends.

What Google launched

A canvas is not a separate product: it lives in a spreadsheet and reads one of its tabs. The details below come from Google's Workspace Updates posts and the Docs Editors Help pages, read on November 19, 2026.

Who gets it

Business Standard and Plus, Enterprise Standard and Plus, Google AI Pro and Ultra, Google AI Pro for Education and AI Expanded Access. Business Starter is not listed. Rapid Release domains from November 11, 2026 and Scheduled Release domains from December 2, each taking up to 15 days to appear.

Workspace Updates: Publish a Sheets canvas as a standalone link
Limits

Web only, not the Sheets mobile app; English only; one tab per canvas and up to 1 million cells of source data; not for files where downloading, copying or printing is disabled; per-user usage limits that Google does not state as a number.

Docs Editors Help: Create a Sheets canvas

What viewers actually receive

The published link hides the spreadsheet file, not the data. External viewers cannot open the spreadsheet by default, but the data behind the canvas is sent to their browser, so a technical viewer may be able to read values the dashboard never displays, such as the customer names behind a revenue total. Google does not say whether hidden rows or columns are left out, so treat everything in the source tab as visible.

What belongs in a share-only source and what stays out
DimensionFine in the share-only sourceKeep out of it
RevenueMonthly MRR totals and growthPer-customer amounts and invoice lines
CustomersCustomer count, or names a customer agreed to showContact names, emails and deal notes
Pilot statusMilestones, dates and owners for that one customerOther customers' pilots and internal comments
RoadmapThemes and rough timing you are willing to say publiclyDates promised to one buyer, pricing ideas and bugs with customer names
CashRunway in months, if your investors expect itBank balances, payroll and salaries

Set up a share-only source

The simplest safe layout is a separate spreadsheet that contains only the rows you will publish. Keep your real model where it is and bring across only summarized values. A separate file also limits what a viewer could reach if you later widen the audience or share the file by mistake.

  1. Create a new spreadsheet named for its audience, such as "Investor dashboard (share-only)". Keep edit access to yourself and your cofounder.
  2. Use one tab, because a canvas reads one tab. Put one row per month or per item, with only the columns the dashboard needs.
  3. Fill it with summarized values: paste values after each monthly close, or use IMPORTRANGE on a summary range of your model if it should follow changes. Never import the whole model.
  4. Read every cell in the tab once. If you would not email it to every viewer, delete it.
  5. Create the canvas from Insert, then Create a canvas, and describe the dashboard. Check each number on the canvas against the tab.

Choose the audience and the update mode

Click the publish icon in the canvas toolbar and choose Publish canvas. Depending on your plan and your admin's settings, the audience can be everyone on the web, your organization or a group your admin set up; Google says consumer accounts can publish to the whole web and Enterprise users can choose admin-defined groups. Then choose how the data updates.

Which audience and update mode fits each founder use
DimensionAudienceUpdates
Investor metricsPublished to the web; send the link only to your investorsStatic; republish after each monthly close
Pilot status boardPublished to the web, one canvas and file per customerAutomatic, so the board follows your updates
Public roadmapEveryone on the webAutomatic, after removing anything not public
Team or advisorsYour organization or an admin-defined groupAutomatic

Check before you publish

  • Confirm your plan is eligible and the publish icon appears. On Scheduled Release domains it arrives from December 2, 2026 and can take up to 15 days.
  • If Create a canvas does not appear, check that your Google account language is English; canvas is English only.
  • Publish from the share-only file, never from your working model.
  • Read every row and column of the source tab, including hidden ones; Google does not say hidden data is excluded.
  • Open the published link in a private browser window to see exactly what a viewer sees.
  • For investor numbers, choose the static view and republish when the month is closed, so a half-entered month never appears.
  • Write down who has each link. To end access, use Stop publishing; otherwise a forwarded link keeps working.
  • Remember that editors of the file can change the canvas and its data; viewers of the published link cannot.

Starter prompts for a founder

Type these in the canvas prompt box on your share-only tab and replace the bracketed parts. Gemini may not support every request, so check the result against the tab and refine it with follow-up prompts.

Download Markdown

Worked example: a monthly investor dashboard

This example is invented to show the workflow. A two-founder B2B SaaS company uses Workspace Business Standard.

  1. The founder creates "Investor dashboard (share-only)" with one tab: month, MRR, paying customers, monthly net burn and cash at month end.
  2. After each monthly close, the founder pastes summarized values from the financial model. The model's per-customer revenue tab never enters the file.
  3. October MRR is $5,040, up from $4,200 in September: ($5,040 − $4,200) ÷ $4,200 = 20% growth. Cash is $252,000 and net burn is $18,000 a month, so runway is $252,000 ÷ $18,000 = 14 months.
  4. The founder publishes the canvas to the web as a static view and puts the link in the monthly investor update, then republishes after the November close.
  5. Each pilot customer gets its own file and canvas in place of weekly status emails. When a pilot ends, the founder stops publishing that link.

Where Soloop fits

Soloop does not connect to Google Sheets and does not build or publish dashboards. Use Google's canvas for the dashboard itself.

According to the Soloop manual, Soloop can research a market with sources and send outreach through a connected Gmail account, publish X posts and replies through a connected account, and run Google Ads search campaigns after setup and payment, with actions waiting for your approval by default.

Sources, limitations and refresh

Google's Workspace Updates posts and Docs Editors Help pages were read on November 19, 2026, eight days after the publish option began rolling out to Rapid Release domains. Google does not say whether hidden rows or columns reach the viewer's browser, which audience options each Business edition shows, whether published canvases can appear in search results, or what the usage limits are; this guide assumes none of them and keeps only shareable data in the source. The tables, checklist, prompts and worked example are editorial guidance, and the example is invented.

This guide will be reviewed by February 19, 2027, or sooner if Google changes eligibility, what a published canvas sends to viewers, or its audience options.

Google

English only; one tab and 1 million cells; not in the mobile app; read-write for editors; external viewers see the displayed data, and the underlying data is sent to the browser.

Docs Editors Help: Create a Sheets canvas
Product capability

The Soloop manual describes research with sources, Gmail outreach, X posting and Google Ads campaigns, with approval first by default. It does not connect to Google Sheets.

Soloop product manual