Load Existing Users From the Admin Console

When you launch Gopher for Users in a blank Google Sheet, you will see the Load managed devices in the sidebar tab, which allows you to import users into the Manage existing users tab of your sheet. By default, the users are imported from the Admin console. The query filters help you narrow down the users who are loaded.

You can also load users from a list of emails.

The query filters available for loading existing users include:

User Type

• is Active or Suspended (default)
• is Active
• is Suspended
• is Recently Deleted

Org Unit Path

• is any value (default)
• equals
• contains

Last Login Time

• is any value (default)
• is before <date>
• is after <date>
• is never

These provide a powerful combination of user query options not easily available in the Google Workspace Admin Panel; however, for even more filtering power, the More Filters button explains how to use native Sheets filters in your import.

To load existing users:

1. From the sidebar, select query parameters using the WHERE, AND, AND drop-downs.
2. (Optional) Check the Include group membership box to populate an additional Current group membership column listing all domain groups each user is a member of.
   Note: For performance reasons, a maximum of 100 groups will return for each user.
3. Click Load to Sheet. Users load to a new tab, Manage Existing Users.