Install Gopher for Drive

Storage Amounts Included/Not Included on Reportsstep 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 allowed 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.
    installAllowInstallSettingAllow.png
  3. In the left navigation, click Apps list.
  4. Click the Allowlist App link at the top right of the page. The Add an app to the allowlist stepper opens
  5. Search for Gopher for Chrome.
  6. Click Select at the right of the app name
  7. Select Allow users to install this app and click Continue.
  8. Select who to allow list the app for; Everyone or Specific groups or organization units
  9. Click Finish.

Step 2: Add Gopher for Drive Client Id’s 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.
    Screenshot
  5. Select Individual Install.
    Screenshot

    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 at which point you will be asked to accept permissions.
    Screenshot
  7. To complete installation, click Allow.
  8. Once it is completely installed, 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 has not been authorized against your organization. 
    Scopes1HL.png
  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 popup, review auto-populated information.
    Scopes2HL.png
  5. Click Authorize.
  6. Return to the Sheet with the sidebar open.
  7. Click Confirm Install to scan for installed credentials.
    Scopes3HL.png

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.

 

Document Version Date Description of Change
1.0 3/11/2024 Changed first navigation link to open in a new tab
1.1 7/22/2024 Admin console screen change, Andrea review, reverify

 

Articles in this section