All templates
For Remote team managers, operations managers & agencies

Turn Hubstaff time data into a weekly team scorecard

Every Monday, WebRun opens Hubstaff, pulls last week's tracked hours and activity level for each team member, writes the totals to a Google Sheet, and emails the manager a scorecard highlighting anyone with low activity or missing time.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 8:00 AM WebRun
1 Hubstaff pull tracked hours and activity
2 Google Sheets log the weekly totals
3 Gmail email the scorecard
Run a sample
In short

How do I get a weekly Hubstaff hours and activity scorecard for my team?

WebRun pulls each team member's tracked hours and activity level from Hubstaff every Monday, logs the week's totals to a Google Sheet, and emails the manager a scorecard that flags anyone below your hours or activity threshold. The team member is never contacted directly, so the manager always starts the week with a clear, private summary.

  • Managers start the week with a ready-made hours scorecard
  • Low-activity team members are flagged automatically
  • A full weekly hours log builds up in Google Sheets

Built for Remote team managers · operations managers · agencies · distributed 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 app.hubstaff.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Hubstaff - pull tracked hours and activity
    hubstaff.com
    WebRun in Hubstaff: pull tracked hours and activity
    WebRun opens Hubstaff to pull tracked hours and activity.
    • Open Hubstaff and pull last week's timesheets
    • Read each team member's total hours and activity percentage
    • Flag anyone below your activity or hours threshold

    Done when Every team member's weekly hours and activity are captured.

  3. 2
    Google Sheets - log the weekly totals
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log the weekly totals
    WebRun opens Google Sheets to log the weekly totals.
    • Add a row per team member for the week
    • Record total hours, activity percentage, and projects worked
    • Highlight rows flagged for low activity or missing time

    Done when The week's totals are logged in the tracking sheet.

  4. 3
    Gmail - email the scorecard
    gmail.com How to Automate Gmail
    WebRun in Gmail: email the scorecard
    WebRun opens Gmail to email the scorecard.
    • Draft a scorecard summary of the week's hours and activity
    • List anyone flagged for low activity or missing time first
    • Send it to the manager, not the team member directly

    Done when The manager has the week's scorecard in their inbox.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.hubstaff.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Weekly scorecard · Gmail
OutputWhat each run produces - A weekly Google Sheet of hours and activity per team member, plus an emailed scorecard for the manager.
Scorecard
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 message the team member about low activity?

No. WebRun emails the scorecard to the manager only. Any conversation with the team member stays a human one.

What counts as low activity?

Whatever hours or activity-percentage threshold you set. Anyone under it for the week is flagged first in both the sheet and the email.

Does it track anything beyond hours and activity?

No, it reports what Hubstaff already tracks: total hours and activity percentage per project. It doesn't add new monitoring.

Put this on autopilot.

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