Step 1: Confirm That Gopher for Users 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.
- Navigate to Manage access to apps, Apps > Google Workspace Marketplace apps > Settings.
- Verify that Allow users to install only allowed applications from Google Workspace Marketplace is selected.
- In the left navigation, click Apps list.
- Click the Allowlist App link at the top right of the page. The Add an app to the allowlist stepper opens
- Search for Gopher for Users.
- Click Select at the right of the app name
- Select Allow users to install this app and click Continue.
- Select who to allow list the app for; Everyone or Specific groups or organization units.
- Click Finish.
Step 2: Add Gopher for Users 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
- In Google Sheets, open a sheet.
- Navigate to Extensions > Add-ons > Get add-ons.
- Search for Gopher for Users.
- Click on the Gopher for Users tile.
- Select Individual Install.
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.
Opening Gopher for Users
Once installed, you can open Gopher for Users from any Google Spreadsheet.
- In Google Sheets, open a sheet.
- Navigate to Extensions > Gopher for Users.
| Document Version | Date | Description of Change |
| 1.0 | 7/24/2024 | Replaced image, reverify |