Pulling data from one workflow to another without webhooks

[exponexa]

I have two distinct Pabbly Connect workflows.

• Workflow A is triggered by a new Google Doc creation:

  Pabbly

  connect.pabbly.com
• Workflow B is triggered by a webhook that contains specific data I need: https://connect.pabbly.com/workflow...NAWFfSwoOVQMDcFJICApSUQJ4Uh8FfgxZADMPUVB4VDU#

My goal is to use the data from Workflow B's webhook within Workflow A. The challenge is that Workflow A's primary trigger is the Google Doc creation, not a webhook, so I can't directly use Workflow B's webhook data as its starting point.

Is there a method to send the data from Workflow B's initial webhook over to Workflow A after Workflow A has been triggered by a new Google Doc, allowing me to utilize that webhook data later in Workflow A's sequence?

 

[Preeti Paryani]

Hello @exponexa,

To transfer data from one workflow to another in Pabbly Connect, we typically recommend using the Data Forwarder feature. However, since the trigger of your Workflow A is the creation of a new Google Doc (and not a webhook), forwarding data directly from Workflow B won't be feasible in this case.

What we can suggest instead is this:

Since the data you require is already being captured in Workflow B, you can store that data in a Google Sheet as part of Workflow B’s steps. Then, in Workflow A, after the new Google Doc is created, you can use a Google Sheets Lookup Row action to fetch the specific data you need based on a unique identifier (e.g., document name, timestamp, or another shared key).

This should help you bridge the gap between the two workflows and achieve your use case effectively.

Let us know if this solution works for you

 

[exponexa]

Hello @exponexa,

To transfer data from one workflow to another in Pabbly Connect, we typically recommend using the Data Forwarder feature. However, since the trigger of your Workflow A is the creation of a new Google Doc (and not a webhook), forwarding data directly from Workflow B won't be feasible in this case.

What we can suggest instead is this:

Since the data you require is already being captured in Workflow B, you can store that data in a Google Sheet as part of Workflow B’s steps. Then, in Workflow A, after the new Google Doc is created, you can use a Google Sheets Lookup Row action to fetch the specific data you need based on a unique identifier (e.g., document name, timestamp, or another shared key).

This should help you bridge the gap between the two workflows and achieve your use case effectively.

Let us know if this solution works for you

Ya, that is what I was thinking. Can you explain or is there a "how to" that shows how I can fetch the specific data from the google sheet in Workflow A? I am thinking it will either be a time stamp or the last row that was loaded.

 

[Preeti Paryani]

Hello @exponexa,

To fetch specific data from the Google Sheet in Workflow A, you can use the Google Sheets “Lookup Spreadsheet Rows” action. This allows you to search for a particular record or row based on a unique identifier.

You can use any common entity or key between Workflow A and the response you want to fetch from Workflow B, this could be a timestamp, order ID, email, or any other field that both workflows share based on your setup logic. Just make sure the value you're using as the search key exists in the Google Sheet data.

Once the matching row is found, you can extract and use the corresponding data in Workflow A as needed.