Table A & B & C are collected daily at 1:00 AM, Table D & E & F are consumers that are planned to start at 2:00 AM and MUST wait A & B & C were prepared as expected.
The question is how to configure a workflow B that B has to wait the latest A’s execution’s status being completed successfully.
Don’t know if this will work for you but you can start workflows from a workflow with the “execute workflow” node. This way you do not have to schedule the second set, but can simply start them at the end of the first set.
Another popular solution would be maintaining the status of the operations in some datastore (Airtable/Nocodb etc.) and then monitoring that status to execute the subsequent workflows.
It would be perfect if a workflow node could represent another workflow’s latest execution and be used in flow control. I’m new here, if this could be extended with n8n API, please give me some hint, I would like to have a try.