Skip to main content

Update Spreadsheet

danger

This action has been deprecated and will no longer be available in new automations.

Sets values in a range of a spreadsheet in the form of sheetname!startCell:endCell. For example, Sheet1!A1-E1 will update the first five cells in the first row of the sheet called "Sheet1".

Basic Parameters

ParameterDescription
Major DimensionThe major dimension of the values. For output, if the spreadsheet
data is: A1=1,B1=2,A2=3,B2=4, then requesting range=A1:B2,majorDimension=ROWS
will return [[1,2],[3,4]], whereas requesting range=A1:B2,majorDimension=COLUMNS
will return [[1,3],[2,4]]. For input, with range=A1:B2,majorDimension=ROWS
then [[1,2],[3,4]] will set A1=1,B1=2,A2=3,B2=4. With range=A1:B2,majorDimension=COLUMNS
then [[1,2],[3,4]] will set A1=1,B1=3,A2=2,B2=4. When writing, if this field
is not set, it defaults to ROWS.
RangeThe range the values cover, in A1 notation: sheetname!startCell:endCell.
For example, Sheet1!A1-E1 will update the first five cells in the first row of the sheet called "Sheet1"
Spreadsheet IDThe ID of the spreadsheet to update.
Value Input OptionHow the input data should be interpreted.
ValuesA JSON list of the data to be written. Supported value types are: bool, string, and double. Null values will be skipped. To set a cell to an empty value, set the string value to an empty string. e.g ["value1", "2.1", "false"].

Advanced Parameters

ParameterDescription
Delegated User OverridePerform the action on behalf of another user, overriding the delegated user defined in the connection.

If not specified, the delegated user is the one provided in the connection.

Has no effect when using an OAuth connection.

NOTE: the connection details are not edited by this input.

Example Output

{
"spreadsheetId": "1uW957i4riQvq4E4zRwpwCMuwas_BRIuEPvlPQ0qsB70",
"updatedRange": "Sheet1!A2:D2",
"updatedRows": 1,
"updatedColumns": 4,
"updatedCells": 4
}

Automation Library Example

Update Spreadsheet with Google Sheets and Send Results Via Email

Automation LibraryPreview this Automation on desktop