I am trying to "delete" a row. Since there is no action available for this, I tried using "" while in formula mode in all the fields for the row I'm trying to update. It is giving me this error. However, I am using the Row ID from my search step, which does show that rows were retrieved.
Updating all the fields in the row with "" will cause this error. If you would like to clear all the fields, you should use "clear" instead, in formula mode without the quotes.
As for not having a prebuilt action for this, unfortunately, it seems this is also not supported via Google Sheets' API.
I hope this helps!
Send us a ticket, we will try our best to assist you with your problem