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- 01FormReact, TypeScript, Vite and client-side validation
- 02WebhookSecure transmission to an n8n workflow
- 03AutomationIdentifier, status, Google Sheets and SMTP email
- 04OperationsDocker, Nginx, HTTPS, Ubuntu VPS and SSH tunnel
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
- 01FormReact, TypeScript, Vite and client-side validation
- 02WebhookSecure transmission to an n8n workflow
- 03AutomationIdentifier, status, Google Sheets and SMTP email
- 04OperationsDocker, Nginx, HTTPS, Ubuntu VPS and SSH tunnel
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