Batch Clear
|
|||||
|
|
||||
Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept
Authorization
To use this building block you will have to grant access to at least one of the following scopes:
- See, edit, create, and delete all of your Google Drive files
- View and manage Google Drive files and folders that you have opened or created with this app
- View and manage your spreadsheets in Google Drive
Input
This building block consumes 2 input parameters
| Name | Format | Description |
|---|---|---|
spreadsheetId Required |
STRING |
The ID of the spreadsheet to update |
ranges[] |
STRING |
= Parameter name
= Format
|
spreadsheetId STRING Required The ID of the spreadsheet to update |
|
ranges[] STRING |
Output
This building block provides 2 output parameters
| Name | Format | Description |
|---|---|---|
spreadsheetId |
STRING |
The spreadsheet the updates were applied to |
clearedRanges[] |
STRING |
= Parameter name
= Format
|
spreadsheetId STRING The spreadsheet the updates were applied to |
|
clearedRanges[] STRING |