v1

latestOpenAPI 3.0.12026-07-1711094.7 KB

Updates values in a specified range of a Google Sheet.

This function updates the values in a specified range of a Google Sheet with the provided data. It takes an input object containing the range and values to update, along with an optional parameter to specify how the input data should be interpreted. The function returns a promise that resolves to an object containing information about the update operation.

post/updateValues

Request body

Response

Successful operation

spreadsheetIdstring required

The ID of the spreadsheet

updatedRangestring

The range that was updated

updatedRowsnumber

The number of rows updated

updatedColumnsnumber

The number of columns updated

updatedCellsnumber

The number of cells updated

clearedRangestring

The range that was cleared