Automation · Shipped Mar 2026
Prayer City Outreach Automation
Gmail → Google Sheets → automated follow-up pipeline powering volunteer outreach, daily digests, and bounce handling for Prayer City serve days.
Related: Prayer City platform →
Problem
Volunteer lists lived in inboxes and ad-hoc spreadsheets. Daily role content required manual sends every morning.
Solution
- Apps Script pipeline: form submissions → Sheets → Gmail sequences
- Scheduled daily role digests triggered by Cloud Functions
- Bounce detection and list hygiene automation
- Leadership dashboard via live Google Sheet views
Results
Zero manual digest sends through peak signup season — automation handled 500+ emails per month. Leadership eliminated manual digest sends and gained a live roster without exporting CSVs.
Agentic AI evolution
Daily Digest Intelligence Agent
Built on the same Gmail + Sheets pipeline, a Genkit agent now dry-runs daily digest analysis: reads roster data, runs Gemini reasoning, flags mismatches (e.g. scheduled slot discrepancies), and queues suggested actions — coordinators approve before anything sends.
Technology
Screenshots
"Zero manual digest sends through peak signup season — automation handled 500+ emails per month without us touching a spreadsheet."
Need Gmail or Sheets automation?
Discuss workflow automation