How to customize Google Sheets embed

Question

Back in the day, I know it was possible to really customize your Google Docs/Forms. Is that still the case? There were all these tricks about how to make it look the way you want when you embed them onto a page (and remove Google's branding). The closest post I'm finding is from 2014 and it doesn't appear to work anymore.

What I'm trying to do is embed a small table into a webpage -- and only that table. I don't want anything else from Google. This table will be updated by me on the backend, so it can't be just an image.

You have to publish to the web and then get the iframe code to embed. At the top of your Spreadsheet , click File and then Publish to the web. Click on the Embed tab and then on the "Publish" button, this will generate the iframe element you can use in your web. Is that what you needed? — Andres Duarte
Thanks for your help! What I'm looking for is the ability to really customize the appearance of the Google Sheet within its iframe. The example I linked to allowed you to pull out just specific cells from Google Sheets and embed them onto your page. That'd be an awesome application instead of trying to embed the whole sheet. — user3753138

Andres Duarte Andres Duarte · Accepted Answer · 2020-02-28T15:00:08

You have to publish to the web and then get the iframe code to embed. At the top of your Spreadsheet, click File and then Publish to the web. Click on the Embed tab and then on the "Publish" button, this will generate the iframe element you can use in your web.

Within the iframe, there's the src attribute with a URL you can edit with some query parameters to customize Sheet's behaviors, for example, to specify the range to be displayed in the iframe, you can add the range query parameter:

<iframe src="https://docs.google.com/spreadsheets/d/e/[SPREADSHEET-ID]/pubhtml?gid=0&amp;range=[RANGE]&amp;single=true&amp;widget=true&amp;headers=false"></iframe>

In your case it would appear your Spreadsheet ID and you need to replace the [RANGE] with the A1 notation of the range you want to display.

How to customize Google Sheets embed

1 Answers