Internal · Meeting Deck · Not for public sharing
Workflow automation

From a 45-minute manual sequence to a 4-minute review.

What becomes possible when an estoppel order, a bank questionnaire, or a violation walk stops being an email and starts being a workflow.

The estoppel pipeline

Title company hits "Pay & submit." Here's everything that happens in the next four minutes — without anyone touching a keyboard.

Today · cmgcam.com ~45 min

Manual sequence

  1. Title company emails request
  2. Office staff sees email, opens AppFolio, looks up unit
  3. Pulls owner ledger, copies balance into a Word template
  4. Fills in seller, buyer, closing date by hand
  5. Verifies against governing docs
  6. Sends draft to manager for review
  7. Manager edits, signs PDF
  8. Replies to the email with attachment
  9. Separately invoices title company (often forgotten)
  10. Updates internal spreadsheet (sometimes)
After Phase 1 · The pipeline ~4 min

Automated workflow

  1. Title company orders + pays via Stripe
  2. System pulls owner ledger from CSV / API
  3. Auto-populates the certificate template
  4. Manager opens one screen — review, edit if needed
  5. One click → signed, watermarked, dispatched
  6. Title company, buyer's attorney, and CMG file all receive the PDF
  7. Payment receipt and audit trail logged automatically
  8. SLA timer starts; manager dashboard reflects status
−91%Manager time per estoppel
+$295Cash collected at submit
100%Get invoiced (no missed)
0Closings held up by CMG

Watch one move through the system

This is a simulation — same events, timestamps, and data shapes the real pipeline emits. Press play.

~ orders.cmgcam.live · estoppel-pipeline · live

The full architecture

Each box is a service we'd build (or wire). All of it sits next to AppFolio — no AppFolio replacement required for Phase 1.

1 · Intake

  • Public order form
  • Stripe checkout
  • Title-company / lender accounts
  • Webhook to pipeline

2 · Data lookup

  • Association profile DB
  • AppFolio CSV import (daily)
  • Owner ledger fetch
  • Delinquency calc

3 · Document gen

  • Per-association template
  • Statutory clause library
  • Auto-fill seller/buyer/dates
  • PDF render w/ branding

4 · Review queue

  • Manager dashboard
  • One-screen approve
  • Inline diff view
  • Mobile-friendly

5 · Sign & deliver

  • E-signature (DocuSign-class)
  • Audit log
  • Email to all parties
  • Watermark + secure link

6 · Track & escalate

  • SLA countdown
  • Stale-order alerts
  • Status emails to requester
  • Reporting dashboard

"But AppFolio doesn't have an open API…"

True — AppFolio's REST API is gated behind their Stack partner program (apply, wait, scoped access). For Phase 1 we don't depend on it. Here's the actual data flow:

1 · Nightly CSV import

  • AppFolio's built-in scheduled exports
  • Owner ledgers, balances, charges, delinquency aging
  • Dropped to S3 / SFTP, ingested into our DB
  • Refreshes 4×/day during business hours

2 · Association profile DB

  • Master record per association
  • Insurance, master deductible, # units, reserves %, FHA/VA approval, litigation
  • Maintained by CMG team — once, then kept current
  • Source of truth for questionnaire auto-fill

3 · "Refresh from AppFolio" button

  • For closing-day staleness
  • Manager clicks → on-demand CSV pull
  • Optional Skywalk fallback for live read
  • Manual override always available
Worst case · stale ledger +1 click

Manager hits "Refresh"

  1. Manager opens the order, sees "ledger from 6h ago"
  2. Clicks Refresh from AppFolio
  3. System runs an export, ingests, recalculates
  4. Manager confirms → signs → delivers
  5. Total added time: ~30 seconds
Phase 2+ · partner API Real-time

If/when Stack partnership lands

  1. Same pipeline — but reads switch from CSV to live API
  2. No "refresh" button needed
  3. Closing-day ledger is always current
  4. Same UI for managers — they don't notice
  5. ~60 day swap-in once approved

Bottom line: the pipeline is built around AppFolio, not against it. Phase 1 lives entirely on CSV exports + an association profile DB — both of which CMG controls. If AppFolio ever opens their API or you migrate to Vantaca / Enumerate, the pipeline keeps running and just gets faster.

What else this unlocks

The same pipeline pattern handles other CMG workflows that are entirely manual today.

Bank questionnaires

Lender selects form type → 80% of fields filled from the association profile → manager confirms loan-specific fields → signed and emailed. Today: ~30 min. After: ~5 min.

Field violations

Manager walks the property, taps a unit on a map, snaps a geotagged photo, picks a violation type → the courtesy letter generates and queues for mailing. Cure deadline tracked. Today: half a day. After: under an hour.

ARC requests

Owner submits with photos → committee votes in-app → owner sees status → board meeting agenda auto-populates. Today: 2–6 weeks of email. After: real-time tracker.

Board packets

One click pulls financials, delinquencies, violations, work orders into a branded PDF the night before each meeting. Today: 4–8 hrs/month/association. After: automatic.

New owner onboarding

Estoppel ships → buyer enters automated 14-day onboarding flow: portal invite, governing docs, ARC overview, payment setup, parking permit. Today: piecemeal over weeks. After: zero manager touch.

AI inquiry triage

Owner emails → classifier sorts into billing / maintenance / ARC / general → drafts a reply citing the right doc → routes to the right manager only when human input is truly needed. Cuts inbox load 40–60%.

Phase 1 ships in 4 weeks.

Estoppel + questionnaire pipelines, owner portal Stripe billing, manager dashboard. Everything you saw above, in production.

See the full roadmap →