Add protected range
The Google Sheets Add Protected Range tool enables users to add edit protection to specific cell ranges within a spreadsheet, ensuring data integrity and controlled access.
Features
- Add protection to a specific cell range in a Google Sheet.
- Customize permissions by specifying users or groups who can edit the protected range.
- Support for selecting spreadsheets and worksheets by ID or name.
- Option to add descriptions to protected ranges for clear identification.
- Compliance with Google Sheets API formats and standards for seamless integration.
Benefits
- Prevent unauthorized edits and maintain data accuracy in shared spreadsheets.
- Enhance collaboration by controlling edit permissions on sensitive data areas.
- Easily manage and update protected ranges with unique identifiers.
- Improve audit and accountability with editable descriptions of protected ranges.
- Streamline workflows with API-based protection management integrated into Pipedream.
Description
Add edit protection to cell range with permissions. See the documentation
IMPORTANT: The arguments have specific formats. Please follow the instructions below:
- protectors: Return JSON in this format: string[]
Parameters
8 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-protected-range, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-protected-range, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-protected-range, propName: worksheetId. |
| protectedRangeId | integer | The ID of the protected range (required for update and delete operations). This is a unique identifier assigned by Google Sheets |
| rangerequired | string | The range of cells to protect (e.g., |
| description | string | A description of the protected range |
| requestingUserCanEdit | boolean | If true, the user making this request can edit the protected range |
| protectors | string[] | Email addresses of users/groups who can edit the protected range (e.g., user@example.com) |