Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to clear values from a Google Sheet range.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Clear sheet range function clears all values from a specified range in a Google Sheets spreadsheet. Formatting and data validation rules are preserved; only values are removed.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | Google Sheets spreadsheet ID |
| Range | Yes | Text | - | A1 notation range to clear (e.g. Sheet1!A1:D10) |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
- Invalid range – the A1 notation is malformed
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