Hi Guys,
I recenly successfully able to get zapier to delete a row through Custom Actionfunction. I can see that few people had the question about this before and i could not respond to the closed thread.
Input Fields
Method
POST https://sheets.googleapis.com/v4/spreadsheets/SPREADSHEET_ID:batchUpdate
Body
in the Body you have a choice to insert below
To Delete A Row
{"requests": s{"deleteDimension": {"range":{ "sheetId": "{{SheetID}}", "dimension": "ROWS", "startIndex": "{{StartID}}", "endIndex": "{{EndID}}"}}},],}
To Delete A Column
{"requests": s{"deleteDimension": {"range":{ "sheetId": "{{SheetID}}", "dimension": "COLUMNS", "startIndex": "{{StartID}}", "endIndex": "{{EndID}}"}}},],}
Hope this help!