Simple Weight Tracker Automatic Add Row

Name: Simple Weight Tracker Automatic Add Row
Uploaded: 2026-07-13T05:00:30-07:00
Description: Learn how to create a simple weight tracker in Google Sheets that automatically adds a new row for daily weight entries. This tutorial covers using Google Apps Script to automate the process and set triggers for daily updates.

Learn how to create a simple weight tracker in Google Sheets that automatically adds a new row for daily weight entries. This tutorial covers using Google Apps Script to automate the process and set triggers for daily updates.

So a common thing to do in weight tracking is to have our sort of header and rows here and then go down from the very first date to the very latest date. But I've reversed it. This is actually much simpler.

So let's go up to extensions appscript and we're going to need to do two things. We're going to need a new row and we're going to need a function new date.

The format is important because it should be the format that you want and that you've already formatted this cell and this column with.

Now, here's a little trickyness that we don't have any trick here. So, it's not tricky for us, but usually it's tricky if we have a header .

Now all of this can be simplified as well. Variable track equals this and then we go track.insert and we go track.

So, over in our app script , go over to triggers on the left side.

Now, we know it's going to run at some point between 4 and 5 a.m. our time.

Go up to extensions appscript. Over on the left side, click triggers and over on the right side of this trigger new row.