Hotel Confirmation Investigation — 2026-04-21

Problem

Hotel confirmation email forwarded by Matt was not added to calendar.

Root Cause Analysis

1. Missing .env Symlink (FIXED)

The .env file with Gmail credentials was not symlinked to the services directory:
- Before: No .env in /home/hoffmann_admin/.openclaw/services/family_assistant/
- After: Symlinked to /home/hoffmann_admin/.openclaw/workspace/scripts/.env

2. Appointment Prompt Excluded Travel (FIXED)

The appointment extraction prompt (prompts/appointment_extract.txt) did not explicitly include travel bookings:
- Before: "What does NOT count: Delivery/shipping notifications, order confirmations"
- Issue: Hotel confirmations likely classified as "order confirmations" and filtered out
- After: Updated to explicitly include "Travel reservations: hotel bookings, flight confirmations, car rentals, train tickets" and clarified "product delivery/shipping" vs travel

3. Email Already Processed (LIKELY)

The hotel confirmation email was likely already marked as read by a previous failed run:
- process --dry-run shows 0 unread emails
- brain-backfill --days 3 found 3 emails but no hotel confirmation
- The pipeline marks emails as read after processing (even on failure)

Fixes Applied

1. ✅ Created .env symlink in services directory
2. ✅ Updated appointment_extract.txt prompt to include travel reservations
3. ✅ Clarified exclusion to "product delivery/shipping" (not travel)

Verification

Test the updated prompt:

cd /home/hoffmann_admin/.openclaw/services/family_assistant
python3 -c "
from family_assistant.appointment_parser import parse_email_with_llm
result = parse_email_with_llm(
    subject='Your Hotel Reservation Confirmation - Marriott',
    body='Reservation confirmed for Matthew Hoffmann. Check-in: April 25, 2026 at 3:00 PM. Check-out: April 27, 2026 at 11:00 AM. Hotel: Marriott Downtown Green Bay. Confirmation: ABC123.',
    from_addr='reservations@marriott.com'
)
print(result)
"

Next Steps

1. For this hotel booking: Manually add to calendar or forward the email again (mark as unread in Gmail first)
2. Going forward: Travel confirmations will be properly extracted
3. Monitor: Next hotel/flight confirmation should auto-process

Prevention

• Consider adding a "reprocess" command to handle emails that were incorrectly filtered
• Add logging to track which emails were filtered and why
• Consider a web UI for manually adding events when auto-extraction fails