Edit cell value in Google Sheets
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 Note: Spreadsheet should provide view access to anyone accessing the spreadsheet via the URL (i.e. Anyone with the link) | Link | Yes | https://docs.google.com/spreadsheets/d/1-/edit |
| 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: - Column letter or header specified cannot be found in file - Row number is unavailable on the file |
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