Back to projects
AutomationWeb
Production solution

LeadFlow — Lead Management Automation

A web solution that collects sales enquiries, orchestrates their processing with n8n, centralizes leads in Google Sheets and automatically confirms receipt.

Surf Web Development

View public page
LeadFlow — Lead Management Automation
  1. 01FormReact, TypeScript, Vite and client-side validation
  2. 02WebhookSecure transmission to an n8n workflow
  3. 03AutomationIdentifier, status, Google Sheets and SMTP email
  4. 04OperationsDocker, Nginx, HTTPS, Ubuntu VPS and SSH tunnel
ValidationTests

Business problem

A sales enquiry submitted on a website must become actionable immediately, without re-entry or lost information. The form had to connect to a reliable workflow, store every lead in an accessible tool and trigger an automatic response.

My role and contribution

I handled requirements analysis, interface design, React development, n8n workflow creation, Google Sheets and SMTP integrations, followed by securing and deploying the complete solution on a VPS.

  • Analysed the need and designed the submission journey
  • Built a responsive React form with validation and submission feedback
  • Created the n8n workflow and secured webhook exchanges
  • Integrated Google Sheets through OAuth 2.0 and SMTP email delivery
  • Containerized the solution and configured Nginx, HTTPS and Ubuntu deployment
  • Protected the n8n editor behind an SSH tunnel and automated backups

Core features

  • 01Responsive interactive form
  • 02Validation and visual submission feedback
  • 03Secure webhook transmission
  • 04Unique identifier and status for each enquiry
  • 05Automatic Google Sheets registration
  • 06Automatic confirmation email
  • 07Automated backup and deployment scripts
  • 08n8n editor available only through an SSH tunnel

Simplified architecture

LeadFlow — Lead Management Automation
  1. 01FormReact, TypeScript, Vite and client-side validation
  2. 02WebhookSecure transmission to an n8n workflow
  3. 03AutomationIdentifier, status, Google Sheets and SMTP email
  4. 04OperationsDocker, Nginx, HTTPS, Ubuntu VPS and SSH tunnel
ValidationTests

Main technical challenge

Exposing only the endpoint required by the public form while keeping the n8n editor off the public internet, then making OAuth 2.0 and SMTP integrations reliable inside a reproducible containerized environment.

Qualitative outcomes

  • Automatic centralization of leads in a shared register
  • No manual re-entry between the form and tracking tool
  • Immediate acknowledgement after every enquiry
  • A documented, secured and reproducible infrastructure

Limits, confidentiality and lessons

Only the public form is linked from the portfolio. No lead data, OAuth configuration, SMTP information, n8n editor capture or sensitive infrastructure detail is exposed. No quantified gain is claimed without verifiable measurements.

Technologies used

Frontend

  • React
  • TypeScript
  • Vite

Automation

  • n8n
  • Webhooks

Integrations

  • Google Sheets API
  • OAuth 2.0
  • SMTP

Infrastructure

  • Docker
  • Nginx
  • Let’s Encrypt
  • Ubuntu
  • VPS
  • Git