Most of an auto repair shop's revenue is recurring work: the periodic inspection, oil changes by mileage, tyre changeover in spring and autumn, and insurance renewal, which the customer often ties to the shop. All these dates are already in your Tekmetric or Shopmonkey database: mileage at the last visit, the recorded inspection date, the set of tyres in storage. But reminders go out only when the service advisor has a free hour, which is rare. The result is that during tyre season everyone calls the same week, the rest of the year the lifts are half empty, and some customers have the inspection done at whichever place reminded them.
The solution is built from Copilot Studio and Power Automate and runs in your Microsoft 365 tenant. Every week a Power Automate flow takes from a Tekmetric or Shopmonkey export or interface the customers whose deadline is approaching: the periodic inspection by the last inspection date (where the date is not in the database, we check the validity by number plate in the public vehicle registry lookup), oil by mileage and average driving, tyres by season and whether you store their tyres, and insurance by the recorded date. For each customer a Copilot Studio agent generates a personal reminder in your tone with the specific car, two or three suggested times from the Bookings calendar and a booking link. The service advisor gets the weekly list: what to send, to whom and by which channel, removes customers who already booked or asked not to be contacted, and approves. Only then do the reminders go out by SMS, e-mail or Messenger, if the customer talks to the shop there. A customer's reply, for example "Thursday works", is passed to the booking assistant or the service advisor, who records the visit, and a flag for the reminder sent appears in the customer record in the shop software. We connect to Tekmetric and Shopmonkey through their APIs or exports, depending on the version; we choose the method after a check. Data does not leave your environment, customers' marketing consent is checked before they are added to the list, and we maintain the flows together with your Microsoft 365 administration.