Tom Kim & Melissa Croll Automation Project | Internal View
| Field | Value |
|---|---|
| Client | Tom Kim & Melissa Croll |
| Industry | Real Estate / Commercial Property |
| Location | Dallas, TX |
| Key Pain | Manual NDA data entry + follow-ups |
| Budget Signal | "$100/hour assistant" |
| Decision Maker | Both (joint decision) |
| System | Access | Phase |
|---|---|---|
| DocuSign | Full | Phase 1 |
| Google Drive | Full | Phase 1 |
| Salesforce | Limited | Phase 2 |
| Crexi | Unknown | Phase 2+ |
| Constant Contact | Full | Fallback |
| Phase | Standard | Tom & Melissa | Timeline |
|---|---|---|---|
| Phase 1: DocuSign â Drive Recommended Start |
$9,000 | $6,000 | 2-4 wks |
| Phase 2: Salesforce Sync | $8,000 | $5,000 | +3-5 wks |
| Phase 3: Crexi â DocuSign | $6,000 | $4,000 | +3-5 wks |
| ALL PHASES | $23,000 | $15,000 | 8-12 wks |
| Tier | Standard | Tom & Melissa |
|---|---|---|
| Monthly Support | $1,200/mo | $750/mo |
| Component | Low | High | Mid |
|---|---|---|---|
| Phase 1: DocuSign â Google Drive ($6k) | |||
| Discovery & Requirements | 6 | 10 | 8 |
| DocuSign Integration | 16 | 24 | 20 |
| Google Drive Routing | 12 | 18 | 15 |
| Follow-up Scheduler | 4 | 8 | 6 |
| Testing & UAT | 8 | 14 | 11 |
| Documentation | 4 | 6 | 5 |
| PHASE 1 TOTAL | 50 | 70 | 60 |
| Phase 2: Salesforce Sync ($5k) | |||
| Salesforce Setup & Auth | 10 | 16 | 13 |
| Contact/Account Sync | 20 | 34 | 27 |
| Dedupe & Linking | 12 | 20 | 16 |
| Dashboard & Testing | 18 | 30 | 24 |
| PHASE 2 TOTAL | 60 | 90 | 75 |
| Phase 3: Crexi â DocuSign ($4k) | |||
| Crexi API Research | 8 | 14 | 11 |
| Lead Trigger Integration | 14 | 22 | 18 |
| Auto-Send NDA Logic | 10 | 16 | 13 |
| Testing & Integration | 8 | 14 | 11 |
| PHASE 3 TOTAL | 40 | 60 | 50 |
| ALL PHASES | 150 | 220 | 185 |
| Phase | Standard Rate | Friends & Family | Your Hours | Your Profit |
|---|---|---|---|---|
| Phase 1: DocuSign â Drive | $9,000 | $6,000 | 40-60 hrs | ~$3,500 |
| Phase 2: Salesforce Sync | $8,000 | $5,000 | 50-75 hrs | ~$2,500 |
| Phase 3: Crexi â DocuSign | $6,000 | $4,000 | 35-50 hrs | ~$2,000 |
| ALL PHASES | $23,000 | $15,000 | 125-185 hrs | ~$8,000 |
| Monthly Support | $1,200/mo | $750/mo | 4-6 hrs/mo | ~$500/mo |
| Scenario | Duration | Assumptions |
|---|---|---|
| Optimistic | 2-3 weeks | All access ready, fast feedback |
| Realistic | 3-4 weeks | Normal delays, 1-2 feedback cycles |
| Pessimistic | 5-6 weeks | Access blockers, scope changes |
| Milestone | Target | Deliverable | Payment Trigger |
|---|---|---|---|
| Phase 1: DocuSign â Google Drive | |||
| M0: Kickoff | Day 1 | Contract signed, API access initiated | 50% upfront |
| M1: Discovery Complete | Week 1 | Requirements doc, field mapping, Drive structure | â |
| M2: DocuSign Integration | Week 3 | Webhook working, PDF extraction complete | â |
| M3: Full Workflow | Week 4 | Drive filing + reminders working | â |
| M4: Phase 1 Go-Live | Week 6 | Production deployment, training, docs | 50% final |
| Phase 2: Salesforce Sync (Optional Add-On) | |||
| M5: Salesforce Setup | Week 8 | Connected App, Contact/Account creation | Per separate quote |
| M6: Full Integration | Week 10 | Duplicate detection, property linking | â |
| System | Auth | Hours | Phase |
|---|---|---|---|
| DocuSign | JWT OAuth | 18-26 | Phase 1 |
| Google Drive | Service Account | 12-18 | Phase 1 |
| Salesforce | Connected App | 26-44 | Phase 2 |
| Crexi | Unknown | TBD | Phase 2+ |
| Component | Technology |
|---|---|
| Backend | Python/FastAPI or Node.js |
| Hosting | VPS (unicorncommander.ai) |
| Database | SQLite or PostgreSQL |
| Orchestration | Direct API or Make.com |
| Monitoring | Logging + email alerts |
| NDA Field | Salesforce Field | Required | Notes |
|---|---|---|---|
| Signer Name | Contact.Name | Yes | Split into First/Last |
| Contact.Email | Yes | Primary dedupe key | |
| Phone | Contact.Phone | No | Secondary dedupe |
| Company | Account.Name | No | Create Account if present |
| Address | Contact.MailingAddress | No | Often incomplete |
| Project Interest | Contact.Project__c | Yes | E.g., "Project A21" |
| Market Interest | Contact.Market__c | No | E.g., "Austin", "Florida" |
| Risk | Phase | Impact | Mitigation |
|---|---|---|---|
| NDA doesn't use DocuSign fields | Phase 1 | High | Request samples immediately; plan OCR fallback |
| Google Drive structure inconsistent | Phase 1 | Low | Build flexible path resolver; fallback folder |
| Client feedback delays | Both | Medium | Set fixed review checkpoints in contract |
| Scope creep | Both | High | Clear phase gates; change order process |
| No Salesforce admin access | Phase 2 | Medium | Deferred to Phase 2; time to resolve |
| Crexi API unavailable | Phase 2+ | Medium | Skip; use DocuSign as trigger |
| # | Item | Owner | Phase | Status |
|---|---|---|---|---|
| 1 | Send 2-3 signed NDA samples (PDF) | Melissa | Phase 1 | Pending |
| 2 | Confirm DocuSign plan level/features | Tom | Phase 1 | Pending |
| 3 | Provide Google Drive folder structure rules | Melissa | Phase 1 | Pending |
| 4 | Get Rachel's Salesforce admin reactivated | Tom | Phase 2 | Pending |
| # | Item | Status |
|---|---|---|
| 1 | Complete master analysis document | Done |
| 2 | Build internal planning website | Done |
| 3 | Build client proposal website | Done |
| 4 | Send follow-up email with sample request | Pending |
| 5 | Schedule next call | Pending |