Skip to main content
Go to the Studio
Values

Clear values

Clear values

Clears the values of a cell range.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Range​

A1 notation of the range to clear, e.g. Sheet1!A1:D10.

Returns​

Javascript code​

js
actions["action-id"].clearedRange // A1 notation of the range that was cleared (Text)

Field selection​

  • clearedRange — A1 notation of the range that was cleared (Text)

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Range fields are required.
  • The range must be in A1 notation (e.g. Sheet1!A1:D10).
  • Only the cell values are removed; formatting, validations, notes and formulas in other cells are not affected.
  • If the given range does not exist in the spreadsheet, the robot stops with an error.