Add-GoogleSheets Cmdlet
Inserts Google Sheets data.
Syntax
Add-GoogleSheets [parameters]
Remarks
The Add-GoogleSheets cmdlet allows you to use a syntax similar to SQL INSERT statements to create new Google Sheets records.
Add-GoogleSheets -Connection $connection -Table "Spreadsheet1_Sheet1" -Columns @("Column1") -Values @("Jon Doe")