Add row of data in Google Sheets

Adds a row of data at the end of 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)

Note: Ensure the requirements below have been completed before configuring the Wrk Action

Common use cases

• Data and Content Manipulation

Application

• Google Sheets

Inputs (what you have)

NAME	DESCRIPTION	TYPE	REQUIRED	EXAMPLE
Spreadsheet link	Link to the Google Sheets spreadsheet where the row of data will be added.	Link	Yes	https://docs.google.com/spreadsheets/d/1eQ
Columns and data assignments	Map the spreadsheet columns to the datapoints to be inserted.	Text	Yes	See below
Sheet name	The name of the Google Sheets tab. First tab will be used by default. Sheet name is case sensitive	Text	No	Sheet1
Table start row number	The row number where the headers of the table are located. If left blank, the first row will be used by default	Integer	No	10

Note 1: 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. These variables in the Data Library are the outputs of previous Wrk Actions in the Wrkflow.

Note 2:

1. The file mapping supports the following assignment types:

   1. variable assignment: A==#{{Field1}}
   2. formula assignment: 2 == =VLOOKUP(Value2,Range,0,1)
   3. value assignment: Column2==12

2. The fields can be listed as Column names, letters or indexes.

3. All field labels are required to be the same type.

4. Multiple assignments will be separated by a double pipe ||

Examples:

Example 1: Field name 1 == #{{Field1}}|| Field name 2 == #{{Field2}}

Example 2: A == {Field1}|| B== {Field2}

Example 3: 1 == Value1 || 2 == =VLOOKUP(Value2,Range,0,1)

Outputs (what you get)

• N/A

Outcomes

NAME	DESCRIPTION
Success	This status is selected if the data was successfully added to the Google Sheets sheet.
Unsuccessful	This status is selected in the event of the following scenarios:- Spreadsheet link does not work- Headers/ column assignments do not match the ones in the file.

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.