Extract the last collection(s) added to an array

[Stan]

Hello,
I have an array which is constantly updated with new collections. Each of these collections include the first name, last name and email of my clients.
I would like to be able to extract the last collections added to the array (i.e any new account created on my add) in order to be able to update a google sheet with their details and send them a welcome email. The scenario would be activated every 2 or 3 mins.
Do you know how I could complete this workflow?
Thank you in advance for your help
Stan

[dilipborad]

Hello @Stan,
When there is any module that returns multiple bundles that you need to access specific(last) bundles from always use Array Aggregator after you get a list(search) of bundles.

After that, the aggregator module returns the array. Now you can use an iterator or use make’s function with setup multiple variables.
The setup variable for the last element uses this formula.
{{get(yourArray; length(yourArray))}}

Then in the next module use the get and map functions to point out specific values on specific fields.

---

A couple of hours ago I gave one answer to the one of posts. which has output is different but the inner concept is the same.

Process just the first Bundle

Hello @mdb213, By default when you use Make’s default Iterator module it needs an Array as input and then it’s iterate through it. Check this carefully and understand it. How Iteration work with different modules In Make when you have any of the modules that return multiple bundles and then after that on the very next module, you use direct operations like add/update/delete, They consider it as an iterator and integrate through several bundle returns from that module. For example, when you us…

The answer post is about how to use Iterator or Aggregator with using Make’s default function.

---

P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution and
Need expert help or have questions? Contact or comment below!

[abhilash_naik]

Alternatively, to what @dilipborad described you can also do a reverse function to turn the first item into last and vice versa and then use a first function or a get function with key as 1

{{first(reverse(array))}}

{{get(reverse(array); 1)}}

but if there are multiple collections you can use an excel or data store to add a column that stores the last added collection id, time or some unique data to reference then when you fetch the array next time you can compare with it and filter to retrieve the new collections

[Stan]

Hello @dilipborad, thank you for the answer, this is very clear!

[Stan]

@abhilash_naik

but if there are multiple collections you can use an excel or data store to add a column that stores the last added collection id, time or some unique data to reference then when you fetch the array next time you can compare with it and filter to retrieve the new collections

@abhilash_naik, thanks for the answer, this is exactly what I have been trying to achieve. I manage to store all the data from the array into a googlesheet using the Iterator, but I struggle to find how I could make sure that the data are not added into the google sheet if they already added.
Would you use the “search row” module of googlesheet and then use the “add a row” module of googlesheet?

[dilipborad]

Hello @Stan,
If your problem is solved then please complete this topic with the
It helps others to find things easily.

[Msquare_Automation]

Hi @Stan

You can also use the last() function to retrieve the final element of an array.

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation