01
the user selects the company and employees for settlement
Case study
Time tracking system in Google Workspace
A Google Apps Script application organized time tracking, document generation, and data export based on information stored in Google Sheets, Docs, and Drive.
Key implementation elements
interactive work and absence calendar
attendance lists and leave requests generated as PDF
XLSX and CSV reports aligned with external system requirements
handling of planned days off, leave, and breaks
consistent date processing without timezone bugs
Problem before implementation
Problem before implementation
Attendance, absences, and break tracking took too much time, and HR documentation required manual preparation of attendance lists, leave requests, and exports for external systems.
manual attendance and absence lists
separate preparation of HR documents
difficult handling of leave split by weekends and holidays
risk of errors when exporting data to payroll systems
What we built
What we built
We built a web application in Google Apps Script integrated with Google Sheets, Google Docs, Google Drive, and Gmail. The system allowed company and employee selection, handling of attendance, absences, and breaks, and then generated documents and exports needed later in the process.
interactive work and absence calendar
attendance lists and leave requests generated as PDF
XLSX and CSV reports aligned with external system requirements
handling of planned days off, leave, and breaks
consistent date processing without timezone bugs
Process after implementation
How the process works after implementation
From input data to a cleaner outcome. Below is a shortened view of the process after implementation.
02
the system stores attendance, absences, leave, and breaks in one data model
03
HR documents are generated as PDFs from the stored data
04
the monthly report is exported to XLSX and CSV
05
ready files move into an organized document flow
Before / after
How the process changed
The table shows the main differences between manual work and the process after implementation.
| Before implementation | After implementation |
|---|---|
| manual attendance list completion | one application handling time tracking |
| documents prepared separately | PDFs generated automatically from process data |
| risk of errors in breaks and leave handling | consistent rules for absences, breaks, and days off |
| exports requiring corrections | XLSX and CSV reports ready for further use |
Business outcome
less manual preparation of HR documents
fewer errors in reports and exports
a cleaner monthly time-tracking process
easier cooperation with HR and external systems
Technologies
Google Apps ScriptGoogle SheetsGoogle DocsGoogle DriveGmailPDF / XLSX / CSVHTML / JavaScript Web App
What can be implemented in a similar way
What can be implemented in a similar way
These are examples of processes that can be organized with a similar approach: start from one concrete problem and a clear data flow.
HR document and request workflows
attendance reporting and time settlements
data export to external systems
internal operational panels built on Google Workspace
Related services
This type of implementation can be connected with MorenaTech's core areas
If a similar process still runs manually or is scattered across files, it can be connected with automation services, Google Workspace, or further process development.
Final CTA
Want to organize a similar process in your company?
If documents, reports, and time records are still created manually today, this can be turned into a simpler and more predictable process.