Automated & Non-Automated Task Tracker (Google Sheets)

Stay organized with this simple to use custom automated or non-automated task tracker!

Both the Automated and Non-Automated versions of the Google Sheets task tracker are included in this purchase. See below for the highlights of each:

Save $$$ by purchasing these templates in the All Google Sheets Bundle + Excel Task Tracker Bundle!

Customizable Automated Task Tracker: (Full Walk-Through) *** NEW***

Launched August 2026!

• Task automatically moved to a single lists of all completed tasks and is removed from the active task lists once the task is marked as "Done"
• Automatic timestamp when a task is added or marked as "Pending" or "Done"
• Task automatically moved to the Parked Tasks list when the status is updated to "Parked". This will allow you to keep an eye on tasks you need to keep on your radar but it wont clutter your task list. Marking the status as "Ready will automatically move the task back to your Task List
• Dropdowns to keep track of your task type, progress/status, priority & task focus
• Recurring tasks can now repeat by an exact day of the month (like the 5th, or the last day of the month) in addition to weekday-based rules like "First Monday" - fits how your job actually schedules things
• Guided timezone & schedule setup walks you through confirming your timezone and picking exactly which days and times trigger your Daily tasks 
• Set a "Days to Complete" countdown on any recurring task and its Deadline gets calculated automatically the moment it's added to your list
• Task Bundles: build a reusable, one-click group of tasks (like a New Hire checklist) and add the whole thing to your task list instantly from its own menu - run it as many times as you need
• Rename or reorder your column headers and the automation still finds them - you're not locked into a fixed layout
• One click ("Sync Columns Across Tabs") keeps Parked and Done matching Task List whenever you add, remove, or rename a column - no manual rebuilding
• Pause every automation at once with a single Resume Date - perfect for vacation, nothing fires until you're back
• Update your Priority or Progress dropdown options in one place and every tab (plus the sort order) updates with them
• Overdue deadlines highlight in red automatically - no manual refresh, no trigger needed
• Links pasted into Website keep their preview card even after a task is automatically moved or added
  
• This will be the version that receives future upgrades!

Note: This currently excludes the calendar snapshot, kanban view, and charts. These will be added soon.

Rolling Automated Task Tracker Features: (Full Walk-Through)

• Recurring tasks are automatically added to your task list each day based on the day they need to be done
• Visualizations showing the breakdown of your task focus, priority, task type, and on time completion by week and month to easily see where you're spending your time
• Automatic timestamp when a task is added or marked as "Pending" or "Done"
• Dropdowns to keep track of your task type, progress/status, priority & task focus
• Task automatically moved to a single lists of all completed tasks and is removed from the active task lists once the task is marked as "Done"
• Task automatically moved to the Parked Tasks list when the status is updated to "Parked". This will allow you to keep an eye on tasks you need to keep on your radar but it wont clutter your task list. Marking the status as "Ready will automatically move the task back to your Task List
• Text formatting to easily identify which tasks are next
• Saved views for your table
• Completed task counter
• Easily updated and customizable
  

Non-Automated Task Tracker Features: (Full Walk-Through)

The non-automated version has essentially the same features as the automated version except for the automatic timestamps and automatically moving from tab to tab. There is also no parked tab. Otherwise it works the same. Don't worry though, it requires minimal upkeep to operate and super easy to use!

Make it your own by updating the color schemes and adding additional columns that would help your productivity.

Note: This tracker is for Google Sheets only. It is not transferrable to Excel.

 *** While not common, some employers may not allow Apps Script due to company firewalls. If this is the case, the Non-Automated Task Tracker without Apps Script is a better option.

Improving your workday (and mental health) should be for everyone. If you cannot afford this item or want to make it yourself, I have a step-by-step training on my Youtube Channel @sheetsbyolan where I teach you how to make it from scratch. If you cannot afford it and are unable to make it from scratch just send me an email!