I’m trying to feed project start/stop dates from Monday into Google Calendar and can’t seem to set up the automatic update zaps. I know there’s a 2-zap process for having GCal events update via GSheets, but I’m using Monday and haven’t figured it out yet.
I have a Project Board that contains 4 date columns: Pre-Pro Start, Pre-Pro End, Production Start and Production End. I’m able to get these into Google Calendar no problem, but by the time I add the item/project, Zapier has already run the trigger and the GCal events uses default date values before I can fill those fields in on Monday. Also, this means anything create in GCal is immediately obsolete once we have date updates for a project.
Currently, I have two zaps that create GCal events for each new item in my project board. Any insight would be greatly appreciated!