We have added two new actions to Google Sheets. Search by query and update an existing row.
Click here for more information.
It would be great to have a "delete row" action as well. It would really be useful. At this time I just mark the rows for deletion and then manually delete them when I open the spreadsheet from time to time. Automatically would be ideal.
Send us a ticket, we will try our best to assist you with your problem