Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Automate Your G Suite Administration with Google Sheets

Name: Automate Your G Suite Administration with Google Sheets
Rating: 4.6 (200 reviews)

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

Created byGoldy Arora

Last updated 10/2018

English

English [Auto],

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.

Course content

5 sections • 15 lectures • 38m total length

Installing Ok Goldy Google Sheet Add on4:02
Install the Ok Goldy Google Sheet add-on from the Google Sheets add-ons gallery, then use the setup wizard to create setup sheets for managing users and groups.

Bulk Create G Suite Users2:33
Learn how to bulk create G Suite users from a Google Sheets add-on, supply first name, last name, password, and organizational unit details, and monitor creation status.
Bulk Update G Suite Users3:12
Update Google Sheets from a dedicated add-on to bulk update G Suite users, adjusting names, emails, employee IDs, and organizational units, and review batch results showing all users updated.
Bulk Suspend G Suite Users1:54
Automate bulk suspension of G Suite users from a Google Sheet using a suspend users add-on, input primary emails, and call a data API to update suspension status.
Bulk Delete G Suite Users2:06
Use a Google Sheets add-on to delete G Suite users in bulk by pasting email addresses, running the delete script, which calls the Directory API and updates the deletion status.
Export All G Suite in Google Sheet2:14
Export all G Suite users and their attributes to Google Sheets with the User Manager add-on, visualizing enrollment, MFA status, login state, and mailbox creation dates.

Bulk Create G Suite Groups2:26
Create G Suite groups directly from Google Sheets using the Groups Manager add-on and the Directory API, providing group name, group email, and description, with provisioning status updated automatically.
Bulk Delete G Suite Groups1:47
Learn to delete G Suite groups in bulk from Google Sheets using the Ok Gulabi add-on, exporting emails and deleting them via the directory API.
Export All Your G Suite Groups in Google Sheet2:10
learn to export all your G Suite groups to Google Sheets with the Pequot add-on, showing group name, email, and member count, plus a caveat about domain-wide groups.

Bulk Add Members to your G Suite Groups3:50
Bulk add Google Groups members from a sheet using the add-on, with group email and member roles. Capitalization matters, and existing-member errors may occur.
Bulk Remove Members from your G Suite Groups3:23
Learn to bulk remove G Suite group members from Google Sheets using the Ok Goldie add-on, by providing group email and member email and running the remove function.
Exports Members of given G Suite groups right in your Google Sheet1:39
Automate your G Suite administration by exporting Google group members to Google Sheets with an add-on, revealing member emails, roles (members, managers, owners), and active status.

Bulk Create G Suite User Aliases2:28
Bulk create G Suite user aliases from Google Sheets using the alias manager add-on. Enter the user's primary email and aliases, then apply them to primary or secondary domains.
Bulk Export G Suite User Aliases2:27
Bulk export G Suite user aliases into Google Sheets using the add-on, by entering each user’s primary email and running the export script.
Bulk Delete G Suite User Aliases2:44
Learn how to bulk delete Google Workspace user aliases directly from Google Sheets using the alias manager add-on, with Directory API calls that remove specified aliases.

Requirements

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.

Description

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.

Who this course is for:

G Suite Administrator

Automate Your G Suite Administration with Google Sheets

What you'll learn

Explore related topics

Course content

Add On Installation1 lecture • 4min

G Suite User Management5 lectures • 12min

G Suite Groups Management3 lectures • 6min

G Suite Group Memberships Management3 lectures • 9min

G Suite User Aliases Management3 lectures • 8min

Requirements

Description

Who this course is for: