I’m really scratching my head with a data consolidation issue in my scenario, and I’d really appreciate some help figuring out what’s going on.
Here’s what I’m trying to do:
-
My “Airtable - Search Records” module finds multiple records (say, 3 of them).
-
Each of those records comes through as its own separate operation/bundle.
-
Inside each of those bundles, I have a few specific arrays (like
LeadandSummaryarrays) that contain the data I need. -
Ultimately, I need to pull out those specific arrays from all the records/operations and combine them into one single block of text or one large array, which then gets sent as a single input to a “Google Gemini AI” module.
My Problem: I’ve tried using both the “Text aggregator” and the “Array aggregator.”
-
When I use the “Text aggregator” directly after Airtable, it processes each operation separately, leading to multiple outputs for Gemini.
-
I also tried the Array aggregator. While it aggregates the arrays within each bundle, it still passes through the multiple original operations. So, I still end up with separate outputs for Gemini.
-
I’ve even tried using both of them together, just to see if that would work, but still no.
What’s the right Make pattern or module configuration to consolidate data from multiple incoming operations (where each operation’s bundle contains arrays) into one single output bundle that can then be used as a combined input for a subsequent module like Gemini?
Any advice on how to correctly achieve one final consolidated output would be greatly appreciated. Here’s a screenshot of my flow. Thanks in advance!
