Best answer

BambooHR-> Google Clendar time off sync to individual calendars

  • 4 May 2023
  • 1 reply

Userlevel 1

Does anyone know if it’s possible to have a new approved Day Off request in BambooHR trigger a new event to be added in each individuals google calendar? 


The problem is that people do not update their calendars when taking time off through Bamboo so am looking for an automation that doesn’t just summarise all days off in one calendar but distributes and blocks time off in each individual one. 


Best answer by SamB 4 May 2023, 15:42

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +11

Hi there @ausmanovs, welcome to the Community! 👋

The Google Calendar action would need to be connected to each individual person’s Google Calendar account. So you’d need to set up a Zap for each individual to have each approved time off request added to their own calendar. So you’d have a Zap for each individual with the following trigger and actions:

  • Trigger: New Time Off (BambooHR) set to only trigger for time of with a Status of Approved and limited to each individual. 
  • Action: Create Detailed Event (Google Calendar) - set to create an event on the calendar of connected Google account using the information from the BambooHR trigger.

Alternatively, a better option might be to have each individual would need to share their calendar with the Google account that’s connected to the Zap (set permissions to Make changes to events when sharing).

And with that option, you’d be able to handle it within a single Zap. To do that you’d need to use something like a Formatter (Utilities > Lookup Table) action to match up the employee name received from BambooHR with the ID for their shared Google Calendar (you’d need to use the Custom value option to select the calendar ID from the Formatter action). If you’ve not worked with lookup tables in Zaps before you can find out more about using them here: Create lookup tables in Zaps

Hope that helps to get you pointed in the right direction. Please keep us updated on how it goes!