Embedding Google Sheets

The process of Embedding Google Sheets in your digital signage content is as follows:

  1. Make the sheet public by going to File -> Publish to web
  2. Copy the link given and add it as a web page in our editor

Embedding Google Sheets in your Play Digital Signage content

FAQ

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 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