Add each staff member once with name, email, and department. When assigning a task by typing just their name or department, their email auto-fills.
All data syncs to your Google Sheet and is visible to all users. The URL is auto-fetched from the sheet — you never need to change it here manually.
Config tab using getConfig — no manual updates needed.
Staff receive an email when a task is assigned to them and a reminder 2 days before due date.
The email is sent by Google Apps Script using your Google account.
To enable: enter a staff email when assigning a task in the Tasks tab.