Automated Church Capital Campaign Tracking
Every Monday during a capital campaign, WebRun opens Pushpay to pull total pledges made and payments received against the campaign fund, updates the progress tracker in Google Sheets with current totals and pacing data, and posts a clean progress report to the leadership channel in Slack.
How do I automatically track capital campaign pledge progress for church leadership?
Every Monday during your capital campaign, WebRun pulls current pledge totals and payments received from Pushpay, updates the campaign tracker in Google Sheets with pacing data, and posts an aggregate progress report to your leadership Slack channel. No manual report pulling and no individual donor data in Slack.
- Leadership sees current pledge totals and pacing data in Slack every Monday without manual report pulling
- Behind-schedule pledges are flagged in the tracker for the giving team to review
- Individual donor data stays private while aggregate progress is visible to the full leadership team
Built for church executive pastors · capital campaign committees · church finance teams · development directors
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
pushpay.comin a real browser with your saved login - no setup, no API keys. -
1
Pushpay - pull pledge totals and payments received
pushpay.com
WebRun opens Pushpay to pull pledge totals and payments received. - Open Pushpay and navigate to the capital campaign fund
- Pull total pledges made, total payments received to date, and number of pledging households
- Identify pledges that are behind on their payment schedule
- Note any new pledges made this week and any one-time large gifts toward the campaign
Done when Current pledge totals, payments received, and pacing status are captured from Pushpay.
-
2
Google Sheets - update campaign progress tracker
google.com
WebRun opens Google Sheets to update campaign progress tracker. - Open the capital campaign tracker in Google Sheets
- Update this week's row with total pledges, payments received, percentage of goal reached, and number of pledging households
- Calculate the pacing variance: whether payments are ahead, on track, or behind the campaign timeline
- Flag pledges that are more than one payment behind schedule
Done when The campaign tracker is updated with current week totals and pacing status.
-
3
Slack - post weekly progress report to leadership
slack.com
WebRun opens Slack to post weekly progress report to leadership. - Post a formatted campaign progress report to the leadership channel
- Lead with the headline: total received, percentage of goal, and weeks remaining
- Include the pacing indicator and flag if the campaign is tracking below the needed pace
- Keep individual donor data out of the Slack report. Post only aggregate totals.
Done when Leadership has a current, aggregate campaign progress report in Slack.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does the Slack report include individual donor names or gift amounts?
No. The Slack report contains only aggregate totals: total pledges, total received, percentage of goal, and pacing data. Individual giving records remain private in Pushpay and the restricted Google Sheets tracker.
What does it do about pledges that are falling behind on payments?
WebRun flags behind-schedule pledges in the Google Sheets tracker for the giving team to review. It does not contact donors automatically. Any pledge follow-up is handled separately by the giving team with a human-reviewed message.
Can it track a multi-year campaign with phases?
Yes. The Google Sheets tracker can be set up with phase goals and timelines. WebRun reports progress against the current phase goal as well as the overall campaign total each week.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.