Google Sheets API Integration Profile
Information and guides about integrating with Google Sheets API
Add Google Sheets Integration to Your ProductSheets Spreadsheets Values Clear in Google Sheets API
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.
Input schema fields
| Field Name | API Key | Type | Description |
|---|---|---|---|
| Path Parameters | pathParameters | object | |
| Spreadsheet Id | pathParameters.spreadsheetId | string | |
| Range | pathParameters.range | string | |
| Query | query | object | |
| Access Token | query.access_token | string |
Output schema fields
| Field Name | API Key | Type | Description |
|---|---|---|---|
| Spreadsheet Id | spreadsheetId | string | The spreadsheet the updates were applied to. |
| Cleared Range | 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.) |