GLP-1 tracker template: the four logs
| Log | One row per | Columns |
|---|---|---|
| Shot log | Injection | Date, time, medicine, dose (as prescribed), site, notes |
| Weight log | Weigh-in | Date, weight, conditions (time of day, before or after breakfast) |
| Side effects | Day you notice something | Date, day after shot, symptom, severity 0 to 10, how long, notes |
| Questions | Question | Date added, question, answer from your clinician |
Separate logs are easier to read than one wide sheet with twenty columns. In a spreadsheet, put each log on its own tab. On paper, give each one its own page.
What to leave out
A tracker is a record of what happened. Leave out columns such as "next dose to take" or "target weight this week" unless your prescriber gave you those figures. Dose changes come from your prescriber, not from the sheet.
Shotbloom puts date, time, dose and site on one screen, keeps weight and side effects in the same log, and exports everything to CSV for a spreadsheet. Get it on Google Play
Shot log: an example week by week
Here is how four weeks of a once-weekly shot might look. The dose column says "as prescribed" because the amount is whatever your prescription says; write the actual figure in your own log.
| Date | Time | Dose | Site | Notes |
|---|---|---|---|---|
| Sun, week 1 | 8:00 pm | As prescribed | Abdomen, left, upper | First pen |
| Sun, week 2 | 8:30 pm | As prescribed | Abdomen, right, upper | |
| Mon, week 3 | 7:45 am | As prescribed | Thigh, left | Late by half a day, travelling |
| Sun, week 4 | 8:00 pm | As prescribed | Thigh, right | Small bruise |
Writing down late or missed shots matters as much as the on-time ones. The rules for a missed dose differ between medicines, and they are set out in each Medication Guide; your log shows exactly what happened, which is what your clinician will ask.
The site column feeds your rotation. Our guide to injection site rotation has a sample rotation chart to copy.
Setting up a GLP-1 tracker spreadsheet
- Create four tabs: Shots, Weight, Side effects, Questions.
- On each tab, type the column headings from the table above in row 1.
- Format the date column as a date, so the sheet can sort and count days.
- Freeze row 1 so the headings stay visible as the list grows.
- Add the two formulas below if you want the sheet to do some arithmetic.
Days since the last shot
On the Shots tab, with dates in column A starting at row 2, put this in a spare column on row 3 and fill down: =A3-A2. Format the result as a number. A weekly schedule shows 7; a late shot shows 8, an early one 6.
Weight change between weigh-ins
On the Weight tab, with weights in column B, use =B3-B2 on row 3 and fill down. A negative number is a drop. For the change since the start, use =B3-B$2; the dollar sign keeps the first weigh-in fixed.
If you weigh in kilograms or stones, keep one unit for the whole sheet. To convert, 1 kg is about 2.2 lb, and 1 stone is 14 lb.
A free printable version
If you prefer paper, one A4 or letter-size page per month is enough for a weekly shot:
- Top third: a shot log with five rows (some months have five shot days).
- Middle: a weight log with a row per weigh-in and a small blank grid to sketch a line.
- Bottom: a side effect box for each week and three lines for questions.
Keep the sheet with your pens. Filling it in right after the shot takes under a minute; filling it in from memory a week later is where the gaps come from.
Using your tracker at appointments
Before a visit, read down the logs and write a short summary at the top of the Questions page: how many shots since the last visit, any late or missed ones, the weight change over that time, and which side effects came up and how strong they were. Our list of questions to ask your doctor about GLP-1 can help you fill the Questions tab.
Skip the spreadsheet setup
Shotbloom keeps your shots, weight and side effects together on your phone, with no account, and reminds you on your scheduled day.
Get it on Google PlayiPhone version coming soon
More guides
- Injection Site Rotation for Weekly GLP-1 Shots: A Simple LogHow injection site rotation works for weekly GLP-1 pens: the areas the official leaflets list, a sample rotation chart, and how to log each site to plan the next one.
- GLP-1 Side Effect Tracker: How to Log Symptoms ClearlyWhat to write in a GLP-1 side effect tracker: timing after your shot, a 0 to 10 severity scale, duration and context, with an example log and when to call your doctor.
- How to Track GLP-1 Progress: Weigh-Ins, Charts and NotesHow to track GLP-1 progress without reading too much into one number: consistent weigh-ins, weekly averages, a simple weight chart and non-scale notes worth keeping.
- Questions to Ask Your Doctor About GLP-1, Before and DuringQuestions to ask your doctor about GLP-1 before starting and at follow-ups, questions for your pharmacist, and what to bring from your shot log so the visit is quicker.
Published by Zoranta, the developer of Shotbloom.