Web
Google Sheets Plugin

Google Sheets

Show live data from Google Sheets, like sales figures or schedules, on your screens.

About

Show live data from Google Sheets on your digital signage screens: sales figures, appointments, schedules and more. Play Digital Signage’s Website plugin embeds the sheet, so your audience always sees up-to-date information.

Video: Google Sheets

Get Started

Add a Google Sheet to your content in a few steps:

Add Google Sheets to a slide

  • 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 field.

Options

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, paste it into the code pop-up. Where to find widgets?

Pre-load website

The player starts loading the plugin 15 seconds before it is displayed, so the website has already loaded when the slide is shown. 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, scrolling 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, but you can set a refresh interval to refresh it more often.

Refresh Interval Seconds

Set how many seconds between refreshes

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 the plugin pixel by pixel.

Sizing

Manually adjust the size of the plugin pixel by pixel

Add Script

This is where you add and edit your scripts. Learn more about website scripting.

FAQ

Can I embed Office 365 spreadsheets?

Yes. Microsoft 365 (Office 365) Excel tables can also be embedded with the Website plugin. Go to File > Share > Embed. In the window that opens, click Generate, 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?

Google doesn’t offer options to change the look, but a product called Awesome Table gives you more customization options.

How to display specific cells?

To display a specific cell range, publish only one sheet of the document. In the “Publish to web” dialog, deselect “Entire document” and make sure only a single sheet is selected.

Once you have selected the sheet, 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 use the range from cell A1 to B2, so we add this parameter to the end of the URL:

&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

Related Articles

Get started designing your content

Most people think designing content for digital signage is super difficult, but if you can use PowerPoint, you can also create and design your own content in our editor.

Book a free demo

Loading free times…