Can I customize the project and task fields?
Yes. You can modify the Google Sheets columns, Apps Script backend, and frontend forms to match your workflow.
Project Management template
Simple Project & Team Task Tracker
A lightweight project and team task tracker built with Google Sheets and Google Apps Script. Manage projects, assign tasks, track deadlines, monitor team progress, and organize work with a simple Kanban board. Designed for freelancers, startups, and small teams that need an easy project management system without complex software or monthly subscriptions.
project trackertask trackerteam task managerproject managementGoogle SheetsApps ScriptKanbansmall team productivity
Template capabilities
What Simple Project & Team Task Tracker helps you automate
project tracker
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
task tracker
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
team task manager
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
project management
Adapt this part of the workflow to your own Google Workspace files, fields, users, and operating process.
Common use cases
Built for practical project management work
- Track freelance client projects
- Manage startup team tasks
- Organize small business projects
- Assign work to team members
- Track project deadlines
- Monitor overdue tasks
- Plan weekly team workload
- Manage simple internal projects
- Replace manual task spreadsheets
- Use as a lightweight Trello alternative
How to use it
From access request to working automation
- 1
Make a copy of the provided Google Sheet
- 2
Open Extensions > Apps Script
- 3
Add the included app files
- 4
Save the Apps Script project
- 5
Run the setup function once if needed
- 6
Authorize Google Sheets permissions
- 7
Deploy the project as a Web App
- 8
Open the Web App URL
- 9
Add your team members
- 10
Create projects
- 11
Create and assign tasks
- 12
Use the dashboard and Kanban board to track progress
Setup checklist
Before using the template
Use the correct Google account
Create or copy the Google Sheet
Open the Apps Script editor
Add Code.gs
Add Index.html
Add Styles.html
Add Scripts.html
Save all files
Run setupDatabase once if required
Complete Google authorization
Deploy as a Web App
Set access permissions for your intended users
Open the deployment URL
Test project creation
Test task creation
Test Kanban status changes
FAQ
Questions about Simple Project & Team Task Tracker
Do I need a paid Google Workspace account?
No. A regular Google account can run this app within normal Google Apps Script usage limits.
Does it support multiple team members?
Yes. You can create team members and assign them as project owners or task assignees.
Does project progress update automatically?
Yes. Project progress is calculated from the percentage of project tasks marked as Done.
Does it include a Kanban board?
Yes. Tasks are organized into To Do, In Progress, and Done columns, with drag-and-drop status changes.
Is there a login system?
No. The MVP intentionally does not include a custom login or complex permission system.
Where is the data stored?
All project, task, team, and settings data is stored directly in Google Sheets.
Can I use it for client projects?
Yes. It works well for freelancers, agencies, startups, and small teams managing multiple projects.
Related templates
Continue exploring Apps Script automation
Finance & Billing Automation
Smart Invoice & Payment Reminder Tracker
A Google Sheets + Apps Script invoice tracker that helps freelancers, consultants, and small businesses create invoices, track payment status, send email reminders, and manage overdue payments. It solves the problem of forgotten invoices, late payments, and messy billing records.
CRM & Sales Automation
Lightweight CRM + Follow-Up Automation
A lightweight CRM built with Google Sheets and Apps Script to manage leads, clients, status pipelines, notes, and automated follow-up reminders. It helps freelancers, agencies, and small businesses keep track of prospects and improve response consistency. It solves the problem of lost leads, forgotten follow-ups, and disorganized client data.
Booking & Scheduling
Appointment Booking + Email Reminder System
A booking and scheduling app built with Google Sheets and Apps Script that helps service businesses manage appointments, customer details, time slots, and automatic email reminders. It helps reduce no-shows, keeps bookings organized, and makes scheduling easier. It solves the problem of manual appointment handling and forgotten reminders.