Skip to main content

Clear Spreadsheet Range

danger

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

Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.

Basic Parameters

ParameterDescription
RangeSets the ranges of values from the spreadsheet which will be cleared, in the form of sheetname!startCell:endCell to be returned.
For example, Sheet1!A1-E1 will clear the first five cells in the first row of the sheet called "Sheet1".
Spreadsheet IDThe ID of the spreadsheet to update.

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",
"clearedRange": "Sheet1!A1:B1"
}

Workflow Library Example

Clear Spreadsheet Range with Google Sheets and Send Results Via Email

Workflow LibraryPreview this Workflow on desktop