Enriched Shadow Mode — Architecture Spec

Family Chat Message
        │
        ▼
┌───────────────────┐
│ Tier 1: Tripwire  │── Score ≥ 0.4? ──► Log silently (done)
│ (regex/keywords)  │
└───────────────────┘
        │ Yes
        ▼
┌───────────────────┐
│ Tier 2: LLM       │── Extract who/what/when/where/confidence
│ Extraction        │
└───────────────────┘
        │
        ▼
┌───────────────────┐
│ [NEW] Calendar    │── Query Google Calendar (readonly)
│ Validation        │── Fuzzy match event title
│ (Event-Driven)    │── Check person/time/location overlap
└───────────────────┘
        │
        ├─ MATCH ───► Log: "Would have confirmed existing event"
        │              (No DM needed, silent)
        │
        ├─ NO_MATCH ─► Admin DM: "I would have added [Sully Pickup] 
        │              to calendar for tomorrow 8 AM. Accurate? [Yes] [No]"
        │              ► [Yes] → Log to staging.db (not real calendar)
        │              ► [No]  → Log to staging.db with rejection flag
        │
        └─ CONFLICT ─► Admin DM: "Calendar shows 'Sully haircut' at 9 AM,
                       but message says 8 AM. Which is correct? [9 AM] [8 AM]"
                       ► Either answer → Log to staging.db for tuning

# Event-driven only — called from shadow_bot.py after Tier 2 extraction
calendar.check_event(
    date_range=(extracted_date - 1 day, extracted_date + 1 day),
    query_text=extracted_what,  # "Sully haircut"
    family_member=extracted_who,  # "Sully"
)

🔍 Shadow Mode — Proposed Calendar Action

Message: "I've got Sully tomorrow"
Extracted: Pickup Sully, tomorrow, unspecified time
Calendar: ❌ No matching event found

I would have added:
  📅 "Sully Pickup" — tomorrow (all day)

Accurate? [Yes] [No] [Edit]

⚠️ This is a simulation. Your calendar has not been modified.

🔍 Shadow Mode — Calendar Conflict Detected

Message: "Sully's haircut at 8"
Extracted: Sully haircut, tomorrow 8:00 AM
Calendar: ✅ "Sully Haircut" — tomorrow 9:00 AM

Conflict: Time mismatch (8 AM vs 9 AM)

Which is correct?
[📅 Keep Calendar: 9 AM]
[💬 Use Message: 8 AM]
[❓ I'm Not Sure]

⚠️ This is a simulation. Your calendar has not been modified.

Logged silently to staging.db:
  "Sully pickup" — matched existing event "Sully Pickup" (tomorrow 3 PM)
  Action: None needed

-- Add calendar validation columns to shadow_extractions
ALTER TABLE shadow_extractions ADD COLUMN calendar_check_status TEXT;  -- match | no_match | conflict
ALTER TABLE shadow_extractions ADD COLUMN calendar_event_id TEXT;       -- Google Calendar event ID
ALTER TABLE shadow_extractions ADD COLUMN calendar_event_title TEXT;   -- Matched event title
ALTER TABLE shadow_extractions ADD COLUMN calendar_event_time TEXT;    -- Matched event time
ALTER TABLE shadow_extractions ADD COLUMN admin_dm_sent BOOLEAN DEFAULT FALSE;
ALTER TABLE shadow_extractions ADD COLUMN admin_response TEXT;         -- yes | no | edit | timeout
ALTER TABLE shadow_extractions ADD COLUMN would_have_written BOOLEAN; -- What we would have done

{
  "client_id": "...",
  "scopes": ["https://www.googleapis.com/auth/calendar.readonly"],
  "restrictions": {
    "allowed_ips": ["Tailscale IPs only"],
    "rate_limit": "100 queries/day"
  }
}