All templates

Automated Substack Subscriber and Post Reporting

Every morning, WebRun opens Substack, checks new subscriber counts and the latest post's open and click performance, posts the digest to Microsoft Teams, and logs a Trello card summarizing it for the content calendar.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every day at 8:30 AM WebRunorchestrates each step
1 Substack check subscribers and post performance
2 Microsoft Teams post the digest
3 Trello log a content-planning card
In short

How do I get a daily digest of my Substack growth and post performance?

WebRun checks Substack every morning for new subscribers and the latest post's open and click rates, posts the digest to Microsoft Teams, and logs a Trello card summarizing it for the content calendar, so your team starts the day knowing exactly how the newsletter is growing and performing.

  • The team sees subscriber growth and post performance every morning
  • Underperforming posts get flagged for the content calendar the same day
  • No more manually checking Substack analytics each day

Built for newsletter writers · content teams · independent publishers

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

  2. 1
    Substack - check subscribers and post performance
    substack.com
    WebRun in Substack: check subscribers and post performance
    WebRun opens Substack to check subscribers and post performance.
    • Open Substack and check new subscribers gained since yesterday
    • Pull the latest post's open rate and click rate
    • Note any change in paid subscriber count

    Done when Today's subscriber and post performance numbers are captured.

  3. 2
    Microsoft Teams - post the digest
    microsoft.com
    WebRun in Microsoft Teams: post the digest
    WebRun opens Microsoft Teams to post the digest.
    • Open the content team channel in Microsoft Teams
    • Post the subscriber growth and latest post performance
    • Note any post underperforming its usual open rate

    Done when Today's digest is posted to Microsoft Teams.

  4. 3
    Trello - log a content-planning card
    trello.com
    WebRun in Trello: log a content-planning card
    WebRun opens Trello to log a content-planning card.
    • Open the content calendar board in Trello
    • Add a card summarizing today's numbers for planning reference
    • Flag it for follow-up if a post underperformed

    Done when Today's numbers are logged as a Trello card.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
substack.com
ScheduleRuns automatically on this cadence
Every day at 8:30 AM
DeliveryHow each run's result reaches you
Subscriber digest · Microsoft Teams
OutputWhat each run produces - A daily summary of new subscribers and the latest post's open and click rates.
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

Does it publish or edit posts for me?

No. WebRun only reads subscriber and performance data. Writing and publishing a post is always done by you in Substack.

Does it message my subscribers?

No. The digest goes to your internal Microsoft Teams channel and a Trello card, never to your Substack readers.

What counts as underperforming?

A post whose open or click rate falls noticeably below your recent average, based on what Substack's own analytics show.

Keep going

Related templates

Automated ActiveCampaign Campaign Reporting
WebRun checks yesterday's ActiveCampaign campaign performance, logs the numbers to Google Sheets, and updates a Notion dashboard so your team always has fresh campaign data.
ActiveCampaign›Notion›Google Sheets
Automated Act-On Campaign Performance Digest
Every morning, WebRun opens Act-On, reads yesterday's campaign opens, clicks, and lead score changes, logs them to a Google Sheet, and emails the marketing lead a short summary through Gmail.
Act-On›Google Sheets›Gmail
Automated Airship Push Delivery Alerts
WebRun monitors Airship push campaign delivery and open rates, and when a campaign drops below your threshold, it blocks a review slot on Google Calendar and alerts Microsoft Teams.
Airship›Google Calendar›Microsoft Teams

Put this on autopilot.

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

Deploy this workflow Talk to us