Parameters   Output Objects  

Searches Google Sheets data.

Syntax

Select-GoogleSheets [parameters]

Remarks

The Select-GoogleSheets cmdlet allows you to use a syntax similar to SQL SELECT statements to search Google Sheets data.

$conn = Connect-GoogleSheets
Select-GoogleSheets -Connection $conn -Table "Spreadsheet1_Sheet1" -Columns @("Id","Column1") -Where "Column2='Bob'"