Delete Range

Delete the range of contents in google sheets.

Delete the contents of the specified range in the sheet 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 is to be deleted.
• Sheet Name: String Argument The name of the sheet is to be deleted.
• Range: String Argument The range of the sheet is to be deleted.

Options

• Shift: The shift options to delete the range of data.

  • NoShift - Cells will be shifted after deleted the range of data.

  • Up - Delete the range of data and shift up.

  • Left - Delete the range of data and shift left.