All templates

MyApiary Automated Hive Loss Reporting

At season end, WebRun opens MyApiary, reads the starting hive numbers and the dead-out and deadout-cause records for each apiary site, calculates the loss rate per site and overall in a Google Sheet, and drafts a plain summary email to your partners or beekeeping association, leaving it unsent for you to review.

Runs on WebRun · Strict Lockdown policy
On demand at season end WebRunorchestrates each step
1 MyApiary read hive numbers and dead-outs
2 Google Sheets calculate loss rates by site
3 Gmail draft the season summary
In short

How do I calculate my seasonal hive loss rate automatically?

At season end WebRun opens MyApiary, reads the starting hive numbers and every dead-out with its recorded cause, and calculates the loss rate per apiary site and overall in a Google Sheet. It then drafts a plain summary email to your partners or association and leaves it unsent for you to review, so reporting losses takes minutes, not an afternoon.

  • Loss rate per site and overall is calculated without spreadsheets by hand
  • Losses break down by recorded cause so patterns are visible
  • The season summary is drafted ready to send, never sent on its own

Built for commercial beekeepers · apiary managers · beekeeping associations · research and extension teams

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

  2. 1
    MyApiary - read hive numbers and dead-outs
    myapiary.com
    WebRun in MyApiary: read hive numbers and dead-outs
    WebRun opens MyApiary to read hive numbers and dead-out records.
    • Open MyApiary and read the hive numbers at the start of the season per apiary site
    • Read the current live hive count and every dead-out logged this season
    • Capture the recorded cause for each loss where one is noted
    • Group the numbers by apiary site and overall

    Done when Start, end, and dead-out counts with causes have been read per site.

  3. 2
    Google Sheets - calculate loss rates by site
    google.com
    WebRun in Google Sheets: calculate loss rates by site
    WebRun calculates the loss rate per site in the sheet.
    • Open the Season Loss Report sheet
    • For each apiary site write the start count, end count, losses, and the loss rate as a percentage
    • Add an overall row for the whole operation
    • Break the losses down by recorded cause where available

    Done when The sheet shows the loss rate per site and overall with causes.

  4. 3
    Gmail - draft the season summary
    gmail.com
    WebRun in Gmail: draft the season summary
    WebRun drafts the season loss summary and leaves it unsent.
    • Draft a plain summary email to your partners or beekeeping association
    • State the overall loss rate, the per-site figures, and the main recorded causes
    • Attach or link the Season Loss Report sheet
    • Leave the email unsent in Drafts for you to review before sending

    Done when A season summary email is waiting in Gmail drafts, unsent.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.myapiary.com
ScheduleRuns automatically on this cadence
On demand at season end
DeliveryHow each run's result reaches you
Loss report · Gmail draft
OutputWhat each run produces - A loss-rate-by-site Google Sheet plus a drafted season summary email left for you to review.
Report + draft 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

Will it email my partners or association without me?

No. WebRun leaves the season summary as an unsent draft in your Gmail. You read the figures and send it yourself, so no report goes to partners or an association on its own.

How is the loss rate calculated?

It divides the hives lost by the starting count for each apiary site, read from MyApiary, and expresses it as a percentage, then adds an overall figure so you can compare sites and see the whole operation at once.

Can it show why hives were lost?

Yes, where causes are recorded. It reads the dead-out cause noted in MyApiary, such as starvation, varroa, or queen failure, and breaks the losses down by cause so patterns across the season are visible.

Put this on autopilot.

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