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 |
|
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:
The file mapping supports the following assignment types:
variable assignment: A=={{Field1}}
formula assignment: 2 == =VLOOKUP(Value2,Range,0,1)
value assignment: Column2==12
The fields can be listed as Column names, letters or indexes.
All field labels are required to be the same type.
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.comand given "Editor" permissions.The data within the spreadsheet should be formatted as a table with headers.