Insert Row
insert data into a row
Last updated
insert data into a row
Last updated
Insert row data into the specified row of the sheet in the google sheets.
This activity can only be used after the Create GSuite Connection Activity
.
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 data is to be inserted.
Sheet Name: String Argument
The name of the sheet in which row data is to be inserted.
Starting Cell: String Argument
The starting cell in which row data is to be inserted.
Row Data: String Argument
The row data is to be inserted.
Insert Method:
The method for inserting row values.
SHIFT
- shift row after inserting the row data when the column to be inserted contain values.
REPLACE
- replace the row values with the row data if the specified row contains values.