Hello, I’m having a problem with my workflow. My goal is that every time I manually enter the date of an appointment in a Google Sheet, it should automatically transfer to my calendar. Everything seems fine in my workflow, but when I try to activate it, I get an error message. I don’t know why. i send u a lot of capture like this u can see my exactly my workflow.
Google Calendar expects start and end fields as full date-time strings in ISO format like 2025-12-09T10:00:00+01:00 or 2025-12-09T10:00:00Z, you trigger is just sending 09/12/2025 is in the wrong format.
The fix is to convert your date string to a proper ISO datetime string that Google Calendar accepts, including time and timezone.
Use a Function node before the Create an event node
const inputDate = $json[‘DATE/HEURE DU RENDEZ VOUS’]; // “09/12/2025”
const [day, month, year] = inputDate.split(‘/’);
const dateObj = new Date(${year}-${month}-${day}T10:00:00Z); // setting 10 AM UTC as start time
return [{
json: {
…$json,
startDateTime: dateObj.toISOString(),
endDateTime: new Date(dateObj.getTime() + 60601000).toISOString(), // +1 hour
}
}];
then in the create an event node
use this as start date {{ $json.startDateTime }}
use this as end date {{ $json.endDateTime }}
Give it a try sending the right date format is always a pain… hope this is the fix
1 Like
It’s still not working. I see that Google Calendar seems to be very temperamental. I’m thinking of replacing Google Calendar, or perhaps using WhatsApp reminders instead, to remind me of my appointments. What do you think? Another question: if I stick with Google Calendar and add an AI agent, wouldn’t that be easier?