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

Question

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

PaulKortman · Accepted Answer

@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:

Trigger on a new event in the calendar
Delay by 3 minutes to allow the team member to get all the information in the event
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

AndrewJDavison_Luhhu · Answer

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

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded