Syncing Google Calendar with Bubble: Auto-Create and Update “Session” Things

I’m building a feature that connects Google Calendar with Bubble so that each user’s calendar events automatically create and update “Session” things in the database. The goal is for Bubble to create a new Session whenever a user schedules a new event in their Google Calendar. Each Session should include the event title, start and end time, attendees (as a list of users or emails), and the calendar event ID for tracking updates or deletions. If an event changes in Google Calendar, the corresponding Session should automatically update. Each user should be able to connect their own Google Calendar so that their sessions populate independently.

I know how to enable and connect the Google Calendar API using the Bubble API Connector and handle OAuth2 authentication for each user. Right now, I’m trying to figure out the best workflow setup for:

  1. Listening for new events or updates (possibly using Google’s push notifications or webhooks).

  2. Automatically creating or updating the corresponding Session thing in Bubble without manual refreshes.

  3. Handling multiple users, each with their own Google account and synced events.

If anyone has figured out a clean or reliable way to set this up, I’d love to collaborate, hire you or get advice on the best approach to structuring these workflows.