How Can I Use the Google Sheets App?

The Google Sheets App is a tool to incorporate Google Sheets into your digital signage. The steps below provide guidance for preparing your spreadsheet and adding it to the Google Sheets App.

The Google Sheets App is available in the Signagelive Marketplace. If you are unsure how to find and use this, please see this article.  

How do I prepare my spreadsheets?

First things first, you will need to ensure that your document is formatted so that your Spreadsheet will display correctly once on screen. You can configure this within Google Sheets before saving your Spreadsheet.

Now, you’ll need to Publish your Spreadsheet to the web. You can do this by following these steps:

1. Select File
2. Select Publish to Web
3. Select Link tab
4. Choose between showing all sheets, or a specific sheet
5. Ensure that “Require viewers to sign in with their [Company Name] account is unchecked
6. Select Publish

Top Tip: Once you have the URL for your Slides presentation, you can just copy and paste that into the App and then configure the settings there.

How do I display my spreadsheet in the App?

Once you have added the Google Sheets App to your network you can select it in the library, or move it to a playlist. From there you can;

• Enter Properties
• Add the URL from your sheet using the process above to the App properties

And that’s it! Set the other properties like any other asset you’re ready to publish!

How can I update my spreadsheet?

Now that your spreadsheet is published to the web, you can simply update the Google Sheets document with any changes, and this will then automatically update on your Signagelive Player the next time the asset loads in a playlist.

How do I add my own image to the transparent background menu?

If you're looking to use your own image under the transparent menu app, you will need to create two playlists. 

The first playlist will have your menu app with transparent properties.

The second playlist will store your image or video background. (You can use multiple images or videos if you choose).

Once you have those two playlists, you will need to create a layout background. By creating two zones on top of each other, you will be able to see your menu items over your own playlist. 

When publishing, make sure to add your background to the zone at the bottom and your menu playlist to the top. 

How can I find out more?

You can speak directly to the Signagelive Support team via Live Chat or by emailing. You can find out more about contacting the team, here.