Bulk Add-Update-Remove Google User Accounts

The GAT+ new ‘User Interface’ is available to all working GAT+ customers. The new UI is evolving to be the main interface. However, as well as transferring old features we are also making new features available there. Some of these features do not exist on the old UI.

We have just added bulk import/change/deletion (add-update-remove) of user accounts for G suite domains. This feature is enabled by the export, change, and import of a spreadsheet.

As a first step G Suite Admins should export some or all of the existing user to create the template spreadsheet. (Tip, filter first for a small OU to get a manageable list of user, thus creating a smaller spreadsheet in terms of size.)

Once GAT+ creates the spreadsheet the Admin will be given a pop-up offer a ‘Click to view’ link for opening the sheet.

From here the Admin can modify the spreadsheet. All changes on the sheet will be reflected in the Users accounts.

Admins will be able to change names, add to, change or remove users from OU, add or remove user email aliases, add or remove group membership for each user, set Super Admin rights, suspend accounts and delete accounts.

You can also change photos. Here’s a post about how to bulk remove Google profile photos.

To delete accounts you remove the account ‘id’ and change the ‘Is_Deleted’ column to ‘Yes’ for each user account you wish to delete.

See ‘Delete’ walkthrough video:


To add new accounts first ensure the G Suite license space exists. Add a new row with an email address and Name, along with other details. Do not add a value for ID or Alias. Ensure ‘IS_SUSPENDED’ and ‘IS_DELETED’ are both set to ‘No’. Accounts created will automatically have a randomly generated password created for the account and a copy of the password will be written to a new spreadsheet. For the new accounts, this new spreadsheet will be created and it will be situated in folder “GAT/{domain_folder}/GeneratedUsers/{current_date}/

See ‘Add’ walkthrough video.

This feature set is particularly useful for education domains where bulk changes are frequent.

Before using this feature, in the G Suite Admin console, under Apps, Marketplace Apps, check that GAT+ is enabled for ‘Everyone’ and that Data access is ‘Granted’.

Related Resources:

Bulk Export All Your Google Groups