Skip to content

Home & Vehicle Renewals Tracker

Example prompt: "I have a Google Sheet with my household renewals — MOT, car insurance, home insurance, boiler service, council tax — each with a renewal date. Every Monday, check what is due in the next 30 days and email me the list with the date, the supplier, and last year's price."

How to automate household renewal reminders with GloriaMundo

The Problem

Households accumulate a quiet pile of annual renewals — MOT, car and home insurance, boiler service, TV licence, council tax direct debit, breakdown cover, pet insurance, gas safety check for landlords. Each one arrives by post or email at a slightly different time of year, and most renew on autopilot at a price 15–25% higher than what you would pay if you shopped around. Missing an MOT or letting insurance lapse is a real legal and financial risk. Remembering all of them without a system is unrealistic, but setting up a calendar full of one-off reminders is fiddly and tends to drift out of sync.

How GloriaMundo Solves It

We build a workflow that runs weekly on a schedule. A Google Sheet holds the renewals — one row per item with the renewal date, supplier, last year's price, and an optional notes column. An integration step reads the current sheet. A code step computes which items fall within the next 30 days (and a longer 60-day window for higher-value renewals like insurance, where shopping around takes more time). An LLM step formats a tidy summary grouped by lead time — "due in the next 7 days", "due in 8–30 days", "due in 31–60 days for insurance" — with last year's price next to each so you have an anchor when you renew. An integration step emails you the digest. For anything inside 7 days, a second integration step creates a Google Calendar reminder so it cannot be missed. Glass Box preview shows the full output before anything is sent.

Example Workflow Steps

  1. Trigger (scheduled): Runs every Monday morning.
  2. Step 1 (integration): Read the renewals sheet from Google Sheets — date, supplier, last year's price, notes.
  3. Step 2 (code): For each row, compute days until renewal and bucket items into "next 7 days", "next 8–30 days", and "next 31–60 days for insurance".
  4. Step 3 (llm): Format the digest with grouped sections, supplier names, dates, and last year's price for each item.
  5. Step 4 (integration): Email the digest to you via Gmail.
  6. Step 5 (conditional): If any items are inside 7 days, proceed to add calendar reminders.
  7. Step 6 (integration): Create a Google Calendar reminder for each imminent renewal.

Integrations Used

  • Google Sheets — stores the list of renewals with dates, suppliers, and last year's prices
  • Gmail — delivery channel for the weekly digest
  • Google Calendar — backup reminder for renewals inside 7 days

Who This Is For

Anyone running a household who has been caught out by an expired MOT, an insurance auto-renewal at a worse price, or a forgotten boiler service. Particularly useful for households with multiple cars or properties where the renewals stack up quickly.

Time & Cost Saved

Manually keeping renewals on top of mind takes a small amount of time each month and a larger amount when something is missed and you scramble. The bigger saving is from getting enough advance warning to shop around on the big-ticket items — insurance and breakdown cover savings of £50–200 per year are realistic when you switch rather than auto-renew. The workflow uses integration, code, LLM, and conditional steps, costing a few credits per weekly run.