Skip to main content

​
Intro

Google Sheets enables you to create and edit spreadsheets online while collaborating with other users in real-time. With Domo’s Google Sheet OAuth Writeback WIF connector, you can transfer your data from a Domo dataset to your Google Sheet. You can connect to your Google Sheets OAuth Writeback WIF account in the Data Center. This topic discusses the fields and menus that are specific to the Google Sheets OAuth Writeback WIF connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Google Sheets OAuth Writeback WIF account and create a DataSet, you need the following: Workload Identity Federation must be configured in the Google Cloud Console before an account can be created in Domo.
  • If you have an existing Workload Identity Federation, you need the following:
    • If you select to enter the configuration values manually, then you need:
      • Project Number
      • Project ID
      • Pool ID
      • Provider ID
      • Service Account Email
      • Choose whether to use the user email address or a unique GUID ID representing the connector and your Domo instance
    • If you prefer to enter the JSON Configuration from the Google Cloud Console, then you need the following:
      • Enter the JSON configuration for the Workload Identity Federation
      • Select how you want to limit access to your External Identities
  • If you select the Go through prerequisites steps, then enter the following:
      • Project Number
      • Project ID
      • Pool ID
      • Provider ID
      • Service Account Email
      • Choose whether to use the user email address or a unique GUID ID representing the connector and your Domo instance

​
Connecting to Your Google Sheets OAuth Writeback WIF Account

This section enumerates the options in the Credentials and Details panes on the Google Sheets OAuth Writeback WIF Connector page. The components of the other panes on 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.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your Google Sheets OAuth Writeback WIF account. The following table describes what is needed for each field:

Field

Description

Project Number Enter the project number of the newly created .project.
Project ID Enter the project ID of the newly created project.
Pool ID Enter the chosen pool ID.
Provider ID Enter the chosen provider ID.
Service Account Email Enter the service account email address generated for the chosen service account ID.
Once you have entered valid Google Sheets OAuth Writeback WIF credentials, you can use the same account at any time to create a new Google Sheets OAuth Writeback WIF DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

Menu

Description

Input DataSet Id

Enter your Domo dataset ID(GUID) located in the dataset URL.

Example: https://customer.domo.com/datasources/ aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee /details/settings.

Input Sheet Id

Enter the Google Sheet ID shared with the Service Account.

Example: https://docs.google.com/spreadsheets/d/ 18zN0RQ8HIaEj2USwtAkCMX7AKBl-x-_vq24kPd4_Tsk /edit#gid=0<br>

Note: - All the data in this sheet will be replaced.

Sheet Name

Enter the sheet name. The default sheet name should be Sheet1.

​
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 Connector.