Enterprise Case Study · Digital Transformation

Glam Color Studio

End-to-End AI-Powered Automation for a Premium Beauty Salon — Cali, Colombia

Client
Glam Color Studio
Industry
Premium Beauty & Wellness
Location
Cali, Colombia
Engagement
Full-Stack Automation Sprint
Primary Stack
Node.js · Supabase · Claude AI
Records Processed
1,405 legacy client records
1,405
Legacy Records Migrated
7
System Components Built
18
Services Automated
24/7
Autonomous Bot Coverage

Project at a Glance

Glam Color Studio operated a 1,400+ client portfolio managed entirely through manual processes within the Litzo ERP platform — with zero digital customer engagement, no automated communication layer, and an undifferentiated web presence that failed to reflect the brand's premium positioning.

This engagement delivered a full-stack digital transformation: a branded marketing website, an AI-powered WhatsApp conversational agent, a custom CRM dashboard seeded with real client data, an automated Litzo data pipeline, birthday campaign automation, and a production-ready deployment architecture — all engineered within a single intensive development sprint.

Operating Environment Prior to Engagement

Operational ChallengeBusiness Impact
Client records stored exclusively in Litzo ERP with no external access layerZero ability to trigger automated outreach or segment client base
No digital communication channel between appointmentsHigh client churn risk; no re-engagement mechanism for inactive clients
Static or absent web presenceBrand visibility gap; premium positioning undermined by digital absence
Manual birthday and follow-up campaignsMissed revenue opportunities across 839+ clients with confirmed birthdays
No conversion layer on Meta ad spend15 conversations generated from paid campaigns with zero confirmed bookings
No structured stylist data capture post-serviceRecurring service history unavailable for personalized recommendations

Seven-Component Integrated Digital System

The solution was architected as a cohesive seven-component ecosystem, where each layer feeds data and context into the next, eliminating manual intervention across the full client lifecycle — from initial discovery to post-service re-engagement.

01
Premium Marketing Website
HTML/CSS/JS · Cloudflare Pages
Brand anchor and primary conversion surface — cream/sand/gold palette, Playfair Display + DM Sans typography
02
AI-Powered WhatsApp Agent
Claude Haiku API · Express.js · Railway
Autonomous 24/7 client qualification and consultation with dual-track architecture for new vs. returning clients
03
Custom CRM Dashboard
HTML/JS · Supabase PostgreSQL
Unified client intelligence hub loaded with 1,404 real Litzo records — no third-party CRM subscription required
04
Litzo Data Pipeline
Node.js · Puppeteer · Cron
Automated extraction from legacy ERP — continuous sync without manual export intervention
05
Make Automation Middleware
Make (Integromat) · Excel → Drive → DB
Zero-infrastructure-overhead data sync pipeline — Excel export triggers full CRM upsert flow
06
Birthday Campaign Engine
Python · Pillow · Antonio Font
Personalized mass-communication at scale — 839 clients, zero marginal cost per unit, fully automated image generation
07
Post-Service Follow-Up Flows
Make · WhatsApp Business API
Automated re-engagement and loyalty retention — 48h, 7d, 30d cadence triggers post-visit

Legacy CRM Analysis: 1,405-Record Litzo Export

A full forensic analysis was conducted on the Litzo Excel export, revealing critical data quality gaps that informed both the migration strategy and the segmentation logic for automated campaigns.

Phone Number (WhatsApp)
93.6%
1,315 records — Primary WhatsApp outreach channel
Email Address
74.8%
1,051 records — Secondary email campaign channel
Date of Birth
59.7%
839 records — Birthday automation engine active
Neighborhood / Address
0%
0 records — Geo-segmentation requires enrichment
Referral Source
3.6%
51 records — Attribution modeling requires enrichment

WhatsApp Bot: Brand Voice Specifications

The WhatsApp agent was engineered with a dual-track architecture that dynamically routes clients based on CRM recognition — delivering a personalized, contextually-aware experience to returning clients while efficiently qualifying new prospects.

Pronoun Register
"nosotros" — never "nosotras"
Gender-neutral for brand inclusivity
Tone Archetype
Warm premium advisor — not chatbot
Reflects salon's expert consultant positioning
Approved Endearments
"hermosa", "preciosa", "cariño"
Warmth without infantilization
Diminutives
Strictly prohibited
No "preguntitas", "fotito", "servicitos"
Emoji Usage
Moderate — elegance over frequency
✨ 💫 🌸 — contextual, never decorative
Response Length
Maximum 3–4 lines per message
Mirrors natural WhatsApp conversation rhythm

Conversational Flow Logic

StepBot ActionData Captured
1. IdentificationPhone number checked against Supabase CRMNew vs. returning client flag
2a. New ClientWarm welcome greeting + service inquiryService category of interest
2b. Returning ClientPersonalized greeting with name + visit historyConfirmation of intent
3. Service QualificationInquiry into desired procedureSpecific service requested
4. Chemical HistorySingle consolidated prior-process question (if color)Last chemical treatment date/type
5. Photo RequestRequest back-of-head photo + reference inspirationVisual assessment data
6. Human HandoffGraceful escalation to human advisorFull context passed to stylist

Enterprise-Grade, Cost-Efficient Infrastructure

The architecture was deliberately selected to maximize operational capability while maintaining optimized cost structures — leveraging serverless and edge deployment paradigms that eliminate traditional infrastructure overhead entirely.

Node.jsExpress.jsClaude Haiku API Supabase PostgreSQLRailway.appCloudflare Pages Make (Integromat)PuppeteerPython Pillow Meta WhatsApp APInode-cronGoogle Drive Playfair DisplayAntonio Fontffmpeg
LayerTechnologyRoleCost Model
FrontendHTML/CSS/JS + Cloudflare PagesMarketing site + CRM UIZero-infrastructure overhead
AI EngineClaude Haiku API (Anthropic)WhatsApp bot intelligencePay-per-token, optimized margins
Bot ServerNode.js + Express + RailwayWebhook handler + API orchestratorCost-efficient serverless runtime
DatabaseSupabase (PostgreSQL)Client CRM + campaign dataHigh-throughput serverless DB
AutomationMake (Integromat)Data pipeline middlewareEvent-driven, zero-compute overhead
ScrapingPuppeteer + Node-cronLitzo ERP data extractionSelf-hosted scheduled extraction
Image EnginePython + PillowBirthday personalizationZero marginal cost per unit
MessagingMeta WhatsApp Business APIOutbound + inbound messagingPer-conversation pricing model

Delivered Value & Strategic Expansion

All core deliverables were reviewed and approved by the client during a live presentation session. Diego confirmed approval of the website design and system architecture, commissioning a Phase 2 expansion immediately.

Premium marketing website — approved by Diego in live review session
Custom CRM dashboard with 1,404 real client records — fully operational
AI web chat bot — trained on 18 real services and prices from Litzo
Supabase database schema — all 4 modules deployed and seeded
Litzo Puppeteer scraper — production-ready, cron-scheduled
WhatsApp bot server — Railway-ready, pending Meta API credentials
Birthday automation engine — validated with Pillow + Antonio font
Bot demo simulation — presented to and approved by Diego

Phase 2: Approved Expansion Roadmap

2A
Module Expansion
Full Litzo integration across all modules (services, finance, inventory)
Complete operational visibility beyond client data
2B
Retention
Post-service follow-up automation — 48h, 7-day, 30-day cadence
Measurable reduction in client churn rate
2C
Revenue
Birthday campaign full activation — 839 confirmed-birthday clients
High-ROI re-engagement at scale, zero marginal cost
2D
Analytics
Social media analytics integration for paid campaign optimization
Direct attribution for Meta ad spend recovery
2E
Conversion
Meta ads campaign restructure — 15 conversations / 0 bookings → conversion layer
Direct revenue recovery from existing ad investment

"The measure of a digital transformation is not the technology deployed — it is the degree to which every client interaction becomes effortless, personal, and intelligently orchestrated."

Glam Color Studio Digital Transformation · Portfolio Case Study