Current Volume 9
Google Apps Script-Based Automation for DPWH Project Document Preparation: A Developmental Design Science Case Study
Abstract
This study documented the development and preliminary artifact-based evaluation of a Google Apps Script-based document generation engine for selected DPWH project document preparation. The problem addressed was the continued manual or semi-manual preparation of formal project documents despite the availability of structured digital data in spreadsheet-based sources. Using a developmental design science case study approach, the study examined a Google Workspace artifact that connects Google Sheets data with Google Docs templates through predefined placeholders. No external respondents were involved; instead, the evaluation used artifact-based evidence, including workflow comparison, step count, time trial records, repeated encoding count, output consistency testing, limitation logging, and researcher observation. Results showed that the artifact-supported workflow reduced counted workflow steps from 45 to 8, decreased listed repeated encoding points from 10 to 0, and shortened researcher-conducted preparation time for both a certification document and a Straight-Line Diagram vital dates document. The tested certification output passed 14 of 14 output consistency checks. However, the findings are limited to selected document tests and should not be interpreted as proof of office-wide productivity improvement or full deployment readiness. The study contributes a practical case of Google Workspace-based document automation and identifies future improvement needs, including placeholder standardization, missing-field testing, and support for complex document structures.
Keywords
Developmental Design Science, Document Generation, Google Apps Script, Google Docs Automation, Process Improvement.
Citations
IRE Journals:
Jarred Dave D. Serrano, Lorinda E. Pascual, Ryan John L. De Lara, Marvin O. Mallari, Antonio Buendia "Google Apps Script-Based Automation for DPWH Project Document Preparation: A Developmental Design Science Case Study" Iconic Research And Engineering Journals Volume 9 Issue 11 2026 Page 3989-3998 https://doi.org/10.64388/IREV9I11-1718216
IEEE:
Jarred Dave D. Serrano, Lorinda E. Pascual, Ryan John L. De Lara, Marvin O. Mallari, Antonio Buendia
"Google Apps Script-Based Automation for DPWH Project Document Preparation: A Developmental Design Science Case Study" Iconic Research And Engineering Journals, 9(11) https://doi.org/10.64388/IREV9I11-1718216
About IRE Journals
IRE Journals is an open access online journals established with an aim to publish high quality of research work in various diciplines. We have more than 6 years in publications. Over 2500+ papers already published.
Important Links
For Authors
Volume 8:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 7:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 6:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 5:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 4:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12Volume 3:
Issue 1, Issue 2, Issue 3, Issue 4, Issue 5, Issue 6, Issue 7, Issue 8, Issue 9, Issue 10, Issue 11, Issue 12