Skip to main content
waffle.svg
Domo Knowledge Base

Google Drive Service Connector

Version 3

 

ImportantDue to Google’s change in allowing Domo connectors to use OAuth authentication, all users must now use service account key authentication to create new data connections. To create new Google Drive DataSets, use this connector. All pre-existing Google Drive DataSets will continue to run normally. 
 

Intro

Google Drive is a file storage and synchronization service developed by Google that allows users to store files in the cloud, synchronize files across devices, and share files. Use Domo's Google Drive Service connector to retrieve Excel and CSV files from a Google Drive account and output them as Domo DataSets. To learn more about the Google Drive API, visit their page (https://developers.google.com/drive/).

You connect to your Google account in the Data Center. This topic discusses the fields and menus that are specific to the Google Drive connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Prerequisites

To connect to a Google service account, you must have a Google service account JSON key. To generate a key, do the following:

  1. In the GCP Console, open the IAM & Admin page.

  2. Click Service accounts in the left-hand navigation pane.

  3. Select your project and click Open.

  4. Click Create Service Account.

  5. Enter a name and description for the service account.

  6. Click Create.

  7. Select Project Owner.

  8. Click Continue.

  9. Click Create key.

  10. Select JSON as the key type.

  11. Click Create.

A private key will be saved to your computer.  

Connecting to Your Google Service Account

This section enumerates the options in the Credentials and Details panes in the Google Drive Service Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane  

This pane contains fields for entering credentials to connect to a Google service account. The following table describes what is needed for each field:

Field

Description

Service Account Key JSON

Copy and paste the JSON for your Google service account key. For information about creating a key, see "Prerequisites," above.

Once you have entered a valid key, you can use the same account any time you go to create a new Google Drive Service DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

In this pane, you can choose to import a list of files in your Google Drive account or specify a Google Drive file to import into Domo and set options for how you want the data to appear.

Menu

Description

Report

Select whether you want to import a list of files ("Files") or download a specific files ("FileDownload"). 

How Would You Like to Choose Your File?

Select how you want to choose the file you intend to import into Domo. Select Enter File Name or Enter File ID to enter the name or ID yourself. Select Files Discovery to choose your file from a list of files.

File ID

Enter the ID of the file you want to import. To see all IDs for files in your account, run the "Files" report.

File Name

Enter the name of the file you want to import from Google Drive. 

File Discovery

Select the file you want to import into Domo.

MIME Type

Select the MIME type of the file you want to import into Domo.

What File Type Would You Like to Import?

Select whether your file is a CSV, XLS, or XLSX file.

File Password (optional)

Enter the password needed to access the requested file. 

Sheet Name (optional)

Enter the name of the sheet in which the file is found. If you do not enter a sheet name, data will be pulled from the first sheet in the file.

Delimiter 

Select the delimiter to use to parse your CSV file. To choose a custom delimiter, select Other, then enter your delimiter in the Custom Delimiter field.

Custom Delimiter

Enter the custom delimiter you want to use to parse your CSV file. Enter tab or Unicode characters in \uxxxx form (e.g. \u005e). 

Quote Character

Select the desired quote character for parsing your CSV file. (A double quote is the CSV standard.) To choose a custom quote character, select Other, then enter your quote character in the Custom Quote Character field. 

Custom Quote Character

Enter the custom quote character you want to use to parse your CSV file. 

Escape Character

Select the escape character to use to parse your CSV file. To choose a custom escape character, select Other, then enter your delimiter in the Custom Escape Character field.

Custom Escape Character

Enter the custom quote character you want to use to parse your CSV file.

Header Start Row (Optional)

Enter the header start row for your Excel file. 

Data Start Row (Optional)

Enter the data start row for your Excel file. 

Footer Rows to Skip (Optional)

Enter the number of rows to skip at the end of your Excel file, if any. 

Other Panes 

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

FAQs

How often can the data be updated?

As often as needed.

Are there any API limits I should be aware of?

No.

What do I do if my Google Drive file is not visible in the "Files" report?

If you are unable to locate the drive file, please share the file with the service account email (client_email found in the JSON key).