Rows deletion

[TDenisM]

Do you plan to implement more actions with Sheets e.g. rows deletion?

[sammachin]

You're the first person to ask for that! but I guess it makes sense to add in a delete row/column method. I'll need to look at how best to configure that, the underlying API seems to take an Index value so starting at 0 but I think it would be neater if we used the same references as the sheet eg A-Z 1-100?

[TDenisM]

It makes sense for me definitely! Also I want to have insert combo box option currently. 8-) Also it may be useful to be able to insert rows/columns (after or before some position) with some values. Also (I'm sorry for repetition) I didn't get how to make bulk insertion if it's possible. The current (existing) index logic is based on zero start indexing so I don't think that you should change that for deletion and other options. Also it will be nice to have to be able to set node method (GET/UPPEND/CLEAR and so on) dynamically with msg properties. (I know - too many alsows - sorry for that)

[omygolly]

Would love to see this as well! Trying to do a simple daily to-do list which fetches data from sheets and when responding that they are done they get removed. So would help me a lot if the whole row got delited not just the data in the cell (which I will have to address with some really really crappy js-skills in a function node for the time being..) :)

[skywurz]

I too just ran into a need for this as my sheet is beyond 1000 rows so i was trying to just move the oldest (top row) to a second sheet. Well moving it works but then my data appends to the top cleared not deleted top row.