Ok Goldy

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…

Log into your G Suite account.

Go to Google Sheets

Create a blank sheet and give it an appropriate name.

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

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

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.

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 G Suite administrator.

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”.

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

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 G Suite 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.

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

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 G Suite 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 G Suite administrator, using the OK Goldy add-on for G Suite.

Create Users

How to bulk create or add G Suite users

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

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

Although G Suite 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 G Suite functions in bulk The OK Goldy G Suite add-on has been created to help you perform many G Suite admin functions in bulk using Google Sheets.

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

In the “How to install the OK Goldy G Suite 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 G Suite-administration-related functions in bulk. Now, let’s learn how to create G Suite users in bulk.

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.

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 G Suite account.
Status – this information will be filled by the OK Goldy add-on itself

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

Run the add-on module for creating new G Suite 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 G Suite 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 G Suite 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 G Suite users

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

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

Bulk Updated Users with OK Goldy You can use the “Update Users” worksheet to update your G Suite 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 G Suite dashboard.

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

Select the worksheet “2. Update Users”.

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.

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 G Suite, you will get the “Success” status.

Suspend Users

How to bulk suspend users in your G Suite account

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

There might be many reasons to bulk suspend users in your G Suite 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 G Suite accounts temporarily.

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

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

Select the “3. Suspend Users” worksheet.

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.

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 G Suite users

In this section you will learn how to bulk delete G Suite users.

There comes a time when you have to delete many users in bulk. If you use the usual G Suite 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 G Suite add-on can help you delete G Suite users in bulk.

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

Select the “4. Delete Users” worksheet.

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

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 G Suite users in a Google Sheet

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

Use OK Goldy Bulk Export Users You may need to export users from your G Suite 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.

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

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 G Suite user information will be exported into the associated columns.

Bulk export G Suite 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 G Suite entries to the OK Goldy worksheet.

The “Success” status also shows you the additional details about your G Suite 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 G Suite groups with OK Goldy

Remember Google Groups? In G Suite 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 G Suite groups in a single sitting, the OK Goldy add-on has the perfect solution for you.

This is how you can create the G Suite groups in bulk:

Select the “6. Create Groups” worksheet.

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

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.

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 G Suite groups with OK Goldy

You may need to bulk delete your G Suite 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 G Suite groups can be done one after another, but if there are multiple G Suite groups you can easily use the OK Goldy add-on to bulk delete your G Suite groups.

This is how it is done…

Select the “7. Delete Groups” worksheet.

Enter all the emails representing individual G Suite groups.

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

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

The success status of the bulk delete of G Suite 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 G Suite groups using OK Goldy

If you manage multiple G Suite 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 G Suite groups into a Google Sheets worksheet.

Select the “8. Export Groups” worksheet.

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 G Suite group members with OK Goldy

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

Select the “9. Add Members” worksheet.

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.

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 G Suite group using the OK Goldy add-on

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

Select the “10. Export Members” worksheet.

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

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

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

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 G Suite group “Group Email”.

Bulk Remove Members

How to bulk remove G Suite group members with OK Goldy

Removing individual group members from individual G Suite 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 G Suite group members is a breeze.

Select the “11. Remove Members” worksheet.

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 G Suite dashboard screenshot below, there are some group members existing in this group. They will be exported into the OK Goldy add-on worksheet.

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 G Suite aliases in bulk with OK Goldy

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

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.

Enter the email ids and their respective aliases.

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 G Suite aliases using the OK Goldy

It is useful if you can have all the aliases belonging to all your G Suite 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 G Suite aliases into the OK Goldy worksheet.

Select the “14. Export User Aliases” worksheet.

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

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 G Suite user aliases with OK Goldy

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

Select the “13. Delete User Aliases” worksheet.

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.

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 G Suite, 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

How to download all G Suite users from Admin Console to Google Sheet

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 G Suite Add on Review Process.) which is obvious looking at the massive number of G Suite businesses and users which rely on the add-ons available in G Suite marketplace today.

“Ok Goldy” has passed all the checks by Google’s review process and is now trusted by over 15,000 G Suite Administrators to perform bulk G Suite 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 G Suite 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 G Suite deployment.

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

I always try to help G Suite 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 G Suite Education Admins to perform bulk operations on Google Classroom objects.

My daughter’s school here in West Windsor school district, Plainsboro, NJ also uses G Suite, 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) G Suite 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 G Suite community.

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

85 thoughts on “Ok Goldy – Easily perform G Suite bulk operations from Google Sheets”

selim atmaca
October 10, 2019 at 6:35 am

Great tool, thanks a lot

Reply
1. Goldy Arora
  October 10, 2019 at 10:30 pm
  
  Your welcome, glad I could help.
  
  Reply
Jeremy
October 2, 2019 at 7:58 am

Great tool, easy to use. The videos are awesome! Thanks Goldy!

Reply
1. Goldy Arora
  October 10, 2019 at 10:31 pm
  
  Your welcome Jeremy, glad its helping you perform bulk tasks in G Suite.
  
  Reply
Daniele Debiagi
September 26, 2019 at 12:19 pm

Hi, thank you for these helpful scripts. When I delete users, I’d need to transfer the Google Drive files property to an archive account before I delete them. Is that feature available? Are you thinking about implementing it?
Thank you!

Reply
1. Goldy Arora
  October 10, 2019 at 10:32 pm
  
  Your welcome, though Ok Goldy does not have that functionality and I don’t plan to add it to it, however i will see if i can put together a standalone script for that and publish in coming weeks.
  
  Reply
Adrienne Schneider
July 24, 2019 at 3:33 pm

I have two questions

1. Will you be offering a capability of a bulk renaming of Groups?
2. I really like the app scripts that you have provided for other tools. Is it possible that you could offer the scripts for your other tools within the OK Goldy add-on?

Thank you,
Adrienne

Reply
1. Goldy Arora
  September 5, 2019 at 10:44 am
  
  1. Yes, I will add it, don’t have specific timeline though as this is kinda side project for me.
  2. You will find some here https://github.com/gsuitedevs
  
  Reply
Mike Farace
July 13, 2019 at 5:43 pm

Hi, I created 3 “master” gmail accounts, demouser1, demouser2 and demouser3, and want to create 90 email aliases, 30 per “demo user”. This is for an internally used domain for.. demos 🙂

for demouser2, all 30 aliases worked fine. for demouser1 and demouser2, I got the error:
“API call to directory.users.aliases.insert failed with error: Not Authorized to access this resource/api”

I am a super admin for the domain I administer in GSuite, and I created all 3 accounts at the same time, which was about 5 mins before I tried to create the aliases. Any ideas?
Great video and tool! Thanks for this!

Reply
1. Goldy Arora
  September 5, 2019 at 10:50 am
  
  can you create aliases from the admin console UI for those users using the same admin account you used with ok goldy? if yes, can you run the tool again this time only for demouser1 and 2 and send me the screencapture link?
  
  also check your admin console logs for the admin user you are using with the tool.
  
  If you need to provision them urgently and if nothing works, you can consider virtual routing table instead of creating aliases as I show in the video here https://youtu.be/X1bNgp30j9U
  
  Reply
Steen Jensen
July 1, 2019 at 11:10 am

Hi Goldy,
Thank you for a very cool tool!
Is it possible to extend User Export to include all fields in the Directory, including custom attributes?
It would also be nice to have them in Update Users.
We add some custom attributes to Users and would like to maintain them with your tool.
Thanks.

Reply
1. Goldy Arora
  September 5, 2019 at 10:51 am
  
  You’re welcome Steen, appreciate the feedback. I will consider including custom attributes, don’t have specific timeline though.
  
  Reply
  1. Anders
    September 30, 2019 at 8:59 am
    
    Would love this!
    
    Reply
Cory
April 26, 2019 at 10:18 am

Trying to use your add-on unfortunately it seem the “Create Aliases’ is giving me problems. I want to assign a universal alias to everyone’s email for bulk emailing. I get the error ‘API call to directory.users.aliases.insert failed with error: Entity already exists.’ Any help would be massively appreciated!

Reply
1. Goldy Arora
  April 26, 2019 at 8:10 pm
  
  Alias is also an email address, so it has to be unique, once you create an alias for a user, you can not create the alias for another user with the same email.
  
  Looking at your scenario, you should be better off leveraging G Suite groups.
  
  Simply create a G Suite group, and click on “Add all domain users” to make it dynamic, so when anyone sends an email to this group’s email address, all of your users will receive that email in their respective mailboxes.
  
  I just recorded this quick clip if it helps.
  
  Reply
Ricahrd Lee
April 1, 2019 at 5:38 pm

Hello

Thank you for your great work.
It helps me arrange the company’s g suite account users and groups a lot.
By the way, Can you help me that the exporting groups with members count? with members list?
or exporting users comes with what group they are under it?

I appreciate your help in advance.
thanks,

Reply
1. Goldy Arora
  April 1, 2019 at 5:48 pm
  
  Your welcome, glad it helps you perform mass G Suite operation.
  
  For your member export, see if following helps-:
  1. Export your Groups from the group management module.
  2. Now out the required groups in “Export Members” sheet, run the export members function to get members count and their emails as output.
  
  Reply
  1. Richard Lee
    April 1, 2019 at 6:37 pm
    
    Thank you so much for your quick response. 🙂
    it is a BIG help.
    By the way, Is there any export group and members that arrange to match between the group and members all??
    I mean, when I grep all group and put on exporting members on the sheet, it comes with members but not match with groups.
    
    Thank you!
    
    Reply
    1. Goldy Arora
      April 1, 2019 at 8:44 pm
      
      Its not possible in the add-on, but I get your use case, i’ll try to add this functionality in coming weeks.
      
      Reply
      1. Richard Lee
        April 2, 2019 at 8:22 am
        
        thank you so much!
        I really appreciate it.
      2. Marius Buda
        May 17, 2019 at 6:42 am
        
        It will be very useful to be able to export all groups members at once. Thank you for your work.
      3. Goldy Arora
        May 19, 2019 at 2:04 pm
        
        Thank you for the feedback, did you mean export all the groups in the domain along with their respective members?
Hans Verschuur
March 4, 2019 at 8:37 am

Hi Goldy
Thanks for your very good info video’s

during my trial period G suite, my provider had problems with changing DNS and MX records and our mail did not work well
I changed provider, deleted all on Gsuite and let it expire
now I want to set Gsuite up with my domain (are2be.com) at a new provider, but when Google checks my domain it reports that: this domain is in use
it also reports : Hi Hans all you have to do is fill in the payments
can you tell me what to do
Thanks
Hans

Reply
1. Goldy Arora
  March 8, 2019 at 12:52 pm
  
  Ideally, you should have deleted it, though you let the trial expire, but your domain is still in Google’s database, so now i would recommend you to simply go to admin.google.com and sign in with your G Suite admin credentials –> make the payment and start using it.
  
  There is another option (a bit lengthy) –> You can contact a G Suite reseller near by (Google partner directory https://cloud.withgoogle.com/partners), they will then contact Google to purge your domain from their database, and once thats done, they should be able to offer you 30 days trial.
  
  Hope it helps.
  
  Reply
Amit
March 4, 2019 at 8:36 am

Yoo goldy i watched it !!! Works
thats an amazing Project what you did here !!!

i have another question those days i am forwarding mails with gam do you have a solution for that with Ok goldy ?

Reply
1. Goldy Arora
  March 8, 2019 at 12:56 pm
  
  Glad to hear you were able to successfully add members to G Suite groups in bulk.
  
  Regarding your forwarding emails via GAM –> help me understand the use case, is this something you can’t do with https://support.google.com/a/answer/4524505 ?
  
  Reply
Amit
March 3, 2019 at 3:29 pm

API call to directory.members.insert failed with error: Invalid value for: Member is not a valid value

how do i fix it ???

Reply
1. Goldy Arora
  March 3, 2019 at 3:36 pm
  
  It seems you didn’t watch the video above before performing members addition.
  
  Please watch it and you should be good.
  
  Please make sure you are putting the member’s role in uppercase (e g MEMBER, or OWNER).
  
  Reply
Yan Sth
February 14, 2019 at 10:24 am

Hi Goldy,
Great Addon! I am using GSuite Education. I have couple of queries in using your tool.
1. How can I include Secondary Email addresses of users during account creation?
2. How can I automatically send login info to secondary email after account creation?
3. How can I assign suspension date (if possible) to individual users during account creation?

Thanks,

Reply
1. Goldy Arora
  February 28, 2019 at 11:19 am
  
  All of these features aren’t in the add-on yet, but i’ll consider adding them (especailly #1 and #3) in the next update.
  
  Reply
Daniele Debiagi
February 11, 2019 at 9:59 am

Thank you for this great add-on!
I was going to create something similar via apps script, but I found your one 🙂
Since I’d like it do to a more complex work in my organization, have you published somewhere the source code?
If so, could you tell me how to find it?
If not, thank you anyway for the great and precious work!

Reply
Robert Parker
January 31, 2019 at 1:18 pm

What is the best way to “clean-up” g-mail filters – many filters have labels that have no relevance to the e-mail – will exporting the filters to Sheets, deleting the not needed labels, and then importing back into Sheets do – or am I missing some steps? thanx!

Reply
1. Goldy Arora
  February 28, 2019 at 11:22 am
  
  I have written another add-on that can tell you how many emails are there (read and unhread) in your labels, and then you can (if you want) also delete the labels you don’t need anymore right from your google sheet.
  
  Its called Labels Manager for Gmail, you can install it here https://gsuite.google.com/marketplace/app/labels_manager_for_gmail/772030519259
  
  Reply
Chintal Modi
January 23, 2019 at 11:16 pm

Hi Goldy,
New GSuite Basic User. Just wanted to say thank you so much for your awesome videos in getting me started. Much Appreciated!!!!!
Chintal

Reply
iamokaye
January 21, 2019 at 5:19 pm

Hello — I found Ok Goldy today! I’m trying to export all my groups and see all the members in each group. I have only been able to put in a single group. When I copy several groups, I get all the users, but not listed by group. I get a sum total of all members of all groups. I was hoping that Group 1 would show me the Group1 members, then Group 2 would show me the group 2 members etc. Is there a way to accomplish this?

Reply
1. Eric
  March 17, 2019 at 11:19 am
  
  I’m looking for this, too. Thank you for this great tool. I found it while on a chat with Google Support who told me “there is no way to export a list of all groups from your account…”. Even if I can’t get this from your tool it’s been helpful for getting me past their response.
  
  Reply
AMAR NATH MISHRA
January 18, 2019 at 8:29 am

Hi Goldy Ji,
Nice video for me.
I am Delhi base and working for Google Premier Partner as G Suite Services.I want to certified for G suite Administrator and Deployment Specialist but i have few query.So that i need your suggestion.

Can your share your contact detail or whats app details or any online session.
Waiting for your Valuable Response.

Regards,
Amar

Reply
Shane
January 2, 2019 at 11:38 am

Is there a way to add fields to the “update user” tab. I am looking to set info such as Address and Telephone?

Reply
1. Goldy Arora
  January 21, 2019 at 8:39 pm
  
  Not yet, but i’ll considering adding in coming weeks.
  
  Thank you
  
  Reply
  1. Jaques Pretorius
    January 31, 2019 at 4:09 am
    
    Hi Goldy, please assist me in filling in the correct codes in the columns for the Label BG color (which i just want white) and Text color (which i just want black).
    
    Reply
  2. Jaques Pretorius
    January 31, 2019 at 4:23 am
    
    please advise on legitimate color codes for label BG and label text color columns. Thanks
    
    Reply
    1. Goldy Arora
      February 28, 2019 at 11:23 am
      
      Sure, here you go
      The background color represented as hex string #RRGGBB (ex #000000). This field is required in order to set the color of a label. Only the following predefined set of color values are allowed:
      #000000, #434343, #666666, #999999, #cccccc, #efefef, #f3f3f3, #ffffff, #fb4c2f, #ffad47, #fad165, #16a766, #43d692, #4a86e8, #a479e2, #f691b3, #f6c5be, #ffe6c7, #fef1d1, #b9e4d0, #c6f3de, #c9daf8, #e4d7f5, #fcdee8, #efa093, #ffd6a2, #fce8b3, #89d3b2, #a0eac9, #a4c2f4, #d0bcf1, #fbc8d9, #e66550, #ffbc6b, #fcda83, #44b984, #68dfa9, #6d9eeb, #b694e8, #f7a7c0, #cc3a21, #eaa041, #f2c960, #149e60, #3dc789, #3c78d8, #8e63ce, #e07798, #ac2b16, #cf8933, #d5ae49, #0b804b, #2a9c68, #285bac, #653e9b, #b65775, #822111, #a46a21, #aa8831, #076239, #1a764d, #1c4587, #41236d, #83334c
      
      color.textColor string The text color of the label, represented as hex string. This field is required in order to set the color of a label. Only the following predefined set of color values are allowed:
      #000000, #434343, #666666, #999999, #cccccc, #efefef, #f3f3f3, #ffffff, #fb4c2f, #ffad47, #fad165, #16a766, #43d692, #4a86e8, #a479e2, #f691b3, #f6c5be, #ffe6c7, #fef1d1, #b9e4d0, #c6f3de, #c9daf8, #e4d7f5, #fcdee8, #efa093, #ffd6a2, #fce8b3, #89d3b2, #a0eac9, #a4c2f4, #d0bcf1, #fbc8d9, #e66550, #ffbc6b, #fcda83, #44b984, #68dfa9, #6d9eeb, #b694e8, #f7a7c0, #cc3a21, #eaa041, #f2c960, #149e60, #3dc789, #3c78d8, #8e63ce, #e07798, #ac2b16, #cf8933, #d5ae49, #0b804b, #2a9c68, #285bac, #653e9b, #b65775, #822111, #a46a21, #aa8831, #076239, #1a764d, #1c4587, #41236d, #83334c
      
      Reply
Alex
November 26, 2018 at 1:53 pm

Hi,
Your tool looks cool.
I’ve having small issues with it, can you provide more details for this error:
After any task that I start, I get this error:
Message details
Daily Limit Exceeded. The quota will be reset at midnight Pacific Time (PT). You may monitor your quota usage and adjust limits in the API Console: https://console.developers.google.com/apis/api/admin.googleapis.com/quotas?project=939946549872
I’m unable to access link provided here in error log. Thanks

Reply
ximo
November 23, 2018 at 6:45 am

Thanks for the great job Goldy!
Is it possible to share the spreadsheet generate between diferent admins? or should each user has it’s own spreadsheet?

Thanks!

Reply
Bayo Simmonds
November 16, 2018 at 5:05 pm

Hello Goldy, thanks for the nice app. Do you have a way that it sorts each email in bulk by the labels onto google sheet in an automated way? That I do not have to repeat this process daily, but it’s sorted daily for me? I use labels to the person sending the email in a very descriptive way that helps other people read those tags and know what action to take. So let’s say, If I get a new email from a company like Trulia.com that allow anyone to post rentals through their platform, and someone who someone who I’ve already spoken to months ago contacts me again, Trulia will have a reply interface that’s standard where the name, and phone number and email(?) are always in the same place within their email structure. I would have already tagged this person so other people using the same email account can see and reply based on my colored and highly descriptive tags. Currently, we have to manually open each email, and use the phone number mainly to bring up any old file we have on that person. Once we do a search, we’ll see our descriptive tags and we then retag all emails including the recent email to make sure they are up to date with the most recent tq=ags. Ok, now my question is, is there a way I can use this application to, or you can have it function so I can sort the email out by the tags as they come in? Or I can manually tag it when they come in but from that stage, you can have a function that allows me to upload that email from Gmail to google sheets so now I can use formulas to send replies to who I want based on those emails that were separated by tags? It would allow me to adjust my messages after I can get them into google sheet in a bulk manner. I hope what I wrote made sense and hope you can contact me at bayostheave@gmail.com. Thank you!!

Reply
1. Goldy Arora
  November 20, 2018 at 1:32 pm
  
  I got it, it should be doable to parse and put all emails in your Google Sheet along with the given label, you may also have another script running on top of it which asks the name of the label to whom you want to send email, and it does just that using your email template.
  
  Reply
Jo Osler-lane
October 18, 2018 at 8:18 am

Hi
I’m trying to set up a WordPress website on Google Cloud Platform with a domain purchased from Go Daddy through Gsuite. Initially I could access the website admin but have since been unable to. It keeps coming up with the 404 error. Also I cannot access the domain via Go Daddy, although I can through Gsuite. I have tried to change the nameservers but with no success. I’m working on the site for someone else but I’m struggling to get it off the ground and getting very frustrated and any suggestions would be great.

Reply
1. Goldy Arora
  November 20, 2018 at 1:27 pm
  
  My apologies, I am not able to help help here with these limited details.
  
  Reply
Santiago
September 29, 2018 at 3:37 am

Hello and thanks for the add-on. It is wonderful
Comment that I get the following error when I try to export users: TypeError: Cannot read property “givenName” from undefined.

Reply
1. Goldy Arora
  October 14, 2018 at 8:42 pm
  
  Thank you for bringing this up, can you check in your admin console if any of your users do not have first or last name?
  
  Reply
zetawi
September 29, 2018 at 3:23 am

Hi,
Is there a way for me as google admin in my company to access certain employee google drive and see their stored documents and files. I get this request frequently from top executives. appreciate your support.

Reply
1. Goldy Arora
  October 14, 2018 at 8:43 pm
  
  Yes, you can use Google Vault or Google Drive API.
  
  Reply
Pípol
September 21, 2018 at 11:37 am

Hi, GoldY! First excelent work! You said in an answer that need a update to ask for change the password… It is done yet? Sorry my english O:)

Reply
1. Goldy Arora
  September 23, 2018 at 3:42 pm
  
  Thank you, glad you find it useful.
  
  Yes, I pushed the update last week, and now its under Google’s review, hopefully should be out soon. I will keep you posted here.
  
  Reply
  1. Goldy Arora
    September 26, 2018 at 7:07 pm
    
    So Google approved the update, now when newly created users will have “password change at next login” will be turned on by default.
    
    Reply
    1. Vangelis Tougias
      November 8, 2018 at 10:56 am
      
      How to turn this feature off? So that the default would be that users WILL NOT be asked to change their password at their first login.
      (Great tool by the way)
      
      Reply
      1. Goldy Arora
        November 20, 2018 at 1:25 pm
        
        just trying to understand, why would you that, won’t it make it insecure?
      2. Sergi
        July 30, 2019 at 5:07 am
        
        For example, sometimes we want small kids in schools to have “predefined” passwords so they won’t change them; is it possible to set this to “FALSE” then?
      3. Goldy Arora
        September 5, 2019 at 10:41 am
        
        Earlier I had it that way, but then someone commented saying we should enforce password change at first login so i changed it, but I think I should rather make it configurable by allowing putting yes/or in the column.
        
        I will do that very soon, appreciate the feedback.
Marouane Daoudi
September 19, 2018 at 6:48 pm

it is great , Just a little issue , it doesn’t deal with large data , I was trying to add 10 000 member to a group and after adding 2000 it stopped and showed an error message says “exceeded maximum execution time” , I hope if there is any solution of this problem it will be perfect for me , thank you

Reply
1. Goldy Arora
  September 19, 2018 at 8:11 pm
  
  Thank you for giving it a try, am glad its useful to you.
  
  This add on uses Google Apps Script where Google enforces an execution limit of 6 minutes (30 mins if you are on G Suite business or enterprise edition).
  
  I recently attended Google Next in SFO,CA where they shared plans to launch “Job Service” which will help to break the tasks and run them simultaneously, hopefully it’ll help to avoid this limitation.
  
  For now, a dirty workaround would be to run the add on a few times.
  
  Hope it helps.
  
  Regards,
  Goldy
  
  Reply
ansh
September 17, 2018 at 10:36 am

well i read the above comments, and i am facing problem similiar to one user.
when i click on ok goldy addon, it shows me “help”.
even though i open the spreadsheet from this link https://chrome.google.com/webstore/detail/ok-goldy/gmabiogplcnaoilfpffhdeomgajmlbod?utm_source=permalink

any suggestion?

Reply
1. Goldy Arora
  September 17, 2018 at 10:39 am
  
  Sorry to hear that, delete that one, and install as per this video https://youtu.be/t8dZ7S7avig
  
  Let me know how it goes.
  
  Reply
samson momoh
September 17, 2018 at 8:54 am

Hi Gordy, is there a way to reach you via email because the one I saw gave me an error in delivery. Pls I need a reply asap.

Reply
1. Goldy Arora
  September 17, 2018 at 9:20 am
  
  help@goldyarora.com
  
  Reply
Paco Ballesteros
September 16, 2018 at 10:14 am

Wonderful script! Thank you very much for share. Your voice in videos is pleasant. And, of course, your work awesome. Thanks again

Reply
1. Goldy Arora
  September 16, 2018 at 11:58 am
  
  haha, thank you so much for your pleasant comment, appreciate it, glad I could help.
  
  Reply
Vicenç
September 14, 2018 at 4:38 pm

Thanks so much! Fantastic add-on!!
One question: when you bulk create some users, could you obligate to change the password in the next session?
Thanks again!

Reply
1. Goldy Arora
  September 14, 2018 at 6:19 pm
  
  Your welcome, glad you liked it.
  
  Thank for proposing idea to enforce password change at next login, I just added that feature, now all new created users via Ok Goldy will need to change their password at first login.
  
  However, Google may take couple of days to review and publish the latest version.
  
  Reply
2. Paco Ballesteros
  September 16, 2018 at 5:18 am
  
  Wonderful script! Thank you so much. Awaiting the new version to change password at first login in new users. Thanks again
  
  Reply
Antonio Romeo
September 13, 2018 at 10:23 am

Hi Goldy,
Your videos and tips are awesome! I do have a technical question. I am testing custom url for my employer and have updated the following: http://email.domain.ca. I have also set the CNAME record with the registrar for our domain. The problem we are having is that this custom URL is really an alias and redirects to https://mail.google.com/a/domain/mail…. We need it to stay as email.domain.ca. The reason is that we have many members that cannot access Gmail from their employers as their employer blocks Gmail. Our members’ employers however have whitelisted our domain http://email.domain.ca. How can we get our members to access http://email.domain.ca from their employers while their employer can still block these users from accessing their personal @gmail.com email accounts? Hoping you can help.

Reply
Kristin
September 13, 2018 at 9:52 am

Does this add-on still work? I’ve installed the add-on, and I see it via the Add-ons menu, but the option option available within Add-ons > OK Goldy is Help. No option for the setup wizard or anything else?

Reply
1. Goldy Arora
  September 13, 2018 at 10:29 am
  
  Sorry to hear that, seems you installed it via G Suite Marketplace, please install from the Google Sheet Add on gallery by following this link and it should work as shown.
  
  https://chrome.google.com/webstore/detail/ok-goldy/gmabiogplcnaoilfpffhdeomgajmlbod?utm_source=permalink
  
  let me know how it goes.
  
  Reply
Dean Ouellette
September 11, 2018 at 1:28 am

Question, I have watched a lot of your videos. Here is what I am still not sure of. I have 4 domains i have and pay for G Suite. For now let’s just call them 1.com, 2, 3, 4.com

In all 4 I have an email address, and under each i have several google docs and sheets, many of which i share with other people outside my domain.

If I want to get them all under 1.com so i am only paying for one, but have sheets/docs in all of them… A how can i combine the sheets/docs into one and also if i am using 1.com as my main, and someone creates a new sheet and shares it with me at 2.com, how would that work?

Thanks for your help

Reply
Brooke Carey Ahrens
September 8, 2018 at 10:45 pm

This is the error I’m getting when I try to use the “Export Users” function on sheet 5.

TypeError: Cannot read property “givenName” from undefined.DetailsDismiss

Reply
1. Goldy Arora
  September 9, 2018 at 9:05 pm
  
  Hope the chat we had at Ok Goldy facebook group solved your issue?
  
  Reply
Nayela
September 5, 2018 at 3:19 am

Hi Goldy,
Can you please share the code to get Gmail message Id in the new Gmail. I have checked your video on youtube, https://www.youtube.com/watch?v=7Oi8POY7hfQ, where you have mentioned you will be putting up the code in your website. But, I am unable to locate the same.
Thank you

Reply
Binit Tiwari
September 4, 2018 at 3:30 am

Hi Goldy Arora Ji
I would like to talk to you for G-Suite I want to purchased, but before we confirm that how to work G-suite and how create group we are Delhi based web development company i cant used this service for sent email for suite email to customer.

Reply
1. Goldy Arora
  September 9, 2018 at 9:08 pm
  
  sorry, I didn’t understand your question.
  
  Reply
anil khichar
August 30, 2018 at 11:41 am

Wonderful…Thank you for sharing such a good automation stuff.

Reply
1. Goldy Arora
  September 2, 2018 at 10:08 pm
  
  Your welcome, glad I could help.
  
  Reply
Karen Patterson
August 29, 2018 at 12:26 pm

Hi, I am grateful to you for creating this add-on to help streamline the process of creating and updating users; etc. My question to you is with regards to the Create User set-up sheet, when entering the Password for each user, I only know my PW as the Admin but my other assigned users who are active on my G suites email/domain have already updated/changed their login PW. How do I obtain this info from the system without my users feeling as if I’m being intrusive. Additionally, am I able to add new user accounts (alias; etc.) within the Add-on feature? (Please excuse this last question as ignorant. I’m just not certain how this feature would work). Thank you

Reply
1. Goldy Arora
  August 29, 2018 at 2:19 pm
  
  Thank you Karen, glad I could help.
  
  I am not sure if I understand first part of your question, so i’ll try based on guess-:
  
  1. You use “Create Users” sheet only when you need to create new users (users which don’t exist in your G Suite yet).
  2. If you want to update already created users, consider using update users, suspend users or delete users sheets as required.
  
  Alias Management -: Hopefully I will add feature to manage aliases (create, remove, delete) in coming few days.
  
  Reply
Brooke Carey Ahrens
August 28, 2018 at 12:23 pm

Hi!

your add-on is AMAZING. I’m updating our gmail mailing lists, suspending users no longer on campus and cleaning up our domains.

I’m getting an error code today though every time I try to run the Add-On. I’m thinking it’s Google but I wanted to see if you had any more info.

Thank you again!

Reply
1. Goldy Arora
  August 28, 2018 at 1:37 pm
  
  Your welcome, glad I could help.
  
  Whats the error?
  
  Reply

Ok Goldy

Video Tutorials

Text with Screenshots

Table of Contents

Installing OK Goldy

Installing OK Goldy

Users Management

Create Users

Update Users

Suspend Users

Bulk Delete Users

Bulk Export Users

Groups Management

Bulk Create Groups

Bulk Delete Groups

Bulk Export Groups

Members Management

Bulk Add Members

Bulk Export Members

Bulk Remove Members

Alias Management

Bulk Create Aliases

Bulk Export Aliases

Bulk Delete Aliases

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

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

Log into your G Suite account.

Go to Google Sheets

Create a blank sheet and give it an appropriate name.

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

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

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.

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 G Suite administrator.

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

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 G Suite 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.

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

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.

Create Users

How to bulk create or add G Suite users

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

Update Users

How to bulk update G Suite users

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

Suspend Users

How to bulk suspend users in your G Suite account

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

Bulk Delete Users

How to bulk delete G Suite users

In this section you will learn how to bulk delete G Suite users.

Bulk Export Users

How to bulk export G Suite users in a Google Sheet

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

Bulk Create Groups

How to bulk create G Suite groups with OK Goldy

Bulk Delete Groups

How to bulk delete G Suite groups with OK Goldy

Bulk Export Groups

How to bulk export G Suite groups using OK Goldy

Bulk Add Members

How to bulk add G Suite group members with OK Goldy

Bulk Export Members

How to bulk export group members from a G Suite group using the OK Goldy add-on

Bulk Remove Members

How to bulk remove G Suite group members with OK Goldy

Bulk Create Aliases

How to create G Suite aliases in bulk with OK Goldy

Bulk Export Aliases

How to bulk export G Suite aliases using the OK Goldy

Bulk Delete Aliases

How to bulk delete G Suite user aliases with OK Goldy

Troubleshooting & FAQ

Most frequent questions and answers

Come together to help G Suite community.​

85 thoughts on “Ok Goldy – Easily perform G Suite bulk operations from Google Sheets”

Leave a Reply Cancel reply

Come together to help G Suite community.