I have a large sheet that is fed by our salesforce connector which serves to collect status on orders. We have automation in place on this sheet (and many others) so that when a date is reached the rows automatically move to a Completed sheet in order to keep the original sheet clean and focused. This was working, but a few months ago the automation still said it was running successfully but wasn't actually moving any rows. A few weeks after I noticed, I got an alert saying the automation had failed too many times and would be disabled.
Not a huge deal, I thought I'd just move them myself. But when I try to move the rows myself it spins for a bit & 9/10 eventually times out and I get the error message below. Every once in a while if you select only a single row & you get lucky, the row will actually move. Copying doesn't work because I lose the cell history which is very important to me.
How can I get this to work reliably?
To clarify on the connector aspect: I am only trying to move rows that are already filtered out of the connector. They are in their own section (parent/child) so it's not a case where they're being removed & then re-added via that workflow.
Screenshot of my actual workflow, which is currently "unable to run":
