Bulk Create Users

The Batch Script will allow you to bulk create G Suite users that are located in the "BAT-CreateUsers.csv" file.

You will need to add the below information to the CSV:

Email
FirstName
LastName
Password

When creating the CSV in Google Sheets or Microsoft Excel I like to use the formula below to create the passwords, which will generate passwods such as "ZY24WK48"

Google Sheets / Microsoft Excel Random Password Formula

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)

BAT-CreateUsers.csv

BAT-CreateUsers.bat

Code

@ECHO OFF

CLS

ECHO --------------------------------------------------

ECHO Creating user(s) from the file BAT-CreateUsers.csv

ECHO --------------------------------------------------

gam csv BAT-CreateUsers.csv gam create user ~Email firstname ~FirstName lastname ~LastName password ~Password

:END

ECHO -----------------------------------------------------------

ECHO Finished creating user(s) from the file BAT-CreateUsers.csv

ECHO -----------------------------------------------------------

Pause

Google Sites

Report abuse