Volunteer Capacity Simulator
See the burnout cliff three months out — before it shows up as no-shows on a Sunday.
See the burnout cliff three months out — before it shows up as no-shows on a Sunday.
| Category | Operations |
| Church-health domain | Close the Back Door (volunteer retention) |
| Data-privacy tier | Medium — names, contact, availability; minors who serve = high |
| Mastery-ladder target | Level 4 · Context |
| Build stack | Planning Center Services API → Google Sheets (Apps Script); optional LLM for the summary |
The problem
Volunteer burnout is real but more nuanced than "everyone is quitting." Barna's 2025 State of the Church found weekly church volunteering actually rebounded to 24% of US adults — above the pre-COVID 2019 level of 18%, led by Gen Z and Millennials. The real problem is distribution and retention, not headcount: a small core does most of the serving (pastors estimate only ~42% of adults carry regular responsibilities), and when that core fatigues, it shows up as creeping no-shows and quiet attrition months before anyone names it.
What good looks like
A weekly pull of scheduling data computes, per volunteer, fill rate, no-show rate, and months-since-last-serve, then projects 90 days forward and flags teams: yellow at 80% fill, red at 70%. When a team enters yellow or red, the leader gets a heads-up — "Worship has 3 volunteers trending toward burnout; fill drops below 70% in ~6 weeks" — early enough to rotate or recruit before a Sunday breaks.
Market scan
| Tool | Fit | Pricing (verify) |
|---|---|---|
| Planning Center Services | Scheduling system of record; rules-based | ~$14–239/mo by size |
| Ministry Scheduler Pro (Rotunda) | Self-scheduling, subs, reminders; rules-based | Annual subscription |
| SignUpGenius | Generic sign-up sheets; no analytics | Free–$19.99/mo |
| Elvanto | Full ChMS rostering; rules-based | By active-adult count |
| Rock RMS | Open-source group scheduler; rules-based | Free (self-hosted) |
The gap: every incumbent answers "who's scheduled this week?" — none forecasts "who's about to disappear." The DIY edge is a thin analytics + projection layer. Keep the "AI" honest: simple trend math on serve cadence does the projection; an LLM only writes the leader-facing summary. Real ML prediction is optional.
Data privacy & security
- Medium sensitivity for names/contact/availability; high for any minors who serve — segregate or exclude them, and never put youth contact data in an LLM prompt.
- Tokenize identities (Volunteer #047) before any AI call; keep the name lookup in the sheet only.
- Restrict sheet sharing, use a service account, and build the demo on synthetic data.
How to build it
- Pull Services data weekly via Planning Center's free, documented, no-rate-limit API into Google Sheets (Apps Script
UrlFetchApp, or Zapier/Make if you'd rather not script). - Sheets formulas compute fill rate, no-show rate, and months-since-last-serve.
- An Apps Script time-driven trigger runs the 90-day projection and sends the email; post to Slack via an incoming webhook for DMs.
- Optional: an LLM API call drafts the alert text from the tokenized aggregates.
Rollout plan
- Q1: Make sure serving is consistently tracked in Planning Center Services (the real prerequisite). Start computing fill and no-show rates.
- Q2: Add the 90-day projection and the yellow/red thresholds.
- Q3: Wire the leader alerts; review burnout-risk volunteers monthly and rotate.
Effort & cost
- Build: ~15–25 hours with Apps Script.
- Run: Planning Center (existing) + $0 Apps Script/Sheets + optional Make ($9–29/mo) + a few dollars of LLM.
Sources
- Barna 2025 State of the Church (volunteering rebound) — https://www.baptistpress.com/resource-library/news/state-of-the-church-more-men-attending-than-women-volunteering-rebounding/
- Lifeway (who actually serves) — https://research.lifeway.com/2023/05/23/most-churchgoers-say-they-want-to-serve-fewer-actually-do/
- Carey Nieuwhof (church trends) — https://careynieuwhof.com/church-trends-2025/
- Planning Center developer API — https://developer.planning.center/docs/
Honesty flag: the Barna 24%/18% figures are corroborated across secondary reporting on the March 2025 Barna/Gloo report; treat exact pricing as approximate and confirm on vendor sites.