nguyentrieu210/labor-crm-gas

This project is a customer relationship management system built for a specific real world business: staffing agencies that recruit and supply workers to foreign owned factories, mentioning companies like Goertek, Foxconn, and Luxshare as examples. It is written entirely inside Google Apps Script and Google Sheets, so there is no separate server or hosting cost, the spreadsheet itself acts as the database. At its core, the system tracks a recruitment pipeline that moves candidates through stages: registration, interview, passed interview, and started work, alongside weekly hiring targets and results. It also manages customer accounts, pricing policies, scheduled customer care follow ups, and accounts receivable, including aging of unpaid balances and a collection workflow. Access is controlled through a three tier permission model based on a person's role, their assigned branch, and which projects or staff they are responsible for. The feature set includes role based dashboards showing fill rates and pending tasks, daily reporting forms that automatically roll up into weekly KPI numbers, a customer overview screen combining projects, contracts, debts, and care history in one place, and an admin area for managing users, bilingual category lists, and an audit log. The interface supports both Vietnamese and Chinese, works as an installable progressive web app, and is responsive on both desktop and mobile. Under the hood, the code is organized into numbered Apps Script files, each handling one concern such as configuration, the sheet based data layer, KPI calculations, receivables logic, customer care scheduling, permissions, and workflow. A scheduled trigger runs early each morning to recalculate KPIs, age receivables, flag overdue customer care visits, and back up the spreadsheet. Setting it up involves creating a blank Google Sheet, adding the script and HTML files through the Apps Script editor or a provided push tool, running setup functions to seed the sheets, then deploying the project as a web app. The author notes the repository includes real operational sample data and screenshots, and suggests replacing them with anonymized data before reusing the project elsewhere.