Automated Lease Renewal Forecasting
Every week, WebRun opens AppFolio, reads the lease expirations over the next 120 days, groups them by month and property, notes which are already in renewal or on notice, logs the forecast into a Google Sheet, and posts your team a Slack digest of how many leases roll off each month so renewals and turns get planned early.
How do I forecast my lease renewal pipeline automatically?
Every week, WebRun opens AppFolio and reads lease expirations over the next 120 days, grouping them by month and property and noting which are already renewing or on notice. It logs the forecast to a Google Sheet and posts your team a Slack digest of how many leases roll off each month, so renewals and turnovers get planned before the crunch.
- Heavy renewal months are visible 120 days out
- Revenue up for renewal is quantified per month
- Renewals and turns get staffed before the crunch hits
Built for property managers · residential property teams · real estate investors · leasing teams
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
account.appfolio.comin a real browser with your saved login - no setup, no API keys. -
1
AppFolio - read lease expirations
appfolio.com
WebRun opens AppFolio to read upcoming lease expirations. - Open AppFolio and run the Lease Expiration report for the next 120 days
- Capture each lease's tenant, unit, property, rent, and end date
- Note which leases are already renewing or on notice to vacate
Done when Every lease expiring in the window is captured with its end date.
-
2
Google Sheets - build the renewal forecast
google.com
WebRun builds the renewal forecast by month and property. - Group expiring leases by month and by property in the sheet
- Tally how many roll off each month and how many are still undecided
- Show current rent so the revenue at risk is visible per month
Done when The renewal forecast is built by month and property in the sheet.
-
3
Slack - post the pipeline digest
slack.com
WebRun posts the renewal pipeline digest to Slack. - Post a digest of how many leases expire each month over the window
- Call out the heaviest months and the still-undecided leases
- Leave it for your team to plan renewal offers and turnover timing
Done when Your team has the renewal pipeline digest 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
Will it send renewal offers to tenants?
No. This workflow only forecasts and reports. It reads AppFolio leases and posts an internal Slack digest, so drafting or sending any renewal offer stays a separate, human-approved step.
How far ahead does the forecast look?
By default it reads lease expirations over the next 120 days and groups them by month, so you can see heavy renewal months coming and staff renewals and turnovers before the crunch.
Can it show the revenue at stake?
Yes. It carries each lease's current rent into the forecast, so the digest shows how much monthly revenue is up for renewal in each month, not just a count of leases.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.