Skip to main content

Knowledge > Runbooks > Voice Ops > Prayer Request Follow-Up

Prayer Request Follow-Up

Review and action prayer requests received via voice agent or chatbot. The voice_prayer_requests table is shared between both channels — the legacy name reflects its origin.

Prerequisites​

  • Supabase MCP or direct DB access
  • Church admin contact information (from premium_churches)
  • For crisis/urgent requests: direct contact with church pastor

Steps​

  1. Query pending prayer requests for a specific church:

    SELECT
      pr.id,
      pr.church_id,
      pr.requester_name,
      pr.requester_phone,
      pr.request_text,
      pr.urgency,
      pr.source_type,
      pr.status,
      pr.created_at
    FROM voice_prayer_requests pr
    WHERE pr.church_id = '[uuid]'
      AND pr.status = 'pending'
    ORDER BY pr.urgency DESC, pr.created_at ASC;

    source_type will be 'voice' or 'chatbot'. urgency indicates severity (e.g., 'crisis', 'high', 'normal').

  2. Triage by urgency:

    • Crisis / high urgency — requires immediate pastoral follow-up. Contact church directly.
    • Normal — include in standard weekly pastoral care summary for the church.

  3. For crisis requests, immediately notify the church pastor:

    SELECT pc.admin_email, c.name, c.phone
    FROM premium_churches pc
    JOIN churches c ON c.id = pc.church_id
    WHERE pc.church_id = '[uuid]';

    Email or call the church admin using the details above. Reference the prayer request ID.

  4. Mark crisis requests as escalated so they are not overlooked in routine reviews:

    UPDATE voice_prayer_requests
    SET status = 'escalated', updated_at = now()
    WHERE id = '[request-uuid]'
      AND urgency IN ('crisis', 'high');

  5. For normal-priority requests, compile a summary and send to the church admin's email: Include: requester name (if given), request text (verbatim), date/time, source (voice or chatbot).

  6. Mark normal requests as notified after sending the summary:

    UPDATE voice_prayer_requests
    SET status = 'notified', updated_at = now()
    WHERE church_id = '[uuid]'
      AND status = 'pending'
      AND urgency = 'normal';

  7. Confirm follow-up is complete by checking the status column:

    SELECT status, COUNT(*)
    FROM voice_prayer_requests
    WHERE church_id = '[uuid]'
    GROUP BY status;

Verification​

  • No rows remain with status = 'pending' and urgency IN ('crisis', 'high').
  • Church admin has been contacted for all requests requiring follow-up.

Escalation​

If a caller indicated they are in immediate danger (self-harm, medical emergency), contact emergency services or a crisis line — this is not something the church admin alone can action. Document in voice_prayer_requests.notes if a field is available.

See Also​