Time-tracking > integromat > google-calendar integration

We need to have a better control on time reports, so we found a workaround using integromat.

I set up a scenario where once a day integromat searches for elements by time tracking column, filters the time entries of the day before, and creates corresponding google calendar events.

In this way, activity reports are neatly displayed in google calendar, with direct link to corresponding pulse in description:

I know the scenario is a little bit convoluted, and I’m sure it can be improved in a number of ways, but the results are really fine fo our use case.

Caveat: it works for only one board and you have to set up google calendars for every users.

Thanks in advance, I will be happy to share details if needed.

Hi @peppinob!

This is amazing! I’m so glad to hear that it seems to be working for your team.

Regarding the limitations you’ve identified, what if you added in another module that can list a predefined number of boards in your account? I believe it would be the very first module in the scenario. Could something like this work?

When you say you have to set up a Google Calendar for every user, do you mean that a new calendar is created? Would love to learn more here!

Thanks,
Helen

Hi @Helen ,

Regarding the limitations you’ve identified, what if you added in another module that can list a predefined number of boards in your account? I believe it would be the very first module in the scenario. Could something like this work?

I think it would work, we just don’t need right now to connect more than one board.

When you say you have to set up a Google Calendar for every user, do you mean that a new calendar is created? Would love to learn more here!

Yes we created a calendar for every user, so you get a nice interface on Google Calendar where you can turn on/off every user for better visibility:

image

1 Like

Amazing! I can see how useful this would be for many of our users.

Thanks for posting!

1 Like