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 Apps > Google Workspace Marketplace apps > Settings > 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.
    AllowInstallMarketplaceHL.png
  3. Click Manage allowlist.
  4. Click Add app to allow list.
  5. Search for Gopher for Drive.
  6. Click Add to allow list.

Step 2: Install the Sheets add-on from the Google Workspace Marketplace.

  1. In Google Sheets, open a sheet.
  2. Navigate to Add-ons > Get add-ons
  3. Search for Gopher for Drive.
  4. Click on the Gopher for Drive tile.
    GopherDriveInstallHL.png
  5. Select Individual Install.
    GopherDriveIndividualInstallHL.png

    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.
    GoherDriveScopes2HL.png
  7. To complete installation, click Allow.
  8. The screen shows an image demonstrating where Gopher for Drive can be found on the interface as a Google Sheets Add-on once it is completely installed. Click Done.
    GopherDriveDoneHL.png

Step 3: 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 Add-ons > Gopher for Drive
  3. Click 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
  4. The Client ID and Scope automatically populate. Click Install Scope. The Admin Console opens to the Domain-wide Delegation page.
  5. At the Add new client ID popup, review auto-populated information.
    Scopes2HL.png
  6. Click Authorize.
  7. Return to the Sheet with the sidebar open.
  8. 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 Add-ons > Gopher for Drive.
  3. Click Launch Sidebar.