Automated PHQ-9 and GAD-7 Trend Digest
Every Monday, WebRun opens Osmind, reads each active patient's most recent PHQ-9 and GAD-7 measurement-based care scores, compares them to baseline and the prior reading, records the change in a Google Sheet, and posts clinicians a Slack digest grouping patients into improving, flat, and worsening so review time goes where it matters.
How can I track patient PHQ-9 and GAD-7 response trends automatically?
WebRun opens Osmind every Monday and reads each active patient's latest PHQ-9 and GAD-7 scores. It compares them to baseline and the prior visit, logs the trend to Google Sheets, and posts clinicians a Slack digest grouping patients into improving, flat, and worsening, so review time goes to those who are stalling.
- Stalled and worsening patients surface every Monday instead of at the next visit
- Clinicians open Slack to a response digest sorted by direction of change
- A running Google Sheet shows each patient's outcome curve across treatment
Built for interventional psychiatrists · psychiatric nurse practitioners · measurement-based care clinics · behavioral health quality leads
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.osmind.orgin a real browser with your saved login - no setup, no API keys. -
1
Osmind - read latest PHQ-9 and GAD-7 scores
osmind.org
WebRun opens Osmind to read each patient's rating-scale scores. - Open Osmind and go to the measurement-based care scores for active patients
- For each patient, read the most recent PHQ-9 and GAD-7 result and the date it was recorded
- Pull the baseline score and the immediately prior score for comparison
- Capture patient initials, latest scores, baseline, prior score, and the change since last visit
Done when Every active patient has their latest PHQ-9 and GAD-7 scores captured alongside baseline and prior values.
-
2
Google Sheets - log the score trend
google.com
WebRun logs each patient's score change and response direction. - Open the Outcome Trend sheet
- Append this week's row per patient with latest scores, change from baseline, and change from last visit
- Compute the direction of change and tag each patient improving, flat, or worsening
- Keep prior weeks so the sheet shows each patient's response curve over the course of treatment
Done when The trend sheet holds this week's scores and a computed direction tag for every patient.
-
3
Slack - digest who is improving or stalling
slack.com
WebRun posts the weekly response digest to the clinical channel. - Post a weekly digest to the clinical Slack channel grouped into improving, flat, and worsening
- Lead with patients whose scores worsened or plateaued so clinicians can prioritize plan changes
- Use patient initials only and link the full Google Sheet for detail
Done when Clinicians have a Slack digest sorting every patient by response direction with the stalled ones surfaced first.
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
Is this an internal report or does it reach patients?
It is internal only. WebRun posts the trend digest to your clinical Slack channel and logs a Google Sheet for your team. It never messages patients or changes any treatment plan on its own.
How does it decide a patient is improving or worsening?
It compares each patient's latest PHQ-9 and GAD-7 scores to their baseline and prior reading in Osmind, then tags the direction of change. Falling scores read as improving, rising or flat scores are surfaced for review.
Does any patient health information leave our systems?
No. The Slack digest and Google Sheet use patient initials and scores only, and both live inside your own connected workspace, so no protected health information is sent to any outside service.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.