Google Drive Service Connector
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:
-
In the GCP Console, open the IAM & Admin page.
-
Click Service accounts in the left-hand navigation pane.
-
Select your project and click Open.
-
Click Create Service Account.
-
Enter a name and description for the service account.
-
Click Create.
-
Select Project Owner.
-
Click Continue.
-
Click Create key.
-
Select JSON as the key type.
-
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).