Skip to main content
Question

Help setting up an scheduling automation

  • Nov 14, 2026 12:09 AM UTC
  • 7 replies
  • 37 views

i need help to automate scheduling email data to a google calendar--. like scheduling, rescheduling and cancelation

7 replies

  • Author
  • Beginner
  • Nov 14, 2026 12:14 AM UTC

i get scheduling emails from a place than don’t provide google calendar syncing

When someone schedules I want to block date and start to end time on google calendar

and appropriate action when they reschedule or cancel --- date and time changes or blocked date and time clears.  

I also want the booker Initial (S)


WebhookEngineer
Forum|alt.badge.img+1

You’ll need to match each reschedule or cancellation to the original booking. Extracting the date and time alone could leave the old time blocked and create a second event when someone reschedules.

I’d keep a link between the booking reference and its calendar event, then use that link to update or remove the original event when another email arrives. I’d also include the booker’s initial in the event title.

Do the scheduling, rescheduling and cancellation emails all include the same booking number or reference?


  • Author
  • Beginner
  • Nov 14, 2026 12:37 AM UTC

I get a separate email each event. I can trace 1 to see the similarities. Are you able to work with me on this


  • Author
  • Beginner
  • Nov 14, 2026 12:40 AM UTC

Could it just be by date and time, meaning change the calendar based on the event. If someone booked block the date/time that same date/time cancels reopen same for rescheduling 


WebhookEngineer
Forum|alt.badge.img+1

Yes, I can help work through the setup here. Matching by date and time could work if the original slot uniquely identifies the booking.

A cancellation email would need to identify the slot to clear. For a reschedule, we’d need the original slot to find the existing event and the new slot to move it to. The new time alone doesn’t tell us which old block to remove. If multiple events match, the workflow should leave them unchanged rather than guess.

Do the rescheduling emails include both the original date/time and the new date/time?


  • New
  • Nov 15, 2026 1:08 PM UTC

Matching on date and time alone can work, but it is risky if two emails share the same slot. A safer pattern is to store the calendar event’s ID when you first create the blocked event, then re-use that same ID to update or delete the event when a reschedule or cancellation arrives. You can use Formatter by Zapier Date/Time to normalise the time zone and seconds, and include the booker initial in the event title so you can spot-check matches. If your emails carry any reference number even a booking code or a subject-word that stays the same across schedule and reschedule, try using that as the match key instead.


  • Author
  • Beginner
  • Nov 16, 2026 10:40 AM UTC

Yes, I can help work through the setup here. Matching by date and time could work if the original slot uniquely identifies the booking.

A cancellation email would need to identify the slot to clear. For a reschedule, we’d need the original slot to find the existing event and the new slot to move it to. The new time alone doesn’t tell us which old block to remove. If multiple events match, the workflow should leave them unchanged rather than guess.

Do the rescheduling emails include both the original date/time and the new date/time?

Yes it does, original date and time- new date and time