v1

latestOpenAPI 3.0.12026-07-1711094.7 KB

Clears values from a specified range in a Google Sheet.

This function clears all values from a specified range in a Google Sheet. It takes a single input object containing the sheet ID and the range in A1 notation. The function returns a promise that resolves to an object with information about the clear operation.

post/clearValues

Request body

Response

Successful operation

spreadsheetIdstring

The ID of the spreadsheet

clearedRangestring

The range that was cleared

clearedRowsinteger

The number of rows that were cleared

clearedColumnsinteger

The number of columns that were cleared