Gcal event -> array -> email, but sorted by the event date

[Teresa_Skorupa]

What is your goal?

send a single email with my team’s time off extracted from a gcal events sorted by the events’ start date

What is the problem & what have you tried?

i cannot get to the sorted output, i’ve tried set variable, sort(), timestamp

Error messages or input/output bundles

[
{
“text”: “ name1: 25.11.2025 – 04.12.2025\n​:palm_tree: name2: 05.12.2025 – 05.12.2025\n​:palm_tree: name3: 28.11.2025 – 02.12.2025\n​:palm_tree: name4: 27.11.2025 – 27.11.2025\n​:palm_tree: name5: 19.11.2025 – 27.11.2025\n​:palm_tree: name6: 20.11.2025 – 24.11.2025\n​:palm_tree: name7: 21.11.2025 – 24.11.2025\n​:palm_tree: name8: 28.11.2025 – 01.12.2025\n​:palm_tree: name9: 01.12.2025 – 05.12.2025\n​:palm_tree: name10: 02.12.2025 – 02.12.2025”
}
]

Screenshots (scenario flow, module settings, errors)

[samliew]

Welcome to the Make community!

Can you provide screenshots or example output bundles of both the Search and Aggregator modules?

To allow others to assist you with your scenario, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are extremely important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

• the full scenario,
• the zoomed in section of the scenario that you are referring to (if your scenario is huge),
• a full scenario run/execution (showing output “speech” bubbles),
• any error messages,
• individual module fields,
• relevant filter settings (conditions), and
• each module’s output bundles
• any external services (spreadsheet headers, sample data, regex101.com, etc.), for example, to show that the item/record exists and set up correctly

You can upload images here using the Upload icon in the text editor:

We would appreciate it if you could upload screenshots here instead of linking to them outside of the forum. This allows us to zoom in on the image when clicked, and avoid tracking cookies from third-party websites.

2. Scenario Blueprint

Please export the scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return - this would greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!

To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.

You can upload the file here by clicking on this button:

Sharing these details will make it easier for others to assist you.

[Teresa_Skorupa]

here’s link to the scenario (public view): Integration Google Calendar - Make.com Automation Scenario

Google Calendar Integration Blueprint (2).json (21.8 KB)

array agg output:
[
{
“_IMTKEY_”: “ name1 - Urlop wypoczynkowy”,
“array”: [
{
“end”: “2025-12-04T23:00:00.000Z”,
“start”: “2025-11-24T23:00:00.000Z”,
“summary”: “ name1 - Urlop wypoczynkowy”
}
]
},
{
“_IMTKEY_”: “ name2 - Urlop wypoczynkowy”,
“array”: [
{
“end”: “2025-12-05T23:00:00.000Z”,
“start”: “2025-12-04T23:00:00.000Z”,
“summary”: “ name2 - Urlop wypoczynkowy”
}
]
},
{
“_IMTKEY_”: “ name3 - Urlop wypoczynkowy”,
“array”: [
{
“end”: “2025-12-02T23:00:00.000Z”,
“start”: “2025-11-27T23:00:00.000Z”,
“summary”: “ name3 - Urlop wypoczynkowy”
}
]
},
{
“_IMTKEY_”: “ name4 - Urlop wypoczynkowy”,
“array”: [
{
“end”: “2025-11-27T23:00:00.000Z”,
“start”: “2025-11-26T23:00:00.000Z”,
“summary”: “ name4 - Urlop wypoczynkowy”
},
{
“end”: “2025-11-28T23:00:00.000Z”,
“start”: “2025-11-27T23:00:00.000Z”,
“summary”: “ name5 - Urlop wypoczynkowy”
},
{
“end”: “2025-11-26T23:00:00.000Z”,
“start”: “2025-11-23T23:00:00.000Z”,
“summary”: “ name5 - Urlop wypoczynkowy”
}
]
},
{
“_IMTKEY_”: “ name6 - Urlop wypoczynkowy”,
“array”: [
{
“end”: “2025-11-27T23:00:00.000Z”,
“start”: “2025-11-18T23:00:00.000Z”,
“summary”: “ name6 - Urlop wypoczynkowy”
]
}
]

set multiply variables output example:

[
    {
        "summary": "🌴 name1 - Urlop wypoczynkowy",
        "start": "2025-12-04T23:00:00.000Z",
        "end": "2025-12-05T23:00:00.000Z",
        "sort": [
            {
                "end": "2025-12-05T23:00:00.000Z",
                "start": "2025-12-04T23:00:00.000Z",
                "summary": "🌴 name1 - Urlop wypoczynkowy"
            }
        ]
    }
]

second array agg output example

[
{
“array”: [
{
“end”: “2025-12-04T23:00:00.000Z”,
“sort”: [
{
“end”: “2025-12-04T23:00:00.000Z”,
“start”: “2025-11-24T23:00:00.000Z”,
“summary”: “ name1 - Urlop wypoczynkowy”
}
],
“start”: “2025-11-24T23:00:00.000Z”,
“summary”: “ name1 - Urlop wypoczynkowy”
}
],
“_IMTAGGLENGTH_”: 1
}
]

text agg output:

[
    {
        "text": "🌴 name1: 25.11.2025 – 04.12.2025\n🌴 name2: 05.12.2025 – 05.12.2025\n🌴 name3: 28.11.2025 – 02.12.2025\n🌴 name4: 27.11.2025 – 27.11.2025\n🌴 name5: 19.11.2025 – 27.11.2025\n🌴 name6: 02.12.2025 – 02.12.2025"
    }
]

[samliew]

1. You are incorrectly using “Group by” on the Array Aggregator.

2. You are incorrectly using an Array Aggregator module a second time, on the Set Multiple Variable module.

If in doubt, just remember Iterators and Aggregators usually go in pairs.

Your scenario should look something like this:

Integration Google Calendar, Gmail.blueprint.json (6.6 KB)

I’d recommend going through the Make Academy if you haven’t yet!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

• Help Centre | Tutorials – Make’s “manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth
• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

How-Tos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Aggregate an array for mapping complex fields
• Getting started with OpenAI - How to setup and use OpenAI in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy - tutorial on how to use Webhooks

Hope this helps! If you are still having trouble, please provide more details.

— @samliew