NORTHERN dark gradient background
Case Study

Drop the File,
Jobs Go Out.

Every week DT Leak Protection Group get a spreadsheet of tank monitor jobs from across the UK. Someone had to sort it, split it by area and send each engineer their share. We built a tool that does it from one upload.

  • WHO — DTLPG (DT Leak Protection Group), part of DT Technology Group
  • WHAT — Custom Web App, Workflow Automation, n8n, Email Dispatch, Hosting & Support
  • WHEN — Live since March 2026, supported since
  • WHERE — Engineers covering England, Wales & Scotland
  • HOW — A password-protected upload page in PHP, feeding a self-hosted n8n workflow that emails each engineer their jobs
DTLPG weekly job distribution upload page DTLPG upload page, earlier blue theme DTLPG password sign-in n8n workflow: webhook, parse spreadsheet, group jobs, send emails DT Technology Group website
The Results

One Upload,
546 Jobs Dispatched.

546
Jobs Dispatched In One Run, 2 Oct 2026
3
Engineers Emailed Their Own List
The Problem

One Big Sheet,
Many Engineers.

DT Technology Group install and look after oil, liquid and LPG tanks, and run a tank monitor service. Each week the jobs arrive as one Excel file: site, address, postcode, priority, tank ID and contact numbers. Splitting that file by hand, engineer by engineer and postcode by postcode, took time and was easy to get wrong.

  • Weekly job spreadsheet covering the whole UK
  • Jobs need sorting by priority
  • Each engineer should get only their own area
The Problem
The Tool
The Tool

One Page,
One Button.

We built a single web page on DTLPG’s own domain. You drag the weekly Excel file onto it and it checks the file first. You see how many jobs there are, how they split between engineers, and anything that needs attention, before a single email goes. Then you press Send Jobs and confirm.

  • Drag-and-drop upload for .xlsx and .xls
  • Preview of the split before anything is sent
  • Confirmation step, because it can’t be undone
  • Branded with the DT Technology logo
Messy Data

Reads the Sheet
However It Comes.

Spreadsheets change. Columns get renamed, moved or added. The tool matches headers loosely, so “Post Code”, “pcode” and “Postcode” all work. When DTLPG started sending a planner format with an Urgent column and word-based priorities, we added support for it. Multi-sheet workbooks are flattened to the active sheet before they go out.

  • Loose header matching with a list of known aliases
  • Number and text priority schemes both understood
  • Jobs re-sorted with the highest priority first
  • Multi-sheet planner files handled
Messy Data
Catching Problems
Catching Problems

No Number,
No Wasted Trip.

An engineer can’t book a visit without a phone number. The tool flags any job where the contact is blank, a dash, “#N/A” or too short to be real, and puts those jobs on a separate missing-contact list instead of in an engineer’s inbox. It also spots when the same file is uploaded twice within two hours, so nobody gets their jobs twice.

  • Placeholder and short phone numbers caught
  • Missing-contact jobs listed separately
  • Duplicate uploads blocked for two hours
  • Every upload written to an audit log
Routing

The Postcode
Decides.

Each engineer owns a set of postcode areas. The tool uses the longest match first, so a district like G72 can go to one person while the rest of G goes to another. When the team changes, we change the rules. In October 2026 DTLPG asked us to give all 16 Scottish postcode areas to a new engineer. The change was live and his first list was sent the same day.

  • Longest-prefix postcode matching
  • Rules updated as engineers join or areas move
  • New Scottish engineer added and dispatched in a day
Routing
The Automation
The Automation

Four Steps,
Every Friday.

Behind the page is an automated workflow. It started on Make.com and in June 2026 we moved it to n8n, self-hosted on our own server. It takes the uploaded file, reads it, groups the jobs by engineer and sends each engineer an email with their own sorted spreadsheet attached. No copy and paste, no forgotten areas.

  • Webhook, parse, group, send
  • Moved from Make.com to self-hosted n8n
  • Each engineer gets their own spreadsheet by email
Kept Running

Locked Down,
Looked After.

The tool sits behind a password gate with hardened sessions, because it handles customer addresses and phone numbers. We host it, watch the weekly runs and make changes when DTLPG ask, from new engineers and moved areas to new spreadsheet formats and email providers.

  • Password gate with hardened sessions
  • Hosted and supported by Northern
  • Changes made as the business changes
Kept Running

DTLPG

A weekly admin job turned into one upload.

Got a spreadsheet job that eats your week?

Gallery

Screenshots
& Photography

DTLPG weekly job distribution upload page
DTLPG upload page, earlier blue theme
DTLPG password sign-in
n8n workflow: webhook, parse spreadsheet, group jobs, send emails
DT Technology Group website
Disclosure

The job distribution tool and automation shown were built and are supported by NORTHERN for DTLPG. Screenshots show the interface only; no customer or job data is shown. The DT Technology website and logo belong to the client and were not made by NORTHERN. Presented to demonstrate capability.

Continue Exploring

More from the Northern portfolio.

Aggregate
Results & KPIs
Real numbers across 80+ case studies.
All Work
Every Case Study
80+ projects across 40+ industries.
Social Proof
★ Client Reviews
Every Google review, end to end.
Google Reviews

What clients say about our work

Real reviews from real businesses.

5.0 (37 Google reviews)

I have really enjoyed working with Dave at NORTHERN Design and Marketing. Dave was quick to understand me and my wish to move away from WordPress and heavy-duty software and systems. I can now manage my own website quickly and easily on HTML5. He has interpreted my wishes - and brand values - to a T. I love my new website and brand.

J
Joanne Dolezal
Web Design, Branding

Working with NORTHERN on the HERMIT UNIVERSE website has been a superb experience. Translating such a complex, visually rich and philosophically driven creative project into an immersive digital layout was no straightforward undertaking. NORTHERN approached it with embracing the concept, steady and extremely efficient work flow, patience and a genuine understanding of the vision. The result is a distinctive website that is receiving excellent, supportive feedback and captures the identity of Hermit Universe. We would very much recommend NORTHERN to anyone looking for a thoughtful, creative and collaborative approach to web design.

8
8 SOLO (Hermit Universe)
Web Design

Dave has worked with two of my clients so far on projects I've written copy for. One was web design and development and one was a brand ID refresh and web. Design and development have been great in both cases. Simple, effective design, and incredibly fast without losing any quality. Dave cares about the outcome, is fair to clients, and listens to suggestions. All of these things are very reassuring.

G
Graeme Jordan
Web Design, Branding
NORTHERN dark gradient background
Free Audit

What's costing you growth?
Let's find out. For free.

Give Dave your website address. He'll look at your site and marketing, find what's not working, and email you exactly where to focus. No waffle. Just a canny plan you can act on.

No contracts No obligation Reply within 24hrs

Request Your Free Audit

Takes 30 seconds. No jargon, just results.

Get In Touch

Let's Colour-in
Together.

Ready for a colourful conversation about your next big idea? We'll bring the crayons, you bring the dreams — and maybe biscuits.

Email
hello@northern.digital
Phone
Location
North East Business & Innovation Centre, Enterprise Park East, Wearfield, Sunderland SR5 2TA
Send Us a Message
No jargon, just results. Fill in the form below and we'll get back to you within 24 hours.


5.0 from 37 Google reviews
80+ Case Studies
13+ Years Experience
12 LinkedIn Recommendations
Add us as a preferred source on Google
Google Partner · Meta Partner · Adobe Certified · WCAG 2.1 AA · Disability Confident · Living Wage