Keep in Touch - Contact Relationship Manager

Helps Alec maintain relationships by tracking interactions and scheduling follow-ups.

How It Works

1. Track contacts in the entities table (1,806+ contacts)
2. Create reminder crons for periodic outreach
3. Log interactions to track when you last connected

Commands

Find a Contact

SUPABASE_URL="https://mlzbjnjkopuzoiobinpz.supabase.co"
SUPABASE_KEY="eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Im1semJqbmprb3B1em9pb2JpbnB6Iiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTc2NzMzNzk2NCwiZXhwIjoyMDgyOTEzOTY0fQ.9XZOTu4e6igI52WefbOxAGIif4y4i_JJANg36wFXAL4"

# Search by name
curl -s "$SUPABASE_URL/rest/v1/entities?name=ilike.*John*&entity_type=eq.person&select=name,organization,job_title,email_addresses,social_profiles" \
  -H "apikey: $SUPABASE_KEY"

Create a Keep-in-Touch Reminder

When Alec says "remind me to keep in touch with [Name]":

1. Find the contact in entities
2. Determine frequency (weekly, monthly, quarterly)
3. Create a cron job:

clawdbot cron add \
  --name "Keep in touch: John Smith" \
  --cron "0 10 15 * *" \
  --tz "America/New_York" \
  --session isolated \
  --message "Monthly reminder: Reach out to John Smith (VP Engineering at Acme Corp). Ideas: congrats on recent news, quick coffee catch-up, share interesting article." \
  --deliver \
  --channel telegram \
  --to "302137836"

Frequency Guide

Relationship	Cron Schedule	Description
Close friend/mentor	0 10 * * 0	Weekly (Sunday 10am)
Professional contact	0 10 1 * *	Monthly (1st of month)
Acquaintance	0 10 1 */3 *	Quarterly
Investor/VIP	0 10 1,15 * *	Bi-weekly

Log an Interaction

After Alec reaches out, save to activity_log:

curl -X POST "$SUPABASE_URL/rest/v1/activity_log" \
  -H "apikey: $SUPABASE_KEY" \
  -H "Content-Type: application/json" \
  -d '{"action_type":"contact_outreach","description":"Sent email to John Smith about coffee catch-up","metadata":{"contact_name":"John Smith","method":"email"}}'

Weekly Contact Review Cron

Every Sunday, suggest 3-5 contacts to reach out to:

clawdbot cron add \
  --name "Weekly Contact Review" \
  --cron "0 10 * * 0" \
  --tz "America/New_York" \
  --session isolated \
  --message "Weekly relationship check: Query the entities table for 5 random contacts with entity_type=person. For each, suggest a quick way to reconnect (email, text, LinkedIn comment). Prioritize people Alec hasn't contacted recently." \
  --deliver \
  --channel telegram \
  --to "302137836"