Help & Documentation
Open Support Ticket

Establish Connectivity to Google Drive

This article describes how to connect to your profile Google Drive in order to use the files from this Data Soure as a basis for the future External Reports in Metric Insigths.

The procedure includes:

  1. Creating a Google Service Account
  2. Sharing your Google Drive files with Metric Insights
  3. Metric Insights' Side Authorization

1. Create a Google Service Account

For this scenario you need a service account, which is an account that belongs to your application instead of to an individual end user. Follow the instructions below to set it up.

For more details, refer to Google Documentation.

1.1. Access Google Developers Console

https://console.developers.google.com/projectselector/iam-admin/iam

When logged in from the account that contains the required files on a Google Drive, follow the link above.

1.2. Create Service Account

Access Service Accounts and click [Create]

1.3. Service Account Settings

  1. Service account name: Define a name for your service account.
  2. Service account ID: This is going to be generated automatically after you define a service account name.
  3. Furnish a new private key: Check this box to create a new private key. The required key type is JSON.
  4. At the bottom of the pop-up click Create.

Once you click Create, the JSON key is generated and automatically downloaded to your computer. Remember the file location.

1.4. Move the File to Server

Put the JSON file into the directory on your server.

The generated key has been downloaded to your computer as a JSON file. Place this JSON file on some directory on your server. For example:

opt/mi/config/google_drive.json

2. Share Google Drive Files with Metric Insights

Once you are done with creating a service account, you need to make sure that all the files that should be accessible by Metric Inisights are shared with this account.

  1. Access the file location.
  2. At the upper right corner of the screen click Share. The Share with others pop-up opens.
  3. In the People field specify the Service account ID. See Step 1.3 for more details.
  4. [Send]

3. Metric Insights' Side Authorization

After setting up the Google Side, create a Google Drive Data Source in Metric Insights:

3.1. Create Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+ New Data Source]
  2. Select "Google Drive" in the Plugin the drop-down list.
  3. [Next]

3.2. Provide the Required Google Drive Parameters

  1. Data Source Name: Give the Data Source a descriptive name.
  2. [Create]
  3. Insert the Client ID and Client Secret, that can be obtained in the Google account.
  4. [Get Token] to generate the Token for connection.
  5. Optionally, Enable On-Demand Element Creation.
  6. [Test Connection] to check if everything works correctly.

3.3. Optional Google Drive Parameters

  1. Drive name filter: Provide a name of the Drive to filter the Objects.
  2. Folder name filter: Provide a name of the Folder to filter the Objects.

3.4. Advanced Data Source Configuration

Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.