Add/Delete Rows

Add or Delete the rows

Add or Delete the specified number of rows from the 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 row is added or deleted.

• Sheet Name: String Argument The name of the sheet in which row is added or deleted.

• Row Index: Object Argument The index of the row is to be added or deleted.

• Number of Rows: Object Argument The number of rows is to be added or deleted.

Options

• Mode: The mode for add delete row operation.

  • INSERT - Insert the rows to the google sheet.

  • DELETE - Delete the rows from the google sheet.