Accounts Manager

molloy.martin(16)•  48,864Sheets Add-onUninstallInstallOverviewManages user accounts. Create users, change passwords and organisations. Also delete accounts and change various properties v3.07.7The add-on allows admin users to use a spreadsheet to manage the domain's user accounts. You can list details of all current accounts, create new accounts, change some account details.

You can also automate the process of creating new accounts - see below.

All features are free for 2 weeks from first use. During that period you can change up to 100 accounts and create up to 100 new accounts. After the initial trial period you will be able to list details of up to 500 accounts so that you can see what data you can retrieve.

The ability to list all users, to create new users or to change user details in bulk will require an annual subscription of $75.

The account details you can change are:
First name and surname,
email addresses;
organisation unit
password,
Work, home and mobile phone numbers,
Work and home address
Work Id and Title,
Department
Cost Centre
Suspend and
Include in Global Address Directory
Remove Image from profile

You can also see (but not change)
If the user is an admin user
Whether 2 step auth is enforced
Whether the user has signed up for 2 step auth
Date the account was created
Date last used
Days since last used
Google User ID

This add-on could save you a lot of time and effort in managing user accounts. It has been designed primarily for educational users but will be useful to anyone managing google accounts for their domain.

Automating the Creation of New User Accounts

If you can export a file of users from a separate system (eg a file of users from a School Information System) you can use this add-on to automate the process of creating new accounts to keep in sync with your main system.

You can also setup a Google form to feed into the spreadsheet for new users so that the process of setting up new users can be delegated to a user who does not have admin rights in your domain.

See the website www.mtmomk.com to get further details.