How to Create Google Calendar Events from a Google Form

Have you ever tried to create events in Google Calendar using data from a Google form and found yourself stuck when it comes to adding the start and end time? You're not alone. Many users have encountered this issue, and it can be quite frustrating. But don't worry, we've got a solution for you.

The Problem

When setting up a scenario to create events in Google Calendar using data from a Google form, everything works fine until you add the start and end time. The system throws a validation error, stating that the date in the 'start' and 'end' parameters is invalid.

The Solution

The issue arises from the format of the date and time being fed into the Google Calendar event. The solution is to convert the date to the USA standard, where the month comes first and then the day. Additionally, it's a good practice to pass dates in the form of universal time stamps. The format is: YYYY-MM-DDTHH:mm:ss. Any application would detect it properly, regardless of countries, timezones, etc. The formula to be used in Make would then be: formatDate({{your_date_field}};YYYY-MM-DDTHH:mm:ssZ).

Troubleshooting Tips

If you're still encountering issues, try the following:

  • Check the format of your date and time fields. Make sure they're in the correct format as mentioned above.
  • Try manually inputting the data to see if the event is created. This can help you identify if the issue is with the data or the setup.
  • Use the 'add hours' function to add the hours to the date when setting the variable. This can help avoid format issues.

Conclusion

While it can be frustrating when things don't work as expected, there's usually a solution out there. In this case, adjusting the format of your date and time fields can help you successfully create Google Calendar events from a Google form. Remember, the key is to ensure the date is in the USA standard and to use universal time stamps. Happy automating!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.