24/7 Digital Legal Intake Engine

A modern digital legal intake and client acquisition system designed to establish a commanding online presence, streamline consultations, and capture qualified leads 24/7.

Desktop View and Mobile View
Desktop View and Mobile View
🔍 Zoom View
Lead Magnet
Lead Magnet
🔍 Zoom View
Booking Form
Booking Form
🔍 Zoom View
Payment Tracker
Payment Tracker
🔍 Zoom View

Introduction

Aquino & Co. Law Firm — 24/7 Digital Legal Intake Engine

Aquino & Co. Law Firm, a general practice firm based in Santiago City, Isabela, Philippines, needed a modern digital acquisition system to establish an online presence and capture prospective client leads around the clock.

The Challenges

  • Dependence on Offline Channels: The firm relied entirely on physical walk-ins and word-of-mouth referrals, limiting growth strictly to traditional foot traffic.
  • Lost After-Hours Inquiries: Without an online platform, prospective clients seeking legal help outside of business hours had no way to reach out, verify firm credibility, or submit inquiries.
  • Lack of Lead Tracking: Inbound client leads were not systematically recorded or centralized, leading to potential follow-up delays and missed consultation opportunities.

The Solution

Engineered a custom, 24/7 digital intake platform paired with an automated pipeline process to educate prospects and capture leads effortlessly:

  • 24/7 Intake Website: Built a professional, responsive site that captures client inquiries around the clock and offers downloadable legal guides to educate visitors upfront.
  • Automated Data Pipeline: Connected custom web forms directly to a real-time Google Sheets database, logging incoming inquiries and client details instantly without manual data entry.
  • Streamlined Workflow: Created an initial response system to acknowledge lead submissions immediately and neatly organize incoming cases for the legal team.

The Results

  • Continuous Client Acquisition: Transformed the firm from a physical-only practice into an online engine capable of capturing leads 24 hours a day, 7 days a week.
  • Full Pipeline Visibility: Provided the legal team with an organized, real-time dashboard to track intake statuses, follow-ups, and prospective client details effortlessly.
  • Cost-Efficient Delivery: Built the entire infrastructure using lightweight, cost-effective tools that eliminated recurring software overhead for the firm.

Backend Implementation & Production Verification

Slide 1 / 2 • Client Alert
Automated Gmail for Client
🔍 Click to Zoom View
Slide 2 / 2 • Law Firm Alert
Automated Gmail for Lawfirm
🔍 Click to Zoom View
⚡

Automated two-way Gmail notification pipeline delivering instant appointment confirmations to clients while immediately alerting the law firm with full intake case details.

Slide 1 / 2 • Visual Studio back-end code
Back-End Code
🔍 Click to Zoom View
Slide 2 / 2 • Search Console SEO
Google search console verified
🔍 Click to Zoom View
🛠️

Production engineering architecture featuring custom Visual Studio back-end code, and verified Google Search Console SEO indexing.

Project Information
Client Name: Atty. Glenn Aquino
Business Name: Aquino and Co. Law Firm
Date Started: December 2025
Date Launch: January 2026 + Ongoing Support
IMPACT

Modernized a walk-in dependent practice into an online automated, cutting off-hours inquiry loss by 100% and enabling round-the-clock client booking and capture leads.

Developer: Joyce Ann G. Yap
Collaboration: Team TPS - Mark Dalumpines, Kent Brian Jintapa, and Errol John Peusca
Built Behind the System

Automation Workflow Framework

Phase 1
Booking Flow
index.html
Homepage — Full Law Firm Showcase
form.html
Booking Form — Structured Client Intake
Google Sheets
Auto-saves to the Appointments tab
Google Mail
Instant alert to Client & Law Firm

How the Booking Flow works

Every visitor who lands on the homepage is guided straight into the booking form. The moment a client submits their details, the appointment is logged automatically to Google Sheets, and an instant email confirmation goes out to both the client and the law firm — no manual follow-up, no missed inquiry.

Phase 2
Lead Magnet Flow
index.html / Contact Form
Get instant access to the Comprehensive Legal Guides
Google Sheets
Leads data auto-saves to Appointments tab
Google Mail
Instant alert to Prospect & Law Firm
legal-Information.html
Access Granted - Legal Information Guides

How the Lead Magnet Flow works

Visitors who aren't ready to book yet are offered free access to the firm's Legal Guides through the homepage contact form. Every request is captured in Google Sheets and triggers an email alert to the firm, while the prospect is instantly granted access to the Legal Information resource hub.

Phase 3
Payment Tracker Upload Receipt
Legal-fees.html
Legal Fees — GCash Receipt Upload
Google Drive
Receipt storage folder
Google Sheets
Payment log
Email
Alert to Law Firm only

How the Payment Tracker Upload Receipt works

Once a client is ready to pay, they upload their GCash receipt directly on the Legal Fees page. The file is stored in Google Drive, the payment is logged in Google Sheets, and the law firm receives an immediate email notification, while the secretary will verify the payment details and references no. - closing the loop from lead to paid client.