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 in to 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.
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.
Copy this code and add it to the ‘Embed’ field in the Google Sheets app setup panel.
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.
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.
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.
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.
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.
For further questions please contact firstname.lastname@example.org with details.