Record time and activities in Calendar and Sheets
Create calendar events for your activities, and synchronise to your timesheet in sheets for reporting.
Last updated: September, 2019
Contributed by Jasper Duizendstra, follow me at @Duizendstra
Keeping track of the time spent on project for customers can be a challenge. Not all time writing apps are user friendly and sometimes you need to record your time in multiple systems. You can end up spending a lot of time writing time on a daily basis in a stubborn system and synchronise that time to other systems.
To solve this problem we can use the one time related application we have open every day, Google Calendar. In an additional calendar we can quickly add an event for the appropriate timeslot. Then add a short description and forget about it. Art the end of the week you synchronise the calendar with a Google sheet. Categorize by customer, project and task based on the description and the data is structured for further processing. Use the dashboard or write a simple query to report or copy in other time sheets.
SpreadsheetAppservice is used to write the events to the sheet
- Custom Menus are used to trigger the synchronisation
CalendarAppservice is used to write the events to the sheet
- Create your secondary calendar: Create a new calendar
- Copy the calendar id. This can be found in the calendar settings
- Copy this sheet
- In the configuration tab you paste the id of the calendar you created in step one.
- Add some events to the secondary calender and hit MyTime -> Sync calendar events
This solution is based on this article
To get started with Google Apps Script, try out the codelab which guides you through the creation of your first script.
You can also view the full source code of this solution on GitHub to learn more about how it was built.
Were you able to get the solution up and running?
If you have an idea for another solution you'd like to see featured in our gallery submit a request on the GitHub issue tracker.