You improved “google sheets” more.
Can I ask you one more option please? (I want to know that I know you are very busy:pray:) Clear Or Delete Option.
This option can delete or Clear one specific row in google sheets
Unfortunately after some test I realize that “Clear” operation is like poison for database in google sheets. It create empty row in a table that cause error when you want to load data from google sheet.
I extremely suggest add “delete” feature to google sheet node for delete a row or range of data in google sheets please?
@mooghermez I will have a look and get back to you. But it looks like it will only be possible to define to delete Columns/Rows and then a Start- and End-Index. Did not find anything to delete by “range”.
That would sadly not be very simple. The link you did post does not seem to be helpful for this case. Google would have to supply the functionality via its API here what it sadly does not do.
It would theoretically possible to build something like that ourselves by analyzing the query, requesting the data via their API, transform and merge it accordingly and then return. But that is sadly just theoretically. Practically would it be so much work that it would not be possible unless you are willing to spend a lot of money to pay a developer to write it for you.