Skip to content
All work
Demo ProjectProfessional Services

Small Business Automation

Every enquiry captured, acknowledged, assigned and visible — without manual handling.

Lead Form + CRM + Email + Dashboard

Lead pipeline

Live

12

New

7

Contacted

4

Qualified

2

Won

Auto-reply sent

Admin notified · task created

Illustrative interface mockup · not a screenshot of a live client system

The problem

Enquiries arrive through a website form, a Facebook page and a LINE account. They are re-typed into a spreadsheet when someone remembers. Nobody can say how many leads came in last month, or which ones were never answered.

The challenge

Three separate intake channels had to converge into one record without duplicates, and the owner needed a view of the pipeline that stayed accurate on its own.

The solution

A single lead pipeline. Every channel writes to one database, the client is acknowledged immediately, the team is notified, a follow-up task is created, and a dashboard shows the pipeline as it actually stands.

The system

01One validated lead form feeding a single database
02Deduplication so repeat enquiries update rather than duplicate
03Immediate client acknowledgement email
04Admin notification with the full enquiry detail
05Automatic follow-up task with an owner and a due date
06Lead status pipeline from new through to won or lost
07Dashboard covering new leads, active projects and pending quotes

The result

What changes.

Outcomes described here are the intended effects of this system design. They are not measured results from a live business.

No enquiry sits unacknowledged while somebody is busy
One pipeline replaces three inboxes and a spreadsheet
Follow-up happens on a schedule rather than from memory
The owner can see the state of the pipeline at a glance

Technology used

Next.js
TypeScript
Tailwind CSS
Supabase
n8n
Resend
PostgreSQL