3. Search for the **Google Drive API** and click on it.
4. Towards the top of the screen you will see an **ENABLE** button.
5. Click **Enable**.
#### To generate a service account JSON key, do the following:
1. In the [GCP Console](https://console.cloud.google.com/apis/dashboard), open the ****IAM & Admin**** page.
2. Click ********Service accounts******** in the left-hand navigation pane.
3. Click ********Create Service Account********.
4. In the **Service account details** section, enter a name and description for the service account.
5. Click **Create and Continue**.
6. Now, in the **Grant this service account access to the project** section, click **Select a role** drop down.
7. Select **Project-> Owner**.
8. Click **Continue**.
9. Click **Done**. An overview of your service account will appear.
10. In the **Actions** column, click the three dots to expand the menu. Click **Manage Keys**.
11. Click **Add Key**. Select **Create new key**.
12. **Create private key** window will appear. Select private key type as **JSON** and click **Create**.
13. 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](/s/article/360042926274).
### 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. |
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. | ||||||
| How would you like to match the Sheet Name? | If the user selects Contains , the connector will retrieve the most recently uploaded file. | ||||||
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. | ||||||
Files Discovery | Select the file you want to import into Domo. Note: The File Discovery option is available only if the number of files in the Google Drive account is less than or equal to 100. | ||||||
MIME Type | Select the MIME type of the file you want to import into Domo. | ||||||
What File Type Would You Like to Import? | Select the file type that you would like to parse and import. | ||||||
Select the delimiting character | Select the delimiting character used in your file. If your delimiter is not listed select 'Other.' | ||||||
Specify your delimiter | Enter the character used to delimit your character separated values (CSV) text. | ||||||
Quote Character | Select the desired quote character for parsing CSV files. (Double quote is the default quote character for CSV standard). | ||||||
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. | ||||||
Date Format | Select the date format that is used in the selected file. | ||||||
Header Start Row | Enter the header start row for your Excel file. | ||||||
Data Start Row | Enter the data start row for your Excel file. | ||||||
Footer Rows to Skip | Enter the number of rows to skip at the end of your Excel file, if any. | ||||||
How would you like to match the sheet name? | Select whether you would like to match the sheet name with a sheet that contains the provided name or is exactly equivalent to the provided name. | ||||||
File Password | If your file is password protected please enter file password. | ||||||
Sheet Name | Enter the sheet name you want to retrieve from the specified spreadsheet be sure to check sheet name for accidental spaces, first sheet of the workbook will be used if the field is left blank. | ||||||
Blank Rows | If you encounter blank rows, you can either skip the blank rows or stop at the first blank row. |