Manages tasks in Google Sheets, output target tasks in Google Docs, and send reminders via Gmail, allowing for efficient task management on Google Workspace.

This tool is a database-style task management tool designed for managing tasks. It enables efficient task management within Google Workspace without using external apps. Unlike Google's built-in apps like Keep and Tasks, SheetTasker offers various features such as embedding URLs into specific words, notifying task reminders via Gmail, and more. In addition to individual-level task management, it also allows for task management at the team level.

• A Google account with access to Google Sheets, Docs, and Gmail.
• A foundational understanding of Google Sheets, Docs, Gmail, and Google Apps Script.

1. Access Your Google Sheet: Begin by opening the Sample Google Sheet.
   【Note】
   • For your reference, you can find sample Google Documents used to display tasks from HERE, which will be explained later.
   • The samples provided are merely illustrative, showcasing a tasks managements for an educational institution.
2. Copy the Google Sheet: Make a copy of the Google Sheet to create your personalized version.
3. Authorization: The first time you run the script, it will ask for your permission to access certain data. If you're using a free Gmail account, you might see a warning that says Not Verified by Google. Don't worry about this warning - you still need to give permission for the script to work. The script is yours alone, and it won't share any data outside of Google, unless you choose to share your Google Sheet. The only data it might send outside of Google is website status codes, for monitoring purposes.
4. Return to Original Format: Use this option to reset the Google Sheet to its original format (i.e., Delete sample task sheets, clear contents in index sheets, reset pre-defined sample information, and delete sample triggers). Navigate to Custom Menu > SETTINGS and click Reset All Pre-Defined Info & Triggers.
5. Set Information to be Pre-defined: Navigate to Custom Menu > SETTINGS > Set Pre-Defined Info to customize the system to your specific requirements.
   • General Setting: Essential to use this tool such as defining index-sheets and name of the editors (work staff) in the Google Sheet.
   • Setting for Each Type of Reminder: This setting is designed to configure each type of reminder: general reminders, which notify designated staff of all incomplete tasks, and staff-based reminders. For each reminder type, users need to set information such as the staff to receive the reminder, the URL of the Google Doc displaying target tasks, and the trigger to execute sending reminder email.
   • Google Sheet and Doc Integration: Set a trigger to monitor task completion statuses in Google Doc and update the completion field in Google Sheet.

   

   

Please note that your use of this website is subject to the Terms and Conditions.

You can find the source code for this tool on Github. Click HERE .