Google Sheets

Adding Google Sheets to your content is easy, follow these simple steps

• Go to Google Sheets and find your sheet
• Make the sheet public by going to File > Publish to web
• Copy the Public URL
• Open your playlist in my.playsignage.com, add the Website plugin, and paste your public URL into the Website address.

• Alignment and Cropping
  • Fit to canvas - Maximize the image to fit the canvas
  • Align Left - Align the image to the left
  • Align Center - Align the image to the center
  • Align Right - Align the image to the right
  • Align Top - Align the image to the top
  • Align Center - Align the image to the center
  • Align Bottom - Align the image to the bottom
  • Locking Objects - Lock images
• Website – If the website is hosted on a server, use the “Website” option and paste the URL.
• HTML code – If you have an HTML code snippet, you can paste the snippet to the code pop-up. Where to find widgets?
• Pre-load website – The player will start loading the plugin 15 seconds before it will be displayed, so when the slide is displayed, the website has already loaded and is ready to display. If the website you want to display has some load animation or video set to autoplay, you can disable this option so that the animation does not run while the plugin is pre-loading.
• Enable scrolling – By default the scrolling behavior is disabled so that the scroll bar is not visible. If you want users to interact with the site, you can enable scrolling.
• Refresh periodically – The website is refreshed every time the slide is shown, however, you can set the refresh interval to refresh more frequently.
• Refresh Interval Seconds - Set how many seconds between refresh
• Zoom – Depending on how the website is built, it may render differently on certain devices. By adjusting zoom, you can make the page fit better.
• Positioning – Manually adjust the placement of your shape pixel by pixel.
• Sizing – Manually adjust the size of your shape pixel by pixel
• Add Script - This is where you add and edit your scripts, learn more.

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, and 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 a 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