I run a CRM roster through Google calendar.
Basically, all I want.
When a lead comes in it allocates the lead to the sales person based on the time the lead came in, looking up a Google calendar event, which then displays the sales persons name.
I've got this working where sales people are allocated for a whole day, but now we're running split shifts and my zap isn't working.
1. A webhook triggers the zap.
2. I run a date/time format zap to give the current time (meta human now).
3. I try to find the event currently underway based on the date time.
Bargle: cannot find event.
I believe it has something to do with the search in the google calendar where I input start time as the output from step 2.
Any advice would be amazing!