The Church of Pentecost Canada Inc

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 Secrets

In Supabase → Edge Functions → send-reminders → Secrets → add only these 3 (SUPABASE_URL and SUPABASE_SERVICE_ROLE_KEY are provided automatically):

TWILIO_ACCOUNT_SID   = <your Account SID from twilio.com/console>
TWILIO_AUTH_TOKEN    = <your Auth Token from twilio.com/console>
TWILIO_FROM_NUMBER   = <your Twilio phone number, e.g. +16471234567>

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 Text Message Notifications (one-time setup)

When a sheet moves through the workflow (submit → verify → endorse), the next person in the chain automatically receives a text message (SMS). This requires one Edge Function and a Twilio account.

Step 1 — Create the Edge Function

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

Step 2 — Add these Secrets to the Edge Function

TWILIO_ACCOUNT_SID   = <your Account SID from twilio.com/console>
TWILIO_AUTH_TOKEN    = <your Auth Token from twilio.com/console>
TWILIO_FROM_NUMBER   = <your Twilio phone number, e.g. +16471234567>

Step 3 — Ensure user profiles have a phone number

Each recipient must have a phone field in the profiles table in E.164 format (e.g. +16471234567). Users without a phone number are skipped automatically.

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