Guides › Food & Home

Catch every bill and renewal before it auto-renews

Gather bills and renewal emails into one label and a tracker, with a reminder a month before each contract ends.

Food & HomeAdvanced45 minGmailGoogle SheetsGoogle CalendarAI assistant
Open the interactive guideBrowse all guides

When to use it

Set up once, runs whenever a bill email arrives

Step by step

  1. Label bill emails automatically

    In Gmail's settings, under Filters, create filters for your energy, broadband, phone, insurance and streaming senders that apply a 'Household bills' label. Outlook users can do the same with rules and a folder.

  2. Build a renewals tracker

    Make a Google Sheets or Excel file with columns: Provider, What it's for, Monthly cost, Payment day, Contract end date, Notes.

  3. Extract the key details

    Open a recent bill or renewal email, copy the text (remove account numbers first) and paste it into your AI assistant with this prompt. Gemini in Gmail can do this inside the email if your plan includes it.

    Prompt to copyFrom this bill or renewal email, extract: provider, what the service is, monthly or annual cost, payment date, contract end or renewal date, any price rise and its date, and the notice period to cancel or switch. Output as one row with columns: Provider | Service | Monthly cost | Payment day | Contract end | Price change | Notice period. If something isn't stated, write 'not stated'. [paste email text]
  4. Set renewal reminders

    For each contract end date, add a Google Calendar event one month earlier called 'Compare deals: [provider]'.

  5. Review the label monthly

    Once a month, open the 'Household bills' label, add any new details to the sheet and check for price rises.

What you get

Broadband | Fibre 150 | 32.00 | 14th | 03/2027 | rises to 35.50 in April | 30 days. Car insurance | Annual | 46.25 | 1st | 22/01/2027 | not stated | not stated. Reminder set: 22 Dec - Compare deals: car insurance.

Tips

More Food & Home guides