Tri descendant ascendant

Beginner Questions
,
1

:bullseye: What is your goal?

Sort my list of appointments in ascending order based on the time in Gmail

:thinking: What is the problem?

My scenario sends me an email with my appointments for the day, but they are listed in a random order.

My scenario: Calendar - text aggregator - Gmail

:test_tube: What have you tried so far?

I tried the SORT function - array aggregator, but without any success.

3

Hey Eddie,

can you send a screenshot of what the data looks like? The sort function should be the right way, maybe it needs some tweaking to sort it properly.

4

I created a sample scenario that sorts events from Google Calendar then send to a supposed Gmail or any email provider

Sort Meetings from Gcalendar to Gmail

I hope this helps.

Here is what I did:

I used the array aggregator to bundle the events:

image
image1832×743 90.5 KB

I used the sort() function which has the formula of sort(array ; asc/desc ; [key])

The key on this case is the Start time of the event that has the key value of start

image
image957×462 36.5 KB

5

Why are you using an AI agent to sort an array? This is a complete waste of tokens and computational power.

6

You’re right. Let me update my reply

7

Hello,

My scenario: calendar/ text aggregator/ Gmail;

When they arrive in Gmail, I would like my events to be listed and sorted by time. ??

Thank you for your help!

8

Since you’re using a Text Aggregator, one option is to sort the appointments before sending them to Gmail. If the appointment times are in a consistent format, you can use an Array Aggregator and sort the array by the time field, then pass the sorted results into the Text Aggregator.

If the time is only inside plain text, you may need to extract the time first so Make can sort it correctly.