Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do you use Zapier to make an hour tracking automation for projects from Google Calendar?
Best answer

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

  • December 4, 2019
  • 3 replies
  • 1037 views
A

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

@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


View original
Did this topic help you find an answer to your question?
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

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Hi @Aleesa

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


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
A
  • Aleesa
  • Author
  • 1 reply
  • December 9, 2019

Hi @AndrewJDavison_Luhhu In a google spreadsheet if possible.


PaulKortman
Forum|alt.badge.img+10
  • PaulKortmanZapier Expert
  • Zapier Expert
  • 469 replies
  • Answer
  • December 9, 2019

@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


Need Additional help? Feel free to reach out here: https://zapier.com/experts/connex-digital/
AndrewJDavison_Luhhu
1 person likes this
  • AndrewJDavison_Luhhu
    AndrewJDavison_Luhhu
Terms & Conditions