Delete used items in a loop/filter

[Billel_Ridelle]

Hi there

I have an issue with a lead. enrichment workflow that scrapes data from Apollo before filtering the leads, and ultimately writing highly personalised icebreakers for each lead.

Currently the flow works well for the first few hundred items however it tends to break after that, due to google sheet apis timing out or other issues related to invalid urls.

Ive done a lot to prevent it from stopping however im currently not able to stop it breaking after 150+ passes. And every time I restart the flow it starts from the first item.

My question is: Is there a way to delete the items/leads it already processed ? I could have it paste all the leads into google sheet first and I would delete the used ones myself but I wonder if I could amend one of the existing nodes to do that automatically.

[darrell_tw]

Is the Google Sheet contains the data that every rows should be sent into Apify?
If there are some rows already get the data from Apify. You can add a status as processed

And make a filter in the Google Sheet node or saved to other sheet as backup and delete that rows.

Be careful when testing. You should use a duplicate sheet to test how this works.