Automated Calendar Weekly Meeting Load Scorecard
Every Monday, WebRun opens Calendar, tallies each team member's meeting hours and meeting count from the past week, logs a row per person to Airtable so the trend builds over time, and drafts a Gmail summary flagging anyone whose meeting load rose two weeks running.
How do I track my team's weekly meeting load in Calendar over time?
Every Monday, WebRun tallies each team member's meeting hours and meeting count from Calendar over the past week, logs a row to Airtable so a real trend builds over time, and drafts a Gmail summary flagging anyone whose load climbed two weeks running. Managers see rising meeting loads before they turn into burnout.
- Rising meeting loads get flagged two weeks in, not two months in
- A dated history of meeting hours builds up in Airtable automatically
- Managers open a ready trend summary instead of building one by hand
Built for Team managers · operations leads · people ops · remote team leads
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
calendar.comin a real browser with your saved login - no setup, no API keys. -
1
Calendar - tally last week's meeting load
calendar.com
WebRun opens Calendar to tally last week's meeting load. - Open Calendar and pull each team member's meetings from the past 7 days
- Total the meeting hours and meeting count per person
- Note anyone whose hours jumped noticeably from the week before
Done when Every team member's weekly meeting hours and count are captured.
-
2
Airtable - log the weekly scorecard row
airtable.com
WebRun opens Airtable to log the weekly scorecard row. - Open the meeting load tracker base
- Add this week's row per person with hours, meeting count, and the date
- Keep the running weekly history intact
Done when This week's scorecard is logged for every team member.
-
3
Gmail - draft the trend summary
gmail.com
WebRun opens Gmail to draft the trend summary. - Draft a summary ranking the team by meeting hours this week
- Flag anyone whose load rose two weeks in a row
- Leave the draft in Gmail for the manager to review and send
Done when A drafted trend summary is waiting for the manager's review.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Will the trend summary email send without review?
No. WebRun only drafts the email in Gmail. The manager reviews and sends it, so nothing about anyone's workload goes out unchecked.
How is the meeting load calculated?
It totals each person's booked meeting hours and meeting count from Calendar over the trailing 7 days, so the number reflects a full week, not a single busy day.
Does it change anyone's calendar or decline meetings?
No. It only reads and reports. Adjusting availability or declining meetings inside Calendar stays entirely up to each person.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.