Home
How to set passwords on users provided only an address to a G Suite group, and share the results back to the teacher who asked for it.
https://docs.google.com/spreadsheets/d/1OE74rUE4zpgu9c_3ks8zuBaq-ACmWIeNKRvZNTvDsDQ/copy
Click the link with a delegated admin (often superadmin) account. However, do note that the user running the script doesn't have to be a superadmin! The delegated admin only needs to be able to change passwords, and have Groups API read access. So doesn't even need to be group admin!
It's easy to create a custom admin role for this, with only password reset (with forced change) and read access to groups.
Remove Copy of and - Template from name of spreadsheet.
Try to run Set password on group of users / Prepare sheets. It should ask for authorisation.
Allow access to your superadmin/CB Admin account. Else nothing will work.
The script will run, create and prepare a number of sheets.
Fill in the necessary data in the Indata sheet.
Then continue running the functions in the order they are listed. The script will move your view along to the active sheet, so you can see what is happening.
When you are done, you need to remove the project from the sheet. Open the Script Editor go to File menu and click Remove Project. If you don't, then the script will be available to the teacher you just shared the list with, and it will mess things up.
If you don't want to create a Sheet copy, the scripts are also available here in this repo.
DO NOTE! If you copy the scripts from here, instead of copying the entire Sheets file, you will have to enable the API manually. Here's how you do that. Click the following menus.
Tools / Script Editor Resources Advanced Google Services
Then click the button for
Admin Directory API
Ok and save.
You are in full control of all the data. The script is only accessing data you yourself have access to. No data is sent anywhere, except between you and Google. No matter if you create a copy of my Sheet or my scripts, I will never gain access to any of your data. All data reading and writing is done by you on your own account.
