Building Applications for Library Services using Google Workspace and Apps Script

Authors

DOI:

https://doi.org/10.17821/srels/2026/v63i3/171992

Keywords:

Atmanirbhar Library, Computer-based Exam, Google Apps Script, Google Sheets, Google Workspace, Regex

Abstract

The development of digital solutions for library operations often requires significant financial investment, technical infrastructure, and skilled manpower. In addition to this, libraries have to consider data protection, backups, and privacy. These are the key hindrances to library services. There is a need for a platform/ecosystem that can be implemented easily and remains unaffected by the challenges commonly faced by libraries. Google Workspace provides an environment for building lightweight applications that require no server or network infrastructure. Google Workspace is an ecosystem of 100+ different services that can be used for many different purposes. The beauty of these services is that they can be integrated. This study presents the implementation of Google Workspace services (Google Sheets, Google Drive, Google Docs, and Google Forms) and Apps Script to streamline three key processes in library services, i.e., recruitment of manpower, complaint/feedback system, and Computer-Based Test (CBT).

Downloads

Download data is not yet available.

Downloads

Published

2026-07-31

How to Cite

Garg, M., Raj, N., & Nair, A. R. (2026). Building Applications for Library Services using Google Workspace and Apps Script. Journal of Information and Knowledge, 63(3), 239–248. https://doi.org/10.17821/srels/2026/v63i3/171992

Issue

Volume 63, Issue 3, June 2026

Section

Articles

License

Copyright (c) 2026 Journal of Information and Knowledge

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

All the articles published in Journal of Information and Knowledge are held by the Publisher. Sarada Ranganathan Endowment for Library Science (SRELS), as a publisher requires its authors to transfer the copyright prior to publication. This will permit SRELS to reproduce, publish, distribute and archive the article in print and electronic form and also to defend against any improper use of the article.

Crossref
Scopus
Google Scholar
Europe PMC

References

Babu, B. R., & O’Brien, A. (2000). Web OPAC interfaces: An overview. The Electronic Library, 18(5), 316-330. https:// doi.org/10.1108/EL-11-2011-0159

Babu, P. B., & Krishnamurthy, M. (2013). Library automation to resource discovery: A review of emerging challenges. The Electronic Library, 31(4), 433-451. https://doi.org/10.1108/ el-11-2011-0159

Bakrania, S., & Johnson, B. J. (2015). A cloud-based tool for assigning students to projects [Conference paper]. ASEE Annual Conference and Exposition. https://doi. org/10.18260/p.23606

Bhuvaneshwari, B., Prasadh, H. R. K., Sathish, P., Anuja, V., & Mythily, A. (2023). Automated contactless attendance system. In S. Shakya, G. Papakostas, & K. A. Kamel (Eds.), Mobile computing and sustainable informatics (Lecture Notes on Data Engineering and Communications Technologies, Vol. 166, pp. 523-532). Springer. https://doi. org/10.1007/978-981-99-0835-6_37

Boman, C., & Voelker, R. (2017). Between the sheets: A librarywide inventory with Google. Code4Lib Journal, (38). http:// journal.code4lib.org/articles/12783

Channgam, S., Nilsook, P., & Wannapiroon, P. (2019). Intelligent information management with digitization workflow. International Journal of Machine Learning and Computing, 9(6), 886-892. https://doi.org/10.18178/ ijmlc.2019.9.6.888

Clarke, C. L., & Cormack, G. V. (1997). On the use of regular expressions for searching text. ACM Transactions on Programming Languages and Systems (TOPLAS), 19(3), 413-426. https://doi.org/10.1145/256167.256174

Ehrenpreis, M., & DeLooper, J. (2022). Implementing a chatbot on a library website. Journal of Web Librarianship, 16(2), 120-142. https://doi.org/10.1080/19322909.2022.2046205

Engkus, E. (2025). The impact of digital transformation on public sector organizational commitment: A case study of public management practices. Edelweiss Applied Science and Technology, 9(2), 2256-2269. https://doi. org/10.55214/25768484.v9i2.5062

Gnatyuk, V., Batrak, O., Hamretskyi, R., & Golovan, M. (2024). Organizational and technical support of cyber security using a virtual assistant. In CH&CMiGIN’24: Third International Conference on Cyber Hygiene & Conflict Management in Global Information Networks. https://ceur-ws.org/Vol- 3925/short08.pdf

GoodFirms. (n.d.). Best free and open source exam software solutions. https://www.goodfirms.co/exam-software/blog/ best-free-open-source-exam-software-solutions

Google. (2025). Apps Script: Low code platform for business solutions. Google Workspace. https://workspace.google. com/intl/en_in/products/apps-script/

Hanson, E. D., Okorie, U. U., & Nsit, A. (2024). The roles of artificial intelligence in library automation: The prospects and challenges. Erudite Compendiums in Education, 13-23.

Homocianu, D., & Homocianu, M. (2019). GiPlot: An interactive cloud-based tool for visualizing and interpreting large spectral data sets. Spectrochimica Acta Part A: Molecular and Biomolecular Spectroscopy, 209, 234-240. https://doi. org/10.1016/j.saa.2018.10.046 PMid:30414571

Hussain, A. (2023). Use of artificial intelligence in the library services: Prospects and challenges. Library Hi Tech News, 40(2), 15-17. https://doi.org/10.1108/lhtn-11-2022-0125

Jacob, A., GS, Jeevitha, Mohandas, M., & Gatty, M. (2024). Webbased university results analytics tool. Grenze International Journal of Engineering & Technology, June, 5157-5162. https://doi.org/10.21065/22498982.10.2.10

Jhan, P., Sreekumar, M., & Kuriakose, R. (2025). Enhancing library services with artificial intelligence: A framework for an automated news delivery system. IFLA Journal, 51(3), 836-848. https://doi.org/10.1177/03400352251358064

Knight, R. C., Rodrigues, E., & Ciota, R. (2017). Collaborating for metadata creation on digital projects: Using Google Forms and Sheets. Library Hi Tech News, 34(8), 20-23. https://doi.org/10.1108/LHTN-08-2017-0056

Laskowski, L. (2016). Google Forms and Sheets for library gate counts. Journal of Access Services, 13(3), 151-158. https:// doi.org/10.1080/15367967.2016.1184577

Lukito, D. (2024). No IT background? No problem: Develop your HRM application using Google Workspace. IBIMA Business Review, 1-11. https://doi.org/10.5171/2024.341724

Mandour, W. S. (2025). AI-powered tools for linguistic and sentiment analysis in language learning: Applications using Google Sheets and large language models. In Using AI tools in text analysis, simplification, classification, and synthesis (pp. 67-112). IGI Global Scientific Publishing. https://doi. org/10.4018/979-8-3693-9511-0.ch003

Mierzecka, A., & Suminas, A. (2018). Academic library website functions in the context of users’ information needs. Journal of Librarianship and Information Science, 50(2), 157-167. https://doi.org/10.1177/0961000616664401 Osei-Wusu, F., Asiedu, W., Yeboah, D., Kar, S., Muntaka,

S. A., & Appiah, J. K. (2025). Leveraging information technology tools to create cost-effective alternatives: Using Google Sheets as a platform for competitive debate and public speaking tabulation. Plos One, 20(9), Article e0332576. https://doi.org/10.1371/journal.pone.0332576 PMid:40953049 PMCid:PMC12435689

Pacios, D., Ignacio-Cerrato, S., Vázquez-Poletti, J. L., Moreno- Vozmediano, R., Schetakis, N., Stavrakakis, K., …, Vázquez, L. (2025). Amazon Web Service-Google crosscloud platform for machine learning-based satellite image detection. Information, 16(5), Article 381. https://doi. org/10.3390/info16050381

Pahayahay, A. B. (2025). Enhancing collaboration through Google Workspace: Assessing and strengthening current practices. International Journal of Computing Sciences Research, 9, 3602-3617.

Panda, S., & Kaur, N. (2024). Revolutionizing language processing in libraries with SheetGPT: An integration of Google Sheet and ChatGPT plugin. Library Hi Tech News, 41(5), 8-10. https://doi.org/10.1108/lhtn-03-2023-0051

Pandit, S. D. (2023). Atmanirbhar Bharat Abhiyan and higher education in India. University News, 61, 24.

Rajput, P., & Parekh, R. (2020). On-board diagnostics based remote emission test for light motor vehicles. In 2020 IEEE International Conference on Electronics, Computing and Communication Technologies (CONECCT) (pp. 1-6). IEEE. https://doi.org/10.1109/CONECCT50063.2020.9198374 PMid:35299773

Ranganathan, S. R. (1963). The five laws of library science. Asia Publishing House.

Rozputnia, B., Shevchenko, L., Umanets, V., Sabadosh, Y., Kushnir, A., & Voitsekhivska, N. (2025). Future trends of AI in higher education: Google Workspace and Gemini. In 2025 15th International Conference on Advanced Computer Information Technologies (ACIT) (pp. 1019-1025). IEEE. https://doi.org/10.1109/ACIT65614.2025.11185626

Saito, H., & Tsukiyama, T. (2025). Use of artificial intelligence in manuscript preparation: AI as a coauthor. International Journal of Periodontics and Restorative Dentistry, 45(3), 293- 299. https://doi.org/10.11607/prd.7022 PMid:40279143

Salih, M. M. (2021). A comparative study between Google Workspace and Microsoft Office 365 productivity services in Iraqi educational institutions. International Journal of Humanities and Educational Research, 3(5), 123-135. https://doi.org/10.47832/2757-5403.5-3.11

Sharov, S., Tereshchuk, S., Filatova, O., Hinkevych, O., & Ksendzenko, O. (2024). Survey analysis of university teachers in Ukraine regarding the use of Google Workspace for education. TEM Journal, 13(1), 315-325. https://doi. org/10.18421/tem131-33

Suon, E. B. (2019). DIY data dashboards in Google Sheets. Computers in Libraries, 39(7), 16-19.

Suranofsky, M., & McColl, L. (2019). MatchMarc: A Google Sheets add-on that uses the WorldCat Search API. Code4Lib Journal, (46). https://journal.code4lib.org/ articles/14813

Thakkar, D., Rajput, P., Dubey, R., & Parekh, R. (2018). Design and implementation of autonomous UAV tracking system using GPS and GPRS. In Progress in advanced computing and intelligent engineering (pp. 433-439). Springer. https:// doi.org/10.1007/978-981-13-0224-4_39

Thomas, P. B. M. (2017). Bespoke automation of medical workforce rostering using Google’s free cloud applications. Journal of Innovation in Health Informatics, 24(4), Article 334. https://doi.org/10.14236/jhi.v24i4.885 PMid:29334350

Vijayalakshmi, V. J. (2020). Centralized attendance monitoring system. In 2020 6th International Conference on Advanced Computing and Communication Systems (ICACCS). IEEE. https://doi.org/10.1109/ ICACCS48705.2020.9074162

Wibisono, Y., Wardhana, M. A., & Pamungkas, W. H. (2022). Design of Google Apps-based helpdesk ticketing system at university using extreme programming approach. AIP Conference Proceedings, 2658, Article 070005. https://doi. org/10.1063/5.0106944

Wijaya, S. A., & Hikmawati, E. (2025). Comparative performance analysis of data processing technologies: Google App Script and distributed frameworks for varying data volumes. In 2025 IEEE International Conference on Artificial Intelligence for Learning and Optimization (ICoAILO) (pp. 55-61). IEEE. https://doi.org/10.1109/ ICoAILO66760.2025.11156004 PMid:40630976 PMCid:PMC12233944

Wulan, S., S., & Dirgahayu, T. (2024). Pengembangan sistem informasi pendanaan sumber daya manusia menggunakan Google Apps Script. EDUSAINTEK: Jurnal Pendidikan, Sains dan Teknologi, 11(4), 2238-2254. https://doi. org/10.47668/edusaintek.v11i4.1448

Yu, S. (2007). RFID implementation and benefits in libraries. The Electronic Library, 25(1), 54-64. https://doi. org/10.1108/02640470710729119