All Collections
Apps that automate content updates for your displays
Business intelligence
Google Sheets - Automate KPIs and table data from Google Sheets to digital displays
Google Sheets - Automate KPIs and table data from Google Sheets to digital displays

Integrate digital signage with Google Sheets to automate your KPIs and table data

Katariina avatar
Written by Katariina
Updated over a week ago

Use Google Sheets data to add metrics and visualisations to workspaces across organisations. Share alerts instantly where you know everyone will see them.

App main features

✔ Choose the right file from your Google Drive without the need to make your sheet public​

✔ Secure authenticate using Google Sign In

✔ Easy to use with integration with choose from Google Drive

App settings

✔ Set the desired tab and data Range

✔ Enable automated scrolling if needed

✔ Enable automated width if needed

✔ Create multiple apps out of one Google sheet to target the right content to the right people

Google Sheets - Activate and use

Easiest way for activating a content App is from Valotalive Dashboard. Just click the icon of the content you wish to activate and proceed. More detailed info of the first steps can be found here:

Settings on the Apps' Configuration tab

  1. Authorize using OAuth2 Authorization

  2. Choose the Google Sheet you want to use

  3. SHOW ADVANCED settings

    1. Data range from the sheet

      Type in the data range you wish to show.

      Example: To show contents from Sheet1 with data range B1:C9 type in: Sheet1!B1:C9

      NOTE! Sheet name cannot have spacing as Word Spacing is not supported.
      E.g. Sheet January!B1:C9 does not work, data cannot be fetched.
      But SheetJanuary!B1:C9 will work.

    2. Time to show one screenful

      Use a value starting from 10-15 seconds and count how long does it take to absorb the screenful

    3. How many screenfuls should be scrolled

    4. Show grid borders

      Use a contrast color if you want grid borders to show.

    5. Cell border color

      Use a contrast color if you want cell borders to show.

    6. Scale the content on screen to fit the width

      "Yes" is in most cases the best option for this field.

  4. Rename the App

    Rename the app by clicking the name on top of the page.

    The best practice is to name the App to match the selected data source, in this case the name of the Google Sheets file you are using.

Complete the work by adding the app to a flow or directly to a display.

You might also be interested in this article:

Did this answer your question?