Hello everyone,
I'm developing an AI receptionist that integrates with a Google Calendar plugin to check availability for booking jobs or appointments.
We utilize a CRM called ServiceM8 for booking jobs. This CRM can connect to an external Google Calendar via a webcal link. If I book an appointment in Google Calendar, it prevents my CRM from booking a job at that specific date/time.
The problem is that the webcal data isn't added to the primary Google Calendar but rather as a secondary one. When testing my AI with the Google plugin, it appears to allow users to book appointments on days that are already occupied.
It seems the Google plugin only references data from the primary calendar, not the webcal data (unless the webcal data lacks a busy or free status). I'm unsure if the webcal data has a "busy" or "free" status, or if this is configurable, so I'm assuming it cannot be changed.
I've managed to duplicate the webcal data and insert it into my primary calendar, marking the events as "busy," which works well. However, the challenge arises when I edit or cancel a job, as it won't update my primary calendar (I only make edits within the CRM).
Based on my research, this might be achievable using Google Sheets and checking ID numbers.
Would anyone be able to provide detailed assistance on how this could be implemented?
In summary, I'd like to clone events from Calendar A (a webcal linked to Google Calendar) to Calendar B (primary or another account). Crucially, if an event in Calendar A is deleted, or its date/time is modified, I need Calendar B to be updated accordingly.
Thanks