Automation Case Study
Lead Generation &
Tracking System
A fully automated pipeline that captures website leads, organises them in real time, and sends personalised welcome emails — without a single manual step.
A fully automated pipeline that captures website leads, organises them in real time, and sends personalised welcome emails — without a single manual step.
Most small and mid-size businesses rely on website contact forms — but what happens after someone fills one out? The answer was always the same: a spreadsheet, a delay, and a missed opportunity.
Every lead from a web form had to be copied by hand into spreadsheets. Staff spent 2–4 hours daily just transcribing contact data — time that could have been used for actual sales conversations.
Without a centralised system, hot leads were buried in email inboxes or forgotten entirely. Research shows responding within 5 minutes is 9× more effective — that window was regularly missed.
There was no easy way to see how many leads came in, which pages drove conversions, or which sources performed best. Business decisions were made on gut feel rather than data.
Welcome emails were sent manually — if at all. A lead who did not hear back within 24 hours was effectively lost to a faster-responding competitor.
The entire pipeline triggers automatically the moment a visitor submits a form. No human intervention needed at any stage.
Each node has one clear job. Together they form a reliable, error-tolerant pipeline that runs silently in the background — 24 hours a day, 7 days a week.
Connects to the client's website via a secure HTTPS endpoint. Fires instantly when any contact or lead form is submitted, passing all field values to n8n in real time.
Appends a structured row with lead name, email, phone, source page, and timestamp. Acts as a live CRM the business can filter, sort, and share at any time — on any device.
Sends a personalised welcome email using the lead's first name. The email confirms their inquiry, introduces the business's services, and invites the next action — within seconds of submission.
Built in four deliberate phases, each solving a distinct part of the problem. The result is a pipeline that is resilient, scalable, and requires zero daily management.
A secure webhook was configured in n8n and connected to the client's existing website forms using an HTTPS POST connector. No changes needed to the site's code — the integration is invisible to visitors but fully active in the background.
The n8n workflow reads every submitted form field — name, email, phone, inquiry type, and source page. A Set node cleans and structures the data, removing duplicates and validating email format before it reaches the spreadsheet.
Each verified lead is added as a new row with a timestamp. The business owner gets a real-time, sortable CRM at zero setup cost — accessible from any device, shareable with the sales team, and filterable by date, source, or status.
Within seconds, the lead receives an email that uses their first name, confirms their inquiry, and introduces the business's services with a clear call to action. Fully templated and editable by the business owner at any time.
Automation does not just save time — it directly protects and grows revenue. Here is how this system translates to measurable value for a typical SME handling 30–80 leads per month.
Every tool in this stack is free or low-cost, widely available, and requires no developer to maintain once built. The business owns everything.
n8n is an open-source workflow automation platform that connects any two services without writing code. Unlike Zapier, it can be self-hosted (zero per-task fees at scale), supports complex branching logic, and gives the business full transparency into what is happening with their data.
A short walkthrough showing the workflow from form submission to Google Sheets entry to welcome email — in real time.
Click anywhere here to upload your screen recording. Supported formats: MP4, MOV, WebM.