DRAFT v0.1

Salesforce + MLS AI Agents

Phased Spec for TLH Automation

Overview

This spec outlines a phased approach to integrating MLS data scrubbing and AI agents into TLH's Salesforce instance. The goal: automate deal discovery, property analysis, and reporting while maintaining human oversight.

Current State

MetricValue
Leads13,042
Opportunities5,767
Active Flows183
IntegrationsLeftMain CRM, DocuSign, RingCentral, smrtPhone, CallRail

Note: LSTMJ already built a prototype that syncs MLS data into Salesforce.

Core Components

1. MLS Data Scrubbing Agent

Monitors MLS feeds for properties matching TLH acquisition criteria.

FunctionDescription
Feed MonitoringWatch MLS for new listings in target areas (SD, OC, LA)
Criteria MatchingFilter by: estate/probate mentions, senior seller signals, price range, property type
Data EnrichmentPull property history, tax records, owner info
SF SyncCreate/update Lead records with MLS data
AlertingNotify team of high-priority matches

2. Deal Analysis Agent

Runs financial analysis on properties.

FunctionDescription
Pro Forma GenerationAuto-calculate acquisition costs, rehab estimates, ARV
Comp AnalysisPull recent sales, adjust for condition
Risk ScoringFlag title issues, permit problems, market risk
RecommendationBuy/pass/investigate-further rating

3. Reporting Agent

Automated dashboards and alerts.

FunctionDescription
Daily PipelineNew leads, stage changes, stuck deals
Market TrendsPrice movements, inventory levels, days-on-market
PerformanceConversion rates, CPA, acquisition velocity
Anomaly AlertsUnusual patterns, data quality issues

Phased Implementation

Phase 1: MLS Integration In Progress

Weeks 1-3

  • Build on LSTMJ's MLS→SF prototype
  • Define matching criteria with Paul/Jeff
  • Set up Lead creation flow
  • Basic alerting (email/SMS on matches)

Phase 2: Deal Analysis Planned

Weeks 4-6

  • Connect to comp data sources (Zillow API, Redfin, county records)
  • Auto-populate Acquisition Pro Forma object
  • Build risk scoring model
  • Human review workflow (approve/reject/revise)

Phase 3: AI Agent Layer Planned

Weeks 7-10

  • Deploy AI agent to interpret listings (natural language)
  • Auto-draft outreach messages
  • Integrate with TLH Orchestrator
  • Connect to Marketing Team agents for lead nurture

Phase 4: Full Automation Planned

Weeks 11-12

  • End-to-end: MLS → Analysis → Outreach → Pipeline
  • Self-improving criteria (learn from closed deals)
  • Expansion to additional MLS feeds (LA, Bay Area)

Technical Architecture

ComponentApproachNotes
MLS Data SourceRETS/API feed or scrapingNeed to confirm MLS access
ProcessingServerless (AWS Lambda / Cloudflare Workers)Per Tran: serverless + databaseless
SF IntegrationSalesforce API (existing sf CLI)Already have API access
AI LayerClaude API / OpenAIFor natural language analysis
OrchestrationOpenClaw agentsTies into Marketing Team architecture

Open Questions

🤔 Need input from Paul/Jeff/Tran:

  1. MLS Access: Which MLS feeds do we have access to? CRMLS? Sandicor? Others?
  2. Matching Criteria: What signals indicate a good estate/probate opportunity? (keywords, owner age, days on market, price drops?)
  3. Pro Forma Inputs: What's the standard formula for TLH acquisition analysis? Rehab cost assumptions?
  4. Priority Markets: Start with SD only, or include OC from day 1?
  5. LSTMJ Prototype: What's the current state? Can we demo it?
  6. Integration Depth: Just leads, or full opportunity creation with stages?

Success Metrics

MetricTarget
Leads from MLS scrubbing50+/week
Time to analysis<1 hour from listing
Analysis accuracy90%+ alignment with human review
Deals sourced via automation20% of pipeline within 6 months