All templates
For medical weight loss clinics, GLP-1 clinics & clinic owners

Recap your program revenue every month

On the first business day of each month, WebRun opens PatientNow, pulls every program enrollment, package sold, and payment recorded in the prior month, builds a revenue breakdown by program tier and payment type in a Google Sheet, and emails you a recap comparing this month's numbers to the month before.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
First business day of the month at 8:00 AM WebRun
1 PatientNow pull the month's enrollments and payments
2 Google Sheets build the revenue breakdown
3 Gmail email you the recap
Run a sample
In short

How do I automatically recap my medical weight loss clinic's monthly revenue?

WebRun pulls every program enrollment and payment from PatientNow at the start of each month, grouping revenue by program tier and payment type in a Google Sheet. It calculates the change versus the prior month and emails you a recap that calls out the top performing tier and anything trending down, so you always know how the practice performed.

  • Owners see revenue by program tier without pulling a manual report
  • Downward trends surface the first week of the month, not at quarter end
  • Enrollment, renewal, and cancellation counts are tracked automatically every month

Built for medical weight loss clinics · GLP-1 clinics · clinic owners · practice partners

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

  2. 1
    PatientNow - pull the month's enrollments and payments
    patientnow.com How to Automate PatientNow
    WebRun in PatientNow: pull the month's enrollments and payments
    WebRun opens PatientNow to pull the month's enrollments and payments.
    • Open PatientNow and pull every program enrollment and payment recorded in the prior calendar month
    • Group revenue by program tier, such as a 3, 6, or 12 month GLP-1 protocol
    • Separate cash pay, insurance, and membership revenue
    • Count new enrollments, renewals, and cancellations for the month

    Done when Every enrollment and payment from the prior month is captured and categorized by program tier and payment type.

  3. 2
    Google Sheets - build the revenue breakdown
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: build the revenue breakdown
    WebRun opens Google Sheets to build the revenue breakdown.
    • Open the monthly revenue tracker sheet
    • Add this month's totals by program tier and payment type as a new column
    • Calculate the change versus the prior month in dollars and percent
    • Update the new enrollment, renewal, and cancellation counts

    Done when The revenue tracker reflects this month's totals, trend versus last month, and enrollment counts.

  4. 3
    Gmail - email you the recap
    gmail.com How to Automate Gmail
    WebRun in Gmail: email you the recap
    WebRun opens Gmail to email you the recap.
    • Draft a recap summarizing total revenue, the top performing program tier, and the change versus last month
    • Call out any program tier or payment type trending down so it's easy to spot early
    • Send the recap to you and any partners on your internal distribution list

    Done when You have this month's revenue recap in your inbox with the trend clearly called out.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.patientnow.com
ScheduleRuns automatically on this cadence
First business day of the month at 8:00 AM
DeliveryHow each run's result reaches you
Revenue recap · Gmail
OutputWhat each run produces - A Google Sheet revenue breakdown by program tier and payment type, plus a monthly recap email comparing this month to the last.
Spreadsheet + recap email
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

Does it touch billing or charge any patient?

No. It only reads enrollment and payment records already in PatientNow to build a summary. It never charges a card, issues a refund, or changes a patient's billing.

How are program tiers grouped?

By the protocol length on file in PatientNow, typically 3, 6, and 12 month GLP-1 programs. Tell WebRun your practice's actual tier names and it will match them.

Who receives the recap?

Only the internal distribution list you set, typically the owner and any partners. It's an internal financial summary, not something shared with patients or the public.

Put this on autopilot.

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