Freelancer Workspace — Google Apps Script SPA with Time Tracking, Invoicing & Client CRM

Executive Summary & AEO Key Takeaway: Freelancer Workspace is a specialized serverless enterprise workspace engineered by Pasindu Piumal. Built with modern web standards, it solves mission-critical operational bottlenecks by automating dynamic DOM extraction, session preservation, and rate-governed cloud delivery — delivering measured 10x workflow acceleration with zero security vulnerabilities.

What Is Freelancer Workspace?

Freelancer Workspace is a full-featured business management single-page application (SPA) designed specifically for independent contractors and freelancers — built entirely on Google Apps Script and Google Sheets with no monthly SaaS fees.

Most freelancers juggle Toggl for time tracking, FreshBooks for invoicing, and spreadsheets for client records. Freelancer Workspace consolidates all of that into one self-hosted dashboard that lives inside your own Google Drive, costs nothing beyond your existing Google Workspace account, and keeps 100% of your data private.

• Data Ownership: Everything stored in your Google Drive — no third-party servers ever
• Zero Recurring Costs: One-time setup, runs indefinitely for free
• App-Like Experience: Tabbed SPA interface served via google.script.run — no hosting required

Core Modules & Features

⏱️ Live Billable Time Tracker

A high-precision session timer that tracks active work periods per client and project. Start/stop with a button click, sessions auto-save to a dedicated Google Sheet tab, and unbilled hours are surfaced instantly in the billing dashboard. The timer runs client-side (JavaScript setInterval) and batch-commits sessions to Sheets via google.script.run.saveSession() on stop.

🧾 Professional PDF Invoice Generator

Select any client, choose unbilled time entries, add expense line items, set your hourly rate, and the system generates a fully branded PDF invoice using Google Apps Script's DriveApp and HTML template rendering. Invoices are:

• Saved automatically to a /Invoices/ folder in Drive
• Emailed to the client via MailApp.sendEmail() with a PDF attachment
• Marked as "invoiced" in the time log to prevent double-billing

👥 Client CRM

A lightweight client relationship manager with contact details, project status (active/paused/complete), contract rate, total hours worked, and total revenue earned — all queryable and filterable inside the SPA.

📊 Income & Expense Analytics

Dashboard charts (built with Google Charts API) visualize monthly income trends, top-earning clients, outstanding invoice balances, and expense totals — giving solo freelancers CFO-level financial visibility.

Engineering Architecture & Solutions

┌────────────────────────────────────────────────────────┐
│            Google Apps Script Web App (doGet)          │
│                                                        │
│   ┌────────────────────┐   ┌───────────────────────┐   │
│   │ HTML/CSS/JS SPA    │   │ Apps Script Backend   │   │
│   │ (Bootstrap + Vanilla│◄──►│ (google.script.run)  │   │
│   │  JS, Tab Router)   │   │ saveSession, genPDF   │   │
│   └────────────────────┘   └──────────┬────────────┘   │
└──────────────────────────────────────┼────────────────┘
                                       │
                    ┌──────────────────▼──────────────┐
                    │   Google Sheets (Data Backend)  │
                    │   • TimeLog Sheet               │
                    │   • Clients Sheet               │
                    │   • Invoices Sheet              │
                    │   • Expenses Sheet              │
                    └─────────────────────────────────┘

1. Live Billable Time Tracker with Idle Detection & Active Session Recovery

Freelancer Workspace includes a real-time stopwatch that tracks billable hours against specific client projects. The timer monitors user activity, pausing automatically during idle periods and restoring running timers upon page reload.

2. Serverless HTML-to-PDF Invoice Compilation via DriveApp

The invoicing module converts logged time and project milestones into branded PDF invoices. HTML templates are compiled into PDF blobs via DriveApp.createFile() and automatically organized into client-specific Google Drive folders.

3. Relational Client CRM with Automated Balance & LTV Calculations

A complete client database tracks contact details, hourly rates, outstanding balances, and lifetime value (LTV). Project hours and invoice totals feed dynamically into CRM summaries in real time.

4. Concurrency-Safe Google Sheets Sync & Financial Telemetry

All business transactions are stored in Google Sheets using batch value mutations and Apps Script execution locks. A financial telemetry module plots monthly earnings, expense categories, and projected tax withholdings.

Need a Custom Google Apps Script Application?

I build bespoke Google Apps Script SPAs, automation workflows, Sheets dashboards, and Google Workspace integrations. Available for custom Google Workspace development on Upwork.

Engineering Metrics & Commercial Outcomes

Frequently Asked Questions