Skip to main content
All CollectionsWrk Action LibraryGoogle Sheets
Edit cell value in Google Sheets
Edit cell value in Google Sheets
Wrk Product avatar
Written by Wrk Product
Updated over a week ago

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

Did this answer your question?