Hello everyone,
I am developing an AI receptionist that integrates with Google Calendar to check availability for booking jobs or appointments.
We utilize a CRM called ServiceM8 for booking jobs. It offers the capability to connect to an external Google Calendar via a webcal link. If I make a booking in Google Calendar, it prevents my CRM from scheduling a job at that specific time.
The challenge is that the webcal data isn't merged into the primary Google Calendar; it remains a separate calendar. When testing my AI with a Google Calendar plugin, it appears to allow users to book appointments on days that already have a job scheduled.
It seems the Google Calendar plugin only considers data from the primary calendar and not the webcal data (unless the webcal data lacks a busy or free status). I'm uncertain if webcal data includes a "busy" or "free" status, or if this is an adjustable option, so I assume it cannot be modified.
I have successfully cloned the webcal data and inserted it into my primary calendar, marking the events as "busy," which works perfectly. However, the issue arises when I edit or cancel a job, as it doesn'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.
Could someone provide detailed assistance on how this could be implemented?
In summary, I need to clone events from Calendar A (a webcal linked to Google Calendar) to primary Calendar B or another calendar account. Crucially, if an event in Calendar A is deleted or its time/day is modified, Calendar B needs to be updated accordingly.
Thanks
Hi,
Welcome to the Community.
To sync events between your primary Google Calendar and a Webcal linked to ServiceM8, use callin.io to automate the process. Trigger the callin.io with ServiceM8's "New Job" event to create a corresponding event in Google Calendar. For updates, use the "Updated Job" trigger and store event IDs with callin.io's "Storage" app to match and update events. Since Google Calendar doesn't trigger deletions, you may need a scheduled check for discrepancies. This setup ensures better synchronization, though adjustments may be required based on your specific workflow.
I hope this helps. Feel free to ask if you have any further questions.
Great, I'll look into it. Thanks for your help!
Hi,
Please keep us informed so we can provide further assistance if necessary. Thank you.