Use Google Sheets in Sites

Google Sheets dynamically brings data into Google Sites for powerful insights.

How to Embed a Sheet on Your Google Site

There are several methods available for embedding your Google Sheets on a Google Sites website.

Google Sites Insert Sheets Embed

The benefit of this method is that Sheets can be private, restricted or shared only in your Workspace domain. Users without view or edit permissions will see a screen which prompts them to login or request access from the document owner. Here's how to add your Google Spreadsheet to your website:

In edit mode on your Google Site select Insert > Sheets
Select your Sheet from Google Drive
The only setting available is to select the default tab displayed on load

Onboarding Checklist

Embed an iframe of a published Google Sheet

Inserting a Google Sheet on Google Sites can sometimes look clunky. Customization settings are limited. This way of inserting a Google Sheet allows for adding parameters which will change the look of your embedded view. For instance, you can remove the frameborder and headers for a cleaner look to your iframe widget. You can also remove the appearance of multiple tabs that appear by default.

To publish a Google Sheet and receive an iframe code snipper, go to File > Share > Publish to Web.

Here are the available parameters to add on your published sheet URL:

rm=minimal
rm=full
rm=embedded
rm=demo
rm=(render mode)

ui=2 (select the interface version)
chrome=false (full screen mode)
frameborder=(size of border)
q=(Whatever) Search Query

gid=24 (Which sheet you want to display)
widget=false
single=true
range=A2:AA26
Output=html format=(export spreadsheet)
format=xlsx
format=csv

widget=false
width=(width)
height=(height)
viewer?
start=
channel=
ibd=
client=

Example Code with no frame, bounding box, headers, sheets tabs or scrollbars (vertical and horizontal)