How to track time with Google Calendar and sync to Google Sheets

In this episode of Sheets to Apps, we will show you how to track your work time on projects via Google Calendar. More importantly, he’ll be showing you how you can sync Calendar events to Google Sheets, creating a spreadsheet that shows you the total time spent on your projects.

Product: G Suite Development, Calendar, Sheets; fullname: AGV;

#SheetsToApps
#CustomizingGoogleWorkspace

[ameelaxpati]

The Sheet I copied from your link doesn't contain the configurations tab. So nothing is working

[tuvshuun]

More of these kinds of videos please. I would like being able to sync google sheets with google calendar back and forth being able to create and plan and also measure my tasks with a given weight.

[rodusaev]

Hey, this is amazing and replaces all of time tracking apps. Please update it so in the HOURS tab, when filter tasks and projects, you see only those that relate to a project and a relative client instead of all!

[ArtistPennyFireHorse]

So I followed the instructions but the google sheet does not have a configuration tab at the bottom and suggestions?

[rogerjansson]

As other people has mentioned, there is no custom menu.
Can someone fix this?

[taylorprescott]

Hi. I am currently trying this on my IPad and I am unable to sync together at all because there’s no tool bar ( my time tab)

[carolinegarrett]

Sorry if I missed it, but is there a way to pull multiple calendars in together?

[dr.yahyaelewa]

I wish someday to see my daughter like 👍you. Hats lift up.
Thank you so, so much great lady. Blessings.

[jasonfanclub]

I am going to try this very soon. Looks so helpful!

[vargaagnes]

Thank you for your app - it's been really helpful! However, I need help with the event time zone setting. The app reschedules my events 8:00 hours earlier which is not ideal. Can you please guide me on how to set my own time zone in the app? I need GMT+2.00 and GMT+1.00 version. Thank you for your feedback in advance.

[marianarichter]

thank you for this video. does it work on tablet? it is working good on the computer but I cant see "myTime" extension at the menu when using tablets.

[leahs.]

I'm not able to get this to work any longer.

[sea_hous]

I can't find configuration on Google Sheets.

[CaptainSnackbar]

i take it this is only works if you have "G Suite" and its not in the regular google accounts?

[shivonviwe]

Hey thanks for your video really helpful
i was thinking via app-script we can import google calendar details to any google sheet. Can You please guide how to get the details of all guest list in the same manner in google sheet

[heinzdieterkaemmererluque]

@Jasper Duizendstra This is looking really great and perfect for what I was searching for my team. Just a quick question to understand the "background" configuration, which APIs should be enabled from the Google Workspace to be able to see the results? I may think on Calendar API and Admin SDK, but I want to be sure. Thanks!

[Justme-uvtl]

Can I use this to track my work hours and add photos of my work?

[mckenseyhanmer]

@Jasper Duizendstra I'm having an error on the daily section of the dashboard. Do you know how to fix this? ERROR: unable to parse query string for Function QUERY parameter 2: NO_COLUMN: D

[Stevendmercer]

Is there a way to indicate if an event was accepted or declined? Both type of events are being imported, which is fine, but I'd like to be able to decipher which is which. Thanks.

[amkrad]

how do you get a total of hours automatically to show? I can get this to sync to my calendar but cannot get a tally of all the hours..