Many formulas feature automatic workflow chaining, e.g. Getting all the Tweets for Someone's Followers, which first runs a workflow to get all followers of a target account and passes the output (list of usernames) to get their tweets in the second workflow run.
However, you may want to do this manually for more control (e.g. you want to manually curate the list that gets passed from step 1 to step 2) or to combine completely unrelated workflows that haven't yet been automatically chained together.
1 - Execute the First Workflow
Here we'll get all the Twitter followers for @stevesiedata in step 1 - just enter the inputs and run the workflow normally (you can skip this step if you just want to use an existing execution):
2 - Open the Output
Download the CSV file from the workflow execution and open it up in your editor of choice (e.g. Excel):
I now want to pass the
users.screen_name column into part 2 (so I can get all of these users' most recent Tweets). I can select all of the usernames like in this example or manually curate a selection (e.g. only look up users with more than 100 followers where I can see this count in column K).
3 - Paste Into the Second Workflow
Once we figure out the inputs we want to use for our second workflow, we simply paste them into the User Tweet's input collection that asks for Twitter usernames:
Save your changes and then execute the second workflow and that's it! You'll now get the Tweets for the users you selected that you retrieved from the output of the first workflow.
4 - Make it Automatic
If you're happy with how this is working, you can make the chaining happen automatically!
Unlink the source Input Collection
Just go to the 2nd workflow where you pasted your inputs into and unlink the input collection as the source by clicking on the ➡️ icon:
Then select "Unlink" in red:
Re-Link as a Workflow Chain
Now you need to find the target input, which will be under Optional Inputs and select "Link Source Input..."
On the next screen, select "Workflow Chaining" as the source type:
Select the workflow and extractor you want to use as the source (this will correspond to the workflow you used for step 1):
Lastly, we need to tell the system which column from the output we want to use (where we selected column F, or the "users.screen_name" column in the intermediate step):
Now just create the link and you'll see the chained input under "Advanced Inputs" showing you the workflow that will trigger it, and how it will look up the values to inject:
Run a Test
If you scroll down on the workflow screen, you'll now notice that you can't directly execute the workflow since it depends on the output of the first workflow:
So to give this a run, just follow the link to the first step of the chain and execute - it will then trigger your 2nd workflow to run as desired.