Insert Rows

Description

This activity inserts one or more rows in a sheet at the specified row address.

note

This activity works only inside Google Context activity.

Insert - Specify one of the following options.

Option	Description
Single	Insert a single row at the specified address. A new row will be inserted before the row represented by the Row Address property.
Multiple	Insert multiple rows at the specified address. The new rows will be inserted before the row represented by the From address. The number of rows would be calculated based on the specified From and To addresses.

Row Address - Specify either row address or cell address to insert a new row in that address.
From - Specify the starting address of the range. The address can be either a row address or a cell address. It is a mandatory field if Multiple Rows is selected.
To - Specify the ending address of the range. The address can be either a row address or a cell address. It is a mandatory field if Multiple Rows is selected.

Spreadsheet Path / Id - Specify the relative spreadsheet path or Id inside Google Drive.

DisplayName – Add a display name to your activity.
Private – Logs the variable and argument values at the Verbose level when unchecked.

Sheet Name - Specify the sheet's name where you want to insert the new row. By default, it will operate on the currently active sheet.
Inherit Perious Formatting - If checked, the new row's format will match its previous row's format. By default, the new row's format will match its next row's format.
Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.

note

Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Download Example

Insert Rows