Help Centre › Functions & Formulas
Clear cell contents in a range.
Add it to a process
In the process designer, open the Add step tab. Find Clear cell contents in a range under Google Workspace › Sheets, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Range | Yes | Cell range to clear in A1 notation (e.g. 'Sheet1!A1:D10') |
| Connection | No | Pick an "environment-aware" alias to resolve the connection per the run's environment (with a shared fallback), or a specific connection to always use that one. Configure connections and aliases in Settings > Connectors. |
| Spreadsheet ID | No | Supports variables and formulas, e.g. {rate} or =ROUND({rate}, 6). |
| Range | No | Supports variables and formulas, e.g. {rate} or =ROUND({rate}, 6). |
| Variable | No | Name of the variable where the result will be stored |
| Repeat for each (list) | No | Optional, Cloud processes only. A list expression like {{steps.previousStep.output.items}}. The step runs once per item, with {{item}} available in the fields above. |
| Idempotency key | No | Optional, Cloud processes only. An expression that uniquely identifies each item, e.g. {{item.id}}. The step skips any item it already processed in a prior run, so it is safe for recurring syncs. |
| Watermark field | No | Optional, Cloud processes only. A field in each record to track as the sync cursor, e.g. modifiedDate. Reference the stored value in this step's inputs as {{vars.watermark}} to pull only newer records each run. |
| Watermark list path | No | Optional, Cloud processes only. Dotted path to the array of records in the response, e.g. data. Leave blank if the response is itself the list. |
| Secure inputs | No | Cloud processes. Redact this step's request inputs in the run trace. The call still runs; HTTP status and errors stay visible. |
| Secure outputs | No | Cloud processes. Redact this step's response body and headers in the run trace. HTTP status and errors stay visible. |
See all Google Workspace steps.
Tips
- Use Sheet1!A:Z to clear an entire sheet’s values
- Formatting is preserved – only cell values are removed
- To remove formatting as well, use the Batch update spreadsheet function
Related functions
- Write sheet range – Write values to a range
- Delete rows – Delete entire rows