Install Gopher for Drive

Step 1: Confirm That Gopher for Drive Is an Allowed App on Your Domain and That Your User Accounts Are Authorized to Install It

As a Google Workspace super admin, under Manage access to apps, confirm that users in your domain are allowed to install apps from the Google Workspace Marketplace

1. Navigate to Manage access to apps, Apps > Google Workspace Marketplace apps > Settings.
2. Verify that Allow users to install only allowed applications from Google Workspace Marketplace is selected.
   
3. In the left navigation, click Apps list.
4. Click the Allowlist App link in the top-right corner of the page. The Add an app to the allowlist stepper opens
5. Search for Gopher for Chrome.
6. Click Select to the right of the app name
7. Select Allow users to install this app and click Continue.
8. Select who to allow to list the app for: Everyone, Specific groups, or organization units.
9. Click Finish.

Step 2: Add Gopher for Drive Client IDs to the Trusted List of API Access

See Client IDs: Add Labs tools to the trusted list of API access for the full list of scopes.

Step 3: Install the Sheets Add-on From the Google Workspace Marketplace

1. In Google Sheets, open a sheet.
2. Navigate to Extensions > Add-ons > Get add-ons.
3. Search for Gopher for Drive.
4. Click on the Gopher for Drive tile.
   
5. Select Individual Install.
   
   Note: Domain administrators will see the Domain Install and Individual Install buttons. Gopher for Drive will not allow a Domain-wide installation.
6. Gopher for Drive requires your permission to start installing on your domain. Click Continue once prompted to install. Clicking continue does not install Gopher for Drive on your domain. It merely takes you to the next step, where you will be prompted to accept permissions.
   
    
7. To complete installation, click Allow.
8. After install, you can open the app from the Extensions > Add-ons menu.

Step 4: Perform the one-time authorization for domain-wide delegation

In this step, you will give domain-wide delegation just for the Google Drive read-only scope.

1. In Google Sheets, open a sheet.
2. Navigate to Extensions > Gopher for Drive > Launch sidebar. You’ll see a notification on the User Drive and Shared Drive Level reports tabs because Gopher for Drive is not authorized against your organization. 
   
3. The Client ID and Scope automatically populate. Click Install Scope. The Admin Console opens to the Domain-wide Delegation page.
4. At the Add new client ID pop-up, review the auto-populated information.
   
5. Click Authorize.
6. Return to the Sheet with the sidebar open.
7. Click Confirm Install to scan for installed credentials.
   

Opening the Gopher for Drive sidebar

Once installed, you can open Gopher for Drive from any Google Spreadsheet.

1. In Google Sheets, open a sheet.
2. Navigate to Extensions > Gopher for Drive.
3. Click Launch Sidebar.