Midlumes Consultancy Services Ltd Book health check
Home Services About Blog HisaabPe Book health check midlumes.com ↗

Case study · Business systems

How I built a lead system that only lets real enquiries through

Free tools, UK GDPR-ready, and designed the way I would design it for a client. Here is the process, step by step.

Case study cover: How I built a lead system that only lets real enquiries through. Free tools, UK GDPR-ready, designed the way I'd design it for a client.

The problem: enquiries that leak

Most small businesses don't lose customers because of price. They lose them because an enquiry lands in the wrong inbox, waits days for a reply, or comes from a fake address that wastes everyone's time.

When I set up Midlumes Consultancy Services, I had the same problem to solve. Before writing any code, I treated it the way I would for a client: as a business process, not a website.

Small businesses rarely lose customers on price, they lose enquiries: it lands in the wrong inbox, it waits days for a reply, or it comes from a fake or mistyped email.

Step 1: Requirements before code

I wrote down what the system had to do, in plain language, as I would in a discovery session:

  1. Capture genuine enquiries only. No fake emails and no spam in the inbox.
  2. Never lose a lead. Every enquiry is stored in one place.
  3. Alert me straight away, so I can reply the same day.
  4. Collect only what's needed: name, contact details, area of interest and a short message.
  5. Follow UK GDPR from day one, at almost no running cost.
Step 1, requirements: capture genuine enquiries only, never lose a lead, alert me straight away, collect only what's needed, UK GDPR from day one at almost no cost.

Step 2: How the enquiry flow works

Only verified enquiries reach the lead sheet
  1. Visitor fills in a short form
  2. One-time code sent to their email
  3. Code correct? No: re-enter or resend the code Yes
  4. Server checks the input
  5. Saved to one lead sheet
  6. Instant email alert
  7. Reply the same day

A visitor fills in a short form and gets a 6-digit code by email. Only a confirmed code lets the enquiry through, so fake and mistyped addresses stop there. The server then checks the details again, saves the enquiry in one Google Sheet and sends me an alert.

A few small safeguards do a lot of work:

  • The code expires after 10 minutes, and wrong guesses are limited.
  • The number of codes one email address can request each hour is capped, which stops abuse.
  • Every value is length-limited before it reaches the sheet, and text that could run as a spreadsheet formula is neutralised.
  • Details shown in the email alert are escaped, so nobody can inject code through the form.

Step 3: Data protection built in

A lead system holds personal data, so I designed the safeguards in rather than adding them later:

  • Ask for less: no ID, financial or health details through the website.
  • Consent where it's collected: every form has a consent tick box linked to the privacy policy.
  • One store: enquiries live in a single sheet, not scattered across inboxes.
  • A retention rule: enquiries that don't become clients are kept for 24 months from the last contact.
Step 3, data protection: ask for less, consent where it's collected, one store you control, and a retention rule for old leads.

How I built it: a business analyst, with AI

I set the requirements, designed the process, made every decision, and reviewed and tested the result before launch. I used Claude, an AI assistant, to help write and check the code, draft and review copy, and spot gaps in security and privacy.

That combination is the real lesson. AI speeds up delivery, but it doesn't replace knowing what to build and why.

Designed by a business analyst, built faster with AI. My job: set the requirements, design the process, make every decision, review and test before launch. Claude helped: write and check the code, draft and review copy, spot gaps in security and privacy.

What this means for your business

The same pattern works for a trades business in Kent, a clinic in Riyadh, a coaching practice in Dubai or a trader in Delhi. The tools change; the process doesn't:

  1. Decide what a good enquiry looks like.
  2. Capture only that, with consent.
  3. Store it in one place you control.
  4. Get alerted fast, and track every lead to a reply.

Are enquiries slipping through the cracks?

In a free 20-minute call, I'll map your lead process and show you where it leaks. You leave with at least one fix you can make this week.

Book a free health check