Google Sheets just got G Suite user-management superpowers

Make molehills out of mountains

  • How easy is it for you to manage important properties and settings flags on your G Suite users?
  • Are you spending too much time in the admin panel, or fiddling with command line tools to perform bulk actions on users?
  • Are you using the Google Contact directory and employee information attributes to their full potential?
  • Can you quickly spot users missing from or inappropriately belonging to Google domain groups and make bulk modifications to group membership?

Challenges that can block schools from effective G Suite user management practices

  • Organizing and bulk-moving large numbers of users from one org unit to another is time-consuming if performed in the Admin Panel.
  • Account passwords are difficult to bulk-reset and quickly distribute out to school staff.
  • Account suspensions and re-activations can be a chore to monitor and keep up with.
  • Limited search parameters in the Admin Panel make it a challenge to filter for users of interest — such as inactive or “never logged in” users — and then take bulk actions on them.
  • Useful Contact information and Employee information attributes go unused because they are too hard to bulk update.
  • Google domain groups go under-utilized, or they pose a security and communications challenge when they are unreliably maintained.

How User Gopher works

User Gopher is an Add-on for Google Sheets that can be installed by any user with global administrative rights to provision and manage G Suite users.

Quickly find and bulk-update interesting slices of users

User Gopher includes built-in import filters for user type, org unit, and last-login date, but the magic really begins when you add in Google Sheets filters!

Sheets filters will take your user management workflow to a new level

User Gopher respects your Sheets filters — giving you the ability to perform actions on just those users that are currently visible in the Sheet.  #timesaver

Bulk-modify user properties and attributes

Make otherwise time-consuming mass-modifications to user properties and attributes in a matter of minutes.

Get a full preview of changes before you apply your updates

Get all the re-assurance you need before performing a bulk-edit to users.  Quickly explore how many users will be touched by each field edit, and dive into the granular, per-user preview of all changes to be made before you pull the trigger!  Try that in a command line tool;)

More easily mass-reset and distribute student passwords

Auto-generate secure, memorable passwords and merge them into a printer-friendly email to designated teachers or school-level point people for easy distribution to students.

Bulk add / remove users to / from Google domain groups

Download users’ current group memberships, use filters to find groups of users that are missing from (or inappropriately assigned to) important groups, and bulk add / remove users from groups.  All from the powerful, flexible interface of a Google Sheet.

The right tool for the job

User Gopher makes your work 100’s of times faster than the Admin Panel, and more visible and less error-prone than command line utilities.

Spot and fix user issues more easily

Makes it easier to identify and take action on inactive, never-logged-in, and suspended users.

Designed with schools in mind

A bulk user password reset workflow that works the way schools work.

Early access program

  • Limited access, by application / invitation only
  • Selected districts will receive free access to User Gopher through July 1, 2017, contingent upon participating in at least one product feedback interview and one Forms-based survey.
  • Thanks in advance for your interest!
Apply for early access

Get help

Learn more about how to install and use Chrome Gopher.

Support & FAQ

Check out these other Amplified Labs tools

Remove the administrative bottleneck and empower school-level staff to keep their own domain groups up to date.

Manage your Chrome devices with bulk power, reporting intelligence, and efficiency.

Bulk-generate Google calendar events from Sheets.  Automate event creation from Forms.

Auto-sync your SIS rosters to Google Classroom.

Share This