How to make a Google Sheets time tracker?

Did you know you can create a time tracker for your work using Google Sheets? If you want to learn how to do it, follow this step-by-step tutorial.

The first thing you’ll need to do is create a blank Google Sheet. You may copy this template spreadsheet and use it instead of creating everything from scratch.

Click Extensions and choose App script.

google-sheets-time-tracker

You will be redirected to the App script page. 

Please, copy the code from this Google Doc and paste it to the page. Save the script by clicking and return to the spreadsheet.

Now we need to create the headers. If you want a different column order, make sure to change the references in your script.

The next step is to add buttons. Click Insert, Image, and Insert an image over the cells.

You may insert any images for this. If you want to use the images from this tutorial, please, find them in this document

Now we link the buttons to each of the functions by clicking the three dots, clicking Assign a script, and adding the functions name. You need to add buttons for Start, End, and NewRow.

Next, all you need to do is create a tab for each month, add the dates on the first columns, and use the time tracker.

Watch how to make a Google Sheets time tracker

To see a video demo of all of Kanbanchi's features right here, please, accept functionality cookies.


More Google Workspace tips from Kanbanchi.

Also read: How to create a Gantt chart in Google Sheets?


Want to try the power of Kanbanchi and Google Workspace?

Start your free trial