TaskFlow: A Google Sheets-Based Task Assignment & Notification System
Link to Live Project: https://docs.google.com/spreadsheets/d/1lgQgQqQNr6plFXgrc1qdP_3HP9-NQPNWc6KIgQNZFtE/edit?usp=drivesdk
Built a lightweight task management system entirely within Google Sheets using Google Apps Script and Twilio Sandbox for WhatsApp messaging.
🔹 Secure user login with role-based access
🔹 Create, assign, and track tasks with email + WhatsApp notifications
🔹 Real-time task status updates: Assigned, Pending, Completed
🔹 Admin dashboard to monitor all users and filter by status
🔹 Fully styled HTML interfaces embedded into Google Workspace environment
📬 Technologies Used: Google Apps Script, HTML/CSS, Twilio WhatsApp API (Sandbox), Gmail API
📋 How to Run the Project:
1. Make a copy of the Google Sheet
2. Go to the Users tab and add your username, password, email address, and phone number
3. Go to Extensions > Apps Script
4. In the script, update your Twilio Account SID, Auth Token, and WhatsApp Sandbox Number
5. Use the menu to Log In or open the Admin View, and begin assigning and completing tasks
