Google Sheets Metadata Connector

​

Intro

• Spreadsheet Name
• Spreadsheet ID
• Spreadsheet URL
• Time Zone
• Locale
• Sheet Count
• Sheet Name(s)
• Sheet ID(s)
• Sheet Index(es)
• Column Count
• Row Count
• Column Headers
• Owner Email(s)
• Shared With (Emails and Access Level)
• File Size
• Last Edited Time
• Last Editing User Email

​

Prerequisites

​

Creating a Google Cloud Project

1. Navigate to the Google Cloud Console at https://cloud.google.com/cloud-console.
2. In the top right corner of the screen, select Console.
3. If you are accessing Google Cloud Console for the first time, then verify that you’re logged into the correct account and that your country of residence is correct. Agree to the terms of service, and then click AGREE AND CONTINUE.
4. In the top left corner of your screen, click the project name. (If you’re a first-time user, this will display as “Select a project.”)
5. In the top right corner of the window that appears, click NEW PROJECT.
6. Name your project as Domo Sheets Connector. You may optionally select an organization or choose No organization, and click CREATE.
7. After clicking CREATE, you will return to the home screen. Go back to the top left and click the project name (or “Select a project”) once more.
8. From the list, click the name of the project you just created (Domo Sheets Connector). This will take you to the project’s home page.
9. Scroll down to the Quick access menu in the middle of the page and select the APIs & Services checkbox.

​

Enabling Required APIs

1. On the menu of the APIs & Services page, select Library.
2. In the API Library, scroll down to the Google Workspace section.
3. Click the Google Drive API (located on the left side of the page).
4. On the Google Drive API page, select “Enable.” This action enables the API for use with your project and returns you to the APIs & Services page.
5. Repeat this exact process to enable the Google Sheets API.

​

Setting up OAuth 2.0

1. From the left navigation menu on the APIs & Services page, select OAuth consent screen.
2. For User Type, select External.
3. Click CREATE. This will take you to a page where you can begin configuring the details of your OAuth consent screen (these settings can be modified later).

​

Configuring the OAuth 2.0 Consent Screen Details

1. App name: We recommend the app name as Google Sheets Metadata Connector.
2. User support email: Enter your own email address. (You can add other users later.)
3. Optional fields: You do not need to add an app logo or domain.
4. Scroll down to the Authorized Domains section.
   • Select ADD DOMAIN, and enter domo.com in the text box.
5. In the Developer contact information section, enter your email address.
6. Select SAVE AND CONTINUE. This action saves your details and advances you to the next configuration step: Scopes.

​

Configuring OAuth 2.0 Scopes

1. Add Google Drive Metadata Scope
2. At the top of the Scopes page, select ADD OR REMOVE SCOPES.
3. In the Enter property name or value search bar enter the following Google Drive Metadata scope exactly as shown: https://www.googleapis.com/auth/drive.metadata.readonly
4. Click the suggestion that appears under Values.
5. In the next screen, select the checkbox to the left of Google Drive API.
6. Click UPDATE.
7. The window will close. Verify that the following scope is now listed under Your restricted scopes : .../auth/drive.metadata.readonly
8. Add Google Sheets Read-Only Scope
9. Repeat the process by selecting ADD OR REMOVE SCOPES again.
10. In the search bar, type the following Google Sheets scope exactly as shown: https://www.googleapis.com/auth/spreadsheets.readonly
11. Click the suggestion that appears, select the checkbox next to Google Sheets API, and click UPDATE.
12. Verify that the following scope is now listed under Your sensitive scopes: ...auth/sheets.metadata.readonly

​

Configuring OAuth 2.0 Test Users

1. Select ADD USERS.
2. In the window that appears, enter the email addresses associated with the Google accounts of the people who need to use this connector in your Domo instance. You can add up to 100 users without needing to publish the app through Google.
3. Click ADD (Users can be added or removed in later edits).

4. Click SAVE AND CONTINUE once you’ve added all necessary users.

​

Review and Complete OAuth 2.0 Setup

1. Review all the information (App details, Scopes, and Test Users) to ensure it is correct.
2. Once confirmed, click BACK TO DASHBOARD.

​

Creating the OAuth Client ID

1. From the left menu, select Credentials.
2. On the top of the Credentials Dashboard, click CREATE CREDENTIALS and select OAuth client ID from the dropdown menu.
3. On the next screen, from the top of page, select Web Application from the Application Type dropdown menu.
4. Enter a Client name (we recommend Domo Sheets Connector Client).
5. Scroll down to the Authorized redirect URIs section and click ADD URI.
6. Enter the following exact URI: https://oauth.domo.com/api/data/v2/oauth/providers/google-drive-metadata-98e4dc30-1712-4b80-85ec-ed6cf3cb1e6b/exchange
7. Click CREATE at the bottom of the page.

• Securely save both the Client ID and Client Secret, as you will need them to set up the connector in Domo.
• You can also view these credentials later by returning to the Credentials Dashboard or downloading them in JSON format.

​

Connecting to Your Google Sheets Metadata Account

​

Credentials Pane

​

Details Pane

​

Other Panes