Automate Your G Suite Administration with Google Sheets

  • Overview
  • Curriculum
  • Instructor
  • Review

About This Course

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

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.

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

Instructor

Profile photo of Goldy Arora
Goldy Arora

I am a G Suite Certified Consultant, In last 7 years, I have learnt lot of things in G Suite (Google Apps) which don’t (and do) work, and I love to share these learnings with community to help you avoid mistakes I did, and get most out of their investment in Google Apps. Regards, Goldy Arora

Review
4.9 course rating
4K ratings
ui-avatar of Shailesh Deshmukh
Shailesh D.
4.5
1 year ago

Good

  • Helpful
  • Not helpful
ui-avatar of Odum Chiamaka Bibian
Odum C. B.
5.0
1 year ago

it was awesome

  • Helpful
  • Not helpful
ui-avatar of ABHISHEK kUMAR
Abhishek K.
5.0
1 year ago

Good

  • Helpful
  • Not helpful
ui-avatar of Keris Kartono
Keris K.
5.0
1 year ago

gus

  • Helpful
  • Not helpful
ui-avatar of Enaam Caloud
Enaam C.
5.0
2 years ago

Very helpfull

  • Helpful
  • Not helpful
ui-avatar of Todd Gauger
Todd G.
5.0
2 years ago

Very helpful.

  • Helpful
  • Not helpful
ui-avatar of Michael Brunold
Michael B.
5.0
2 years ago

Is it possible to automate google account creation from a single form? So in other words, fields are populated in a form then once the submit button is clicked, the account is created and the credentials are sent to a specific address

  • Helpful
  • Not helpful
ui-avatar of Manu D C
Manu D. C.
4.5
3 years ago

its amazing and its helps us work smartly

  • Helpful
  • Not helpful
ui-avatar of Merlin P
Merlin P.
5.0
3 years ago

surely it adds my knowledge on google adds-on to be utilize in doing my work

  • Helpful
  • Not helpful
ui-avatar of Rafael
Rafael
5.0
3 years ago

Very clear of each step to accomplish next.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses