Ok Goldy

Ok Goldy is a free Google sheet add on which can help you perform bulk operations in Google Workspace

You can bulk create, update, suspend, delete, export Google Workspace Users, Groups, Members, Aliases and much more….
‍
All right from your own Google Sheet with just a few clicks, no scripting / coding required.

Ready to bulk manage Google Workspace? Learn how to use the tool with above videos.

‍

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 19 million 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. 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.

I only ask for the OAuth scopes that are must required to make this add on work (e.g Google Directory API scopes specific to users, groups, google sheets, openId).

Also, as per Google's OAuth review process, Google does not grant the scopes that are not required by the add on functionality.

2. 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 the add-on even if the add-on is installed.

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/).

3. 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 had 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.

Please join the community and suggest the feature there, if there are others in the community asking for this too, I would consider investing some time to build it!

Though I would love to help you out, but providing 1 to 1 help is a bit difficult especially as am full employed + has teenager kids + lot of people use this.

I would recommend you to join the community where your question would probably be answered already (if others asked it), and if not, either I or someone in the community would love to answer it.