What is Google Drive - Google Drive is a storage service offered by
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:
Data Sourcebutton in the configuration panel to add a new data connection.
CREATE NEWto launch a new connection from the connection type panel.
Google Driveconnection button in the connection panel.
Connect New Accountin the window opens.
Allowto authorize Bold BI application for downloading your
Google Drivefiles and view meta data for your files.
Importtype for Excel files. Click here to know more.
Refresh Settingsoption and click here to know more.
Selectand then preview window will appear. Here, you can choose your preferred
Tables and Columns.
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.
Now, drag and drop the
worksheet/table you want to analyze, and preview the data by clicking
Saveto 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.