Update row of data in Google Sheets

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	Example: https://docs.google.com/spreadsheets/d/1eQ	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:All outcomes specified in the Application background document.The given Column does not exist

Requirements

• All Drives and Google Sheets spreadsheet need to be shared with: googlewrkbots@wrk.com and given "Editor" permissions.

• The data within the spreadsheet should be formatted as a table with headers.