Trigger response data

[aiweller]

Hi. I'm new to this forum.. I would like to ask how can I extract the trigger response data into a text or json file? For example, I'm using Pabbly Chatflow as the trigger and I want to create a file containing all the labels and values from the trigger response.

Thank you,
Ashley

 

[Hrishabh.pabbly]

Hello @aiweller ,

Thanks for reaching out!

Yes, you can easily store the label and value data from the trigger response by adding a Google Sheets action step right after the trigger.

Here's how you can do it:​

1. After your Chatflow trigger, add the action step:
   ➡ Google Sheets → Add New Row
2. In the mapping fields, map the labels and their corresponding values from the trigger response.
3. This will store each new response as a row in your connected sheet.

Let us know if you’d like help with setting this up or sharing a sample sheet structure.

 

[aiweller]

Hi @Hrishabh.pabbly ,

Thank you for the reply. Yes Im aware we can map the data. But from what I seen, the labels and values are dynamic. Not all the time we get the same fields. For example the Chatflow trigger where if Pabbly Connect receives a voice message or document, there are different labels compared to a normal text message. If I hardcode the mapping I may miss out some fields.

And Im also trying to figure out how do I extract the attachments in the message received. Is it possible?

Thanks
Ashley

 

[ArshilAhmad]

Could you please share the Workflow URL where you have this concern?

 

[aiweller]

Hi @ArshilAhmad,

Thanks for the reply. Here's the URL

Pabbly

connect.pabbly.com

You have take a look at Response C which is an audio message and Response D which is a text message.

Thanks,
Ashley

 

[Preeti Paryani]

Hello @aiweller,

Thanks for sharing the workflow.

We understand that the response structure from Chatflow can vary depending on the type of message (e.g., text, audio, document). To help you better, could you please clarify how you'd like to handle these different types of responses? For example, what should happen when a text message is received versus an audio or document message?

If possible, please share a short screen recording explaining your intended use case. This will help us understand your requirement more clearly and guide you accordingly.

 

[aiweller]

Hi @Preeti Paryani ,

I just wanted to know if its possible to get the labels and values in a text or json format. Sort of like in raw data that I could save into a text file. If not, is there a for each function that could loop through all the output labels and values dynamically.

Thanks.

 

[ArshilAhmad]

You need to disable 'Simple Response', then click on 'Re-Capture Webhook Response' and capture a new response in the trigger step. This will allow you to capture the response in the form of a JSON.

 

[aiweller]

Thank you. What would be the action after that to save the response to a file?

 

[Preeti Paryani]

Hello @aiweller,

You can use Google Docs: Create Document from Text to save it as a readable text format or let us know your preferred way to store the details so we can accordingly suggest.

 

[aiweller]

Hi @Preeti Paryani,

All I can select are the values individually. There's no option to download the complete data even when simple response is disabled.

 

[Preeti Paryani]

Hello @aiweller,

Apologies, but we’re unable to clearly understand your exact requirement at this stage. To assist you more effectively and avoid any back-and-forth, could you please share a short screen recording explaining your use case in detail? This will help us provide accurate guidance and resolve your query more efficiently.