Google Sheets
Clear Google Sheet Row
Clear the contents of a row in a Google Sheet without removing the row.
Freeno per-call chargeRuns in your Google Sheets account
Endpoint
Parameters
| Name | Type | Required | Note |
|---|---|---|---|
| identifieraccount · required | account | required | Google account to use. Select from your connected integrations. |
| spreadsheetIdstring · required | string | required | The spreadsheet containing the row to clear. |
| sheetNamestring · required | string | required | The tab (sheet) containing the row to clear. Example: |
| rownumber · required | number | required | The row number to clear (1-based, where row 1 is the header). Must be a whole number of 2 or greater. Example: |
Response schema
{
"type": "object",
"properties": {
"clearedRow": {
"type": "number",
"description": "The 1-based row number that was cleared"
},
"clearedRange": {
"type": "string",
"description": "The range that was cleared"
},
"spreadsheetId": {
"type": "string",
"description": "The spreadsheet ID"
}
}
}