Guides › Health & Fitness
Stay on top of repeat prescriptions and check-ups
Gather health admin emails in one label, track repeat prescriptions in a sheet and get reminders before you run out.
When to use it
Set up once, runs every month
Step by step
Label health admin emails
In Gmail's settings, under Filters, create filters for emails from your GP surgery, pharmacy, dentist and optician that apply a 'Health admin' label. Outlook users can do this with rules.
Make a prescription tracker
Create a Google Sheets or Excel file with columns: Medicine (or a nickname), Quantity supplied, Date collected, Days it lasts, Reorder by, Notes.
Work out reorder dates
Paste the rows into your AI assistant with this prompt and copy the dates back into the sheet. You can also use a simple formula: date collected plus days it lasts, minus 7.
Prompt to copyHere are my repeat prescriptions: [paste rows using nicknames]. For each, work out the date I'll run out and a 'reorder by' date [7] days before, allowing for weekends. Then list my upcoming routine check-ups from these notes: [e.g. dentist every 6 months, last visit 3 May; eye test every 2 years, last March 2025]. Output one table sorted by date. Don't comment on the medicines themselves.Add calendar reminders
Create a Google Calendar or Outlook Calendar event for each reorder date and check-up, set to repeat where it makes sense.
Review monthly
Once a month, check the 'Health admin' label for anything new and update the sheet.
What you get
Inhaler (blue): collected 1 Nov, lasts 30 days, reorder by 24 Nov. Tablets (morning): collected 5 Nov, 56 days, reorder by 23 Dec. Dentist check-up due 3 Nov - overdue, book now. Eye test due March 2027.
Tips
- Use nicknames for medicines in AI tools if you'd rather not share them, and keep the sheet private.
- Follow your GP or pharmacist's advice on how early to reorder; some surgeries need several working days.