I’m running a test in Make with three modules (see attached image). My input data is what you can see in the image. When I run the scenario, it doesn’t end with an error, but the events are not added to the calendar. I think the problem is related to the date format, but I don’t know the reason.
Welcome to the Make community!
You probably do not need an Iterator there. What does the output of the Excel module look like? How are you mapping the variables in the Google Calendar module?
We’d love to help, however, you have not provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any issue/s and/or error/s.
To allow others to assist you with your scenario, please provide the following:
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:
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.
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:
Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).
Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.
Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.
You can upload the file here by clicking on this button:
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
Here are some ways to provide text content in a way that it won’t be modified by the forum.
Method 1: Type code fence manually —
Add three backticks ``` in a separate line before and after the content, like this,
```
text goes here
```
Method 2: Highlight and click the “preformatted text” button in the editor —
Method 3: Upload your file and share the public link —
(this method is only recommended for large files exceeding the forum upload limit)
Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved, and help you with mapping the raw property names from collections.
Sharing these details will make it easier for others to assist you.
You can test if the date is the issue by trying to reformat it in Make. For example, if your Excel gives 09/24/2025 10:00, run it through formatDate() and see how the output looks in your Calendar module.
ISO 8601
{{formatDate(parseDate(“09/24/2025 10:00”; “MM/DD/YYYY HH:mm”); “YYYY-MM-DDTHH:mm:ssZ”)}}
Gives: 2025-09-24T10:00:00Z (UTC)
Remember: Z means UTC. If you’re in Spain, you’ll need to adjust to the local offset:
{{formatDate(parseDate(“09/24/2025 10:00”; “MM/DD/YYYY HH:mm”); “YYYY-MM-DDTHH:mm:ss+02:00”)}}
2025-09-24T10:00:00+02:00 (Spain summer time, CEST)
Other supported formats
If you prefer not to use full ISO, calendars also accept:
{{formatDate(parseDate(“09/24/2025 10:00”; “MM/DD/YYYY HH:mm”); “YYYY-MM-DD hh:mm A”)}}
2025-09-24 10:00 AM
{{formatDate(parseDate(“09/24/2025 15:00”; “MM/DD/YYYY HH:mm”); “YYYY-MM-DD HH:mm”)}}
2025-09-24 15:00
Here’s an example of how it can look when you set up variables (you can also do this directly inside the Calendar module, this is just for illustration):
Important: First check whether your Excel value is a true date or just text.
If it’s already a date, formatDate() is enough.
If it’s plain text, you’ll need to parse it first wit parseDate()
Exactly. The problem was that I was using an iterator when the previous module was not returning an array. Thank you very much for everything
No problem, glad I could help you with “Create a Google Calendar event from an Excel file. The events aren’t added to the calendar”
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help as newer questions are displayed higher on the forum’s “new” page.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
Hope you get it sorted. Feel free to ask if anything is unclear.
— @samliew
