Hi there,
Thanks for your amazing community. I defined a range of values in my Google Sheets module setting, but only the very first row of data has been sent to my next module, which is a webhook response. Despite trying to use AI assistance and some workarounds, I still have the same issue.
Hi Saeid,
the Get Range Values module is producing one bundle per row in the google sheet. So each value will be sent to the webhook separately. If you need to send all of them together, you will need an aggregator module after the google sheets module to combine all of the outputs in a single bundle.
Hi, thanks a lot for your help, I had a look at the aggregator tutorial and I see in your docs, you have always used Iterator before it to separate the data in a bundle, then I followed the tutorial but unfortunately, there is something in the middle I couldn’t figure out, here is what I have done so far:
I want to retrieve the Name and Phone number of all the users from a sheet file
(upload://vY5qu697QJ2Wp6yOHMLqX2NqrGR.jpeg)
As you see at the end, I haven’t received the name or at least the list of phone numbers of the users. The method I followed is wrong?
I also tried using only an aggregator, but the issue is I can’t find an option to aggregate the data inside the bundles.
On the first try, I see in the OUTPUT of Operation 1 of aggregator phone numbers under Array,
And in the Body section of Webhook response, I see again only one number
Thanks a lot, and sorry for this long inquiry,
This is a very useful feature for us and we can offer it to all our customers, that’s the reason I am very into solving the issue.
Best,
