How LightWorld City Inc. replaced 5 spreadsheets with one system
Shaphan CGT → LCGT Edition
A role-based church management system built entirely on tools they already had — Google Sheets, Apps Script, and Drive. It brings structure, accessibility, and consistency to organizational processes.
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."
Running your organization on spreadsheets?
Let's build
your system
Whether you have a clear vision or just a difficult question — we'll help you find the path forward.
✓ 30 days of free monitoring & support after delivery.