3. On the left pane select **IAM & Admin** > **Service Accounts**.
4. Click **+ CREATE SERVICE ACCOUNT**.
5. Under **Service account details**, enter the service account name and click **CREATE AND CONTINUE**.
6. From the **Select a role** filter, under Quick Access select **Basic** > **Owner** and click **CONTINUE**.
7. Click **Done**.
8. On the left pane select **IAM & Admin** > **Service Accounts** and click the service account created.
9. Click **Keys** > **Add Key** > **Create new key**. A pop-up window opens.
10. Select the Key type as JSON and click **Create**.
11. The JSON file containing the JSON key downloads automatically.
12. Save the downloaded file.
## Enabling Google Sheets API
To enable the Google Sheets API, perform the following steps:
1. Navigate to the GCP Console.
2. On the left pane, under **APIs and services**, select **Library**.
3. Search and click the Google Sheets API.
4. On the top of the page, click **Enable**.
**Note**: The Google service account's email address must be added as a Google Sheet Viewer.
## Connecting to Your Google Sheets Account
This section enumerates the options in the **Credentials** and **Details** panes in the Google Sheets 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 great detail in [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").
## Credentials Pane
This pane contains fields for entering credentials to connect to your Google Sheets account. The following table describes what is needed for each field:
|
Field |
Description |
|---|---|
|
Service Token JSON |
Copy and paste the complete contents of the.json file, generated from your Google API Console. |
|
Menu |
Description |
|---|---|
| {" "} File Selection{" "} | {" "} The Spreadsheet ID is selected from the drop-down list.{" "} |
| {" "} Spreadsheet ID{" "} | {" "} Enter the Spreadsheet ID. The Spreadsheet ID is the last string of characters in the URL of your spreadsheet. For example, in the URL, {" "} [https://docs.google.com/spreadsheets/d/12wVPoRgSLYcD1CBHpN4dpQiPHRNqV7azwGF4JbKoXaw/edit#gid=0,\{](https://docs.google.com/spreadsheets/d/12wVPoRgSLYcD1CBHpN4dpQiPHRNqV7azwGF4JbKoXaw/edit#gid=0,\{)" "} the spreadsheet ID is, 12wVPoRgSLYcD1CBHpN4dpQiPHRNqV7azwGF4JbKoXaw .{" "} |
| {" "} Worksheet Name{" "} | {" "} Select the worksheet name from the drop-down list.{" "} |
| {" "} Spreadsheet Layout{" "} | {" "} Select the spreadsheet layout from the drop-down list.{" "} |
| {" "} Manually Enter Cell Ranges{" "} | {" "} Select this checkbox, if you want to manually enter the cell range.{" "} |
| {" "} Column Header Cell Range{" "} | {" "} Specify the cell range for the header column(For example, A1:N1).{" "} |
| {" "} Column Data Cell Range{" "} | {" "} Specify the cell range for the data columns (Optional, for example, A2:N27).{" "} |
| {" "} Row Header Cell Range{" "} | {" "} Specify the cell range for the header row (For example, A1:A27).{" "} |
| {" "} Row Data Cell Range{" "} | {" "} Specify the cell range for the data rows (Optional, for example, B1:N27).{" "} |
| {" "} Date Format{" "} |
Select the date format from the drop-down list. There are two date formats:
|