Your go-getter for G Suite for EDU users. Bulk updates user properties, contact and employee information, passwords.
Some key User Gopher (beta) features, with more just a short burrow away:
All bulk user actions provide a full, granular preview where you can inspect all changes and optionally exclude unwanted fields from the update.
Load users by OU, active state, or last login time and apply Sheets filters to any user field or property to limit users for update.
Include list of group memberships for each user and bulk Add / Remove users to / from Google domain groups.
Bulk generate and reset user passwords and distribute them via a printer-friendly email to designated points of contact.
Bulk delete users.
Bulk create new users in the correct org units and Google Groups.
Bulk create new users from mapped CSV data -- efficiently saves mappings for future re-use -- and leverage the unmapped data columns in your CSV data to assist with username, OU, and contact directory.
Create new users or bulk modify existing user values for these key user properties and attributes directly via Sheets:
- Org unit
- Global contact visibility
- Force password reset on next login
Basic information, including
- First name
- Last name
- Primary email address
Contact information, including
- Work phone 1
- Home phone 1
- Mobile phone 1
- Work address 1
- Home address 1
Employee details, including
- Organization name
- Employee type
- Employee ID
- Employee title