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 > Marketplace apps > Settings for Marketplace Apps> Manage access to apps, confirm that users in your domain are allowed to install allowed apps from the Google Workspace Marketplace.
Next, allow Gopher for Gmail within the Google Marketplace Apps settings. To do that, navigate to Apps > Marketplace apps > Allow listed Marketplace apps. Select the + icon in the right-hand corner and search Gopher for Gmail. Check the box next to our add-on and select Allow list, then Confirm.
Step 2: Install the Sheets Add-on from the Google Workspace Marketplace
In Google Sheets, start by going to Add-ons > Get Add-ons. Search for Gopher for Gmail and select Individual Install.
Or, cut to the chase and install it directly from here. Note: This Google Workspace Marketplace link will most likely only work from an administrator account on your domain.
Once installed, you can open Chrome Gopher from any Google Spreadsheet from Add-ons > Gopher for Gmail > Launch Sidebar
It is important that you do NOT install the Add-On domain-wide as it will appear for ALL users.
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 (see below) 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 shown below. Why is this necessary? Learn more here.
The values needed for this step are provided in the Gopher for Gmail sidebar.