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