WriteRow

This activity helps the user to write the value as array of row or data row in the specified row in the spreadsheet.

Properties

Configuration

Each activity requires a connection with Google Sheets authentication. Once you select the respective project name where Google Sheets has been authenticated, the activity will automatically retrieve the available connections for that project.

Below are the properties available after the project has been integrated:

Google: *This parameter indicates the account name associated with the integration.

INPUT

WorkbookName: *This parameter indicates to provide the existing spreadsheet. It offers multiple ways to choose the spreadsheet:

1. Browse Option: When selecting the “Click on Browse” option, it will automatically list the folders and spreadsheets available for the specified account. The user must manually select the spreadsheet each time when using this option.
2. Three-Line Menu: Clicking on the “Three lines” icon will open a context menu with the following two options.
a. Reload Folder Picker: Refreshes the selected folder or spreadsheet to select a new folder name.
b. Use Variable: Allows you to provide the “Workbook Name” as a variable in “String” format. You can either hardcode the values as a string or use a variable of the “String” datatype. Below are the values that can be provided as variable,
     i. URL or ID: After creating the workbook in the specified Google account, you will receive the workbook’s URL and ID. Click here to refer how to retrieve the URL and ID of the spreadsheet.
    ii. Spreadsheet Name: You can either hardcode the name as a string or provide a variable of the “String” datatype.

Sheet Name: *This parameter specifies the name of the sheet where the data row needs to be inserted. It provides multiple options for selecting the sheet:

1. Update Range: Refreshes and updates the list of available sheet names, which will appear in a drop-down menu.
2. Use Variable: Allows you to provide the sheet name as a variable in “String” format. You can either hardcode the value as a string or use a variable of the “String” datatype. The following values can be provided as a variable:
a. Spreadsheet Name: You can either hardcode the name as a string or provide a variable of the “String” datatype. (Click here to learn how to retrieve the sheet name from the spreadsheet.)
3. Select Sheet: Allows you to manually select the sheet name from the drop-down menu, which lists the available sheets in the spreadsheet. The user must manually select the spreadsheet each time this option is used.

Range: *It indicates to provide the cell range where the datarow needs to be inserted. It accepts values in “String” datatype, which can be either hardcoded or provided as a variable in the “String” datatype.

How to Write/ WriteType: If the specified cell range in the provided spreadsheet already contains data, the activity offers the following options:

Append: The data will be written after the last cell that contains a value.
Overwrite: The data in the specified cell range will be overwritten.

What to Write / WriteType: This parameter allows you to choose the type of data to be written. By default, “DataRow” is selected.

Data Row to Write / DataRow: This parameter specifies the “DataRow” variable that needs to be written in the specified range. It accepts values of the “DataRow” datatype. You cannot manually assign a value to the DataRow variable; instead, you can iterate and assign the DataRow value from the DataTable variable.

IncludeColumnHeaders: Indicates whether to include the “Column Headers” in the spreadsheet when writing data. If left blank, the column headers will not be considered.

Position: This parameter specifies the index position where the DataRow will be written within the specified spreadsheet. The index starts at “0”. By default, it is set to “0”. If no value is provided, the new DataRow will be inserted at position “0” if the write type is set to “Overwrite.” If the write type is set to “Append,” the DataRow will be written at the end of the spreadsheet.

To write data continuously in the specified spreadsheet, you can use the “Append” option, which will add the value after the last filled row.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Result: It provides the ability to view the execution status of the activity. It returns values in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.