What you’ll learn
In this article, you will learn:
What is Gopher for Users?
Gopher for Users is your user management tool. It allows you to bulk create, delete, and update user account information from within a Google Sheet. You’re also able to get reports on suspended users, users that have never logged in, and account stats per OU.
Whitelisting the add-on
If you are blocking Marketplace apps, you will have to update your setting to at least allow the apps that are whitelisted. You can change this setting in Apps > Marketplace Apps > Manage. See this article for further information.
Setting up delegated users
Non-Super Admins can use Gopher for Users if they have the appropriate Admin Role assigned to them. Check out this article to learn how to set them up.
Install the add-on
Once whitelisted, you can open up a new sheet and install Gopher for Users by going to Add-ons > Get Add-ons. Once the Google Workspace Marketplace window launches, search for Gopher for Chrome, then select Individual Install.
You can load users to the sheet from the Admin console. Either load everyone or taper your search based on account status, OU, and last login time. There is also a box to check if you would like to load all the groups each user is a member of. Please note, however, that checking the box will make loading the users take longer to complete.
Data on the manage existing users tab
All of the columns on the Manage Existing Users tab are filterable and sortable using the native Sheets filter and sort options. Please apply the sorts and filters using the filter icon next to each of the headers on row 2 of the sheet to avoid scrambling your data.
Bulk actions overview
Once a set of existing users are loaded to the Manage Existing Users tab, you can reset passwords, update properties & attributes, update domain groups, create or delete users. Check out our Help Center article for more information.
The ability to change passwordsin bulk is one of our user’s favorite features in Gopher for Users. You can change them statically in the sheet, or we do have a built-in generator where you can choose the password format and complexity. You can also opt to have that password emailed to the teacher, and force the users to change their password on their next login.
Update properties & attributes
The update properties & attributes workflow will allow you to preview and push Google Workspace user updates from any of the following color-coded column groups as well as for enabled, custom-defined user attributes on your domain.
- Basic information
- Last name
- First name
- >Primary email address
- >Org unit path
- Exclude from global contact directory
- Force pw change at next login
- Contact information
- Work phone 1
- Home phone 1
- Mobile phone 1
- Work address 1
- Home address 1
- Employee Details
- Organization name
- Employee type
- Employee ID
- Employee title
- Enabled custom user attributes
Update user aliases
You can add new user aliases or delete existing admin-assigned aliases for your users.
Update domain groups
You can add and remove users to your domain groups. When loading your users to the sheet, it is important to check the box to include Group membership so you are able to see what Groups the user is already a member of.
You can create users in two different ways. You can create them manually in the sheet, and set all of the properties, passwords, and groups at once, or you can use a CSV. The CSV must have unique headers, and at least the first and last name. Once the CSV is loaded into the sheet, you can edit any of the remaining fields before uploading to the Admin Console.
Deleting an account through Gopher for Users will permanently delete all resources (Drive, Calendar, Sites, etc.) owned by the user, including Google Vault retained copies of Gmail.
Unlike the Google Workspace Admin Panel, where it is possible to transfer ownership of Drive Files and G+ pages to another user, Gopher for Users does not permit this.
Once a user is deleted, you have 20 days to manually reverse this permanent data loss via the admin panel. Gopher for Users does not have an undelete users action.
Gopher for Users has 3 built-in reports; suspended users, users that have never logged in, and user properties by OU. Each of these reports once generated will create a tab in the spreadsheet, and can be set to refresh daily.
Data Studio reports
We do have a Data Studio connector built-in to allow you to transform your reports in Sheets to Dashboards, graphs, and charts using Google Data Studio. To learn more about setting that up, check out this article.
You can access support from the Customer Success team in a couple of different ways:
Live chat, when available, is located at the bottom of the sidebar. When chat is offline, you can instead open a support ticket from the chat widget.
In addition, we have an extensiveHelp Center with knowledgebase articles on the tool and its features, and you can also access the live chat from here, as well as submit a ticket.
Finally, you can always email email@example.com to open a support ticket with us at any time.