Google Workspace Auditor script

This script collects users, groups, mailboxes delegation, Shared Drives, YouTube accounts, Analytics accounts, policies of a Google Workspace environment on .xlsx file for audit and review purposes, the file is archived in a .zip file including a screenshot with hash MD5 of the .xlsx file and the script executed. Note that it's prepared to run on GAM configured for multiple projects, change accordly if needed. This project also offer extra features:

• Archive mailbox messages to group
• List, add or remove mailbox delegation

Set variables if different of defined:

$GAMpath = "C:\GAM7"
$gamsettings = "$env:USERPROFILE\.gam"
$destinationpath = (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path

$GAMpath defines the GAM application folder

$gamsettings defines the settings folder of GAM

$destinationpath defines the location were script result is saved

Check testing-guideline.md file as suggestion for testing guideline

You can find scripts related to mailbox delegation and mailbox archive to group in Other scripts folder

Instructions

• Save all .ps1 files locally
• Change variables of mainscript.ps1 if needed
• Run mainscript.ps1 on PowerShell (right-click on file > Run with PowerShell)
• Follow instructions selecting project name, option 1 to generate audit report and collect .zip file on $destinationpath

Screenshots

*parts ommited on screenshots are related to project/profile name

Script startup

Script completed

.zip file content

Requirements

• Windows 10+ or Windows Server 2019+
• GAM v7+ using multiproject setup
• PowerShell
• Module ImportExcel on PowerShell (not required to run extra features)