Innovation of G Suite user registration registration work! -Okay Goldy

G suite for Education has been popular in front-line schools, but user management is still hard and difficult.

However, the more you use it, the more difficult it is, the more attractive this tool! 

I'm going to write a post again today!'

1. what's the ok goldy?

Ok Goldy is an add-on available to Google Spreadsheet that allows you to run large-scale operations for G suite users.

It was created by a developer named Goldy Arora, who has developed a variety of apps that can be useful in the G Suite.

*Examples of large-scale tasks: 

register / delete student and faculty accounts / delete and suspend graduate accounts

2. how to install?

1) Install the marketplace app Ok Goldy

Ok Goldy is a marketplace app. Marketplace can be understood as a kind of play store concept that helps users register and use functions that are not provided by G Suite basic functions.

Enter Okay Goldy in the Google search box and click the link in the first search result.

Here is the link: Ok goldy

Next, click "install" button.

* Only G suite accounts with permission to the management console can proceed with the operation.

-You can install it from a personal account ending in @gmail.com and run it from a spreadsheet.

 However, it is useless because the job is not executed in a final stage job that requires 'permissions'.

If you log in with your G Suite account, the domain installation/individual installation selection window appears. In this case, proceed to 'Individual installation'.

<When proceeding to domain installation>

Ok Goldy add-ons will be visible to all accounts created in that domain (not related to user management).

It is a function that only a few administrators will use, so there is no need to install a domain.

(It is okay to proceed with the domain installation, but the task will not be executed in an account without permission.)

When the 'Individual Install' button changes to 'Uninstall', the installation is completed.

*If installation is not working well

Make sure that you have permission to install marketplace apps open in the Marketplace settings in the Admin console.

2)operate in google sheet.

-Go to Google Sheet. (http://sheets.google.com)

-Create a new spreadsheet

-Additional Functions -> Ok Goldy -> Setup Wizard -> Setup Sheets

-Wait until 14 sheets are made.

* Running... Add-ons are not loaded when a message is displayed. Please run it calmly when loading is finished :)

-Additional Functions -> Ok Goldy -> Users Manager -> 5. Export Users

-Check whether users registered in the domain are printed on the sheet.

* Depending on the privileges granted to the account running the job, there may be restrictions on the job.

If you have done so far, the basic work is now complete.

Before we start...

* All Ok Goldy jobs work based on the user's Primary Email.

Basic process of work>

-Select the sheet you want to work on -> Select "Sub, O" -> Execute the desired work

2) Users Manager

Users Manager is a menu for registering, modifying, stopping, deleting, and printing user accounts.

-Create Users: This is a menu that allows you to create a user.

Enter the information of the user you wish to register -> First Name, Last Name, Primary Email, Org Unit, Password

Select "Sub,O" -> Users Manager ->select  1. Create Users

- First Name

- Last Name

- Primary email: This is the representative email that users can log in to and all future                                       work will be done.

- Org Unit: This is where you enter the name of the organizational unit. Essentially, it                            must be created in advance, and when creating an account in the root folder,                         enter '/'.

- Password: Set a password for your account. It is automatically set to change your                                    password after initial login.

Gmail login example of created account

User Update: This is a menu to update the registered user's information (first name, last name, organizational unit, employee ID).

* You can use it when you changes information about your academic history, such as promotion or renaming.

* As mentioned, the reference point for the data is the user's primary email.

-User Suspension: This is the menu to block the login of registered users.

* In the case of graduates, transferred faculty, etc., 

you can leave the account suspended  without deleting the account immediately. 

This is because there are often cases of requesting materials that are required for issuance.

* As mentioned, the reference point for the data is the user's primary email.

-Delete User: This is a menu that allows delete users.

* The maximum number of users that can be at one time in the admin console is 50 people.

This operation is better when the number of users who want to delete is 50 or more.

* As mentioned, the reference point for the data is the user's primary email.

-Export Users: This is a menu that allows you to output all users for organizations with authority.

* If you have full authority, you can filter and check user status by organization.

3) Groups Manager

Groups are systems that manage multiple users with a single email. 

You can invite dozens of students at a time by grouping students

*Create Group: This is a menu to create a group.

* Group Name: Set the name of the group to be created.

* Group Email: This is the representative email of the group you want to create.

 For example, if you want to create a group for grade 6rd class, it could be 6-1@school
.com.

* Group Description: A brief description of the group.

-Delete Group: This is a menu to delete a group.

* Group Email: Enter the email of the group you want to delete.

*Export Groups: Displays the group status (of the organization that has authority) in the domain.

* You can check the email or name of the group you want to work with when you can't remember it.

4)Members Manager

This is a menu to set members of Groups.

*Add Members: This is the management menu for members of the previously created group.

* Group Email: This is the representative email of the group created in 3)

 or has already been created.

* Member Email: The email address of the member you want to add to the group.

* Member Role: You can specify what role the member you want to add will play in the group.

* Notes on Member Role creation

All roles must be!!! It must be entered in uppercase Letters.

There are 2 roles that can be entered, MANAGER and MEMBER respectively.

-Export Members: This is a menu to display the members of the created group.

* You must fill in the representative email of the group you want to view and execute the action.

Remove Members: This can be used to delete specific users from a group.

5) Alias ​​Manager

Alias ​​means nickname.

This means an additional nickname that can be attached to the Primary Email. 

Login must be done through Primary Email, but email can be received through Alias. 

If an individual's ID is complex, communication can be simplified by designating simple pattern information such as extension numbers as Alias.

*Create Aliases: You can create Aliases for Primary Email.

* Primary Email: This is the standard email account.

* Alias: This is the alias you want to set.

-Delete User Aliases: This is a menu to delete registered Alias.

* Primary Email: This is the standard email address.

* Alias ​​Email: This is the alias you want to delete.

If you do not know the information, you can check the Aliases registered in Primary Email in the Export User Aliases menu.

Export User Aliases: This is a menu to print registered Alias.

* Primary Email: This is the standard email address.

* Alias ​​Email: This is the alias email associated with the Primary Email.

* Total Aliases: Total number of alias emails linked to Primary Email. (Up to 30 can be set.)

4. Frequently asked questions

-Is it safe for security?

You can check here

https://www.goldyarora.com/g-suite-addons/ok-goldy/