AutomationDownload
Aftercare & Guarantee Reminders
Checks in with every customer a week after the job and reminds them before their guarantee ends - so problems, and the next job, come to you
£29.00
Download
Van MOT & Trade Card Tracker
Works out when each van needs its MOT and warns you before Gas Safe, CSCS, insurance and every other renewal
£29.00
How you’ll receive this product
Available to download as soon as your payment is confirmed
This is delivered digitally. As soon as your payment is confirmed you will get a private link to your files on your order page. Keep the link to that page — it is where your purchase lives.
You receive
- Van MOT & Trade Card Tracker — van-mot-trade-card-tracker.zip
- Secure Stripe checkout — we never see your card details
- Your files appear on your order page the moment payment clears
About this product
A lapsed MOT, registration or card can stop you working. This keeps every date in one place and warns you in time.
One row per thing that runs out. For an MOT, put the expiry from the last certificate - or for a van under three years old, just its first registration date, and it works out the first MOT from the third anniversary. It reminds you that you can get an MOT up to a month (minus a day) early and keep the same renewal date. A Gas Safe registration renews every 12 months and an upper tier waste carrier registration every 3 years, so for those the date it was issued is enough. Everything else - CSCS cards, insurance, road tax, other qualifications - just needs its expiry date.
You get one email when things reach 60, 30, 14 and 7 days, and on Mondays the month ahead.
Features
- First MOT worked out from the registration date (3 years)
- Tells you the earliest day to test and keep the same MOT date
- Gas Safe renewal 12 months on; upper tier waste carrier 3 years on
- CSCS, insurance, tax and anything else, from its expiry date
- Warnings at 60, 30, 14 and 7 days, all in one email
- Starts in test mode - everything comes to you until you say otherwise
- Keeps a record of every message it sends, so nothing goes twice
- The wording lives on a tab in the sheet, so you change it without touching code
- An Example tab in your own sheet shows a filled-in version, with made-up data
- Runs inside your own Google account. Nothing is sent to us or to anyone else
Product questions
A Google account - a free Gmail account works, and so does Google Workspace - and Google Sheets in your web browser. Nothing is installed on your computer.
Open a new Google Sheet, go to Extensions > Apps Script, paste in the script from your download and run install once. It builds the tabs, the settings and the daily schedule for you. The setup guide shows every click.
No. Test mode is on when you install it: every message comes to you first, marked [TEST], with a line saying who it would have gone to. You switch test mode off in the Settings tab when you are happy with it.
Google asks you to approve any script that reads your sheet or sends email from your account. Because the script runs in your own account rather than as a published app, Google shows its standard warning screen. The setup guide explains each button.
No. Everything stays inside your own Google account. The script cannot contact any other website, and we never see your sheet or your emails.
It stops at 50 a day unless you change that in Settings. Google's own limit is about 100 recipients a day on a free Gmail account and 1,500 on Google Workspace.
No. You pay once. It runs on Google's free Apps Script service in your own account, so there is nothing to renew.
Reviews
No reviews yet. If you have bought this product, yours could be the first.
You might also like
- AutomationDownload
Annual Service Reminders
Emails past customers when their boiler or appliance service is due, so the repeat work books itself
£39.00 - AutomationDownload
Deposit & Stage Payment Chaser
Reminds customers before each deposit or stage payment is due, chases after, and adds statutory interest for business customers
£29.00
