CASE STUDY · SERVICE REPORT AUTOMATION
How We Automated Service Reporting for a Hot Tub Service Business
Reporting went from approximately 4–6 hours per week to under 1 minute per customer after implementation - delivering reports on the spot, tracking chemical lifespans, and eliminating post-job administrative stress.
The Problem: 4–6 Hours of After-Hours Paperwork & Tool Hopping
Flush and Fill is a husband-operated hot tub water-care business in Minneapolis, Minnesota, owned and operated by Brad. The business services sub-50 recurring customers every two weeks with quarterly invoicing.
The Late-Night Reporting Bottleneck
Brad was already performing rigorous physical service work on-site - testing water chemistry, sanitizing shells, cleaning filters, and inspecting pumps. However, delivering a polished, professional service report to homeowners required an exhausting administrative process after his physical workday ended.
Brad spent 4 to 6 hours every week after work hours manually assembling customer reports. He recalled "losing sleep" just to maintain high customer service quality and ensure homeowners received clear service verification.
Tool Hopping & Memory-Based Chemical Tracking
Without a unified mobile tool, Brad had to constantly jump between Wix for client details, Google Sheets for job logs, and manual fillable forms for PDF generation. Furthermore, chemical dosage history and component lifespans were tracked purely off the top of his head as ballpark estimates - making it difficult to systematically predict filter or water replacement dates for clients.
The Goal: 1-Minute On-Site Reporting Using Tools They Already Owned
The goal was to replace late-night paperwork with a 1-minute on-site mobile workflow while seamlessly integrating tools Brad was already using.
Under 1 Min per Customer
Complete full customer service reports on-site immediately after finishing the physical water care.
On-the-Spot Delivery
Generate and send completed PDF reports to homeowners instantly before leaving the property.
Effortless Customer Creation
Add new clients seamlessly into the system without manual multi-app re-entry.
Leverage Existing Tools
Connect directly to Wix, Google Sheets, and Drive so Brad never had to learn complicated new software.
Track Chemical Stats
Store structured pH, alkalinity, and sanitizer history per customer automatically over time.
Component Lifespan Tracking
Monitor chemical usage and filter lifespans per customer to accurately schedule replacement dates.
Mobile Photo Capture
Upload before and after hot tub photos directly from phone camera into the final PDF template.
Restore Peace of Mind
Eliminate after-hours administrative work so Brad no longer lost sleep over reporting backlogs.
What We Built: Technician UI Connected to n8n Automation
Phantos built a lightweight technician-facing mobile interface connected to an n8n automation pipeline. The application allows Brad to select prepopulated customer profiles, log chemistry parameters via drop-down picklists, capture photos, track component lifespans, and trigger automated PDF generation via Gotenberg.
How the Service Report Automation Works
Here is how the automated service report workflow operates during and immediately after a hot tub service visit.
Customer Information Is Prepopulated
When Brad selects a scheduled customer, known metadata - such as client name, address, email, hot tub model, and service history - is retrieved automatically so it never has to be re-typed.
Structured Chemistry & Lifespan Logging
Brad inputs water chemistry readings (pH, alkalinity, sanitizer) using pick-lists. Component lifespans and chemical dosing histories are automatically logged per customer to calculate future replacement dates.
On-Site Photo Capture
Brad takes before and after photos directly within the mobile interface - capturing water clarity, shell condition, and filter state.
Instant Webhook Submission to n8n
Tapping submit sends structured JSON data to an n8n webhook endpoint, triggering the automated background orchestration.
Automated PDF Generation via Gotenberg
The n8n workflow merges customer metadata, chemical test readings, replacement date tracking, and photo URLs into an HTML template, which Gotenberg converts into a crisp PDF.
Automatic Drive Archiving & Database Sync
The completed PDF is saved to the customer’s Google Drive folder, while Google Sheets logs the job URL, chemistry stats, and component lifespan timers.
On-the-Spot Report Delivery
Brad previews the generated PDF right on his phone and sends it to the customer on the spot - completing the entire process in under 1 minute per client.
Before vs. After Service Report Automation
The goal is not to eliminate human oversight, but to shift repetitive administrative work out of Brad's post-job routine and into an automated workflow.
Technical Architecture & Stack
The technician-facing application acts as the input layer. n8n handles orchestration - retrieving customer metadata, processing chemical readings, passing data and photo URLs through Gotenberg for PDF conversion, saving files to Google Drive, updating Google Sheets logs, and triggering customer delivery.
Lightweight, mobile web app optimized for outdoor sunlight and quick 1-minute pick-list data entry.
Workflow automation platform managing webhook endpoints, Wix API hooks, data transformations, and conditional flows.
Structured backend storing customer profiles, chemical histories, and component lifespan timers for replacement dates.
Cloud storage system archiving generated PDF service reports in structured customer folders.
Docker-based microservice converting HTML/CSS templates and photo URLs into crisp, print-ready PDF files.
Automated email pipeline allowing Brad to preview and send reports directly to homeowners on the spot.
The Owner Experience: From Late-Night Paperwork to On-Site Relief
"Before the automation, I was spending 4 to 6 hours a week after work creating reports - literally losing sleep to ensure quality consumer service."
Reporting went from approximately 4–6 hours per week to under 1 minute per customer after implementation. Today, Brad completes service reports directly from his phone while still on site. Reports are delivered to homeowners on the spot, new customer creation is effortless with reduced repetitive re-entry of customer and service information, and past report histories are accessible directly through tools he already owned (Wix and Google Sheets).
Furthermore, water chemistry trends and equipment component lifespans are logged automatically per customer - turning what used to be ballpark mental estimates into reliable data for filter and chemical replacement dates.
Operational Impact Summary
By shifting administrative work into a structured workflow, Brad realized clear operational improvements across daily service routines.
4–6 Hrs/Week Saved
Completely eliminated late-night report creation sessions and restored after-hours sleep.
<1 Minute per Customer
On-site mobile web UI allows completing and delivering reports before driving to the next job.
On-the-Spot Report Delivery
Homeowners receive formatted PDF reports with photos instantly while service is fresh.
Eliminated Multi-App Hopping
Connected Wix, Google Sheets, and Drive into a single background pipeline.
Automated Lifespan Tracking
Chemical stats and component lifespans logged per customer to accurately predict replacement dates.
Effortless Customer Onboarding
New customer profiles and service histories created smoothly, with reduced repetitive re-entry of customer and service information.
Why This Is More Than a PDF Generator
Generating a PDF is only one step in a complete business process. The real power of service report automation lies in connecting data collection directly to business records, document repositories, component lifespan tracking, and customer delivery channels.
Phantos builds end-to-end operational pipelines that connect data collection → business records → document generation → storage → customer delivery. Rather than deploying isolated AI chatbots or single-purpose plugins, we integrate custom automation around your team’s existing software.
Service Report Automation FAQ
Answers to common questions about automating field service reports for home service businesses.
Have a Similar Manual Workflow in Your Business?
If your technicians or office staff are still turning completed jobs into reports, emails, spreadsheets, or documents manually after every service call, that workflow can be automated.