Automate Your G Suite Administration with Google Sheets

Are you a G Suite Administrator investing so much time in G Suite 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 G Suite Administrator and was struggling with this too, all I could find are couple of tools to automate my G Suite Administration but they were either costly or were not easy to use.

Because I make my living helping businesses move to G Suite, 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 G Suite Admins (like you) can easily administer G Suite 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 G Suite Users

— Bulk Create G Suite Users

— Bulk Update G Suite Users

— Bulk Suspend G Suite Users

— Bulk Delete G Suite Users

— Export All your G Suite Users with one click

2. Manage G Suite Aliases

— Bulk Create G Suite User Aliases

— Bulk Delete G Suite User Aliases

— Export G Suite User Aliases

3. Manage G Suite Groups

— Bulk Create G Suite Groups

— Bulk Delete G Suite Groups

— Export All G Suite Groups

4. Manage G Suite Group Memberships

— Bulk Add Members to G Suite Groups

— Bulk Remove Members from G Suite Groups

— Export Members of G Suite 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.

Rating Distribution

• 1 stars: 7 votes
• 2 stars: 4 votes
• 3 stars: 33 votes
• 4 stars: 65 votes
• 5 stars: 77 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!