Missing Aggregator Tool / Alternative for Combining Values into Array

[pcservices]

Dear Pabbly Connect Support,

I am currently building a workflow to manage ChatGPT conversation memory using Google Sheets. I've set up most of the initial steps, but I'm encountering an issue with aggregating data.

Here's a brief overview of my current workflow steps, which are all confirmed as working:

1. Facebook Messenger Trigger: Successfully captures new messages.
2. Google Sheets (Lookup Spreadsheet Rows): This step is now working correctly and successfully retrieves conversation history data from my Google Sheet.
3. Iterator (Pabbly): This step is correctly processing the array of rows returned by the Google Sheets lookup.
4. Text Formatter (Pabbly): This step is correctly taking each individual row from the Iterator and formatting it into a JSON string like {"role": "user", "content": "Hello!"}.

My next required step is to collect all these individual JSON strings (generated by the Text Formatter across multiple iterations) into a single array. This aggregated array is crucial for providing the full conversation context to my subsequent "Code (Pabbly)" step and ultimately to ChatGPT.

The Problem: I am unable to find the Aggregator (Pabbly) tool when adding a new action step. I have searched for "pabbly" in the "Choose App" section and carefully scrolled through all available Pabbly-specific tools (as shown in my screenshots of PabblyApp1.png and PabblyApp2.png). It does not appear in the list.

I also explored Array Function (Pabbly) as an alternative, but its action events like Get Count, Array Reverse, and Get Value By Index (as shown in PabblyFunctionArray.png) do not seem to offer the functionality to combine multiple values into a single array.

My Question: Could you please advise on how I can combine the individual JSON string outputs from my Text Formatter into a single array in my workflow, given that I cannot find the Aggregator (Pabbly) tool?

• Is Aggregator (Pabbly) named something else now, or is it located in a different section?
• Is there an alternative built-in Pabbly tool and a specific Action Event within it that performs this aggregation?
• Could this be related to my Pabbly Connect account type or a temporary UI issue?

Thank you for your assistance.

 

[ArshilAhmad]

Hi @pcservices,

There is no dedicated tool to aggregate strings generated by Text Formatter steps across multiple iterations. As a workaround, you can try adding the data to a Google Sheets spreadsheet from each Text Formatter, and insert a Delay in your workflow to ensure all iterations are complete. Then, use the 'Get Row(s)' action to fetch the aggregated data from your spreadsheet and pass it to the Code (Pabbly) module.

Again, this is just a workaround—there is no built-in tool specifically designed for the use case you're trying to achieve.

 

[pcservices]

Thank you and I will try your suggestion.