GAS-ICS-Sync icon indicating copy to clipboard operation
GAS-ICS-Sync copied to clipboard

Sync Free / Busy availability from restricted employer calendars

Open shadowrock-io opened this issue 1 year ago • 6 comments

Is your feature request related to a problem? Please describe.

No response

Describe the solution you'd like

Would appreciate the ability to incorporate free/busy status from a target Google Calendar into the primary calendar. Could be as an "event" or some other capability to designate the time as busy.

While the existing GAS serves its purpose quite well for my needs, my employer locks down calendar access so that only free / busy details are available to the public. They also restrict the ability to share the calendar with my personal calendar (free / busy as well). I anticipate that I'm not alone in this, as security of calendar events can be critical.

I'm still able to get the ical URL, but the GAS doesn't process the events as true 'events' since it cannot access the details of the events themselves.

Additional context

Current: Screenshot 2023-04-26 at 8 56 19 PM Desired (while actually syncing availability, despite employer limitations on details): Screenshot 2023-04-26 at 9 00 26 PM

Despite showing as Busy in my screenshot, this is just a subscription to the other calendar and the available details. True availability is not currently being incorporated despite linking the ical URL and correct calendar name in the GAS.

Here are the limitations from my employer's calendar setup: Screenshot 2023-04-26 at 9 08 17 PM Screenshot 2023-04-26 at 9 06 10 PM Screenshot 2023-04-26 at 9 04 47 PM

shadowrock-io avatar Apr 27 '23 04:04 shadowrock-io

@shadowrock-io has funded $50.00 to this issue.


IssueHuntBot avatar Apr 27 '23 04:04 IssueHuntBot

True availability is not currently being incorporated

What do you mean with true availability?

jonas0b1011001 avatar Apr 27 '23 07:04 jonas0b1011001

Sorry for the all-over-the-place ramble. I'll try and structure differently:

  • Calendar (employer-restricted "EMP") shows free / busy slots
  • EMP does not allow me to share event details, etc.
  • I want to aggregate free / busy slots from EMP to my personal calendar so that available openings are a true aggregate of my "free" status
  • I would like my personal calendar to appear as the second screenshot - showing that I have EMP appointments during many times throughout the day (even though I can't get all of the details).
  • One approach might be cloning the "busy" slots to calendar events with "busy" status at the times shown in screenshot 2. This currently does not happen in the GAS.

Alternatively, if there was a way to authenticate to multiple Google Calendars via OAuth, that would be incredible. I could then bypass the employer restrictions and get the event details since I would be authenticated to the EMP with the primary user. Even if I had to install the script (or a companion GAS) to each Google Acct, that would be fine. I would pay out an extra $50 for that capability (especially if I don't have to install a GAS in each acct)

shadowrock-io avatar May 01 '23 15:05 shadowrock-io

free/busy calendars should sync just fine. They are just like normal calendars without event details and titles replaced with "busy".

Is the script running successfully? You can check the logs at https://script.google.com/home/executions

jonas0b1011001 avatar May 01 '23 18:05 jonas0b1011001

Hi - I realized that I originally was not including the correct .ics link in my script, so replaced and re-ran.

After running, no change. The runtime is quite long on the executions (1600 seconds).

Despite the successful script run, I've confirmed with an external party that my availability is still only reflecting my primary calendar (not the employer's calendar availability). Only showing free / busy as demonstrated in the first screenshot despite my desire to have my free / busy shown as screenshot 2

shadowrock-io avatar May 01 '23 23:05 shadowrock-io

@shadowrock-io, were you able to resolve this? I just realized this question is pretty stale.

Lonestarjeepin avatar Mar 11 '24 20:03 Lonestarjeepin

Closing as stale issue.

Lonestarjeepin avatar May 29 '24 19:05 Lonestarjeepin