Importing and Updating Users via CSV
Add or update multiple users from a CSV file
Before people within your organization can sign in and use your organization's Google Workspace, they need a user account. If you have many new users, you can add their accounts all at once from a CSV file.
You can also update multiple existing accounts from a CSV file. Patronum uses the same file format of the Google Admin Console, so please check the latest Google Documentation on how to Add or update multiple users from a CSV file.
For each user you want to add, enter the following required information in these columns in the CSV file:
Email Address—Use the format email@example.com
Password—Must be at least 8 characters.
Passwords are case sensitive. By default, a password must have at least 8 characters. You can change password requirements for your organization.
If you're updating existing users and you don't want to change their passwords, enter 4 asterisks.
If a Password Hash Function is also specified, the Password column must contain the hashed password. For example, if you use SHA-1 and the hash of password abc is xyz, enter xyz in the Password column.
Org Unit Path—Enter / (forward slash) to place users in your top-level organizational unit. You might do this if you haven't set up an organizational hierarchy in the Admin console. Or, you can enter the path for a specific organizational unit, staring with a forward slash, such as /Sales.
Your CSV file should look like something like this:
Updated on: 16/01/2024