Complete Project Management Dashboard in Google Sheets & Apps Script | D29

A project management dashboard with the client built into it. Add a customer and the system creates their login; from then on they can follow their own project's progress instead of emailing to ask where it is.

The client portal is the differentiator

Most project tools are internal and the client sees nothing, so status updates become a stream of messages. Here, customer accounts are created automatically when you add the customer, and they get a portal showing their project, its stage and its payment status. The questions stop because the answer is already visible.

Project queue and tracking

Real-time tracking with queue management shows what is in progress, what is waiting and what order it will be worked in. Deadline and payment tracking sit against each project, so delivery dates and money owed are in the same view rather than in two separate places.

Built for cross-border work

Multi-currency support for PKR, USD, INR and BDT means clients in different countries are billed in what they understand, while the dashboard still shows you a coherent picture. For freelancers and agencies with overseas clients, this is usually the thing a generic tool gets wrong.

Notifications and roles

Email notifications go out on status updates, so a client hears about progress without anyone composing a message. Advanced user role management controls who sees and edits what across staff and customers.

Who it suits

Freelancers managing several clients at once, agencies running a project pipeline, and service businesses that want customers informed without a daily reporting habit.

Setup

Copy the sheet, deploy the script, add your first customer and project. Google Sheets is the database. The video covers the admin side and the client portal, and support is free if you get stuck.