All templates

Automated Uscreen Subscriber Revenue Export

Every Monday, WebRun opens Uscreen, pulls new sign-ups, cancellations, and revenue for the last 7 days, logs them as a row in Google Sheets, and drafts a weekly recap in Gmail for your team.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Uscreen pull subscriber activity
2 Google Sheets log revenue and churn
3 Gmail draft the weekly recap
In short

How do I track weekly Uscreen subscriber revenue and churn?

WebRun pulls new sign-ups, cancellations, and revenue from Uscreen every Monday, comparing the week against the one before. It logs the numbers as a row in Google Sheets and drafts a weekly recap in Gmail for your team, left unsent, so you always know how the week went without exporting reports from Uscreen yourself.

  • Weekly revenue and churn are logged without exporting reports by hand
  • Sign-up trends by plan tier are easy to spot
  • Recap emails are ready to send without writing them from scratch

Built for video creators · fitness instructors · course creators · streaming businesses

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

  2. 1
    Uscreen - pull subscriber activity
    uscreen.tv
    WebRun in Uscreen: pull subscriber activity
    WebRun opens Uscreen to pull subscriber activity.
    • Open Uscreen and pull new sign-ups, cancellations, and revenue for the last 7 days
    • Compare against the prior week
    • Note which plan tier drove the most sign-ups

    Done when This week's subscriber activity and revenue are captured.

  3. 2
    Google Sheets - log revenue and churn
    google.com
    WebRun in Google Sheets: log revenue and churn
    WebRun opens Google Sheets to log revenue and churn.
    • Log new sign-ups, cancellations, and revenue as a new row
    • Calculate net subscriber change for the week
    • Update the running monthly total

    Done when This week's Uscreen activity is logged in Google Sheets.

  4. 3
    Gmail - draft the weekly recap
    gmail.com
    WebRun in Gmail: draft the weekly recap
    WebRun opens Gmail to draft the weekly recap.
    • Draft a weekly recap summarizing sign-ups, cancellations, and revenue
    • Address it to your team or business partner
    • Leave it unsent for review before sending

    Done when A weekly recap draft is waiting in Gmail.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.uscreen.tv
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Revenue log · Google Sheets
OutputWhat each run produces - A Google Sheets log of weekly sign-ups, cancellations, and revenue, with a Gmail recap drafted for your team.
Sheet log
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 cancel or refund a subscriber?

No. WebRun only reads sign-up, cancellation, and revenue numbers. Any account action on a subscriber stays in Uscreen with you.

Does the recap email send itself?

No. It's left as a Gmail draft for you or your team to review before sending.

How is net subscriber change calculated?

New sign-ups minus cancellations for the week, logged alongside the raw numbers so you can see both sides.

Put this on autopilot.

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