Score your agency's project budgets every week
Every Friday, WebRun opens Workamajig, checks each active project's logged hours and expenses against its approved budget, logs the burn rate to Google Sheets, and emails account managers a scorecard flagging any project running hot.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track project budget burn across my agency automatically?
WebRun opens Workamajig every Friday and compares each active project's logged hours and expenses against its approved budget. It logs the burn rate to Google Sheets, highlights anything past 80 percent used, and emails account managers a ranked scorecard, so a project running hot gets caught while there is still time to act.
- Projects running over budget get flagged while there is time to fix it
- Account managers get a ranked scorecard instead of pulling reports manually
- A running Google Sheets record shows burn trends week over week
Built for Creative agencies · account managers · agency operations · project management offices
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
workamajig.comin a real browser with your saved login - no setup, no API keys. -
1
Workamajig - check budget vs actuals
workamajig.com
WebRun opens Workamajig to check budget vs actuals. - Open Workamajig and go through each active project
- Compare logged hours and expenses to the approved budget
- Calculate the percentage of budget used to date
Done when Every active project has a current budget burn percentage.
-
2
Google Sheets - log the burn rate
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the burn rate. - Add this week's burn rate for each project to the tracking sheet
- Highlight projects over 80 percent of budget
Done when This week's burn rates are logged in Google Sheets.
-
3
Gmail - email the scorecard
gmail.com How to Automate Gmail
WebRun opens Gmail to email the scorecard. - Draft a scorecard email ranking projects by budget risk
- Send it to the account managers on each project
Done when Account managers have this week's budget scorecard in their inbox.
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
Does it change budgets or approve overages?
No. WebRun only compares logged hours and expenses to the existing budget and reports the burn rate. Adjusting a budget stays a manager decision in Workamajig.
Who gets the scorecard email?
The account manager assigned to each project, sent internally through Gmail. No client or vendor is ever on this list.
What counts as a project running hot?
Any project the tracking sheet shows over 80 percent of budget used is highlighted, so it stands out before it goes over.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.