Manipulating Extracted Array More Effectively

Hello everyone,
I’m trying to find a more effective way to achieve my scenario which in my opinion is consuming too many operations.


The scenario
I’m fetching some items from Google Sheet (resulting in multiple bundles) and I’m trying to create a phoneNumbers variable at the end (Tools [21] module). The phoneNumbers variable is just a simple array of phone numbers


The problem
The phone numbers returned in the Google Sheet module do not have a “+” prefix. I’m trying to add the “+” in the resulting phoneNumbers variable (Tools [21] module).



While my scenario is handling this change successfully, the Tools [20] module increase significantly the number of operations, because it has to create a new variable for each bundle resulting from the Google Sheet search.
I want to know how the same result could be achieve with less operations


In my Array aggregator module, I’m simply aggregating the phoneNumber field created in the step before (Tools [20] module)


Is there a way to handle this data manipulation (appending the “+” to phone numbers) outside of the Tools [20] module so I can save on operations?

Hey there,

what do you need the + for exactly? Maybe you can add it later in the flow? Or add it directly in the google sheet instead?

I created another scenario to handle sending bulk SMS (triggered by Webhook) so I can use it from different sources (here the Google Sheet).
Depending on the sources, the phone numbers may or may not have a “+” in front of them that’s why I need to format it to the expected format from the Webhook.

In this particular case, I’m only exporting items from Google Sheet and would like extract data exactly as they appear on the Sheet (so I don’t need to manipulate its data directly from the sheet).

Hopefully that helps

So you can either change the format of the column in the google sheet to always have a + at the start, regardless of what you input there; or you can add a formula to the other scenario and add the + to the phone number if its missing. Either way, you can delete the tools module from the original scenario to save on operations as this can be done elsewhere.

I was under the impression this could be done in the Array Aggregator, no?