Passing Variables Between Workflows

Help me Build my Workflow
1

So here is the scenario:
I have a Primary work flow which takes Key words for SEO from users as an input.
I have another workflow which do all the search using Dataforseo API.
Users can put multiple words, so our primary work flow first splits them into individual words and then call the secondary workflow in a loop till array finishes.
In secondary workflow I am creating a new folder and then copying the master google sheet into that particular folder.
Afterwards I am filling out different parts of google sheet.
At the end of my process, I got a XLS document filled with multiple keywords into different parts of sheet e.g. SERP, People Also Ask etc.
I want to add the functionality of sending email to client in the end as well.
The Problem:
For sending the email first the XLS file needs to be completely filled out.
As in my workflow there are multiple sheets being filled out simultaneously instead of having sequential path, so I have no way of finding out whether my sheet is filled out or not.
Question:
Is there are way to find out whether the current process or execution is finished or not?
Same as in Programming loop when we know that Loop is finished upon True or False condition.

2

Without seeing your workflow layout I can only share my two cents.

If your email sending node is in first workflow, you might want to put a Merge node before it and set Mode to “Choose a Branche”. In this case you can further choose Output Type to “Wait for All Input Arrive” if you have multiple path dealing with different file operations.

And if you need something like a global variable for process synchronization, you might want to try the DataTable feature which is still in beta but provides a global storage visible to all workflows.

3

Hi Victor,

Thanks for the message, the problem is not passing the variable (that I can easily pass-on when I will be calling the “Sub-Flow”).

What I am stuck is as follows:

  • When the sub-flow finishes, it updates the XLS sheet which is suppose to be sent via email.
  • Because I have no way of finding out at what time / stage sub-flow finishes the execution and gives back control to the Primary workflow.
  • one solution is to find out the Order in which nodes are called and then add the email functionality at that last node. So is there a way of finding out the order in which nodes are called?.

Your help will be greatly appreciated.

Best regards,

Syed