Insert Row

insert data into a row

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.

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 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.

Options

• 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.