Create a Custom Time Tracker with Google Calendar and Apps Script: GAS099

Introduction

In this Google Apps Script project, we aim to transform Google Calendar into a personalized time-tracking tool. By harnessing the power of Google Apps Script, we will extract event data from your Google Calendar and store it in a Google Sheets document, thereby creating your custom time tracker. This project also serves as an educational resource, guiding you through the process of creating Google editor add-ons. By studying the source code, you will gain insights into my approach to managing settings in the sidebar for the time tracker.

YouTube

If you're a visual learner and prefer watching video instructions, I highly recommend checking out these videos.

Instructions (4 Steps)

To establish your own project, adhere to the following steps:

Step 1

Utilizing the provided link, you can create a duplicate of my project on your Google Drive.

Make a copy

Step 2

To fulfill the authorization requirement, navigate to the copied Google Sheets document and select any button located within the custom menu “Time Tracker”.

* Check the authorization guide if unfamiliar with the process.

A Complete Guide to Authorize GAS Project

Step 3

Within the "Settings" tab, pay close attention to the notes in column C. Based on your specific requirements, you can update the values in column B. However, it's crucial to refrain from altering the values in column A, as they directly influence the script's functionality.

Step 4

To access the sidebar, navigate to the custom menu and select "Timer Tracker" followed by "Launch." This action will retrieve a list of your personal calendars. You can activate the time tracker for a particular calendar by toggling the switch. Additionally, you have the option to enable automatic report generation with customizable frequencies, including "Yearly," "Monthly," or "Weekly."

SAVE CHANGES - Configure triggers that automatically initiate time tracking and generate notifications for the enabled calendars.

RESET - Deactivate all switches and remove all triggers.

REFRESH - Ensure the calendar list is current and accurate.

Other Features

• The "Events" sheet will store the event data to generate the report.
• The "Dashboard" tab will aid in creating the report. You can add charts to this tab by utilizing data from the "Events" tab.
• The custom menu "Time Tracker" provides a button for manually sending the report.
• To understand my code, open the Apps Script editor. To do this, navigate to "Extensions" in the menu bar, and then select "Apps Script."

GoogleAppsScript Playlist (Subscribe for New Projects)

Links

Hire me on Upwork  Donate (PayPal) YouTube Github Twitter / X Instagram