To manage my daily tasks, I enter them in my google sheets as follows:
The sheet gets messier to understand when number of rows increase. So what I needed was a summary of tasks, so that I can easily understand what are my delayed tasks, tasks for today and tasks whose deadline I haven't set yet.
I used apps script to achieve this.
- This project uses clasp to run locally. So, need to first install it and setup project
- The function to run locally is
clasp run sendTaskSummaryEmail