Update Cell

Change the value in a cell.

Options

Field Definition Type Required

Use Spreadsheet ID?

Option to specify a Google Sheets spreadsheet by ID.

If you select No, select a spreadsheet from the Spreadsheet dropdown and ignore the Spreadsheet ID field.

If you select Yes, the list of spreadsheets from your account in the Spreadsheet dropdown will be depopulated; select -- Enter Spreadsheet ID -- from the Spreadsheet dropdown and enter an ID in the Spreadsheet ID field.

The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0, the spreadsheet ID is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps.

 Dropdown TRUE

Spreadsheet

List of spreadsheets in your Google Sheets account.

Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option.

 Dropdown TRUE

Spreadsheet ID

Unique identifier for your selected spreadsheet.

 Text FALSE

Worksheets

List of worksheets in the spreadsheet.

 Dropdown TRUE

Input

Field Definition Type Required

Cell Reference

Reference to a call in A1 notation (where A is the column and 1 is the row of the cell).

 Text TRUE

Updated Value

New value for the cell.

 Text FALSE

Output

Field Definition Type

Updated Range

Range associated with the values you updated.

 Text