CRM & AutomationBestMedSpa.us · Ongoing

Building an Automated Med Spa Marketplace with CRM Lead Routing BestMedSpa.us

BestMedSpa.us is an independent medical spa directory and lead marketplace for the United States, helping consumers compare licensed med spa providers by treatment, reviews, and location, while automatically routing qualified leads into provider CRM pipelines.

Duration: Ongoing
Platform: Next.js, MySQL, GoHighLevel CRM, Google Maps API, Microsoft Clarity, GitHub Actions, cPanel
Channels: Healthcare Marketplace, Product Build & Automation
Apply for a demoWhat we installed

The results, visualized

How BestMedSpa.us performed

Provider Records Imported10,333
Treatment Categories14
US City SEO Pages75+
Max Sitemap URLs49,000
Capture
Qualify
Follow-up
Book / Sell
Report

Overview

Technovier designed and developed BestMedSpa.us from the ground up as a full-stack healthcare marketplace. The platform needed to serve two audiences simultaneously: consumers searching for med spa treatments by location, and providers receiving qualified leads automatically inside their CRM. Technovier built the entire system, database schema, lead wizard, provider matching algorithm, GHL automation, admin dashboard, SEO infrastructure, and review pipeline, without third-party CMS or ORM dependencies.

Next.js 14, TypeScript, MySQL 2, Zod, Jose JWT, Leaflet, GoHighLevel API, Google Maps API, Microsoft Clarity, Selenium, Python, GitHub Actions, cPanel FTP

Problem, Constraints, Baseline, Approach, Results

Problem

Consumers had no trusted, neutral comparison tool for US med spa providers. Providers had no automated way to receive and route qualified treatment leads.

Constraints

10,000+ provider records required a scalable import pipeline. Lead capture had to work without a database in fallback mode. GHL CRM sync had to be zero-manual-entry.

Baseline

No structured provider data, no consumer search flow, no CRM pipeline, no SEO presence.

Approach

Built a Next.js 14 App Router platform with MySQL, a scored lead-matching algorithm, full GHL automation, a Python review scraper, and a programmatic SEO system covering 75+ cities × 14 services.

Results

10,333 provider records imported, 75+ city SEO pages live, up to 49,000 sitemap URLs generated, full GHL pipeline automation operational, admin dashboard managing leads, claims, and featured listings.

100%

Automated GHL Lead Sync

10,333

Provider Records Imported

14

Treatment Categories

75+

US City SEO Pages

49,000

Max Sitemap URLs

13

Database Tables

100%

Automated GHL Lead Sync

10,333

Provider Records Imported

Key metrics shown: 10,333 Provider Records Imported; 14 Treatment Categories; 75+ US City SEO Pages; 49,000 Max Sitemap URLs.

Challenges

1. Dual-Audience Architecture: The platform had to serve consumers (search, compare, contact) and providers (lead intake, CRM routing) from a single codebase without cross-contaminating the UX of each audience.
2. Scale Without an ORM: With 10,000+ provider records and complex multi-table lead matching joins, raw parameterized SQL was chosen over an ORM to maintain query control, performance, and zero runtime overhead.
3. Zero-Downtime Fallback: The platform needed to function fully during database unavailability, every read path required a CSV-backed fallback mode that returns real data without DB access.
4. GHL Automation Without Manual Entry: Every lead submitted through the consumer wizard had to create a GHL contact, opportunity, and note, with pipeline stage updates triggered by subsequent consumer actions, all without any manual admin intervention.
5. SEO Coverage at Scale: Covering 75+ cities across 14 treatment categories required a programmatic SEO system that generated city pages, service-city pages, and clinic profiles with full structured data on every URL.

Services Delivered

  • Full-Stack Marketplace Architecture (Next.js 14 App Router + TypeScript)
  • MySQL Database Design (13 tables, raw SQL, no ORM)
  • Lead Capture Wizard with Location Autocomplete and Provider Preview
  • Intelligent Provider Matching Algorithm (score by location, service, rating, featured status)
  • GoHighLevel CRM Full Integration (contact upsert, opportunity creation, pipeline stage automation, notes)
  • JWT-Authenticated Admin Dashboard (leads, clinics, claims, featured listings, CSV import)
  • Programmatic SEO System (city pages, service-city pages, clinic profiles, dynamic sitemap up to 49,000 URLs)
  • Google Review Scraper (Selenium + Python, stateful pipeline with resume support)
  • Instagram Posts Integration (per-clinic social feed)
  • Microsoft Clarity Analytics (custom events: lead submission, wizard steps, provider actions)
  • AI SEO Content Agent (CLI tool for keyword-driven article generation)
  • GitHub Actions CI/CD (lint to build to FTP deploy to cPanel)
  • Database-Independent Fallback Mode (CSV-backed reads on all data paths)

Lead Routing Automation

Every consumer lead submitted through the BestMedSpa.us wizard is automatically routed into the provider's GoHighLevel CRM pipeline, with no manual data entry, no missed leads, and no pipeline gaps.

Provider Matching Algorithm

Leads are matched to up to 8 providers using a multi-signal scoring algorithm that ranks by geographic proximity (ZIP, city, state), treatment match, Google rating, review count, featured status, and data quality score.

  • ZIP-level proximity matching for hyper-local results
  • Treatment-to-service keyword mapping across 14 categories
  • Featured provider boost for paid placements
  • Rating and review count as tiebreakers
  • Fallback to CSV data when database is unavailable

SEO at Scale

The SEO architecture generates city landing pages, service-city pages, and individual clinic profiles with full JSON-LD structured data on every URL, covering MedicalBusiness, LocalBusiness, FAQPage, BreadcrumbList, Article, HowTo, Dataset, and SpeakableSpecification schema types.

Technical Innovations

BestMedSpa.us was built with several architectural decisions that separate it from standard directory platforms.

• No ORM, Raw Parameterized SQL: All database queries are written in raw mysql2 with parameterized inputs, giving full query control and eliminating ORM abstraction overhead.
• DB-Independent Fallback Mode: Every data read path has a CSV-backed fallback, the platform returns real provider data even when the MySQL database is unreachable.
• Automated GHL Pipeline Stages: When a consumer requests an appointment, callback, or general enquiry through the provider match page, the GHL opportunity stage is updated in real time without any admin action.
• AI SEO Content Agent: A custom CLI tool reads treatment keywords, infers related services, generates MDX article drafts, and writes structured frontmatter, enabling scalable blog production at low cost.

Platform Capabilities Delivered

BestMedSpa.us is a production-grade marketplace with full automation across the consumer journey, provider CRM pipeline, and search engine visibility.

• 10,333 Provider Records CSV import pipeline with deduplication, staging table, and per-row status tracking loaded 10,333 US med spa records into the production database.
• Full GHL Lead Automation Contact upsert to opportunity creation to pipeline stage update to CRM note, all triggered automatically from consumer wizard submissions and match page actions.
• Programmatic SEO at Scale Dynamic sitemap covers city pages, service-city pages, clinic profiles, and blog posts, up to 49,000 URLs, with full structured data on every page.

Why This Approach

BestMedSpa.us demonstrates that a healthcare marketplace with automated CRM lead routing, programmatic SEO, and a production-grade admin system can be built as a single Next.js application, without Wordpress, without CMS licensing, and without manual pipeline management.

Roadmap

The platform is designed to scale into provider subscription tiers, direct booking, and regional expansion.

• Provider Subscription Tiers: Paid featured placements and verified profile upgrades for providers.
• Direct Booking Integration: Native appointment booking without leaving the marketplace.
• Comparison Engine: Side-by-side provider comparison by treatment, rating, price range, and location.
• Revenue Systems Audit: Book a Revenue Systems Audit to explore a similar platform for your industry.

Technology Stack

BestMedSpa.us was built on a modern, production-ready stack, no Wordpress, no CMS, no ORM.

Next.js 14

Next.js 14

TypeScript

TypeScript

MySQL

MySQL

GoHighLevel

GoHighLevel

Google Maps API

Google Maps API

GitHub Actions

GitHub Actions

Conclusion

Technovier built BestMedSpa.us as a full-stack healthcare marketplace with automated CRM lead routing, programmatic SEO, a scored provider matching algorithm, and a production-grade admin system, demonstrating that complex two-sided platforms can be built with a modern Next.js stack at a fraction of enterprise platform costs.

Related systems

More installed revenue systems

10.4M+

Total TikTok Impressions

Performance Marketing & SEO Growth for Study Abroad Lead Generation

EdTech Partner

Read the case study →

50%

Increase in Fan Engagement

AI-Powered CRM Automation for Sports Industry

Confidential Sports Organization

Read the case study →

1.04k

Leads in 3 months

STUDYSHED Study Abroad Educational Consultants

StudyShed

Read the case study →

Your funnel is next

Your funnel is next. Let's find the leak.

Apply in two minutes. We map your revenue path, find where it leaks, and walk you through the installed fix — live, in 15 minutes.

Apply for a demoSee more proof

Questions about this system

Frequently Ask Questions

BestMedSpa.us is an independent US medical spa directory and lead marketplace built by Technovier. It helps consumers compare licensed med spa providers by treatment, location, and reviews, while automatically routing qualified leads into provider CRM pipelines.
When a consumer submits a treatment request through the lead wizard, the platform automatically creates a contact and opportunity in the provider's GoHighLevel CRM pipeline, including notes, tags, and pipeline stage. When the consumer takes further actions on the match page, GHL opportunity stages update in real time.
Leads are scored and matched to up to 8 providers using ZIP code proximity, city/state location, treatment-to-service keyword mapping, Google rating, review count, featured placement status, and data quality score.
The platform imported 10,333 US med spa provider records via a CSV pipeline with deduplication, staging table validation, and per-row import status tracking.
BestMedSpa.us uses a programmatic SEO system covering city pages, service-city pages, and individual clinic profiles. The dynamic sitemap covers up to 49,000 URLs. Every page emits full JSON-LD structured data including MedicalBusiness, LocalBusiness, FAQPage, BreadcrumbList, Article, HowTo, and Dataset schema types.
No. BestMedSpa.us is built entirely on Next.js 14 App Router with TypeScript. There is no WordPress, no headless CMS, and no ORM, all database access is raw parameterized SQL via mysql2.
The platform has a full CSV-backed fallback mode. Every data read path falls back to CSV data when the MySQL database is unavailable, so the platform continues serving real provider data with zero downtime to the consumer.
Microsoft Clarity was integrated with custom event tracking covering: lead_submitted, wizard_step_1 through wizard_step_N, provider_action (appointment, callback, enquiry), clinic_page_view, and search events.
Yes. The architecture, two-sided marketplace, lead wizard, CRM automation, programmatic SEO, admin dashboard, is repeatable across healthcare, home services, legal, and professional services verticals. Book a Revenue Systems Audit to discuss your use case.
The platform deploys via GitHub Actions: lint to build to FTP sync to cPanel. The deployment workflow supports clean-slate deploys with environment variable injection via GitHub Secrets.