Automate Your G Suite Administration With Google Sheets





Udemy Online Course Free Coupon Code

Automate Your G Suite Administration With Google Sheets

Save time in G Suite Administration by automating it with this free Google Sheet Add on and become a Pro Admin today. – Free Course

What you’ll learn

  • After this course, you should be able to save your time in G Suite administration by performing bulk operations in G Suite like creating, deleting, suspending, updating and exporting G Suite users, groups, members, aliases and much more.


  • You should be a G Suite Administrator to use this tool and perform bulk G Suite operations like create, delete, update and explore users, groups, members, aliases etc.


Are you aGSuite Administrator investing so much time in GSuite Admin console to manage your users, groups, members and aliases?

Are you wondering what if there is an automated (but easy to use) way to do all that?

I feel you as I have been there.

I am an active GSuite Administrator and was struggling with this too, all I could find are couple of tools to automate my GSuite Administration but they were either costly or were not easy to use.

Because I make my living helping businesses move to GSuite, I thought there should be a better way, and started writing google apps script to help myself saving time.

As its working great for me, I thought to put all those scripts together and convert them in an easy to use Google Sheet Add on, so my fellow GSuite Admins (like you) can easily administer GSuite right from their Google sheet with just couple of clicks.

So what this tool can do for you right from your Google Sheet?

1. Manage GSuite Users

— Bulk Create GSuite Users

— Bulk Update GSuite Users

— Bulk Suspend GSuite Users

— Bulk Delete GSuite Users

— Export All your GSuite Users with one click

2. Manage GSuite Aliases 

— Bulk Create GSuite User Aliases

— Bulk Delete G Suite User Aliases

— Export GSuite User Aliases 

3. Manage GSuite Groups

— Bulk Create GSuite Groups

— Bulk Delete GSuite Groups

— Export All GSuite Groups

4. Manage GSuite Group Memberships

— Bulk Add Members to GSuite Groups

— Bulk Remove Members from GSuite Groups

— Export Members of GSuite Group

I am a full time employed, but try to add more features to this add on as I get sometime, so if you have any suggestion, don’t hesitate to suggest.

Author(s): Goldy Arora

Leave a Reply