When you launch Gopher for Users in a blank Google Sheet, you will see the Load managed devices from in the sidebar tab, which allows you to import users to the Manage existing users tab of your sheet. By default the users are imported from the Admin console. The query filters help you narrow the users who are loaded.
You can also load users from a list of emails.
The query filters available for loading existing users include:
Org Unit Path
Last Login Time
These provide a powerful combination of user querying options not easily available via the Google Workspace Admin Panel, however, for even more filtering power, the More Filters button explains how to use native Sheets filters on your import.
To load existing users:
- From the sidebar, select query parameters using the Where and And drop-downs.
- (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.
- Click Load to Sheet. Users load to a new tab, Manage Existing Users.