Church of Pentecost

One-time Supabase Setup (do this once)

Step 1 — Create the Edge Function

In Supabase Dashboard → Edge Functions → New Function → name it send-reminders → paste this code:

Step 2 — Set the Edge Function Secret

In Supabase → Edge Functions → send-reminders → Secrets → add:

SUPABASE_SERVICE_ROLE_KEY = <your service role key from Project Settings → API>

Step 3 — Enable all 3 cron jobs

In Supabase → SQL Editor → run this SQL (creates all 3 scheduled jobs at once):

All times are UTC. Adjust the cron expressions if your timezone differs from UTC by more than a few hours.

Workflow Step Email Notifications (one-time setup)

When a sheet moves through the workflow (submit → verify → endorse), the next person in the chain automatically receives an email. This requires one Edge Function and the Resend email service.

Step 1 — Create the Edge Function

Supabase Dashboard → Edge Functions → New Function → name it send-workflow-notification → paste this code:

Step 2 — Add these three Secrets to the Edge Function

SUPABASE_SERVICE_ROLE_KEY = <Project Settings → API → service_role key>
RESEND_API_KEY            = <your Resend API key from resend.com>

Step 3 — Verify sender domain in Resend

In resend.com → Domains → Add copaccounting.ca and verify DNS records. The from address in the code is accounting@copaccounting.ca — change it to match your verified domain.

Once deployed, notifications fire automatically on every workflow transition. If the function is not deployed, the workflow continues silently with no email sent.