Ifeoluwa Samuel
Back to work

Case Study 01

Automated Lead Capture & CRM System

Captures leads from web forms, logs them into a CRM database, and sends instant confirmation emails, removing manual data entry entirely.

  • Make.com
  • Tally Forms
  • Google Sheets
  • Gmail
  • Webhook

The business problem

Enquiries arrived through a web form and then sat in an inbox until someone had time to read them. Details were copied into a spreadsheet by hand, so records were incomplete, duplicated, or lost, and nobody could tell which leads had already been contacted. Prospects often waited a full day for a reply, and by then many had already booked with a competitor.

The solution

A webhook picks up each form submission the moment it is sent. The workflow parses and cleans the fields, splits the full name, normalises the phone number and service selection, then writes a fully structured row into the shared Google Sheet that acts as the CRM. A personalised confirmation email goes out to the prospect within seconds, and the row is stamped with the submission time and source so the team always knows where a lead came from and how long it has been waiting. Every step has error handling, so a failed write raises an alert instead of silently dropping a lead.

Walkthroughs for this build

Automated Lead Capture & CRM System workflowAutomated Lead Capture & CRM System workflowAutomated Lead Capture & CRM System workflowAutomated Lead Capture & CRM System workflowAutomated Lead Capture & CRM System workflow

Want a system like this in your business?

Every build starts with a short conversation about where the manual work actually lives.

Book a Discovery Call
Next projectAutomated Invoice Generation Workflow