Google Delete a Row from Spreadsheet
This action is used to delete a specific row from a Google Spreadsheet.
Inputs
| Name | Type | Description |
|---|---|---|
| Spreadsheet ID | String | The id of the spreadsheet. Get the file id (Step 5) |
| Credentials JSON | Object | Service account credentials. Get the credentials |
| Spreadsheet Tab Name | String | The tab name of the sheet. Get the tab name (Step 6) |
| Row to Delete | Number | The row number to delete from the spreadsheet |
Outputs
| Name | Type | Description |
|---|---|---|
| Success | Boolean | Whether the row was successfully deleted. True / False |
| Error | String | Error message if the operation failed. Null if successful |
Row Deletion
This action will delete the entire row specified by the "Row to Delete" input. Be cautious when using this action, as the deletion is permanent and will shift all rows below the deleted row upwards.
Example Usage
{
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"credentials": {
"type": "service_account",
"project_id": "your-project-id",
"private_key_id": "your-private-key-id",
"private_key": "-----BEGIN PRIVATE KEY-----\nYour Private Key\n-----END PRIVATE KEY-----\n",
"client_email": "your-service-account-email@your-project-id.iam.gserviceaccount.com",
"client_id": "your-client-id",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/your-service-account-email%40your-project-id.iam.gserviceaccount.com"
},
"spreadsheetTabName": "Sheet1",
"rowToDelete": 5
}
This example would delete the 5th row from "Sheet1" in the specified Google Spreadsheet.
Updated 4 months ago