Team-capacity tracking with over-allocation alerts

The scenario calculates team load from Microsoft To Do issues, keeps a history in Google Sheets, and on overload emails a report to the manager at AWS SES.

  • Each person's load calculated automatically
  • Load history kept in Google Sheets
  • Overload — an email to the manager at AWS SES
  • The problem seen ahead of the miss