Install Gopher for Gmail

Step 1: Confirm that Gopher for Gmail 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 Gmail.
  6. Click Add to allow list.
    AllowlistGmailGreyHL.png

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 Gopher for Gmail.
  4. Click on the Gopher for Gmail tile.
  5. Select Individual.

Note: Domain administrators will see the Domain Install and Individual Install buttons. It is important that you do NOT install the Add-On domain-wide as it will appear for ALL users. 

Or, cut to the chase and install it directly from here.

InstallGopherGmailHL.png

Step 3: Perform the one-time client name and scopes installation for your domain

Because Gopher for Gmail performs very powerful actions on behalf of Google Workspace users, the sidebar will prompt the first super-administrative user on the domain to perform a one-time installation of a Client Name and API Scopes within the Google Workspace admin console's Manage API client access panel. Why is this necessary?  Learn more here.

The values needed for Manage API client access are provided in the Gopher for Gmail sidebar.

  1. In Google Sheets, open a sheet.
  2. Navigate to Add-ons > Gopher for Gmail
  3. Click Launch sidebar.
  4. At the Getting started step, read the note and click Proceed.
  5. Click Add Authorization. The Admin Console opens to the Domain-wide Delegation page.
  6. At the Add new client ID popup, review auto-populated information.
  7. Click Authorize.
  8. Return to the Sheet with the sidebar open.
  9. Click Confirm.

Opening Gopher for Gmail sidebar

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

  1. In Google Sheets, open a sheet.
  2. Navigate to Add-ons > Gopher for Gmail.
  3. Click Launch sidebar.