Automated Contract Reminders

[Starefossen]

Summary

Daily cron job sends reminders for unsigned contracts.

Implementation

Cron Job

• src/app/api/cron/sponsor-reminders/route.ts
• Runs daily at 9am
• Query signature_status: pending older than 5 days
• Send reminder email (max 2 per sponsor)
• Log reminder in activity feed
• Slack notification to assigned organizer

Action Items Enhancement

• Add type: contract-pending-signature
• Add type: reminder-sent

Configuration

• Update vercel.json with cron schedule
• Reminder thresholds configurable via env vars

Acceptance Criteria

• Cron runs daily without manual intervention
• Reminder emails sent after 5 days
• Max 2 reminders per sponsor enforced
• Slack notifications work
• Action items show pending contracts

Dependencies

• Schema Extensions for Contract Signing #300 (Schema Extensions)
• Sponsor Email Templates #302 (Sponsor Email Templates)

Part of

Epic: CRM Phase 2 - Sponsor Contract Signing & Automation