Better way to lookup and delete multiple raws from sheet?
Just to make sure, I understand it correctly, you want to lookup for specific values and then delete them from the spreadsheet, right?
Also, are you using the Google Sheets node or the Spreadsheet File node?
It’s a google sheet. The number of lines to delete is large - I’m afraid to run into limits if I delete one line at a time. What is the best way to delete if the lines are not one after the other, but scattered throughout the document?
I am afraid it is not possible to use the Google Sheets node directly do this. Pinging @RicardoE105 here. He might have a solution.
You can try setup Cron run delete by seconds?
Yes, thank you, that’s the solution I’m using at the moment.
@maxbaluev I guess you can first do the look-up to retrieve all the rows you want to delete and then use the split batches node with a small wait not to hit the rate limit when deleting all that items. It should look similar to the image below:
Could you share the code of this workflow?