In Sheet Reports

Gopher for Users provides the ability to run several in Sheet reports, which can be refreshed from the Gopher for Users sidebar or set to refresh automatically once every 24 hours via the toggle. The exact time of the refresh is determined randomly based on the last auto-refresh time of your device cache. However, it is timestamped in cell A1 of the relevant report tab.

In this article, you will learn

How to generate reports

Output for User Properties by OU report

Output for Suspended Users report

Output for Never Logged In report

Output for Archived Users report

Generate reports

To generate in-sheet reports:

1. Open a new Google Sheet.
2. In the top menu, go to Extensions > Gopher for Users > Launch Sidebar.
3. In the Import Users to Sheet tab, select Parameters and click Load to sheet. See Loading existing users.
4. Once the sidebar loads, click Run reports to access the reports section. 
   
5. Click User Analysis.
6. Check the checkbox for the type of reports to run: User Properties by OU, Suspended Users, Never logged In Users, or Archived Users.
   
7. If you want the reports to refresh daily, set the Refresh aggregate reports daily toggle, located above the reports list, to ON.
8. Click SAVE/REFRESH. A tab opens for each report you’ve selected.

User Properties by OU

The User Properties by OU report aggregates relevant user properties, including user status, admin role, 2FA status, directory visibility, creation time, and last login time for each organizational unit on the domain.

Applying native Sheets filters in row 3 of this report allows you to see subtotals of the remaining visible rows.

Suspended Users

The Suspended Users report provides a comprehensive list of domain users who are currently suspended and includes the Org Unit Path and Last Login Time.

Never Logged in Users

The Never Logged In report provides a comprehensive list of domain users who have not logged into their Google Workspace accounts and includes the account creation date and organizational unit.

Archived Users

The Archived Users Report offers a detailed snapshot of archived users, making it a valuable tool for auditing and managing archived accounts effectively. It helps administrators monitor user status, organizational placement, and login activity.

Fields included in the report output:

• Last Name
• First Name
• Email Address
• Org Unit Path
• Last Login Time