As of today, what is the best way to pass data between Workflows?
For example, we have an API in which we query each hour which will return a list of users. With each of these users, we want to query a Google Sheet, update their row etc. At present, the only way I can think of doing this is with two workflows:
Workflow A: Call API every hour, then POST each User to a Webhook
Workflow B: Recieve webhook from Workflow A, examine Google Sheet etc
Is there a better way to achieve this? Is it possible to use a Data Store and trigger Workflow B when a row there is updated/changed?
I think your method is one possible way to do it. Another way is to have one workflow only, which will have the trigger to call API every hour, then having a Add Single Row or Add Multiple Rows action to add the rows to your Google Sheet.
On another note, Data Store is a good way to store data between workflow, though currently we have no efficient way to detect changes on Data Store. What you might want to do is to have the Workflow B trigger by interval, process the data in Data Store, then clear the Data Store when it’s done.