Data sources

Google Spreadsheets

The Google Spreadsheets data source is used to retrieve tabular data from Google Spreadsheets for further use in Peakboard.

To add the data source, right-click on [Data] or alternatively click on the […] button and then select [Add data source] and [Google Spreadsheets] (1).

Add data source

Authorize access to Google

Give the data source a name (1). After that you have to connect to a Google account. Click the [Authorize] button (2).

Authorize Google

A login window will open where you have to enter your Google credentials. This gives the Peakboard Designer the right to read tables as an application. Username and password are not stored in the Peakboard Designer. A token is generated which you store in the project and which is later transferred to the Peakboard Box. You can revoke this token for access at any time within your Google account. Copy the generated token (1).

Copy token

Paste the token in the Peakboard Designer and confirm the authorization (1).

Insert token

Set up table access

The […] button (1) allows browsing through the Google Drive folder structure that contains the tables. After selecting them with a double click, the path and file name will be copied to the corresponding text field.

In order to now select the correct section from the spreadsheets as the data basis, the following settings are possible:

  • Worksheet (2) here you define which worksheet from the selected document should be used if several are available.
  • Select all (3) means that all data of a worksheet will be selected and not only a certain section.
  • Range (4) you can specify this value if only a certain section of the worksheet is to be read. The notation is as usual in Excel e.g. A5:C26.
  • Max. rows (5) defines the maximum number of rows to be read, provided that no range is specified.
  • Column names in first row (6) means that the column contents of the first row are used as headers for the output columns.
  • Swap rows and columns (7) treats the rows and columns each in reverse, just like a pivot table.

With the [Reload interval] (8) you define the time interval for the automatic reloading of the data in seconds. A click on [Load data] (9) shows you a preview of the data according to the settings and updates the metadata in the column list.

Set up access

We are learning from you!

Did you find this article helpful?

Be enlightened!

Do you need more support?

Peakboard Youtube icon Visit our YouTube channel

Our numerous videos for beginners and advanced users explain exactly how to design your dashboard.

Peakboard Templates icon Visit the Peakboard Templates

Download our templates for various use cases for free.

Peakboard icon Visit

Find out all about Peakboard and browse our different use cases and success stories.