Edit a row of data in a Google Sheets sheet. The data points and their destination columns will need to be specified.
Avoid using special characters ( ||,== ) in the 'Columns and data assignments" input unless being used to separate assignment expressions )||) or for value assignments (==) (if values contain these characters they can only be passed into the input as a variable)
Application
Google Sheets
Inputs (what you have)
Name | Description | Data Type | Required? | Example |
Spreadsheet link | Link | Yes | ||
Row number | Row number of the cells to be edited | Number | Yes | 1 |
Columns and data assignments | Map the spreadsheet columns to the datapoints to be inserted. | Text
(Long) | Yes | Example 1: Field name 1 == ##{{ Field1 }}|| Field name 2 == ##{{ Field2 }}
Example 2:
A = {Field1}|| B== {Field2}
Example 3: Column1 == Value1 || Column2 == =VLOOKUP(Value2,Range,0,1) |
Sheet name | First tab will be used by default. Sheet name is case-sensitive | Text(Short) | No | Sheet1 |
Ignore blank inputs? | Select true to prevent blank values from overwriting cells that have exsiting values | True or False | No |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library section. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
Name | Description | Data Type | Required? | Example |
Columns and data assignments | Map the spreadsheet columns to the datapoints to be inserted. | Text(Long) | Yes | A == New Value ||B == Second Value |
Outcomes
Name | Description |
Success | This status is selected if the cell range is successfully edited in Google Sheets |
Impossible to Complete | This status is selected in the event of the following scenarios:
|
Requirements
All Drives and Google Sheets spreadsheet need to be shared with:
googlewrkbots@wrk.comand given "Editor" permissions.The data within the spreadsheet should be formatted as a table with headers.