Powershell module for Google / G Suite API calls wrapped in handy functions. Authentication is established using a service account via P12 key to negate the consent popup and allow for greater handsoff automation capabilities
Added Add-GSSheetValues to use the native Append() method instead of BatchUpdate() to prevent needing to calculate the last row like you do with Export-GSSheet. Since the input for this method has additional options and the output differs from what Export-GSSheet outputs, this has been moved to a unique function to prevent introducing breaking changes to Export-GSSheet.
Updated private function Resolve-Email with new IsGroup switch, then cleaned up all *-GSGroup* functions to use it so that Group ID's are respected based on RegEx match.
Added: Archived parameter to Update-GSUser to enable setting of Archived User licenses.
Miscellaneous
Swapped instances of Get-StoragePath for Get-ConfigurationPath in Import-SpecificConfiguration and Set-PSGSuiteConfig to avoid alias related issues with PowerShell 4.0
2.35.0 - 2019-12-29
Add-GSSheetValues
to use the nativeAppend()
method instead ofBatchUpdate()
to prevent needing to calculate the last row like you do withExport-GSSheet
. Since the input for this method has additional options and the output differs from whatExport-GSSheet
outputs, this has been moved to a unique function to prevent introducing breaking changes toExport-GSSheet
.Invoke-GSUserOffboarding
function to wrap common offboarding tasks for ease of access management automation.Get-GSSheetInfo
so it no longer defaults-IncludeGridData
to$true
if not specified in$PSBoundParameters
.Resolve-Email
with newIsGroup
switch, then cleaned up all*-GSGroup*
functions to use it so that Group ID's are respected based on RegEx match.Archived
parameter toUpdate-GSUser
to enable setting of Archived User licenses.Get-StoragePath
forGet-ConfigurationPath
inImport-SpecificConfiguration
andSet-PSGSuiteConfig
to avoid alias related issues with PowerShell 4.0