User icon
Google Sheets for Digital Signage

Google Sheets

Google Sheets is a great way for you to add your sheets to your content by simply adding your sheets URL to our Website plugin.

About

If you are using Google Sheets for sales statistics, appointments, factory times, etc., you can easily embed them in your content using our Website plugin.

Get Started

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.

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

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, 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
capterragetappsoftware-advice

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.

Play Digital Signage, Inc., 2035 Sunset Lake Road, Newark, DE, 19702, USA
We use cookies to ensure that we give you the best experience on our website.Learn more about Privacy Policies
Allow