Hello Gs.
Wasted a lot of time trying to build a scenario, where I extract the data (multiple rows in the Google Sheets) into a Voiceflow.
The difficulty is that I’m only able to extract first row due to separation of data by different “Operations”/“Bundles”.
Here is my json:
{
“Date”: “Date (A)”,
“Time”: “Time (B)”
}
How do I aggregate this data and send it as one row?
Welcome to the Make community!
Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
There are other types of aggregator modules, click the below links to find out more:
All you need to do is to use a Text Aggregator module before your Voiceflow module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Glad I could help! Don’t forget to do the Make Academy!
