Press enter or space to select a node.You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
About This Automation
Pastoral and care records track visits, counselling sessions, and prayer requests for people in a congregation or care network. Manual recording, searching, and follow-up tracking consume significant staff time and create gaps in continuity of care.
Automation captures visit details in a structured form, matches them against existing records to prevent duplication, and automatically alerts pastoral workers when follow-ups are due. This ensures no one falls through the cracks and staff focus on care rather than administration.
Key features:
Capture pastoral visit details in a standardised form immediately after each interaction
Automatically match new records against existing data to prevent duplicate entries
Maintain a complete care history for each person in one searchable location
Generate daily reminders for overdue follow-ups and assign them to the right pastoral worker
Track prayer requests and pastoral notes in a consistent, organised format
Hidden Overhead™Context switching between email, spreadsheets, and folders, plus anxiety about.
7.1/ 10
How The Automation Works
The full workflow, from trigger to completion.
Press enter or space to select a node.You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
1. Pastoral Visit Completedtrigger
A pastoral worker submits a visit form immediately after completing a pastoral interaction. The form captures the person's name, date, visit type, notes, prayer requests, and any follow-up date.
2. Validate & Enrich Record
An automation checks the submitted data against existing records in the centralised database to prevent duplicates and flag any missing information. It enriches the record with the person's contact details and care history.
3. Store in Centralised Database
The validated pastoral record is automatically written to a Google Sheet serving as the centralised pastoral database, with consistent formatting, timestamps, and searchable fields.
4. Check Follow-up Due Date
The automation checks if a follow-up date was recorded. If yes, it creates a task in the system and schedules a reminder. If no follow-up is needed, the record is marked complete.
5. Notify Assigned Volunteer
If a follow-up is due, the automation sends a message or email to the assigned pastoral worker with the person's name, history summary, and due date, ensuring continuity of care.
6. Archive to Drive
A copy of the full pastoral record is automatically saved in a dated, searchable folder structure for compliance and historical reference.
Everything you need to know before mapping this process.
The system cannot automatically capture visits that are not submitted. However, a weekly summary report can remind coordinators to follow up with workers who have not logged visits, and workers can submit forms retroactively with a note.
Google Forms
Google Sheets
Slack
Google Drive
Gmail