---
title: "Bulk Add-Update-Remove Google User Accounts"
description: "GAT+ is an extensive audit tool for Google Workspace domains. With GAT+ the Admin can manage and audit all the users for the domain. ### Users audit Users audit allows the Admin to make changes to the User accounts. Using…"
url: "https://gatlabs.com/knowledge/tech-tips/bulk-add-update-remove-google-user-accounts/"
updated: "2022-07-02"
category: "Users Audit & Management"
tags:
  - GAT+
---

# Bulk Add-Update-Remove Google User Accounts

GAT+ is an extensive audit tool for Google Workspace domains.

With GAT+ the Admin can manage and audit all the users for the domain.

### Users audit

Users audit allows the Admin to make changes to the User accounts.

Using **import and export** functionality in GAT+ the Admin can**add, update and delete** users from the domain.

### Make changes to Users

Navigate to **GAT+ > Users > Basic > Export to Google Sheet**

View all the users of the domain and perform actions.

![](https://gatlabs.com/knowledge/wp-content/uploads/2021/11/2021-11-24-16_32_27-Window.png)

When the data is exported open and perform the changes.

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

When you click on "Export to Google Sheet" - the data will be exported.

![](https://gatlabs.com/knowledge/wp-content/uploads/2021/11/2021-11-24-17_51_47-GAT.png)

Admin will be given a pop-up offering a ‘**Click to view**’ link for opening the sheet.

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
- delete accounts

#### Add users

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

- **Add account** - to add an account add **a new row** with the user's Email address and Name
  - Green fields -  can be edited
  - Red fields - cannot be updated
- Ensure ‘**IS_SUSPENDED**’ and ‘**IS_DELETED**’ are both set to ‘**No**’.

![](https://gatlabs.com/knowledge/wp-content/uploads/2021/11/2021-11-24-17_59_27-Window.png)

**Note:** to add new accounts make sure there are free Google Workspace licenses

#### Delete user

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

- **Delete account** - to delete an account select the accounts in the spreadsheet  and change the field "**Is_Deleted**" to be equal to "**Yes**"

Read this post "[Deleting Suspended Accounts"](https://gatlabs.com/knowledge/tech-tips/deleting-suspended-accounts/)

#### Update user

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

- Update account - to update an existing account - export the users into a spreadsheet as above and **update any green field **

#### Import data

When the accounts are updated - click on the Import option and import the changes.

![](https://gatlabs.com/knowledge/wp-content/uploads/2021/11/2021-11-24-18_08_03-GAT.png)

**Note:** 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}/"*