Deleting Multiple Rows In Google Sheets - N8N

Hey Everyone!

I am working on a workflow and need to delete exact rows in google sheets that have been confirmed and sent out from that google sheet. I am sending out batches of information so I need to delete 5 rows at a time in google sheets through one node or pass.

When mapping the “rows” to be deleted and the “number of rows” after to be deleted, it seems the deleting of rows messes up as it will delete a row then re shuffle the google sheet so everything is organized at the top, then delete the other rows that were in the old place holder from previously in the sequence. Which in turned deletes the wrong data in the google sheet as the old row (5) that needs to be deleted is now at the (4th) row spot, so the workflow deletes the new 5th place row which is not the correct data to delete.

Does anyone have any insights to this issue and may have some solutions to be able to delete multiple rows in google sheets at one time mapped to specific data in your flow.

I appreciate it!!

Keep building!

5 comments