$integration.googleSheets.clearCellData

The method allows clearing specific cells or ranges of cells from a spreadsheet.

Syntax

The method accepts 4 required arguments.

Argument	Description	Type
integrationId	Integration identifier	String
spreadsheetId	Google spreadsheet identifier	String
sheetName	The name of the necessary sheet	String
values	The cells to be cleared	Array of objects

An example of calling the method:

ECMAScript 5

$integration.googleSheets.clearCellData(
    "5a9f649c-bdc4-4805-92c4-7bed80f7c285",
    "1OysnSRFIBTWgVWEX1wYndSLgSZ3umznXR96v0vTh8Hg",
    "Sheet2",
    ["B6", "E6"]
);

ECMAScript 6

In the ECMAScript 6 runtime, the method is asynchronous.

await $integration.googleSheets.clearCellData(
    "5a9f649c-bdc4-4805-92c4-7bed80f7c285",
    "1OysnSRFIBTWgVWEX1wYndSLgSZ3umznXR96v0vTh8Hg",
    "Sheet2",
    ["B6", "E6"]
);

Action

The method allows clearing specific cells or ranges of cells in the necessary spreadsheet.

tip

When clearing the cells, the lines and the columns are not deleted or moved.

You can clear several cells or their ranges at a time.

Example

In the example below, we clear several cells in a spreadsheet.