Delete row in google sheets via cancellation in youcanbookme

[timking]

I'm trying to delete a row in google sheets once a person cancels their appt in youcanbookme. I've successfully been able to use a task to update rows when people reschedule but when trying to coordinate it to delete, I'm not having success.

What values should I be putting in for the "start row number" and "end row number" to correspond to the specific row that needs to be deleted? I've used a row lookup in the prior step using their email since it will be the unique field different from all others.

 

[Supreme]

Hey @timking

To delete the rows from your Google Sheets, you can refer to the following thread for your concern.

Kindly try this at your end and let us know if that helps you out.

Copy Paste value if condition is true in Google Sheet

Hi, So I have 3 columns, ABC. I want the row values of A & B to be copied to another sheet and added to an already existing range of data, if the value in C is True. Not able to figure out how to do this effectively. Any help appreciated. Regards, Sourav

forum.pabbly.com