Home / Auto repair and detailing / SB-019
Draft mileage and date service reminders from your shop's visit records
Use your shop's visit records and interval sheet to draft mileage or date based service reminders, ready for a person to review and send.
- Who it suits
- Auto repair and quick service shop owners and front counter staff
- Time saved
- About 2 hours per month for a shop with a few hundred active customers (estimate)
- Level
- Advanced
- Updated
- Oct 14, 2026
Why this task
A two-bay shop writes the next service mileage on a window sticker, and the customer peels it off within a week. Six months later the car comes back with old oil, or goes to the chain shop down the road. An agent can read the shop's visit records each month, work out what is coming due by date and by the mileage on the last repair order, and draft a short reminder for each customer that a person checks and sends.
You draft service reminders for [SHOP NAME] from our visit records. A person at the shop reviews every reminder before it goes out. Our reminder intervals (the only source for when a service is due): [PASTE INTERVAL SHEET, for example each service with the miles and months your shop uses] Today's date: [DATE] Look-ahead window: [NUMBER] weeks How to book: [PHONE NUMBER OR BOOKING LINK] Stop-reminder wording: [WORDING] Include declined work: [YES OR NO] Visit records, one row per vehicle: [PASTE ROWS: FIRST NAME, CONTACT PREFERENCE, YEAR MAKE AND MODEL, LAST VISIT DATE, ODOMETER AT LAST VISIT, SERVICES DONE, DECLINED WORK, NOTES] For each row: 1. Work out which services come due within the look-ahead window by date, using the interval sheet and the last visit date. For mileage, give the due mileage as the odometer at last visit plus the interval. Do not guess how far they have driven since. 2. Give the row one status with a reason: DUE BY DATE, CHECK MILEAGE (due mileage known, date not reached), NOT DUE, or SKIP (do not contact, sold the vehicle, or missing data). 3. For DUE BY DATE and CHECK MILEAGE rows, draft a text of 30 to 60 words, or an email of 70 to 120 words if they prefer email. Greet them by first name, name the vehicle, say which service is coming up with the due date or due mileage from your math, give how to book, and end with the stop-reminder wording. 4. Mention declined work only if include declined work is YES, and then only in neutral words copied from the record. Never add a price, a coupon, a recall, a warranty statement or a warning that the vehicle is unsafe. If a note mentions brakes, steering or a safety concern, mark the row CALL CUSTOMER and draft nothing. Return a table with customer, vehicle, status, reason, due math and draft. Do not send anything.
Replace each highlighted placeholder with your own details before you run it.
Steps
- Write your shop's reminder intervals in one place, for example oil service, tire rotation, brake fluid and cabin air filter, each with the miles and months your shop uses. These are your own intervals, so set them with your technicians.
- Write your contact rules: hours you text, how often a customer can hear from you, and who to skip.
- Export last year's visit records from your shop management software with the columns the prompt asks for. Remove payment details and street addresses first.
- Run the prompt below on 25 rows. Check the due math on each row by hand until you trust it.
- Run the rest of the export in batches. Read every SKIP row and every draft, and fix any date or mileage that looks wrong.
- A person approves every reminder and sends it from your shop's texting app or email, within your contact hours.
- Mark customers who book so they do not get a second reminder, and update the export each month.
- Check local rules on reminder and marketing texts with someone who knows them, and keep the stop-reminder line in every message.
- Agent mode: this suits a monthly scheduled run if your software can export on a schedule. A one-off chat is the safer place to start.
What you get
A table with one row per vehicle showing its status, the due date or due mileage with the math visible, and a short reminder for each customer who is coming due. Rows to skip carry a reason, safety notes go to a phone call, and no message carries a price, coupon or warning the shop did not write.
What can go wrong, and the check for each
A due date or mileage is worked out wrong and the customer gets a confusing reminder.
CheckThe prompt shows the due math on every row, the owner checks the first batches by hand, and a person approves every message.
The agent guesses current mileage or invents a maker's schedule.
CheckThe prompt uses only the shop's interval sheet and the odometer on the last repair order, and never estimates miles driven since.
Customers who asked not to be contacted, or who sold the car, still get texts.
CheckSKIP rows are listed with reasons, the owner reads them, and bookings are marked before each batch.
Declined work is mentioned in a way that feels like a scare tactic, or a safety note turns into a text.
CheckDeclined work appears only when the owner turns it on, in neutral words, and safety notes become CALL CUSTOMER with no draft.
A full customer export sits in a chat tool.
CheckRemove payment details and addresses before pasting, use only accounts your business has approved, and delete old exports you no longer need.
Related playbooks
Turn a technician's repair notes into a clear customer explanation
Turn your technician's shorthand repair notes into a plain explanation for the customer, with prices only from the repair order.
Write a pickup follow-up text with a review request
Draft a personal follow-up text after a customer picks up their vehicle, with care tips from your own sheet and a polite review request.
Explain a repair estimate in plain words with good, better, best options
Rewrite your own repair estimate as a plain explanation with good, better and best options, using only your prices and warranty terms.