Googlesheet datasource
To create a calendar datasource you need to create and authenticate your Google credential in the Wallboard system.
Googlesheet credentials:
1. Navigate to Settings > Cloud Integration > Google credentials
2. Click on the Add new and select the Spreadsheet
scope
3. You can also select teams if necessary.
4. After you filled the required fields, authenticate the credential with the Sign in with Google
button, this way you can create external datasources from the aquired files.
Create datasource
Go to the Datasources > Click on the Add new
inside the External datasource tab > Choose the Googlesheet
type.
1. You have to decide how your datasource updates from the original source, either by selecting a Refresh Frequency
or by specifying a Cron Expression
2. For Credential, select the credential
you created before then select your Folder, then the spreadsheet and sheet you wish to use.
3. You also have the option to configure alternative settings for both the datasource
First row is header
Legacy format
Active
Ignore Error counter
and the editor.
Cache external resources
Remove broken external resource references
Rotate cache on every update
Exchange internal resource references
Request settings
You can randomize arrays if you enable the Randomize arrays
function.
4. If all this is done you can click on the save
then you are done!