The problem
The client was receiving 20-30 property enquiries per week through their website contact form. Every enquiry required manual reading, a judgment call, and a hand-written reply. This was taking 2+ hours daily and leads were frequently missed or replied to hours later, by which point they had contacted a competitor.
What I built
A fully automated lead handling pipeline: every form submission triggers Claude AI to score the lead as Hot, Warm, or Cold with a one-line reason. All leads log to Google Sheets. Hot leads send an instant alert to the agent. Every lead receives a personalised reply within 60 seconds, 24/7.
Results
- 0 minutes/day spent on manual lead replies, was 2+ hours
- Every lead answered within 60 seconds including evenings and weekends
- Full lead pipeline visible in one spreadsheet with AI scores
- Zero missed leads since implementation
Tools
Make.comClaude API (Haiku)Tally.soGoogle SheetsGmail