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.