Automatisation des tournées de maintenance
The data already existed. Someone was still copying it across, row by row.
Preparing a maintenance round took around four hours of data entry. Not because the information was missing — it was already in a Google Sheet — but because nobody had connected that file to the tool it had to be re-typed into.
- Category
- Automation
- Platforms
- Extension de navigateur
Where it started
ElectroCoeur maintains a fleet of defibrillators spread across many client sites. Before each round, every unit’s details had to be entered into their field-service tool: one record per unit, one form to fill each time. The reference data, meanwhile, was already consolidated in a spreadsheet.
This is the classic case where the problem is not a missing tool but a gap between two tools. The spreadsheet knew everything. The business software needed everything. In between, a person read a row and re-typed it into a form — for about four hours, every time a round was prepared. And with every entry came the risk of picking the wrong row or transposing two digits.
What was built
Rather than replacing the field-service tool or rebuilding the spreadsheet, I closed the gap between them. A browser extension recognises the form as it opens, finds the matching row in the file using the unit’s unique number, and fills the fields in. The person reviews what was filled and confirms. Nothing is submitted without their approval.
What the product does
The existing file stays the reference
No data to re-enter elsewhere, no migration: the spreadsheet the team already uses remains the source.
The right unit, found automatically
Matching runs on the unit’s unique number, which is what guarantees the filled record belongs to the right piece of equipment.
The form fills in seconds
What took around four hours of typing now takes about as long as the page needs to open.
A person stays in control
The extension never confirms the intervention on the user’s behalf. It prepares; a human reviews and submits.
No more copying mistakes
What gets entered is exactly what the source file says. Transposed digits and wrong-row errors disappear.
Nothing new to learn
Same browser, same field-service tool, same file. Only the manual typing goes away.
The decisions that mattered
Automating without removing control
The defining decision was to never let the extension confirm the intervention. It fills, then stops. That is what makes the tool acceptable in an emergency-equipment maintenance context: if a value in the file is wrong, a person catches it before submission, exactly as before. The automation removes the typing, not the responsibility.
Plugging into what exists instead of replacing it
The obvious solution would have been a new tool doing both jobs. That was longer, more expensive, and would have forced the team to abandon software they know well. A browser extension slips between the two tools without changing how either works: setup is measured in days, and the team has nothing to relearn.
A deliberately narrow scope
The extension was kept clear of the rest of the system: it shares no database, no account and no deployment with the application. An automation that touches one screen and does one thing is far simpler to maintain — and if the business tool changes one day, only the extension needs revisiting.
How it fits together
Google Sheets
The file that already holds all the data — left untouched
Extension de navigateur
Finds the right row from the unit’s number
Formulaire métier
Filled automatically, then reviewed and confirmed by a person
The technologies used
Frontend
- Extension Chrome
- JavaScript
Services
- Google Sheets
- Outil de maintenance métier
What was delivered
Preparing a round went from roughly four hours of manual entry to a few seconds, and the risk of copying errors disappeared: what is stored is exactly what the source file says. These durations are the company’s own before-and-after estimate rather than an instrumented measurement. The tool shipped as a companion to the existing file and software, with no change to the team’s habits.
- Extension de navigateur
Need a similar product?
Let’s talk about what you want to build. I reply personally, usually within 24 hours.