Google API - Google Sheets

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:

1. Login to the admin console
   Note: Admin or Super User account required
2. Open Contegro Start > Administration > Global Module Settings
   
3. Open 'Google API'
   
4. 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:

1. Complete the authentication steps above
2. 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

1. Copy shared templates
   1. Open the supplied link in your browser (e.g. https://docs.google.com/spreadsheets/d/..../copy)
   2. Click [Make a copy]
      
   3. Sign in with your Google Account
      
   4. Rename the file
      
   5. Move the saved file to your Google Drive folder
      
2. Delete empty cells - Remove empty columns and rows
   
3. 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.
   
4. 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.