People Care · Rosedale Baptist Church

Needs Attention 0

People not yet contacted this season

▾

Team Progress ·

Add a Prayer Request

Person's Name

Category

Prayer Request

🎂 Birthdays

🏆 Milestones

Log a Visit Note

Person Visited

Visited By

Visit Notes

How to search

Search by last name

Type "Smith" to find everyone with that last name

Search by full name

Type "John Smith" to narrow to one person

Results appear as you type

No need to press Enter — just start typing a name

Campus:

Staff Member	Campus	Assigned	Reached (Season)	% Complete	Needs Attention	Contacts (30d)	Last Activity

Post an Update

Regarding (person)

Posted By

Update

Loading notifications…

No report yet — the first one will arrive Monday morning.

No prayer report yet — the first one will arrive Monday morning.

Campus:

Staff Overview

Click a pastor to see their full list

Needs Attention — All Staff

People overdue or never contacted across the entire team

Recent Activity — All Staff

Reassign People

Change who is responsible for any person — updates the Google Sheet immediately

Load All 13 Pastors at Once

Fetches every tab from the Rosedale assignment sheet simultaneously.

Or load one pastor at a time

MANUAL CSV UPLOAD

Whose list are you uploading?

📂

Drop CSV here or click to browse

Columns: Name · Phone · Notes

Google Apps Script URL

Once you deploy the script from your Google Sheet, paste the Web App URL here. All people data and contact logs sync through it.

Open Apps Script Editor

Test Follow-Up Notification

Run a test to confirm the daily follow-up push notification is working. This fires the sendFollowUpDueNotifications function immediately and sends a push to any follow-up due today.

To test end-to-end:

1. Log a contact with a care keyword (e.g. "hospital", "grief", "surgery")

2. Set the follow-up date to today using the custom date picker

3. Save the contact — it syncs to the FollowUps sheet automatically

4. In Apps Script editor, run sendFollowUpDueNotifications manually

5. You should receive a push notification within seconds

Slack Integration

Connect Slack to send team-wide messages or DM a specific pastor directly from any person's card.

Staff Slack IDs

Click below to auto-match each pastor to their Slack account using their Rosedale email. Required for sending DMs.

SMS Alerts — Twilio

When a care situation is detected, a text alert is sent to you and the assigned pastor. Set up Twilio credentials as Script Properties in your Apps Script editor (Project Settings → Script Properties).

TWILIO_SID — Your Twilio Account SID

TWILIO_TOKEN — Your Twilio Auth Token

TWILIO_FROM — Your Twilio phone number (e.g. +14105551234)

RICHARD_PHONE — Your cell number (e.g. +14435551234)

PHONE_RYAN, PHONE_NICK, etc. — Each pastor's cell

Need a Twilio account? Sign up free at twilio.com — a trial account is enough for SMS alerts.

AI Assist — Claude API

Powers the "Suggest follow-up note" button in the Log Contact modal. Add your Claude API key as a Script Property in Apps Script.

CLAUDE_API_KEY — Your Anthropic API key (starts with sk-ant-)

Without the API key, the button still works using smart pattern-based suggestions.

Ministry Pulse — CCB Queue IDs

In CCB go to Processes → [Process Name], click a queue, and look at the URL for the ID number (e.g. queue_id=42). Paste each below and Save.

First Time Guest

Salvation

Baptism

Serve

Groups

Push Notifications

Care alerts delivered to your phone even when the app is closed. Every pastor is auto-enrolled when they sign in.

One-time backend setup (admin only):

1. In Apps Script → Project Settings → Script Properties, add FCM_CLIENT_EMAIL and FCM_PRIVATE_KEY from your Firebase service account

2. Run createAllTriggers() once from the Apps Script editor to activate all notification triggers

Connection Status

No script URL saved yet.