To-do List Plugin: Stay Organized Without Leaving Google Sheets

Turn your Google Sheet into an easy-to-use task manager with To-do List Plugin — designed to streamline your workflow and keep you focused.

✅ Effortless Task Tracking:
Add, edit, and complete tasks directly in your sheet.
Organize by due date, priority, or category.
Mark tasks as done with a simple checkbox.

✅ Boost Productivity:
Keep all your tasks in one place — no more switching between apps.
Customize the list layout to fit your workflow.
Use Google Sheets' built-in features to sort, filter, or even chart your progress.

✅ Perfect for:
Personal to-dos — stay on top of daily tasks.
Team projects — collaborate in shared sheets.
Work tracking — monitor deadlines and priorities.

🚀 Get Started Quickly:
Install the To-do List Plugin and start managing your tasks in seconds — no extra setup required.

👉 Stay productive and organized — all within Google Sheets!

How to install?

1. Open your existing to-do list Google sheet or a blank Google sheet. 
2. Go to Google Workspace Marketplace  to install this add-on. After Installation, your sheet menu Extensions will have this add-on . If not, please re-open your sheet.
3. From the menu, select 'Plug in'. If the opened sheet is blank, a template will be created for you. Otherwise, a sidebar will pop up for you to configure the plugin parameters, namely your to-do list sheet name, header row number, date column, task column and optional repeating frequency column and sorting columns. 

How to use?

1. You just edit your to-do list. 
2. After a cell which has column configured is editted, Google sheet will trigger this add-on to perform the following:
- For date edited, the task will be sorted according to date.
- For task ticked for completion, the task will be sorted to the end of the list.
- For a new task entered to an empty row, an empty row will be inserted.
- For repeating task ticked for completion, the task date will be advanced according to your given repeating frequency. The frequency can be in number of days (d), weeks (w), months (m) and years (y). The repeating frequency is expressed as nx where n is a number and x is d, w, m or y. For 'd', it is daily excluding weekend. For '1d', it is daily including weekend. For m and y, if the date is on month-end, the advanced date will be on month-end. 

This plugin is using the Google sheet trigger onEdit which is processed in Google cloud. Depending on your network traffic, please allow one to a few seconds for your edits going to the cloud and have the refresh back to your device.  You will notice the start and end of the refresh from the task header which changes color to red momentarily. 

If refresh has mixed with your input,  you can unplug and use Google sheet Undo (Ctrl-Z) to roll back the changes or use restore previous version. After a few times, you will get use to the Google onEdit trigger.

This plugin is free for installation and use. If it saves your time, please support me.

#SPCsoft #to-do #todo #todolist