Development of a Web Application Utilizing RPA and Google Apps Script

Abstract

In this study, we developed a system that automatically acquires and shares environmental data collected from agricultural sensors by utilizing Robotic Process Automation (RPA) and Google Apps Script (GAS) in a web application. The sensors send data via the SORACOM platform, and traditionally these data were used solely by researchers. Our system employs RPA to periodically download the latest data from SORACOM and automatically updates and publishes it on a web application developed with GAS, allowing cooperating farmers and stakeholders to access real-time information. Furthermore, this application functions as a data infrastructure for artificial intelligence (AI)-based environmental data analysis, contributing to the preparation of an environment for future AI model development and application. The system is low-cost and highly versatile, with potential applicability to other fields.