Clear
|
|||||
|
|
||||
Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. 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 |
range Required |
STRING |
The A1 notation of the values to clear |
= Parameter name
= Format
|
spreadsheetId STRING Required The ID of the spreadsheet to update |
|
range STRING Required The A1 notation of the values to clear |
Output
This building block provides 2 output parameters
| Name | Format | Description |
|---|---|---|
spreadsheetId |
STRING |
The spreadsheet the updates were applied to |
clearedRange |
STRING |
The range (in A1 notation) that was cleared. (If the request was for an unbounded range or a ranger larger than the bounds of the sheet, this will be the actual range that was cleared, bounded to the sheet's limits.) |
= Parameter name
= Format
|
spreadsheetId STRING The spreadsheet the updates were applied to |
|
clearedRange STRING The range (in A1 notation) that was cleared. (If the request was for an unbounded range or a ranger larger than the bounds of the sheet, this will be the actual range that was cleared, bounded to the sheet's limits.) |