Edits the value of a cell in a Google Sheets spreadsheet.
Common use cases
Data Manipulation
Application
Google Sheets
Inputs (what you have)
NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
Spreadsheet link | Link of the Google spreadsheet | Link | Yes |
|
Column | The letter, index, or name of the column of the cell to be populated | Text | Yes | A, 1, Column1 |
Row | Row number of the cell to be populated | Integer | Yes | 1 |
Value | The new value to be populated in the cell | Text | No | 100 |
Sheet name | The name of the Google Sheets tab. First tab will be used by default. Sheet name is case sensitive | Text | No | REQ  |
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)
N/A
Outcomes
NAME | DESCRIPTION |
Success | This status is selected if the value was successfully edited in the specified Google Sheets file. |
Unsuccessful | This status is selected in the event of the following scenarios: |
Requirements
The provided links of the sheet must set editing permissions to "Anyone with link"
All drives and sheets need to be shared with:
googlewrkbots@wrk.com