All templates

Automated eClinicalWorks Colonoscopy Prep Reminders

Every morning, WebRun opens eClinicalWorks, finds colonoscopy appointments scheduled within the next 72 hours, drafts prep reminder messages for each patient, logs them to Google Sheets for staff review, and posts a Slack summary so your team can approve and send before the day starts.

Runs on WebRun · Strict Lockdown policy
Every day at 7:00 AM WebRunorchestrates each step
1 eClinicalWorks find upcoming colonoscopy appointments
2 Google Sheets log drafted reminders for staff review
3 Slack alert staff to review and approve
In short

How do I automatically prepare and queue colonoscopy prep reminders for patients?

WebRun opens eClinicalWorks every morning, finds colonoscopy appointments in the next 72 hours, and drafts prep reminder messages for each patient. Staff review and approve the queue in Google Sheets before anything is sent, then receive a Slack alert with counts and urgent cases flagged, so no patient arrives unprepared.

  • Every colonoscopy patient receives a reviewed prep reminder before their appointment
  • Staff spend minutes approving a queue instead of manually tracking each case
  • Urgent same-day reminders are flagged automatically so nothing falls through

Built for gastroenterology practices · GI clinics · ambulatory surgery centers · endoscopy units

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 www.eclinicalworks.com/login in a real browser with your saved login - no setup, no API keys.

  2. 1
    eClinicalWorks - find upcoming colonoscopy appointments
    eclinicalworks.com
    WebRun in eClinicalWorks: find upcoming colonoscopy appointments
    WebRun opens eClinicalWorks to find upcoming colonoscopy appointments.
    • Open eClinicalWorks and navigate to the schedule view
    • Filter appointments for the next 72 hours flagged as colonoscopy or lower endoscopy
    • Capture patient name, appointment time, provider, and prep type for each

    Done when Every colonoscopy appointment in the next 72 hours is listed with patient and prep details.

  3. 2
    Google Sheets - log drafted reminders for staff review
    google.com
    WebRun in Google Sheets: log drafted reminders for staff review
    WebRun opens Google Sheets to log drafted reminders for staff review.
    • Open the prep reminder review sheet
    • Add a new row for each patient with their appointment time, prep type, and a drafted reminder message
    • Mark each row as Pending Review so staff can action it

    Done when All upcoming colonoscopy patients are logged in the sheet with drafted reminders awaiting staff approval.

  4. 3
    Slack - alert staff to review and approve
    slack.com
    WebRun in Slack: alert staff to review and approve
    WebRun opens Slack to alert staff to review and approve.
    • Post a summary to the clinical channel listing how many prep reminders are ready for review
    • Include a direct link to the Google Sheet so staff can approve and send
    • Flag any appointments within 24 hours as urgent

    Done when Staff have a Slack alert with the count of pending reminders and a link to review them.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.eclinicalworks.com/login
ScheduleRuns automatically on this cadence
Every day at 7:00 AM
DeliveryHow each run's result reaches you
Prep reminder queue · Slack
OutputWhat each run produces - A Google Sheet of drafted colonoscopy prep reminders awaiting staff approval, plus a Slack summary with counts and urgency flags.
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 send prep instructions directly to patients?

No. WebRun drafts the prep reminders and queues them in Google Sheets for a staff member to review and approve. No patient message is sent without human sign-off, keeping PHI secure and clinically accurate.

Which prep protocols does it support?

It works with whatever prep types and instructions you have documented in eClinicalWorks. Give WebRun your prep templates and it will match each appointment to the correct protocol automatically.

What if a patient already received their prep instructions?

The sheet includes a status column so staff can mark patients as already contacted. WebRun skips any row already marked complete on subsequent runs.

Put this on autopilot.

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