This topic was automatically generated from Slack. You can find the original thread here.
Hi folks, really needing some help here. I want to create a new google calendar event when I enter data in to a google sheet. I’m fine with the trigger (I think) but i’m getting stuck when I need to enter the event start date, what exactly am I writing in there? TIA
Hey , The start date should be in format yyyy-mm-ddThh:mm:ssZ. The format yyyy-mm-ddThh:mm:ssZ is an ISO 8601 date and time format. Here’s how to break it down:
• yyyy represents the 4-digit year.
• mm represents the 2-digit month.
• dd represents the 2-digit day of the month.
• T is a separator that indicates the start of the time element.
• hh represents the 2-digit hour in 24-hour format.
• mm represents the 2-digit minutes.
• ss represents the 2-digit seconds.
• Z represents the time zone offset from Coordinated Universal Time (UTC).
Here’s an example: 2024-06-16T20:37:20+01:00
This would represent June 16th, 2024, at 8:37 PM and 20 seconds, with a time zone that is one hour ahead of UTC.
This great thanks. How do I add a new row to my sheet and get the google calendar code to pull the date from column c of that row? Essentially i’ve got a list of tasks in a google sheet and every time I add a row I want google calendar to create an event with that date and also pull the title of the event from column A.
I see. There’s a great tutorial here to guide you on how to pass data from trigger and/or other steps, would you mind taking a look? https://youtu.be/RW9FBVuHDHQ
Thank you i’ll take a look. I just thought there might be an easier way for this or possibly a template or something. Thank you, i’ll go and work it out. Much appreciated