Connector Improvement: Domain Wide Google Workspace Calendar Connector
AnsweredI really love the new Google Calendar connector and I noticed that it only works for a single user and not an entire Google workspace.
The connector would be even more useful if it could sync all calendars within the organisation.
While this is not straight forward, it seems to work with some extra steps:
https://stackoverflow.com/questions/59205218/get-all-calendars-in-google-org-via-google-api
In short:
- while syncing calendars, the connector would need to iterate over all users and their calendars
- we would need to provide an actual service account with domain-wide delegation for authentication
There are great use-cases around calendar hygiene if the calendars work across the organisation :D
-
Official comment
Hi Thomas,
Thank you for taking the time to share your insightful feature request regarding the enhancement of the Google Calendar connector to support entire Google Workspaces. We truly appreciate your engagement and the detailed explanation you've provided. It's clear that expanding the functionality to sync all calendars within an organization could offer significant benefits for calendar hygiene and overall efficiency.
I am pleased to inform you that your request has been added to our backlog. As we continue to develop our product offerings, we prioritize features based on community demand and potential impact. Rest assured, we will keep a close eye on this request's popularity among users.
We promise to keep you updated with any progress or future developments related to this feature. Your feedback is invaluable in helping us improve our services, and we look forward to potentially incorporating this enhancement to better serve our community.
Best regards,
Syead Mujtaba Imam Rizwi -
This would be incredibly helpful feature!
Additional workaround suggestion from stack overflow (similar but different from link in original post) here: https://stackoverflow.com/questions/65576851/access-entire-gsuite-domain-calendar-events -
Thanks, @Syead! Can you please:
1. Share a sanctioned workaround for now (e.g., creating a dedicated Google service account with user read and calendar ACL perms, then using something like GAM to give it read access to every workspace-wide email/calendar, then authenticating to Fivetran using that service account)?
2. Share an estimate as to when this might be properly implemented? I understand it may not have a due date, but it's extremely unhelpful and frustrating to hear the typical "we'll get to it when we prioritize it" -- given previous feature requests, this could be next week or in several years. Thanks in advance for the helpful communication to customers!
Please sign in to leave a comment.
Comments
3 comments