HVAC & Plumbing
Never Ask a Returning Customer for Their Information Twice
The Challenge
For a residential HVAC and plumbing company, the phone is still how most customers get in touch — whether they’re brand new or had service three years ago. The problem was the office team had no fast way to tell the difference. Every inbound call or form submission started the same way: a dispatcher manually searched ServiceFusion to check whether the caller was already in the system.
On a busy morning, that lookup could take three to five minutes per contact — longer if the phone number didn’t match because the customer was calling from a different line. Dispatchers searched twice: once by email, and again by phone number if nothing came up. When calls were stacking, lookups got skipped entirely and the same customer ended up entered as a duplicate. The operations manager estimated the team was spending close to 6 hours per week on manual lookups and duplicate cleanup combined.
The Solution
We built a reusable lookup module that other automations in the company’s system can call on demand. When any inbound process needs to know whether a contact already exists in ServiceFusion, it passes the customer’s email and phone number to this module. The module searches by email first, then by phone if needed, and hands back a clean result: either the existing ServiceFusion record or a definitive “not found.” If the lookup itself fails, the workflow sends an automatic alert email to the team so nothing falls through the cracks.
Because this is a shared module rather than a one-off automation, every other workflow that needs to check for an existing customer can use the same logic — no redundant development, no inconsistency across processes.
How It Works
- Another automation passes a contact's email and phone number into this lookup module
- The system searches ServiceFusion by email address first
- If a match is found, the existing customer record is returned immediately
- If no email match exists, the system searches again using the phone number
- If neither search finds a match, a "not found" result is returned so the calling workflow can create a new record
- If the lookup encounters an error, an alert email goes to the operations team automatically
- Results are passed back to the originating workflow within seconds
The Results
- Average lookup time dropped from three to five minutes per contact to under 10 seconds
- Office staff recovered an estimated 5 hours per week previously spent on manual ServiceFusion searches
- Duplicate customer records fell by approximately 80% in the first 60 days, reducing cleanup work and improving dispatch accuracy
- Because the module is reusable, it now powers three separate automations — meaning the time savings multiply across every process that touches customer records
- Failed lookups surface immediately via email alert rather than silently passing bad data downstream
The lookup module does quiet, unglamorous work — but the dispatchers notice it every day. Calls move faster, customers don't have to repeat themselves, and the database stays clean without anyone on the team dedicating time to it.
Why It Matters for Your Business
If your team is hand-searching your field service platform every time the phone rings, you’re burning dispatcher time on a task that should take zero seconds. A reusable lookup module means every automation you run checks for existing customers the same way, consistently. Impression Insights builds automations like this for HVAC, plumbing, and field service businesses. Let’s talk.
Ready to build yours?
Impression Insights builds practical automations for small to mid-sized businesses. Let's scope your first workflow.
Book a Discovery Call