Automation · Shipped Q1 2025

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 →

Shipped: Q1 2025
Duration: 3 weeks
Client: Houston World Cup Prayer City

500+

Emails processed / mo

100%

Digest sends automated

Manual roster exports

Auto

Bounce handling

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.

Technology

Google Apps ScriptGmail APIGoogle SheetsCloud FunctionsScheduled triggers

Screenshots

"Zero manual digest sends through peak signup season — automation handled 500+ emails per month without us touching a spreadsheet."
Prayer City Leadership · Houston World Cup Prayer City

Need Gmail or Sheets automation?

Discuss workflow automation