How to Link Google Sheets to Squarespace, Embed Easily 2026

Whatever the sheet looks like now is what your visitors will see, so spend two minutes on it first. Delete working columns you don't want public, put your headers in row one, and freeze nothing — the published view ignores most of that anyway.

Keep the data tight against the top-left corner, because an embed of a sparsely used sheet shows a lot of empty grid. It's also worth making a dedicated tab holding just the public view, fed by formulas from your working tab, so you can keep messy calculations out of sight while still having one source of truth.

In the sheet, go to File, then Share, then Publish to the web. The dialog opens with the note that the document is not yet published and two tabs across the top — Link and Embed — plus dropdowns for what to publish and in what format.

Leave the format as Web page, and choose either Entire document or a single sheet using the left dropdown; picking one sheet is usually what you want, since publishing the whole document exposes every tab. This is a genuinely public URL, not a share-with-anyone-who-has-the-link permission, so treat anything you publish as visible to the world and to search engines.

Switch to the Embed tab and press Publish, and Google replaces the dropdowns with a ready-made iframe snippet pointing at a docs.google.com/spreadsheets/d/e/… address ending in /pubhtml. That trailing part carries two parameters — widget=true and headers=false — which strip Google's own chrome and row numbers so the embed looks like a table rather than a spreadsheet.

Copy the whole tag including the closing angle bracket; a half-copied iframe is the single most common reason an embed shows up blank. Note the warning Google shows here: viewers may be able to reach the underlying data for published charts, so don't publish a sheet with anything confidential on another tab.

In Squarespace, open the page, click Edit, add a block, and choose Code. Set Mode to HTML, leave Display Source Code off, and paste the iframe into the editor.

Here's the catch worth knowing before you build a whole page around this: Squarespace treats JavaScript and iframe embeds as a premium feature and shows an upgrade notice right in the block, meaning the embed will not publish on the entry-level plan. It renders fine while you're editing, which fools a lot of people into thinking it worked — always check the live site, not just the editor.

Straight out of Google, the iframe carries no width or height, so it renders in a small default box. Add width="100%" and a height in pixels to the tag before pasting, or edit it in place afterwards — height is the one that matters, since too little clips your rows and too much leaves dead space below the table.

Then drag the block's handles in the Squarespace editor to place it in the section you want, and use Add Section if the sheet deserves a band of its own. Check the mobile preview using the device toggle at the top right, because a wide table that looks fine on desktop will need horizontal scrolling on a phone.

Embedding isn't always the right answer. If your sheet is wide, long, or full of formatting, a link often reads better than a squeezed-in iframe — and it works on every Squarespace plan, with no premium block involved.

Add a Button block or a Text block, highlight the text, and paste the Link tab's URL from the same Publish to the web dialog. Set it to open in a new tab so visitors don't lose your site. This is also the pragmatic fallback if you hit the premium-block wall and don't want to change plans.

The point of all this is that the connection is live: change a cell in Google Sheets, wait a moment, and the published page reflects it without you republishing anything in Squarespace. Test that once, properly — edit a value, hard-refresh the live page, and confirm it changed — so you trust the setup before handing it to a colleague.

Google caches published output for a few minutes, so an instant refresh may still show the old value; that's normal and not a broken embed. From then on, the spreadsheet is your CMS for that block, and the website needs no further attention.