Ok Goldy
- Ok Goldy is a free Google sheet add on which can help you perform bulk operations in G Suite.
- Bulk Create, Update, Suspend, Delete, Export G Suite Users, Groups, Members and much more.
- Use it right from your Google Sheets without a line of code to manage tedious G Suite tasks.
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
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.
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?
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.
Yes, you can use Google Vault or Google Drive API.
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:)
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.
So Google approved the update, now when newly created users will have “password change at next login” will be turned on by default.
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
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
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?
Sorry to hear that, delete that one, and install as per this video https://youtu.be/t8dZ7S7avig
Let me know how it goes.
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.
help@goldyarora.com
Wonderful script! Thank you very much for share. Your voice in videos is pleasant. And, of course, your work awesome. Thanks again
haha, thank you so much for your pleasant comment, appreciate it, glad I could help.
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!
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.
Wonderful script! Thank you so much. Awaiting the new version to change password at first login in new users. Thanks again
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.
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?
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.
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
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
Hope the chat we had at Ok Goldy facebook group solved your issue?
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
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.
sorry, I didn’t understand your question.
Wonderful…Thank you for sharing such a good automation stuff.
Your welcome, glad I could help.
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
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.
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!
Your welcome, glad I could help.
Whats the error?