Automated Ganttic Resource Utilization Export
Every Monday, WebRun opens Ganttic, checks each resource's booked hours against capacity for the coming week, logs utilization percent in Google Sheets, and emails the resource manager if anyone is booked over 100 percent.
How do I track Ganttic resource utilization automatically every week?
WebRun checks Ganttic every Monday for each resource's booked hours against capacity for the coming week, logs the utilization percent in Google Sheets alongside prior weeks, and emails the resource manager whenever someone is booked over 100 percent. Overallocation gets caught before the week starts, not after a project stalls.
- Overallocation gets caught before the week starts, not after
- Utilization trends stay logged for every resource, every week
- Resource managers hear about conflicts only when there's a real one
Built for resource managers · operations leads · project management offices · agency staffing managers
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
web.ganttic.comin a real browser with your saved login - no setup, no API keys. -
1
Ganttic - check resource utilization
ganttic.com
WebRun opens Ganttic to check resource utilization. - Open Ganttic and check each resource's booked hours against capacity for the week ahead
- Note utilization percent per resource
- Flag anyone booked over 100 percent
Done when Every resource's utilization for the coming week is captured.
-
2
Google Sheets - log utilization by resource
google.com
WebRun opens Google Sheets to log utilization by resource. - Add a row per resource with this week's utilization percent
- Keep prior weeks' rows so trend is visible
- Highlight anyone over 100 percent
Done when This week's utilization is logged alongside prior weeks in Sheets.
-
3
Gmail - email the overallocated list
gmail.com
WebRun opens Gmail to email the overallocated list. - Email the resource manager the list of anyone overallocated this week
- Include the percent over and which projects are competing for their time
- Skip the email if nobody is overallocated
Done when The resource manager has this week's overallocation list by email.
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 it change any bookings in Ganttic?
No. WebRun only reads booked hours against capacity. It never creates, moves, or deletes a booking.
What counts as overallocated?
Any resource booked over 100 percent of capacity for the coming week, so the email only fires when there's a real conflict to resolve.
Do I get an email every week even if nobody is overallocated?
No, the email only sends when someone is over capacity. The Sheets log still gets every resource's utilization regardless.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.