Search results

Connecting Bold BI to Google Drive data source

What is Google Drive - Google Drive is a storage service offered by Google to store files and folders in the web based cloud drive. It also provides support for synchronization service with your local devices that will keep the files sync with the Google Drive and add benefit for backup system and reduce the local storage usage.

Connecting to a Google Drive

Bold BI dashboard designer allows you to connect files which is uploaded in Google Drive. It supports xlsx, xml, csv and json format files.

To enable this connection, follow the given steps:

  1. Click the Data Source button in the configuration panel to add a new data connection.

Data Source panel

  1. Click CREATE NEW to launch a new connection from the connection type panel.

Create Data source

  1. Click Google Drive connection button in the connection panel.

Google Drive icon

  1. New window will appear. Here, select your account or click Connect New Account in the window opens.

Connect to account

  1. The login window opens to authorize the user. Enter appropriate username and password for your account from which you want to access the Google Drive data.

Sign in

  1. The authorization window opens. Here, click Allow to authorize Bold BI application for downloading your Google Drive files and view meta data for your files.

Allow Access

  1. Now, Google Drive window appears. Set a data source name and choose file as shown in the following image.

File Storage

  1. Bold BI allows different Import type for Excel files. Click here to know more.

Import File

  1. You can schedule refreshes to keep your data on the dashboard up to date using Refresh Settings option and click here to know more.

Refresh Settings

  1. Now, click Select and then preview window will appear. Here, you can choose your preferred Tables and Columns.

File Preview

  1. Click Connect and you will be navigated to data source designer page. Here, the worksheets/tables are listed in a tree view on the left side of the editing window.

  2. Now, drag and drop the worksheet/table you want to analyze, and preview the data by clicking Update.

Data Preview

  1. Click Save to save the data source.

For more information on the API endpoints available for this data source, refer to their official API Documentation

NOTE: To obtain the client ID and client secret for the Google-related data sources, Refer to the Google OAuth Documentation.

Data Transformation

Editing a Data Connection

Dashboard Designer Walkthrough

Google Drive Integration

How to set up OAuth 2.0 authorization to access Google applications in Bold BI

Create and Embed Dashboards with Data Stored in Google Drive