Google Drive Connector

Intro

This article explains how to create Google OAuth 2.0 credentials for the Google Drive API and use them to connect Google Drive to Domo Documents. If you have an Enterprise Account, the steps may vary.

If you already have a Google Drive Client ID and Client Secret, skip to Create a Google Drive Connection.

Note: If you change the scopes of your OAuth client, you must re-authenticate your Google Drive connector.

---

Required Grants

To access Documents, the following grants must be enabled for your role:

• Manage Documents — View, edit, and delete any Document Collections in this instance.
• Edit Documents — Create and edit Document Collections to which you have access.
• View Documents — View only for any Document Collections to which you have access.

Learn more about grants.

Create a Project and Enable the Google Drive API

To get a Google Drive Client ID and Client Secret, generate them through the Google Cloud Console by enabling the Drive API and creating OAuth 2.0 credentials.

1. Open the Google Cloud Console.

2. Log in with your Google account, then select Create Project (or select an existing one).

3. Select your new project.

4. In the top search bar, type Google Drive API and select it from the list.

5. Select Enable to enable the Google Drive API.

6. After enabling the API, select Create Credentials.

7. Select User Data to create an OAuth client.

8. Set the OAuth credentials name, support email, and developer contact.

9. Set scopes by selecting Add or Remove Scopes.

Note: If you add sensitive or restricted scopes, such as scopes that let you access a user’s emails or contacts, you must submit your app for verification.

10. Filter by Google Drive API and select the three non-restricted scopes, then select Update.

Scope	Description
.../auth/drive.install	Connect itself to your Google Drive
.../auth/drive.file	See, edit, create, and delete only the specific Google Drive files you use with this app
.../auth/drive.appdata	See, create, and delete its own configuration data in your Google Drive

There are two options when adding scopes:

1. Filter to the Google Drive API, add all 17 scopes, then remove the sensitive and restricted scopes in the next step (unless you plan to submit your app for verification).
2. Scan the list of 17 scopes and select the three from the table above.

11. Scroll to the bottom of the setup wizard and select Save and Continue.

12. Set the name and type of the OAuth client.

13. Set the authorized redirect URIs:

• https://oauth.domo.com/api/data/v1/oauth/providers/google-drive-oauth-enterprise/exchange
• https://oauth.domo.com/api/data/v1/oauth/providers/google-drive-oauth-enterprise/exchange?flowName=GeneralOAuthFlow

14. Select Create to finish creating the OAuth client.

15. A pop-up displays your Client ID and Client Secret. Copy them directly or select Download JSON to save them to a file. Download your Client ID and select Done.

16. Navigate to Audience. Under Publishing Status, publish your app.

Create a Google Drive Connection

1. Navigate to Domo Documents.

2. Select Create Collection, then select Connectors.

3. Select Google Drive.

4. Select an existing Google Drive account or create a new one.

5. Select the Google Drive OAuth Enterprise connector.

6. Enter your Client ID and Client Secret from when you created your Google Drive OAuth client.

7. Select the appropriate Google account.

8. If this is your personal Google Drive and your OAuth app is not fully verified (Testing Mode), select Advanced and continue to domo.com.

9. Allow Domo to have access to Google.

10. Select all access privileges and select Continue.

11. Select Next, then select the content you want to load from Google Drive.

12. Type root for root directory, or enter the Drive ID.

13. Set the update schedule.

14. Set the name and description of this Document Collection, then select Save.

15. Allow time for the Collection to load files. Select the Files tab to view a listing of the referenced files, or select the Overview tab to enable Agent Knowledge.