📖 2 mins read

Bulk Add-Update-Remove Google User Accounts

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

As a first step Google Workspace Admins should export some or all of the existing users to create the template spreadsheet.

(Tip, filter first for a small OU to get a manageable list of users, thus creating a smaller spreadsheet in terms of size.)

GAT+ | Bulk Add-Update-Remove Google User Accounts 1

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

GAT+ | Bulk Add-Update-Remove Google User Accounts 2

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

GAT+ | Bulk Add-Update-Remove Google User Accounts 3

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/remove the photos. Here’s a post about how to bulk remove Google profile photos.

Delete user

To delete accounts you need to

  • Change the ‘Is_Deleted’ column to ‘Yes’ for each user account you wish to delete.

Add user

To add new accounts first ensure the Google Workspace license space exists.

  • Add a new row with an email address and Name, along with other details.
  • Do not add 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 the 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 Google Workspace Admin console, under Apps, Marketplace Apps, check that GAT+ is enabled for ‘Everyone’ and that Data access is ‘Granted’.

 

If you’d like to run a trial of our products please install GAT+ from the Google Workspace Marketplace and contact us at support@gatlabs.com with any questions you may have.

To request a demo please click here and fill the form, we’ll get back to you in less than 12 hours on weekdays.

If you trailed GAT in the past and you’d like to run a fresh trial again, please enquire through this form.

Thanks for sharing and spreading the word!