Embedding Google Sheet cells

How does one embed cells of a Google Sheets document into Squarespace?

All of my attempts to used the Embed Block have failed, all returning the "URL is not embeddable" error.

Also, any guidance on what I would need to put into the Custom CSS, if anything, would be much appreciated.

Thanks!

Hey,

I know the question is a bit old but it does come up quite often.

For this it is best to use Google's built-in option to create an iframe:

File > Publish to the Web > choose the Embed option and copy the code. This will give you a code that looks like this:

<iframe src="https://docs.google.com/a/....../pubhtml?widget=true&headers=false"></iframe>

This won't look great with the automatic height and width so you can add these in:

<iframe width="100%" height="500px" src="https://docs.google.com/a/.../pubhtml?widget=true&headers=false"></iframe>

Hope this helps someone else!

YOU ARE GENUIS! Thank you!

The embed/iframe approach will work, but your content won't be crawlable; therefore, I added my Google Sheets content directly to my Squarespace site. Here's how - https://selfaware.blog/home/2018/8/16/add-google-sheets-content-to-your-site

On 1/11/2018 at 2:28 AM, dimsk said:

Hey,

I know the question is a bit old but it does come up quite often.

For this it is best to use Google's built-in option to create an iframe:

File > Publish to the Web > choose the Embed option and copy the code. This will give you a code that looks like this:

<iframe src="https://docs.google.com/a/....../pubhtml?widget=true&headers=false"></iframe>

 

 

This won't look great with the automatic height and width so you can add these in:

<iframe width="100%" height="500px" src="https://docs.google.com/a/.../pubhtml?widget=true&headers=false"></iframe>

 

 

Works great! Thanks.

I set the sheet's sharing to 'anyone with the link can view' and put its url in an iframe. In css I set iframe {height:100vh;}

demo: https://letsgetdigital.net/google-sheet-test

B