Integrations that tell the truth.
Crest never reports a Drive operation, an email, an import, or an external request as successful before the provider accepts it. Credentials stay server-side, encrypted where it matters — and every integration below is live today, in production.
MySQL
Production backbone
A private MySQL database with Better Auth sessions and application-owned authorization. Documents stream through a server-side StorageService; dashboards refresh over authenticated polling, not a public database connection.
- +Drizzle-managed schema migrations
- +Every workspace boundary enforced in the request layer, not the database
- +No client ever holds database credentials
Google Drive
OAuth · server-side tokens
One workspace OAuth connection browses Drive live: map a folder per school, upload files, and create dedicated proof folders for visits and expenses. Disconnecting removes Crest's connection, never your files.
- +Tokens encrypted at rest with FIELD_ENCRYPTION_KEY
- +School-folder mapping
- +Proof follows the document security model
Notion
Connected workspace
Map a task database's title, status, due date, and assignee properties to Crest, tag Crest schools to Notion school values, and give the Sales & Marketing team their task surface without leaving the portal.
- +Property mapping, not a one-way sync
- +Assistant endpoint for task queries
- +Notion stays the source of truth for its records
SMTP
Authenticated
Team invitations, contract renewal reminders, and a settings test-send. Delivery failure is distinguished from invitation creation — a failed email never loses the invitation or its shareable acceptance link.
- +Configuration health surfaced in settings
- +Validated, authenticated sending
- +Crest never claims a send that failed
Scheduled scans
Daily · 09:00 & 09:15 Manila
A protected cron job scans contracts against your renewal thresholds, deduplicates notifications per contract, threshold, and recipient, then emails an optional digest. A second job refreshes Customer Care operations with idempotent daily digests.
- +Server-only authorization via CRON_SECRET
- +Deduplicated event keys
- +Runs within Hobby-tier cron limits
Import & export
Built in
Preview-first school CSV import that reconciles by code and normalized name, skips existing matches, and keeps conflicts as review items. Statements and financial reports export as server-generated, permission-checked, audit-logged files.
- +2,000 school rows · 25 MB per upload
- +Never overwrites existing records
- +Every row outcome recorded
Honest about what's next.
One integration is a documented proposal, not a feature — and we say so.
Essentiel population polling
A server-to-server contract for polling each school's separate Essentiel deployment for enrollment counts — documented, reviewed, and waiting. Crest deliberately doesn't market it as running: today's population arrives through entry or import, exactly as recorded.
See Crest on your own portfolio.
A working session with your numbers: schools, subscriptions, receivables. We'll set up a workspace and walk your lifecycle end to end.
Invitation-only · Onboarding guided by the team that built it