Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to remove protection from a range.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Unprotect range function removes a previously set protection from a range, allowing all users with edit access to modify the cells again.
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 |
| Protected range ID | Yes | Text | - | The ID of the protected range to remove (from Protect range output) |
Errors
- Protected range not found – no protection exists with the given ID
- Insufficient permissions – you do not have permission to modify protection
Tips
- Use the protectedRangeId returned by the Protect range function
Related functions
- Protect range – Add protection to a range