v1

latestOpenAPI 3.0.12026-07-1711094.7 KB

Batch clears values from multiple ranges in a Google Sheet.

This function clears all values from multiple specified ranges in a Google Sheet using a single batch request. It takes the sheet ID and an array of A1 notations for the ranges to be cleared, and returns a promise that resolves to an object containing information about the clear operation.

post/batchClearValues

Request body

Response

Successful operation

spreadsheetIdstring

The ID of the spreadsheet that was modified

clearedRangesstring[]

The ranges that were cleared