Record time and activities with Google Sheets, Calendar and Apps Script

Image for post
Image for post
Organizing
Image for post
Image for post
Keeping track of the day
Image for post
Image for post
The calendar entries organised in the sheet
Image for post
Image for post
Image for post
Image for post

Interested? Here is how to set up the sheet.

Disclaimer, some technical knowledge is required to set the sheet up. The code is open and there are examples in the sheet. If you get stuck feel free to ask me for help in the comments.

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

How it works

The menu option is added via the onOpen Action. The myTime object is constructed using the Crockford’s 2014 object creation pattern mentioned in this talk and in JavaScript: The Good Parts.

What’s next

There is still room for optimization, think AI/ML to translate the description into the customer, project and task. Or simply implement a basic #tag system. Automate imports in others systems, or use the calendar to plan your time and then convert the planning into time written. There is more on the list, for now, as is, this sheet saves me time and provides me with a clear overview of time spend.

Freelance Google Cloud Platform Architect, Google Workspace GDE

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store