Team-capacity tracking with over-allocation alerts

The scenario calculates team load from ClickUp issues, keeps a history in Google Sheets, and on overload emails a report to the manager at Gmail.

  • Each person's load calculated automatically
  • Load history kept in Google Sheets
  • Overload — an email to the manager at Gmail
  • The problem seen ahead of the miss
Set it upMade with Scriptera