How LightWorld City Inc. replaced 5 spreadsheets with one system
Shaphan CGT → LCGT Edition
A role-based church management system built on tools the organization already had — Google Sheets, Apps Script, and Drive. The work was less about introducing new technology and more about giving an existing workflow a dependable structure.
The Challenge
Five spreadsheets, no single source of truth
LightWorld City Inc. was running its weekly operations across five separate, disconnected spreadsheets — one for group attendance, another for finance, another for first-timer follow-up, and so on. Each was maintained by a different person, in a different format, updated on a different schedule.
The result: inconsistent data, duplicated entry, and no way for pastoral staff to see a clear, real-time picture of the church's health without chasing several people for reports first.
The Build
One system, five roles
A single web app, built on Google's free infrastructure, with role-based access so each team only sees what's relevant to them.
Group Attendance
Group leaders log attendance directly — no more paper registers or end-of-week collation.
Finance Entry
Giving and expenses are entered once, in one place, with automatic totals instead of manual reconciliation.
First-Timer Logging
Every new visitor is captured and routed for follow-up, so no one falls through the cracks.
Member & Pastoral Admin
A central member record admin and pastoral staff can both rely on — no more conflicting lists.
Pastor Dashboard
Real-time charts on attendance, growth, and giving — visible at a glance, with zero manual reporting.
The Result
From five spreadsheets to
one system of record
In Their Words
What the team says
"This system has transformed how we manage our church. Everything is in one place, and I can see what's happening without chasing people for reports."
"Before, I’d type attendance, send it on WhatsApp, and then remind Pastor at month-end because the messages got lost. Now everything is logged in one system. It’s streamlined and accountable."
A recurring workflow can become a system.
A recurring workflow
can become a system
Some questions arrive as a clear idea. Others arrive as a recurring problem. Either can be the beginning of a useful system.
✓ 30 days of free monitoring & support after delivery.