Best answer

How do you use Zapier to make an hour tracking automation for projects from Google Calendar?

  • 4 December 2019
  • 3 replies
  • 1031 views

Userlevel 2

I am trying to connect Google Calendar to Zapier to track the number of hours each team member spends on a project.


icon

Best answer by PaulKortman 9 December 2019, 21:57

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.

3 replies

Userlevel 7
Badge +10

Hi @Aleesa

Definitely possible! Once you’ve tracked the hours, where do you want to store the data?


Userlevel 2

Hi @AndrewJDavison_Luhhu In a google spreadsheet if possible.


Userlevel 7
Badge +10

@Aleesa so are all the team members putting their hours into one calendar? If so you can have one zap do this, if not you'll need a different zap for each calendar.

Here's how I would build the Zap:

  1. Trigger on a new event in the calendar
  2. Delay by 3 minutes to allow the team member to get all the information in the event
  3. Create a new row in Google Sheets (values including: user, event name, description, start time, end time, duration)

Then have a seperate tab in Sheets that counts the durations for rows that include project name in the event name. something like `SUMIFS(F1:F10, B1:B10, "projectX")` see https://support.google.com/docs/answer/3238496?hl=en