All templates

Automated IRB Approval Expiry Tracking

Every Monday, WebRun opens RealTime-CTMS, reviews all active study protocols, identifies IRB approvals expiring within 60 days, and posts a prioritized renewal list to your Slack channel and a tracker in Google Sheets for your regulatory coordinator.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 RealTime-CTMS find protocols with expiring IRB approvals
2 Slack post renewal action list to regulatory team
3 Google Sheets update the IRB renewal tracker
In short

How do I track IRB approval expiry dates across all my clinical studies?

WebRun reviews all active study protocols in RealTime-CTMS every Monday, flags IRB approvals expiring within 60 days, and posts a prioritized renewal list to Slack and a color-coded tracker in Google Sheets. Submitting renewals is left to your regulatory coordinator.

  • IRB renewals surfaced 60 days early so teams avoid last-minute filings
  • Urgent studies under 30 days flagged separately for immediate action
  • Color-coded tracker gives regulatory staff a single source of truth

Built for regulatory coordinators · research site directors · IRB administrators · clinical research sites

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens realtime-ctms.com/login in a real browser with your saved login - no setup, no API keys.

  2. 1
    RealTime-CTMS - find protocols with expiring IRB approvals
    realtime-ctms.com
    WebRun in RealTime-CTMS: find protocols with expiring IRB approvals
    WebRun opens RealTime-CTMS to find protocols with expiring IRB approvals.
    • Open RealTime-CTMS and navigate to the Protocol or Regulatory Documents section
    • Pull all active study protocols and their current IRB approval expiry dates
    • Flag any protocol with an expiry date within the next 60 days

    Done when Every active protocol with an expiring IRB approval is listed with the study name, sponsor, and days to expiry.

  3. 2
    Slack - post renewal action list to regulatory team
    slack.com
    WebRun in Slack: post renewal action list to regulatory team
    WebRun opens Slack to post renewal action list to regulatory team.
    • Post a ranked list to the regulatory Slack channel, sorted by days to expiry
    • Highlight protocols expiring within 30 days as urgent
    • Include the study name, sponsor, and exact expiry date in each row

    Done when The regulatory team has this week's IRB renewal list in Slack.

  4. 3
    Google Sheets - update the IRB renewal tracker
    google.com
    WebRun in Google Sheets: update the IRB renewal tracker
    WebRun opens Google Sheets to update the IRB renewal tracker.
    • Open the IRB Renewal Tracker in Google Sheets
    • Upsert each study's expiry date, renewal status, and assigned coordinator
    • Color-code rows: red for under 30 days, yellow for 30 to 60 days, green for renewed

    Done when The tracker shows the current renewal status for every at-risk study.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
realtime-ctms.com/login
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Renewal list · Slack
OutputWhat each run produces - A color-coded IRB renewal tracker in Google Sheets and a weekly Slack alert listing studies with approvals expiring within 60 days.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it submit the IRB renewal application automatically?

No. WebRun only surfaces which studies need renewal and tracks status. Submitting the renewal application is an irreversible regulatory action left entirely to your regulatory coordinator.

Where does it get the IRB expiry dates?

It reads the protocol and regulatory document records stored in RealTime-CTMS, so the dates reflect whatever your team has entered there for each active study.

What if a study has already been renewed?

Studies marked with a current IRB approval date beyond the 60-day window are excluded from the alert automatically each Monday.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.