Ok Goldy

Ok Goldy is a free Google sheet add on which can help you perform bulk operations in Google Workspace
Bulk Create, Update, Suspend, Delete, Export Google Workspace Users, Groups, Members, Aliases and much more….
I am glad over 8 Million Google Workspace Admins are saving their time with it today.

Play Video

Video Tutorials

Text with Screenshots

All Tutorials
Installation
Users Manager
Groups Manager
Members Manager
Aliases Manager

Table of Contents

Installing OK Goldy

Installing OK Goldy

Install the Add on to perform Google Workspace bulk operations.

Users Management

Create Users

Bulk Create Google Workspace users right from your Google Sheet.

Update Users

Edit or Update Google Workspace users in bulk in just couple of clicks.

Suspend Users

Suspend multiple Google Workspace users at once with Ok Goldy

Bulk Delete Users

Delete multiple Google Workspace users with just a click.

Bulk Export Users

Export all Google Workspace users with rich information.

Groups Management

Bulk Create Groups

Create multiple Google Workspace Groups at once with Ok Goldy

Bulk Delete Groups

Delete Multiple Google Workspace Groups in just a click.

Bulk Export Groups

Export all your Google Workspace groups into Google Sheet.

Members Management

Bulk Add Members

Add multiple members to Google Workspace groups with Ok Goldy

Bulk Export Members

Export members of a given Google Workspace group in Google Sheet.

Bulk Remove Members

Bulk Remove members from Google Workspace Groups.

Alias Management

Bulk Create Aliases

Create Google Workspace user aliases in bulk easily.

Bulk Export Aliases

Export aliases of given users into your Google Sheet.

Bulk Delete Aliases

Bulk remove aliases of Google Workspace users in just a click.

Installing OK Goldy – The Google Sheets Add-On for Managing Your Google Workspace Users

This tutorial will take you through the steps of installing and setting up the OK Goldy Google Workspace add-on. This add-on is for Google sheets.

As a Google Workspace admin, managing multiple users can turn into an ordeal especially when you have scores of users.

Typically, as a Google Workspace admin you may have to perform the following functions to manage your users:

Let’s say you have to change the status of 50 users.

Although the Google Workspace dashboard is easy to use, shuffling between different screens, one user at a time, can be quite time consuming and tedious.

OK Goldy makes it very easy. All you have to do is, make the changes to the Sheet that is created and used by the add-on, run the associated function of the add-on, and your job is done. Whether you have 5 users or 500 users, just change the respective columns and OK Goldy takes care of the rest.

Here is how you install OK Goldy…

1

Log into your Google Workspace account.

2

Go to Google Sheets

3

Create a blank sheet and give it an appropriate name.

4

In the top menu, click on “Add-ons” and from there, “Get add-ons…”

5

In the Add-on screen, type “OK Goldy” in the search box.

6

The OK Goldy is immediately brought up by the add-on store. To install it, you need to click the blue button. As you can see, the OK Goldy add-on is a free add-on.

7

It asks you which Google account you would like to use to install the add-on. Make sure you select the account that you use as Google Workspace administrator.

8

The next screen is the usual screen that you get when you install an add-on – it tells you what all the add-on will be able to do through your account. It basically makes sure that you know that you are providing a certain level of access to the add-on to be able to perform admin-level functions. Click “ALLOW”.

9

The OK Goldy add-on is installed and you are notified on how you can use the add-on to manage your Google Workspace users in bulk by simply making changes in the rows and columns of your Google Sheet instead of having to shuffle between different Google Workspace dashboard screens.

10

After installing the add-on, you will need to set it up to be able to use it. It uses various worksheets to enable you to perform various functions on your Google Workspace users in one go. But before that, you will need to create the needed worksheets.

You can click on “Setup Sheets” to create all the needed worksheets or you can click “Delete All Sheets” if you have already created worksheets through OK Goldy.

11

Click “Setup Sheets” and you will see at the bottom that all the needed screens are created in different tabs.

12

You can click on the left and right icons at the bottom-right to view all the worksheets that have been created by OK Goldy.

The purpose of all these sheets is to enable you to perform various functions – in bulk – using the OK Goldy Google Sheets add-on.

For example, if you need to create users in your Google Workspace account, you can simply use the “Create Users” sheet by entering the data in that sheet (explained in a different tutorial).

Need to delete the sheets to start all over again? This is the sequence that you can follow…

Do check out our other tutorials on how you can perform various user-management functions as a Google Workspace administrator, using the OK Goldy add-on for Google Workspace.

Create Users

How to bulk create or add Google Workspace users

In this tutorial you will learn how to bulk create Google Workspace users using the OK Goldy Google Workspace add-on.

As a Google Workspace admin, you are often asked to add lots of users to your organization’s Google Workspace account so that they can use the official email ID and use all the apps and functions provided by Google Workspace.

Although Google Workspace has a very straightforward interface for creating new users, it doesn’t have a way of adding them in bulk.

Suppose you need to create 20 users, or 200 users.

Perform Google Workspace functions in bulk The OK Goldy Google Workspace add-on has been created to help you perform many Google Workspace admin functions in bulk using Google Sheets.

In this tutorial you will learn how to bulk create or bulk add Google Workspace users with the OK Goldy Google Workspace add-on for Google Sheets.

In the “How to install the OK Goldy Google Workspace add-on” you have already learned that once the add-on is installed and setup, it creates a set of worksheets in your Google Sheets document.

These worksheets will help you perform various Google Workspace-administration-related functions in bulk. Now, let’s learn how to create Google Workspace users in bulk.

1

Open the Google Sheets document that you used when you set up your OK Goldy add-on (which contains all the worksheets).

In the Sheet, if the “Create Users” worksheet tab isn’t already selected, click it and select it.

2

You can see in the above screenshot that there are six columns in the worksheet, namely

First Name – you enter the first name here.
Last Name – you enter the last name here.
Primary Email – the email that needs to be created within your organization’s domain name.

Org Unit – if you have created different organizational units (for different access levels to your users) you can enter the names of the organizational units here. You can have different names for different rows.
Password – the password that will be used by the user you have created to access his or her email and other components of his or her Google Workspace account.
Status – this information will be filled by the OK Goldy add-on itself

3

Fill in all the details in the appropriate columns.

You will notice that you have to add a forward slash before the name of the organizational unit. This is just for hierarchical purposes. If you want to add a particular user in the “parent” organizational unit, you simply put a “/” in the column, like this

4

Run the add-on module for creating new Google Workspace users in bulk, using the following command path:

Add-ons >> OK Goldy >> User Manager >> 1. Create Users

You will see the “Working” graphic that shows that the Google Workspace users are being created in bulk.

Remember the “Status” column that we left blank and I told you that the values will be filled by the add-on itself? Once your “Create Users” module has run the status column will be filled. It will tell you that all the users have been created successfully.

You can go to your Google Workspace admin dashboard to verify that all your users have been created in bulk. Make sure you go to the appropriate organizational unit to see the status of the new users you have just created in bulk.

Update Users

How to bulk update Google Workspace users

In this section you learn how to bulk update Google Workspace users using the OK Goldy add-on for Google Workspace.

Above you have learnt how to install the OK Goldy add-on for Google Workspace and how to bulk add or bulk create users in your Google Workspace account.

Bulk Updated Users with OK Goldy You can use the “Update Users” worksheet to update your Google Workspace users in bulk. This comes handy if there is a piece of information missing in all user accounts and now, you would like to add it, for example, Employee ID.

Or, you would like to change the organizational unit to which employees with a particular email ID belong. Or maybe suddenly you need to change passwords of scores of employees.

Just make sure that you use exactly those fields that already exist in the user management section of your Google Workspace dashboard.

Here is how you bulk update your Google Workspace users using the OK Goldy add-on for Google Workspace:

1

Select the worksheet “2. Update Users”.

2

Make all the changes that you want

Now all the information that you may select to update is right in front of you in rows and columns. For example, you can change the first name, last name and all other columns visible in the sheet. Just keep in mind that you change only those values that have a corresponding column heading.

3

Execute the “Update Users” module through the following command path:

Add-ons >> OK Goldy >> Users Manager >> 2. Update Users

Once all the rows in your worksheet have been updated in Google Workspace, you will get the “Success” status.

Suspend Users

How to bulk suspend users in your Google Workspace account

In this section you will learn how to suspend multiple users in your Google Workspace account in bulk.

There might be many reasons to bulk suspend users in your Google Workspace account.

Some users might be acting naughty. Or maybe, it’s Halloween.

Suspending users means that they cannot access their emails and other functions associated with their accounts. This is normally done when you don’t want to delete users, you just want them not to be able to access the Google Workspace accounts temporarily.

Make sure OK Goldy is already installed This tutorial assumes that you have already installed the OK Goldy add-on for Google Workspace and there is at least one uses existing in your Google Workspace account upon whom suspension can be applied.

1

In your Google Workspace account, open the Google Sheet document where you installed the OK Goldy add-on.

2

Select the “3. Suspend Users” worksheet.

3

Enter email ids of all the users you want to suspend– since every user is identifiable by a unique email ID, this is the only bit of information you need to enter.

4

Execute the “Suspend Users” module through the following command path:

Add-ons >> OK Goldy >> Users Manager >> 3. Suspend Users

Once the module is successfully executed, the status of the “Suspend Users” will be filled in the “Status” column.

Bulk Delete Users

How to bulk delete Google Workspace users

In this section you will learn how to bulk delete Google Workspace users.

There comes a time when you have to delete many users in bulk. If you use the usual Google Workspace interface, you can delete users one at a time. This is fine if you have to delete one or a couple of users but if you have to delete 30-40 users in a go, this can prove to be a tedious job.

Use OK Goldy Bulk Delete Users The OK Goldy Google Workspace add-on can help you delete Google Workspace users in bulk.

1

Open the Google Sheet where you installed the OK Goldy add-on.

2

Select the “4. Delete Users” worksheet.

3

Add all the email ids that you want to delete in the “User Primary Email Id” column.

4

Execute the “Delete Users” module through the following command path:

Add-ons >> OK Goldy >> Users Manager >> 4. Delete Users

In the “Status” column you can see that all the users in the “User Primary Email Id” column have been successfully deleted.

Bulk Export Users

How to bulk export Google Workspace users in a Google Sheet

In this section you will learn how to export Google Workspace users into a Google Sheet in bulk.

Use OK Goldy Bulk Export Users You may need to export users from your Google Workspace account to your Google Worksheet to get a bird’s eye view of all the users and their attributes, or to carry out various changes OK Goldy is capable of making, in bulk.

For example, if you want to suspend multiple users, you need to enter all these email ids in the designated. The “Export” module allows you to import all the information into the worksheet and then you simply have to copy/paste the needed information.

1

Open the Google Sheets document that you used with your OK Goldy setup.

2

Go to the “5. Export Users” worksheet by clicking the tab “5. Export Users”.

As you can see, all the relevant columns are already created. The Google Workspace user information will be exported into the associated columns.

3

Bulk export Google Workspace users using the following command path:

Add-ons >> OK Goldy >> Users Manager >> 5. Export Users

Whether there are 10 users or 10,000 users, it hardly takes a few seconds to export all the Google Workspace entries to the OK Goldy worksheet.

The “Success” status also shows you the additional details about your Google Workspace users such as in total how many users were imported, how many were logged in at the time of the import, how many never logged in and how many users are using multi-factor authentication.

The information about how many users logged in and how many never logged in is also visually represented via a pie chart.Standard Chartered

Bulk Create Groups

How to bulk create Google Workspace groups with OK Goldy

Remember Google Groups? In Google Workspace also you can create groups to facilitate group conversation and collaboration.

Every group has a dedicated, unique email ID. The people who have joined the group (or are added to the group by the admin) send messages to that particular unique email ID and the messages are broadcast to all the group members.

OK Goldy to Create Groups In case you need to create multiple Google Workspace groups in a single sitting, the OK Goldy add-on has the perfect solution for you.

This is how you can create the Google Workspace groups in bulk:

1

Select the “6. Create Groups” worksheet.

2

Enter all the group-related details in different roles including group name, group email and description.

3

Execute the “Create Groups” module through the following command path:

Add-ons >> OK Goldy >> Groups Manager >> 6. Create Groups

The “Working” animation will show you that the groups are being created.

4

The “Status” column shows the success status of all the groups created.

As you can see, when group was not created because it already exists.

Bulk Delete Groups

How to bulk delete Google Workspace groups with OK Goldy

You may need to bulk delete your Google Workspace groups in case you need to clean up your organizational account or you need to restart everything from scratch.

OK Goldy to Delete Groups Deleting one or a couple of Google Workspace groups can be done one after another, but if there are multiple Google Workspace groups you can easily use the OK Goldy add-on to bulk delete your Google Workspace groups.

This is how it is done…

1

Select the “7. Delete Groups” worksheet.

2

Enter all the emails representing individual Google Workspace groups.

3

Execute the “Delete Groups” module using the following command path:

Add-ons >> OK Goldy >> Groups Manager >> 7. Delete Groups

4

The success status of the bulk delete of Google Workspace groups is displayed within the worksheet.

As you can see, when group was not created because it already exists.

Bulk Export Groups

How to bulk export Google Workspace groups using OK Goldy

If you manage multiple Google Workspace groups sometimes you may have to make changes in multiple groups at the same time and the OK Goldy add-on can make it a breeze. Here is how you can bulk export your Google Workspace groups into a Google Sheets worksheet.

1

Select the “8. Export Groups” worksheet.

2

Execute the “Export Groups” module using the following command path:

Add-ons >> OK Goldy >> Groups Manager >> 8. Export Groups

You will be able to see the success status of all the imported groups.

Bulk Add Members

How to bulk add Google Workspace group members with OK Goldy

Sometimes you may have to add multiple members to different Google Workspace groups and using the usual Google Workspace interface may turn into a chaotic exercise especially when you need to shuffle between different Google Workspace groups, different members, and also different roles – owner, manager, member and other roles.

1

Select the “9. Add Members” worksheet.

2

Add the group members details

Please note that in the “Member Role” column, in the top two rows, I have written “Manager” instead of “MANAGER”. The difference is that the top two bits of information haven’t been entered in ALL CAPS. In a while I will explain what its implication is.

3

xecute the “Add Members” module of the OK Goldy add-on using the following command path:

Add-ons >> OK Goldy >> Members Manager >> 9. Add Members

Once the “Add Members” module has completely run, the success status is printed on the Status column.

As you can see that for three members, the membership addition was unsuccessful. That is because when you are entering roles for the users, they need to be in ALL CAPS (“MANAGER” and not “Manager”.

Bulk Export Members

How to bulk export group members from a Google Workspace group using the OK Goldy add-on

Suppose you want to change the roles of various group members. Instead of using the default Google Workspace interface, it will be easier to first export the information from Google Workspace into the OK Goldy worksheet, make the changes, and then use one of the OK Goldy modules to update your Google Workspace account.

1

Select the “10. Export Members” worksheet.

2

Select the “10. Export Members” worksheet.

As you can see in the Google Workspace dashboard screenshot below, there are some group members existing in this group. They will be exported into the OK Goldy add-on worksheet.

3

Execute the “Export Members” module using the following command path:

Add-ons >> OK Goldy >> Members Management >> 10. Export Members

Please note that in the “Member Role” column, in the top two rows, I have written “Manager” instead of “MANAGER”. The difference is that the top two bits of information haven’t been entered in ALL CAPS. In a while I will explain what its implication is.

3

xecute the “Add Members” module of the OK Goldy add-on using the following command path:

Add-ons >> OK Goldy >> Members Manager >> 9. Add Members

In the above screenshot I have rearranged the columns so that you don’t have to horizontally scroll your screen to get the whole picture. The above screenshot shows all the exported members of the Google Workspace group “Group Email”.

Bulk Remove Members

How to bulk remove Google Workspace group members with OK Goldy

Removing individual group members from individual Google Workspace groups can be a tricky exercise because you will need to jump from group to group, and then group member to group member. With the OK Goldy add-on, bulk removing Google Workspace group members is a breeze.

1

Select the “11. Remove Members” worksheet.

2

Enter group email ids and member email ids in the “Group Email” and “Member Email” columns, respectively. You need to enter group email ids for all member email ids because you can remove different members from different groups.

As you can see in the Google Workspace dashboard screenshot below, there are some group members existing in this group. They will be exported into the OK Goldy add-on worksheet.

3

Execute the “Add Members” module of the OK Goldy add-on using the following command path:

Add-ons >> OK Goldy >> Members Manager >> 9. Add Members

The success status shows you that all group members belonging to all the mentioned groups have been deleted successfully.

Bulk Create Aliases

How to create Google Workspace aliases in bulk with OK Goldy

Planning to create multiple Google Workspace aliases for multiple Google Workspace email ids? You can easily create Google Workspace aliases in bulk with OK Goldy.

1

Select the “12. Create Aliases” worksheet.

Before you can work on the “12. Create Aliases” worksheet the email ids for which you want to create the aliases must already exist.

2

Enter the email ids and their respective aliases.

3

Execute the “Create Aliases” module using the following command path:

Add-ons >> OK Goldy >> Alias Manager >> 12. Create Aliases

You will get the success status of all the aliases created.

Bulk Export Aliases

How to bulk export Google Workspace aliases using the OK Goldy

It is useful if you can have all the aliases belonging to all your Google Workspace email ids at one place either to make bulk changes or just to have a grip over which aliases belong to whom. This is how you can bulk export your Google Workspace aliases into the OK Goldy worksheet.

1

Select the “14. Export User Aliases” worksheet.

2

Enter the email ID whose aliases you want to export into the worksheet.

3

Execute the “Export User Aliases” module using the following command path:

Add-ons >> OK Goldy >> Alias Manager >> 14. Export User Aliases

The success status of all the exported user aliases is displayed.

What if you need to export user aliases belonging to multiple email ids?

You can put all these email ids in the “Provided Email” column like this:

When you run the “Export User Aliases” module again, you get this success status:

You see that all the aliases belonging to all the email ids have been exported into the worksheet.

Bulk Delete Aliases

How to bulk delete Google Workspace user aliases with OK Goldy

Want to delete multiple Google Workspace user aliases? Since deleting them one by one using the default Google Workspace dashboard interface can be quite time consuming, you can use the OK Goldy add-on to bulk delete Google Workspace user aliases. Here is how to do it.

1

Select the “13. Delete User Aliases” worksheet.

2

Enter the emails and their aliases that you want to delete.

Please note that I have also entered a non-existent alias (highlighted) to show you how the add-on responds to a non-existent alias.

3

Execute the “13. Delete User Aliases” module using the following command path:

Add-ons >> OK Goldy >> Alias Manager >> 13. Delete User Aliases

The success status shows you how many aliases were deleted.

The highlighted alias “doesnotexist@goldyarora.com” was not deleted because it was not found.

Troubleshooting & FAQ

Most frequent questions and answers

TypeError: Can not read property "givenName" from undefined.

If you are getting this error, please consider following-:

givenName (first name) is a required attribute to create users in Google Workspace, it seems somehow its missing for any of your users. Please do following-:

1. Go to your admin console and export all your users in a google sheet as shown below.

2. Now filter down to see the user where first name is missing

3. Add first name to the user

4. Try OK Goldy again

Is Using this tool safe?

Great Question.

Google has a very strict add-on review process (you can read more about it here “Google’s Google Workspace Add on Review Process.) which is obvious looking at the massive number of Google Workspace businesses and users which rely on the add-ons available in Google Workspace marketplace today.

“Ok Goldy” has passed all the checks by Google’s review process and is now trusted by over 15,000 Google Workspace Administrators to perform bulk Google Workspace operations.

But……..

I think it’ll be good to tell you a bit more about what do I get access to when you start using this add on.

1. Google does NOT share information like your domain name, email address or any PII with me, though I know how many users installed the add-on, but I don’t get to know “Which” users.

2. This add-on is built with Google Apps Script which leverages OAuth, where when you run the tool, Google asks if you want to permit this add on to access required scopes (Primarily Directory API and Sheets API) and to perform bulk operations.

3. As it leverages OAuth, you can anytime, go to your Google Workspace Admin Console and revoke the token, which will result in no access to “Ok Goldy” even if the add-on is installed.

(Side note -: If you want to audit shadow IT, you can use the script I created to audit OAuth tokens in your domain here https://www.goldyarora.com/blog/g-suite-oauth-token-audit/).

4. Please also read out my privacy policy at https://www.goldyarora.com/privacy/

Final Words-:
This add on is simply a result of my own needs, while working with large enterprise customers, its hard to do things manually in Admin console which made me write script for almost everything that happens in a large Google Workspace deployment.

As I already have these scripts, I thought to publish some of them as a Google Workspace Add on, so mates like you can save some of your time.

I always try to help Google Workspace community, but be aware that everything I offer here is available for free, which means I can’t invest money in hiring a lawyer to write one of the best privacy policies, security documentation, no content writers to write engaging content etc……

All I have here is to share something which works for me for you to test it out, and if I fall short here, you should stop using the add on and send me a feedback email at help at goldyarora.com.

Can you add a new feature for me?

One of the best moments for a to a developer is when a user comes to him saying “I like something you built, and I wanted to ask if you can add this feature to make it even more useful for me”.

So I appreciate it, you just gave me that moment:).

Please put your feature request below in comments, the more detailed the better, though I can not commit a timeline being a full time employed, a husband and a father of two, but rest assured I would try to add it as soon as I can (especially if the use case is broad and can help wider audience).

Whats the roadmap?

I just changed my full time job, and trying to establish myself, however soon I will start investing sometime in enhancing ‘Ok Goldy’.

Feel free to put your comments below to give me feedback, but am thinking of following-:

1. Enhance features of current modules-:
(i) Reset Password in bulk
(ii) Undelete Users in bulk
(iii) Restore (Unsuspend) users in bulk
(iv) Change Group Settings in bulk

2. Add New Module/s-:
(i) Add “Resource Calendar” module which will help you create, update, delete, export buildings and resources.

3. New Add On-:
(i) A whole new Add on dedicated to Google Classroom, which will help Google Workspace Education Admins to perform bulk operations on Google Classroom objects.

My daughter’s school here in West Windsor school district, Plainsboro, NJ also uses Google Workspace, and am trying to help out with this.

How about a name for this, “Ok Sarah” :)?

Please don’t hesitate to put what you think about the new features plan, I would appreciate your feedback including changing or swapping the new features.

Thank you
Goldy

Can I hire you?

Appreciate your consideration, but apologies, I do not freelance.

However, if you have a large (> 10,000 users) Google Workspace implementation project, please write to me at help @ goldyarora.com for a prospective discussion.

If you are a small business, and still need some dedicated help, I might be able to recommend you a company or person in my network and let both of you explore synergies to work together.

Come together to help Google Workspace community.

Provide your feedback & share your use cases
Collaborate to improve Ok Goldy’s current features & add new ones
Share Google Workspace Implementation & Administration best practices
Share Knowledge and make it a win win

© 2021 All rights reserved

Made with love for Google Workspace:)