Bulk Import Google Accounts

Make a copy of the Spreadsheet with the script in it here. Follow the directions below.

Open Scripts. Tools>Scripts.

In Scripts select Resources>Advanced Google Services

Turn the Admin Directory API to On.

Click the Link to the Google API Console. The console will open. Search for Admin SDK. Select it and click Enable. (Note: the below gif is reused but is the same method)

A menu will open when the spreadsheet is opened named "AddUsers" when you open the document. You can use the listed functions on this menu.

Use only True and False check off in the Change Password at Next Sign-In column.

Use only True and False check off in the Change Password at Next Sign-In column.

Bold columns are required. Grey background columns will be added or updated. White columns are not activated in this script.