I am new to Make and am trying to create a google calendar event each time a new row is added to a google sheet.
I’ve tried and tried to figure out why I’m continuously getting error messages, including asking my friend ChatGPT, but none of the fixes are getting me to the finish line.
If you’re getting errors when creating a Google Calendar event from a new Google Sheets row, it usually means one of two things: either the data from the sheet isn’t in the format Calendar expects, or a required field is missing.
A few things you can check:
Date/Time format – Google Calendar needs an exact format like YYYY-MM-DDTHH:MM:SSZ. If your sheet has a date in a different format, use a Formatter module in Make to convert it.
Required fields – Make sure “Start time,” “End time,” and “Summary” are all mapped and not empty.
Attendees format – If you’re inviting people, each email must be passed as a separate array item (not one comma-separated string).
Connection permissions – Double-check that your Google account connection in Make has both Calendar read and write permissions enabled.
If you share the exact error message (minus any personal info), it’ll be easier to pinpoint whether it’s a formatting issue or a permissions one.
