A calendar for tasks in Google Sheets that syncs with Calendar

Open the calendar template in a web browser: link.

In the menu, click File > Make a copy... and save the spreadsheet to your Google Drive (you must be logged in).

From your saved copy of the spreadsheet, click Tools > Script Editor.

Set the value of SPREADSHEET_ID to be equal to the value of your unique spreadsheet id. You can find this in the url, after the '/d/' and before the '/edit'. For example, in the above link, the id is '1Uae2jFOZab0qpTuythyJCJ2uhapkYYy2uhlgj0hXA60'.

Set the value of CALENDAR_ID to the value of the calendar you want tasks to be uploaded to. If left as 'primary', tasks will be uploaded to your default calendar. You can find the id of a calendar by going to Calendar Settings > Integrate Calendar on the Google Calendar website.

Set the value of TIMEZONE to your timezone (keep the same format).

From the Script Editor, click Edit > Current project's triggers. Click 'No triggers set up. Click here to add one now.' Change 'readCell' to 'createMenu' and 'Time-driven' to 'From spreadsheet'. Leave 'On open' as is. Click Save.

From the Script Editor, click Resources > Advanced Google services... and toggle 'Calendar API' to ON. Then, click on the Google API Console link. Search for 'Google Calendar API' and click 'Enable'.

At the bottom of the spreadsheet, switch to the Settings sheet and change the start date to whatever value you would like. If left blank, it will default to the Sunday of two weeks ago. You can change the event color id as well; the default is '5', which is yellow.

Refresh the spreadsheet to enable all the changes.

There are four categories (rename them to whatever you wish). Under these categories, there are tasks. Each task has a day, a time, a name, and a status. When the status is 'Submitted' or 'Complete', the task will be grayed out and struck through. If the task is overdue or due within 3 days, then it will be highlighted and bolded. Additionally, the day the task is due will be highlighted on the mini calendar to the left. The current date is bolded.

Under the General section, you may list days that will show up under the mini calendar, but they are not tasks.

To sync with your Google Calendar, from the top menu, click Calendar > Update Week/Month. Accept the required permissions. All tasks within the next week or month, respectively, will be added to your calendar. If the task was previously added to your calendar, it will not be re-added. (Technical note: tasks are uniquely identified by their cell location and name, so if either of these are changed, then the task will be re-added upon next update).

Your tasks will appear in your calendar as '<category name> <task name>'.

Note that this project will be updated periodically as I actively use it and will push changes every once in a while.

Added ability to have tasks upload to a specific calendar and be a specific color. Start date of the mini calendar will default to two weeks ago. Tasks with the status 'Complete' will now be treated the same as 'Submitted'. The current date is bolded.

Original version.