Publish or embed a selected sheet with exposure checks

Quick answer

Use File > Share > Publish to web, choose the individual summary sheet rather than the entire spreadsheet, and check the intended audience before publishing. Publication is separate from named-person sharing. To withdraw it, use Published content & settings > Stop publishing; removing an ordinary sharing link is not enough.

Prepare a deliberately harmless example

This is a desktop-web workflow for a Google Sheets file you own or are authorized to publish. Work or school policy may disable publication. Do not change organizational restrictions to make the exercise work. The result can be visible to the public, your organization, or an organizational group depending on account settings, so establish that boundary before proceeding.

Create a private practice workbook with two tabs. On PublicSummary, enter the following cells:

Cell	Content
A1	Workshop
B1	Places available
A2	Morning
B2	12
A3	Afternoon
B3	8
A4	Total
B4	=SUM(B2:B3)

On PracticeNotes, enter A1 Not for publication and A2 Synthetic planning note. Do not use a real confidential note to test exclusion. The starting total is 20. The exercise succeeds only if the selected summary is visible as intended and the practice note is not included in the published selection.

Review the whole summary, including off-screen rows and columns, before continuing. A safe visible rectangle does not justify publishing a tab containing sensitive material elsewhere. Use a separate public-only workbook when separation matters. Hidden rows, presentation styling and an obscure URL are not a confidentiality plan.

Review the publication boundary

Open File > Share > Publish to web. Select PublicSummary, not the entire spreadsheet. Inspect the offered format and audience implications. If the dialog cannot establish an acceptable scope, cancel. This is a valid completion of the safety review, not a reason to experiment on live records.

Record a small preflight checklist: workbook name, selected tab, intended audience, the three expected values 12/8/20, and the person responsible for withdrawing the publication. There should be no personal details, internal identifiers, comments copied into cells, or unexpected source values in that selection. A published chart can expose the data behind it, so do not replace this check with a chart that merely looks anonymous.

Only after the audience and content are authorized, click Publish and retain the generated URL. Inspect that URL in an audience-appropriate viewing context. A view in your signed-in editor session alone does not demonstrate what another viewer can access. Check that the output contains Morning, Afternoon and Total with 12, 8 and 20, and that the unwanted tab is not among the published content. Do not send the link to additional people just to test it.

Check a controlled change

Change PublicSummary!B3 from 8 to 9. B4 should become 21 in the source immediately after recalculation. With automatic republishing enabled, the published values should eventually become 12/9/21; allow a few minutes rather than declaring a stale view a failure instantly. Reload the published view and record what it shows.

Open Published content & settings and inspect which tabs are selected again. Unwanted tabs should remain unchecked. The important changed case is not merely that 21 appears: it is that the same restricted selection remains in place while the source changes.

If you need a deliberately stable public snapshot, the same settings include Automatically republish when changes are made. Turning that off changes the update policy, not access rights. Label the public output with a clear as-of date rather than implying it is live. Keep the practice exercise on automatic updates unless you specifically want to investigate snapshot behavior.

Embed only after the same review

For an authorized website, choose the dialog’s Embed option, select the intended sheet, publish, and copy the supplied HTML into the site’s approved embed area. A website preview is not evidence that the underlying workbook’s publication scope is safe. Recheck the source publication settings after embedding.

Parameters that hide headers or tabs alter presentation, not the original disclosure decision. Do not treat a cropped embed or a hidden tab bar as access control. No website or embed is created by this tutorial.

Withdraw and verify

Return to File > Share > Publish to web > Published content & settings, choose Stop publishing, and confirm the intended withdrawal in the product. Revisit the saved published URL and the embed, if used, to check they no longer supply the live publication. Previously copied values or downloaded copies cannot be recalled by this action.

Restore B3 to 8 if keeping the practice workbook. Close and reopen it to confirm 12/8/20 and inspect the publication settings once more. A workbook saved in Drive, a downloaded spreadsheet and a public URL are different artifacts; keeping one does not prove the others were withdrawn.

Troubleshooting and evidence

A missing publication command can reflect administrator policy. An unexpected tab indicates a selection problem: stop publication before investigating. A stale total calls for checking the source formula, automatic-republish setting and update delay. If the audience is unclear, do not publish.

This exercise was checked against documentation, not executed in a Google account; there are no native screenshots or verified publication events.

Official references

See Google’s publication, embedding and withdrawal instructions.