I am trying to connect Google Calendar to Zapier to track the number of hours each team member spends on a project.
Best answer by PaulKortman
View originalI am trying to connect Google Calendar to Zapier to track the number of hours each team member spends on a project.
Best answer by PaulKortman
View originalHi
Definitely possible! Once you’ve tracked the hours, where do you want to store the data?
Hi
Here's how I would build the Zap:
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.