Skip to main content

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!