๐Ÿ“ฌ

Notification Center

Coventry CAD v51 โ€ข Google Workspace Gmail OAuth, automatic run-report email rules, queue, and delivery logs
HomeAdminRMSComms
Gmail Status
โ€”
Enabled Rules
โ€”
Queued
โ€”
Failed
โ€”
Secure setup: Gmail sending happens from the Cloudflare Worker using OAuth secrets. Do not put Gmail passwords or client secrets in this browser page.
1. D1 Tables

Run the v51 SQL blocks in D1 first.

2. Google OAuth

Create Google Cloud OAuth credentials, store Client ID/Secret as Worker secrets, then click Start Google OAuth.

3. Rules

Set each agency recipient list and trigger, then send a test email.

Google Workspace Connection
OAuth status and sender identity
Configured Senders
stored in D1, secrets stay in Worker
Automatic Run Report Rule
per-agency auto email settings





Rules
delivery profiles by agency
Email Queue
pending, sent, and failed report deliveries
Delivery Logs
audit trail for every attempted send
Send Test Email
verify Gmail OAuth after Start Google OAuth returns connected
Cloudflare Secrets Needed
Client ID/Secret on Worker; refresh token is saved by OAuth
GOOGLE_CLIENT_ID
GOOGLE_CLIENT_SECRET
GOOGLE_REFRESH_TOKEN optional; OAuth now saves token to D1
GOOGLE_REDIRECT_URI