Sorry for distubing you but I cant find the answare to a question relatetd to sequential workflow execution in n8n cloud. I tried browsing, asking AI, posting on the Forum but no results.
As you can see from the original post from the link, there is no error. The problem is because both executions start at the same time, when i get rows from sheets, they get the same row modify it in different ways, and when they append them, one overwrites the other. Basically one should be finished, before the other one gets to the node that retrieves the row. Thats why i was thinking that maybe a queue would solve the problem, or maybe a MUTEX ( A mutex, short for mutual exclusion, is a synchronization primitive used in concurrent programming to control access to shared resources. It prevents multiple threads or processes from accessing the same data or code simultaneously, which could lead to data corruption or unexpected behavior. Essentially, a mutex acts like a lock that allows only one thread at a time to “own” the resource, ensuring exclusive access). But this can usually be done at a hard level.
I have solved my problem by using rabbitMQ, at the moment this seems to be the only way to ensure a sequential execution of a workflow / creating concurrency for executions in a workflow. It can even be done in cloud, just host your rabbiyMQ using some free provider (in my case CloudAMQP) and it’s all done, only thing is that you will need to saparate your original workflow in two: a workflow that takes from your webhook or other trigger data and pushes it in the queue, and the rest of the original workflow now starts with the rabbitMQ trigger, that activates for each entry in the queue.