What Google Sheets does well
Many churches move from an Excel file to Google Sheets, and that is an improvement. There is only one version, several people can work at the same time and the sheet opens on any computer. For a small schedule with a few regular people that is often enough. It is free and almost everyone knows it.
Where a spreadsheet stops
A spreadsheet is a table. It does not know who is on holiday, warns nobody and does not see that someone has two tasks on the same Sunday. All that work stays with the person making the schedule:
- Availability is collected by e-mail or group chat and processed by hand.
- Reminders you send yourself, or you hope everyone looks at the sheet in time.
- Swaps happen through messages; afterwards someone has to update the sheet.
- On a phone a wide sheet with many columns is hard to read.
- Permissions: whoever can edit can also overwrite something by accident.
Side by side
| Google Sheets | KerkPoint | |
|---|---|---|
| Cost | Free | From €9.99 per month, first month free |
| One current version | Yes | Yes |
| Passing on availability | No, kept up by hand | Yes, volunteers tick it themselves |
| Automatic scheduling in turn | No | Yes |
| Warning about double tasks | No | Yes |
| Reminders by e-mail | No | Yes (from Plus) |
| Swapping with one click | No | Yes |
| Readable on a phone | So-so | Yes, also as an app on the home screen |
| Schedule in your own calendar | No | Yes (Premium) |
| Free-form columns and formulas | Yes | No, a fixed layout per service and task |
| Account needed | Google account to edit | Log in with a link by e-mail |
When switching pays off
If you notice you are chasing people every week, copying changes from the group chat into the sheet or searching for who is still free, the spreadsheet costs more time than it seems. That is the moment to switch. You bring your current schedule along with an import, so you do not start again.
Want to carry on with a spreadsheet for now? Download our free church schedule template. Also read why a church schedule in Excel gets stuck, what a schedule in a group chat means, or try KerkPoint in the demo.