Our Google API module helps you to connect your Google Sheets data to your digital signage.
Follow the steps below to:
- Connect your Google Account and authorise use of your data
- Link your Google Drive folder(s)
- Google Sheets - Tips & Tricks
To connect with your Google Account, we need you to authorise access to your data:
- Login to the admin console
Note: Admin or Super User account required - Open Contegro Start > Administration > Global Module Settings
- Open 'Google API'
- Authenticate one or more Google Accounts
NB: If your browser has a pop-up blocker, please adjust the settings to allow the 'Google sign in' page to load.
To link to your Google Drive folders:
- Complete the authentication steps above
- Open your Google Drive folder and copy the folder ID into the global settings
TIP: Hit enter or add a line break to add multiple Google Drive Folder IDs
Google Sheets - Tips & Tricks
- Copy shared templates
- Open the supplied link in your browser (e.g. https://docs.google.com/spreadsheets/d/..../copy)
- Click [Make a copy]
- Sign in with your Google Account
- Rename the file
- Move the saved file to your Google Drive folder
- Delete empty cells - Remove empty columns and rows
- Images - Valid URLs can be used to insert images in your Google Sheet. We highly recommend that you host images locally on your website, a secure site or FTP folder with 'Read' permissions. To link to an image URL, enter =image("<add URL between quotations>") in the cell.
- Caching - The 'Minutes to cache Google API calls' global setting determines how long it will take for documents and changes within the linked Google Drive folder(s) to be updated in Contegro.
Comments
0 comments
Article is closed for comments.