Draft membership renewal reminders before they lapse
Every Monday, WebRun opens Blackbaud Altru, finds members expiring in the next 30 days, drafts a personalised renewal reminder in Gmail for each one, and logs the full list in a Google Sheet so your team can review before anything is sent.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically draft membership renewal reminders for expiring members?
Every Monday, WebRun opens Blackbaud Altru, finds members whose memberships expire in the next 30 days, logs them in a Google Sheet, and drafts a personalised renewal reminder in Gmail for each one. No email is sent until your team reviews and approves it, keeping members engaged without the risk of an unreviewed message going out.
- No expiring member is missed because reminders are drafted automatically every Monday
- Staff review polished, personalised drafts instead of writing each email from scratch
- The Google Sheet gives management a full view of the renewal pipeline each week
Built for museum membership managers · cultural attraction development teams · botanical gardens · science centers
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
app.blackbaud.comin a real browser with your saved login - no setup, no API keys. -
1
Blackbaud Altru - find members expiring soon
blackbaud.com How to Automate Blackbaud Altru
WebRun opens Blackbaud Altru to find members expiring soon. - Open Altru and navigate to Memberships
- Filter to members with an expiry date in the next 30 days
- Capture each member's name, membership level, expiry date, and email address
- Note whether this is their first renewal notice or a follow-up
Done when A complete list of members expiring in 30 days is captured with contact details.
-
2
Google Sheets - log the renewal list
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the renewal list. - Open the Membership Renewals tracking sheet (or create one if it does not exist)
- Append a row for each expiring member with their name, level, expiry date, and notice number
- Mark the date each row was processed so duplicates are skipped on future runs
Done when Every expiring member is logged in the tracking sheet with their renewal details.
-
3
Gmail - draft personalised renewal reminders
gmail.com How to Automate Gmail
WebRun opens Gmail to draft personalised renewal reminders. - Draft a personalised renewal reminder email for each member using their name and membership level
- Include the expiry date, a note on the benefits they would keep, and a renewal call to action
- Save each email as a draft and leave it unsent for your team to review before sending
- Never send any email automatically without a human approving it first
Done when A personalised renewal reminder draft exists in Gmail for every expiring member.
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
Will it send renewal emails to members without my approval?
No. Every renewal reminder is saved as a Gmail draft only. Your team reviews and approves each one before anything is sent to a member. WebRun never sends member-facing emails on its own.
What if a member renewed after the run started?
WebRun reads live data from Altru each Monday. If a member renewed mid-week, they will be absent from next Monday's list. Any draft already created for them can simply be deleted without sending.
Can it handle multiple membership levels with different messaging?
Yes. You supply a template for each membership tier during setup. WebRun picks the right template based on the member's current level in Altru and personalises it with their name and expiry date.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.