Guides › Personal Assistant

Never miss a renewal or expiry date

One list of every important renewal, such as passports, car tax, insurance and warranties, with calendar reminders well before each one.

Personal AssistantIntermediate30 minGoogle SheetsGoogle CalendarAI assistant

When to use it

Set up once, update when things change

List everything that expires
Go through your documents and emails: passports, driving licence, car tax and service, insurance policies, TV licence, phone contracts, warranties, prescriptions, pet vaccinations.
Let the AI find what you've missed
Paste your list into your AI assistant with this prompt.
Prompt to copyHere's my list of household renewals and expiry dates: [list with dates]. My household: [for example 2 adults, 1 child, a car, a dog, renting]. Suggest any common renewals I've missed for a household like mine. Then create a table with: Item, Who it's for, Expiry or renewal date, How far ahead to start (for example passports 3 months, insurance 4 weeks), Reminder date, and Notes. Sort by reminder date and format it so I can paste it into Google Sheets.
Create your tracker
Paste the table into a Google Sheet called Life admin. Don't store full document numbers in it.
Add calendar reminders
Add each reminder date to your calendar as an event, with yearly repeats for annual renewals.

Leave out passport and policy numbers. The dates are all you need for reminders.
Some countries require several months left on a passport to travel, so check your destination's rules early.