TU3.19: Automation for Admins: Command line management for Google Workspace with GAM
Channel: Totally Unscripted
Date: 16/07/2021

For show notes and resources visit https://tu.appsscript.info/previous-episodes/season-3/tu3-19

In this episode of Totally Unscripted we are joined by Jay Lee, creator of Google Apps Manager (GAM). GAM is an open source command line tool for Linux, MacOS and Windows which allows administrators to easily manage domain and user settings in Google Workspace. GAM is particularly useful for running bulk operations running commands in parallel from a text or .csv file. This episode will be an opportunity to find out how you can start automating your Google Workspace administration as well as some of the newer GAM features.

Show chapters:
02:00 Introduction to Jay Lee and the GAM command line tool
09:18 Overview of the Google Workspace APIs used by GAM and permission levels
14:00 How Jay uses GAM for migration and clean-up
18:11 Support and resources for using GAM 
23:50 Best approaches for learning how to use GAM
29:00 Preventing GAM horror stories
34:30 Areas where GAM can be enhanced
37:00 Jay Lee's favorite Google Apps Script solutions (inc. Google Chat bot for Workspace updates)
41:30 Jay Lee's other projects including Gmail back-up/restore tool
50:15 Using Google Sheets to prepare GAM .csv batch scripts