The Sheets app allows users to access the data stored in their Google Sheets docs. The docs remain private and secure – no need to ‘Publish to the web’ or ‘make public’ beforehand. As such the app is well suited to internal data, such as price lists, KPIs or financial data, where company guidelines may prohibit general public release.
The user starts by selecting the Sheets app from the Apps drawer in the ScreenScape media editor. If authorization has not been previously provided, they grant ScreenScape an access token to retrieve their data from their Google Drive account. This is a one time step; subsequent connections will default to the same account. Once access has been granted, they cut&paste the URL of the spreadsheet they want to access, and identify the sheet and cell range they want displayed.
ScreenScape’s app will automatically add media layers that correspond to the cells where the data is located. For example: A cell range of “A1..B2” will insert 4 layers into the media item ( A1, A2, B1 and B2); A cell range of “A1..D4” will insert 16 layers (!) into the media item (A1, A2, A3, A4, B1, B2, B3, B4, C1, C2, C3, C4, D1, D2, D3, and D4). [Note: We recommend keeping your cell range to <10 cells for simplicity’s sake; the max number of cells is 30.]
The current values of the referenced cells will be added as Text layers. The layers can be repositioned, formatted and styled just like any other text layer. As the value of the cells are updated in the spreadsheet, the reference layers in the media item will also update.
How is this useful? Why would you use it? Why not, for example, just login to ScreenScape and change the values directly? While seemingly very simple, this basic connection to a spreadsheet app like Google Sheets can supercharge your digital sign.
Looking for more? Here you go:
5 great ways to power up your sign with the Sheets app
Sheets app FAQ