Geração de código em Google Apps Script para desenvolvimento rápido de API's Web a partir de dados em nuvem

Abstract

Much of the current demand for software takes the form of web applications, which are structured around APIs (Application Programming Interfaces) for accessing data. In this domain, the consumption of data and cloud services is also a trend, through platforms aimed at the end user, such as Google Workspace. On this platform, Google Apps Script (GAS) presents itself as a solution for the rapid development of applications inserted in Google’s cloud environment, enabling the construction of APIs that respond to requests for access to data in the cloud. Even with such facilities, development on this platform has repetitive steps that are subject to automation. In this work, we explore these trends by developing a tool for automated generation of web APIs code in GAS, enabling access to data stored in spreadsheets in the Google Sheets service. To evaluate the tool, tests were conducted with developers, which corroborated the proposal of this work.