App Icon
SPOGOU lets delegated admins Set easy-to-use Passwords Of Groups Of Users
Works with:
15
Overview
SPOGOU lets delegated admins Set easy-to-use Passwords Of Groups Of Users, all in the comfort of a Google Sheet and a couple of clicks.

USAGE: To use SPOGOU you need to have your user/students in groups, as SPOGOU pulls the users you wish to change passwords on from a group.

Also, you need to have proper delegated admin access, to be able to run SPOGOU's three steps. If you don't, SPOGOU will fail.

In the Add-ons menu you will find SPOGOU and run Start, which will create the necessary sheets for your process and also show sidebars with instructions on how to proceed.

Only the first step, Start, can be run with a user without delegated admin access. The following steps require delegated admin access.

Prepare Passwords - require the following scopes

https://www.googleapis.com/auth/admin.directory.group.member.readonly
https://www.googleapis.com/auth/admin.directory.user.readonly (but this scope isn't used, as you need to write to users in the next step)
https://www.googleapis.com/auth/script.container.ui
https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/userinfo.email

Set Passwords - this, of course, requires a scope where you can edit the user. 
https://www.googleapis.com/auth/admin.directory.user

So, before any user can actually use SPOGOU, the admin must assign the user those admin privileges. I recommend creating two separate custom admin roles, as the group privilege can't be limited to an OU, which the user privilege can.

This means that a delegated admin can be restricted to only set passwords on users of a specific OU, for example students at their school.
Additional information
Privacy policy
Terms of service
SPOGOU will ask for the permissions shown below. Learn more
SPOGOU will need access to your Google account
This will allow SPOGOU to :
View and manage spreadsheets that this application has been installed in
View group subscriptions on your domain
View and manage the provisioning of users on your domain
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
No comments
Search
Clear search
Close search
Google apps
Main menu