App Guide: Google Sheets

Avatar
by Nor Kanjanahattakij
Follow

The ScreenCloud Google Sheets app makes it easy to build spreadsheets online, that can be published to your digital signage screens. Create a spreadsheet, send it live then add the URL to the ScreenCloud Google Sheets app. This allows you to share and review spreadsheets from your TV monitor using easy digital signage software.  

With the ScreenCloud Google Sheets app you can:

  • Publish any Google Sheets spreadsheet to your screen
  • Choose which cells to show
  • Make live updates, which filter through automatically to your screen

Here’s how it works:

1. Select and install ScreenCloud’s Google Sheets app

To begin, follow this link and select ‘Install this app’ in the bottom right-hand corner. This will log you into your ScreenCloud account, or prompt you to set up our free trial in order to use the Google Sheets app and others within our App Store. 

  • Once logged in select ‘Add this app’ from the top right-hand corner:

ScreenCloud Google Sheets app

2. Publish and embed your spreadsheet

Create your spreadsheet in Google Sheets. Once you’re happy with this, you’ll need to publish the file in order to make it live and to grab the embed code that will make it viewable from your ScreenCloud account.

You can publish the file by following these steps:

  • Open the spreadsheet in Google Sheets
  • At the top, click File and then Publish to the web

Once you have published your file, you will see a tab called “Embed”. By clicking on this you will see an embed code:

Google digital sign

  • Copy this code and add it to the ‘Embed’ field in the Google Sheets app setup panel:

Embed Google sheets

3. Choose your Google Sheets app settings

Now you’ve added your embed code, you can choose the rest of your settings which will determine how your spreadsheet is displayed. 

  • Cell range - choose which cells to show on your digital screen. Note, you need to provide the cell from the top left-hand corner to the bottom right-hand corner of the cells you wish to show. 
  • Toggle titlebar - turn your titlebar on or off.
  • Sheet title - create a custom heading for your spreadsheet.
  • Zoom factor - choose how far to zoom in onto your content. 

Google sheets on screen

4. Preview your results

Once you’re happy with your Google Sheets app settings you have the opportunity to preview it before it gets added to a playlist. This helps you to determine the position of your cells and how many to show. 

Click ‘Preview App’ and a small popup will show the sheet as it will look on your digital screen.  

Google sheets app

5. Add the Google Sheets app to a playlist

Once you’re happy with your spreadsheet, you can add it to one of your digital signage playlists.

Select ‘Add App’ and choose a name for your spreadsheet, for example ‘Google Sheets - Headlines’. This will help you to spot it later if you’re adding more than one spreadsheet to your feed. 

Google sheets add app

  • Next, go to ‘Playlists’ and drag and drop your spreadsheet from the app selection bar on the right-hand side to the playlist of your choosing:

Google sheets app playlist

______________________________________________________________________________

Frequently Asked Questions:

My spreadsheet won’t show

  • Please ensure that your spreadsheet is published to the web. If it has not been published it will not show in your playlist - please note, creating an ‘anyone can view’ file is not the same as publishing the file to the web. You can check if it is published to the web by turning off any of the sharing settings in the Google Sheets document (ensuring it is still published to web) and opening it in a browser where you are not logged in to your Google Account.

How long will the sheet play for?

  • Each sheet will play for the amount of time you have set within the playlist. 

How often does the app refresh? 

  • The app will check for update every five minutes. 

______________________________________________________________________________

If you have any additional questions or concerns on the Google Sheets App, or any other questions or feedback about your ScreenCloud Membership, feel free to reach out to our support team at support@screencloud.io or give us a call at +1-415-449-5426, then follow the prompts to reach support.

Comments

0 comments
Please sign in to leave a comment.