<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Milton Quranda</title>
    <description>The latest articles on DEV Community by Milton Quranda (@milton_quranda_180f2b79b3).</description>
    <link>https://dev.to/milton_quranda_180f2b79b3</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4078453%2F37c205e7-4c15-498f-a626-21126eb6646d.png</url>
      <title>DEV Community: Milton Quranda</title>
      <link>https://dev.to/milton_quranda_180f2b79b3</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/milton_quranda_180f2b79b3"/>
    <language>en</language>
    <item>
      <title>We Embedded a Free CRM Into Our Scheduling Engine. Here's the Architecture and the "Why"</title>
      <dc:creator>Milton Quranda</dc:creator>
      <pubDate>Sat, 15 Aug 2026 04:43:23 +0000</pubDate>
      <link>https://dev.to/milton_quranda_180f2b79b3/we-embedded-a-free-crm-into-our-scheduling-engine-heres-the-architecture-and-the-why-3786</link>
      <guid>https://dev.to/milton_quranda_180f2b79b3/we-embedded-a-free-crm-into-our-scheduling-engine-heres-the-architecture-and-the-why-3786</guid>
      <description>&lt;p&gt;How we collapsed the SaaS stack by embedding a full CRM into our Node.js and Firestore scheduling engine with zero-touch lifecycle automation.&lt;/p&gt;




&lt;h3&gt;
  
  
  TL;DR
&lt;/h3&gt;

&lt;p&gt;We built &lt;strong&gt;Bright Canoe&lt;/strong&gt; (powered by the Scheduling Studio engine), an AI-powered scheduling and operations platform for studios, clinics, coaches, and mobile professionals. &lt;br&gt;
One of our foundational architectural decisions was to ship a full CRM (unlimited contacts, lifecycle automation, AI win-back, e-sign doc vault, and meeting transcription) as a free, built-in layer on every plan, including the $0 tier.&lt;br&gt;
This post explains why we made that decision and how the data flows under the hood.&lt;/p&gt;


&lt;h3&gt;
  
  
  The Problem We Kept Hearing
&lt;/h3&gt;

&lt;p&gt;Every independent studio owner and service operator we interviewed was running 4 to 6 separate SaaS tools to manage a single customer relationship:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Booking Tool -&amp;gt; CRM -&amp;gt; Invoicing Tool -&amp;gt; E-Sign Tool -&amp;gt; Email Tool -&amp;gt; Spreadsheet
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Each connection was either manual copy-paste or a brittle Zapier webhook chain. Customer data lived in isolated silos, and the "client record" was a fiction assembled across half a dozen browser tabs.&lt;br&gt;
We decided the solution wasn't another integration. It was collapsing the stack.&lt;/p&gt;


&lt;h3&gt;
  
  
  The Firestore Data Model
&lt;/h3&gt;

&lt;p&gt;Everything lives in a single Firebase project. The primary collections powering the CRM layer:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;users/{uid}/clients&lt;/code&gt;&lt;/strong&gt;: CRM contacts, lifecycle stage (&lt;code&gt;lead&lt;/code&gt;, &lt;code&gt;client&lt;/code&gt;, &lt;code&gt;repeat&lt;/code&gt;), tags, and private host notes.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;bookings&lt;/code&gt;&lt;/strong&gt;: Appointments linked directly to a client record.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;esign_requests&lt;/code&gt;&lt;/strong&gt;: Signature workflows tied to a client and booking.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;invoices&lt;/code&gt;&lt;/strong&gt;: Stripe invoices and payment receipts.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;&lt;code&gt;users/{uid}/agent_audit_log&lt;/code&gt;&lt;/strong&gt;: AI Agent decisions (Guardian, Negotiator, Scout) logged per client.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;The critical architectural choice: &lt;strong&gt;bookings and &lt;code&gt;users/{uid}/clients&lt;/code&gt; share an atomic boundary&lt;/strong&gt;. There is no background sync job. A booking &lt;em&gt;is&lt;/em&gt; a CRM write. &lt;/p&gt;

&lt;p&gt;During the booking flow, &lt;code&gt;bookingController.js&lt;/code&gt; executes an atomic Firestore transaction that creates or updates the client document in the exact same operation that confirms the appointment.&lt;/p&gt;


&lt;h3&gt;
  
  
  Lifecycle Automation (Zero Manual Steps)
&lt;/h3&gt;

&lt;p&gt;We implemented an event-driven three-stage pipeline:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;booking.created   -&amp;gt; if client.stage === null -&amp;gt; set stage = "lead"
booking.completed -&amp;gt; if client.stage === "lead" -&amp;gt; set stage = "client"
booking.completed -&amp;gt; if client.bookings_completed &amp;gt;= 2 -&amp;gt; set stage = "repeat"
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Full chain of custody, zero tab-switching, and no separate third-party e-signature subscription required.&lt;/p&gt;




&lt;h3&gt;
  
  
  Why Free?
&lt;/h3&gt;

&lt;p&gt;The CRM is not a loss leader; it is our primary retention layer. A scheduling tool that does not remember your client between sessions is just a calendar with a checkout form.&lt;br&gt;
By making the CRM free and unlimited, we provide massive utility while monetizing through advanced AI voice and team capabilities:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Free ($0/mo):&lt;/strong&gt; Core booking, Google Calendar 2-way sync, and full Client 360 CRM with unlimited contacts.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Starter ($24.99/mo or $20/mo annual):&lt;/strong&gt; SMS reminders, custom branding, and modular add-on support.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;All-In-One Studio Suite ($59/mo or $50/mo annual):&lt;/strong&gt; 24/7 AI Voice Receptionist with dedicated phone number, unlimited legally-binding e-signatures, and win-back autopilot.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Premium Scale ($99/mo or $80/mo annual):&lt;/strong&gt; Outbound sales dialer, Scribe meeting bot (25 hrs/mo), and multi-provider team scheduling.
We charge for heavy compute and telephony (AI Voice Receptionist, outbound dialer, custom contracts, multi-provider operations), not for remembering a customer's name.&lt;/li&gt;
&lt;/ul&gt;




&lt;h3&gt;
  
  
  Data Migration and Sovereignty
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;100% Free CSV Import:&lt;/strong&gt; Anyone can import their customer database from Mindbody, Acuity, Calendly, or Google Sheets on day one with zero lock-in.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Full CSV Export:&lt;/strong&gt; Active plans can export full CSV backups of client databases and financial transaction ledgers at any time.&lt;/li&gt;
&lt;/ul&gt;




&lt;h3&gt;
  
  
  What's Next on the Roadmap
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Webhook Parity:&lt;/strong&gt; Adding &lt;code&gt;client.stage_changed&lt;/code&gt; and &lt;code&gt;client.winback_sent&lt;/code&gt; webhooks to our REST API (&lt;code&gt;/openapi.yaml&lt;/code&gt;).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Custom Pipeline Stages:&lt;/strong&gt; Allowing multi-location clinics and studios to define custom deal pipelines beyond Lead, Client, and Repeat.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Automated Scout Dossiers:&lt;/strong&gt; Attaching pre-meeting research dossiers (company intel, attendee bios, Gmail history) directly into client records prior to calls.&lt;/li&gt;
&lt;/ol&gt;




&lt;h3&gt;
  
  
  Try It Out
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Live Platform:&lt;/strong&gt; &lt;a href="https://brightcanoe.com" rel="noopener noreferrer"&gt;brightcanoe.com&lt;/a&gt; formerly &lt;a href="https://scheduling.studio" rel="noopener noreferrer"&gt;scheduling.studio&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;API Documentation:&lt;/strong&gt; &lt;code&gt;/openapi.yaml&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Directory &amp;amp; Semantic Search:&lt;/strong&gt; &lt;a href="https://brightcanoe.com/directory" rel="noopener noreferrer"&gt;brightcanoe.com/directory&lt;/a&gt;
If you are building SaaS for appointment-based businesses or have tackled the challenge of unifying scheduling with CRM data models, I'd love to hear your insights in the comments.&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>saas</category>
      <category>productivity</category>
      <category>firebase</category>
      <category>crm</category>
    </item>
  </channel>
</rss>
