Get Sheet Info

Get specified sheet information from google sheets.

This activity can only be used after the Create GSuite Connection Activity

Input

• Credential: Object Variable A variable name that references the user credential to access the resources.

• SpreadSheet Id: String Argument The Id of the spreadsheet in which sheet information is to be extracted.

• Sheet Name: String Argument The name of the sheet in which sheet information is to be extracted.

Output

• Column Count: Integer Variable The output variable that stores the count of column values in the specified google sheet.

• Row Count: Integer Variable The output variable that stores the count of row values in the specified google sheet.

• Sheet Empty: Boolean Variable The output variable that stores true when the google sheet is empty otherwise store false.