Google Sheets in Digital Signage
Google Sheets in Digital Signage is a great way for you to add your sheets to your content by simply adding your sheets URL to our Website plugin. Perhaps you’re looking for a way to keep the information updated in Google and still have it embedded in your digital signage content.
Embedding Google sheets, docs, etc., requires the use of our Website plugin.
What is Google Sheets in Digital Signage?
The process of Embedding Google Sheets in your digital signage content is as follows:
- Make the sheet public by going to File > Publish to web
- Copy the link given and add it as a web page in our editor
Other Google APP’s Google Docs, Google Maps, Google Slides, Google Calendar
FAQ
Can I embed Office 365 spreadsheets?
Office 365 excel tables can be embedded also with the website plugin. Go to File -> Share -> Embed. You’ll be presented with a window to generate HTML, click on the Generate button, copy the URL inside the src=”” parameter of the embed code that is shown.
Can I customize the look and feel of the embedded table?
By default Google does not offer visual customization options, however, you can look into a product called awesome-table for further customization options.
How to display specific cells?
To display specific cell ranges, you have to publish only one page of the document. In the “Publish to web” dialog de-select “Entire document” and make sure only a single sheet is selected.
Once you have the page selected, you should see a URL like this:https://docs.google.com/spreadsheets/d/e/2PACX-1vRs4_Mn9efvvzTMYSB6is2IhURXp45aeDGImPHixMuJ0OkQ1OvwuHhPB2MjHHVneYMGZ4U_a-GzE4vG/pubhtml?gid=0&single=true
In this example we’ll use range from cells A1 to D3, so we’ll need to append the URL with a parameter: &range=A1:B2
The final URL that needs to be used in the website plugin becomes:https://docs.google.com/spreadsheets/d/e/2PACX-1vRs4_Mn9efvvzTMYSB6is2IhURXp45aeDGImPHixMuJ0OkQ1OvwuHhPB2MjHHVneYMGZ4U_a-GzE4vG/pubhtml?gid=0&single=true&range=A1:B2