🚀 Employee Task Management System Web App | Built Using Google Apps Script & Google Sheets
In this video, I walk you through the development of a comprehensive Employee Task Management System web app using Google Apps Script and Google Sheets. This web app enables employees to manage their tasks efficiently, from logging in to tracking task durations.
Key Features:
- User Authentication: Login functionality to validate employees using Google Sheets.
- Task Overview: View completed tasks with details including task duration.
- Task Management: Create new tasks, update existing tasks, and save end times.
- Responsive Design: Optimized UI for both desktop and mobile devices.
- User-Friendly Interface: Powered by Bootstrap and custom CSS for a clean, modern look.
How It Works:
- Login System: The app validates user credentials stored in a Google Sheet.
- Task Creation: Employees can add new tasks, specifying details and start times.
- Task Completion: Users can update tasks with end times and view completed tasks along with time spent.
- Data Storage: All user data, tasks, and timestamps are managed in Google Sheets, making it easy to track and analyze employee productivity.
Whether you're looking to create a simple task manager or a more complex employee management system, this tutorial will give you the tools and insights you need to get started!
| Step | Instructions |
|---|---|
| Step 1 | Open the web app link provided. |
| Step 2 |
If you see a Google Sheet in view-only mode:
|
| Step 3 |
If you see a page with two options (Make a Copy and AppScript File):
|
| Step 4 | Follow the on-screen instructions to complete the setup. |
| Step 5 | Click on the Extensions menu at the top of the Google Sheet. |
| Step 6 | Select Apps Script from the dropdown menu. |
| Step 7 | In the Apps Script editor, click on the Deploy button. |
| Step 8 | Select New deployment from the dropdown menu. |
| Step 9 | In the deployment configuration, click on Select type and choose Web app. |
| Step 10 | Fill in the required fields and click on Deploy. |
| Step 11 | Grant the necessary permissions when prompted. |
| Step 12 | Once deployed, copy the web app URL provided. |