The use of information technology is now so massive, that even reports on community activities have also used information technology. Online forms for reporting are widely used and very easy to create, with complete features. One of the products from Google is Google Forms. Starting from reservation, registration, data collection, reporting, and many activities of sending information and data can be done using this form online. The results of the data have also been presented in full, either in the form of sheets or graphic information, so that the manager or admin does not need to process it again. In the development of information needs, it turns out that the information needs from the google form are not only needed by managers or admins, but some parties need that information in real-time and do not have to log in as managers or admins, so technology is needed to distribute the data and information and processed or presented in a real-time reporting information system. In the google form, several tools have been provided such as Google APIs, Share to Sheet, CSV, etc. to share information with other parties. This study performs modeling in the design of web application architecture using real-time data from google forms based on CSV files and has been tested and produced an application model that can be pasted into other applications so that information from the google form can be conveyed without having to log in to the manager or admin of the google form.

Technology always has an impact on how products and services are designed. In recent years, there has been unprecedented growth in the web field. Therefore, it requires fast, reliable, attractive  development and powerful applications. One of them is a product from Google, namely google sheets. The results of the data can be presented in full either in the form of sheets or graphic information, so that managers or admins do not need to process anymore and later will be able to be monitored on a web-based app system that uses Progressive Web Application (PWA) technology. In the development of information needs, it turns out that information needs have become very complex both online and offline, even today's technology can combine the transaction process on the local information system synchronized to the information system and or online data. The implementation of Progressive Web Application (PWA) makes it possible to distribute information more easily. The results of this research obtained modeling, designing and implementing local applications with data synchronized to google sheet media, data on google sheets will be accessed by different applications online using Progressive Web Application (PWA). it is also proven that with the implementation of Progressive Web Application (PWA), data after being uploaded and cached can still be accessed even if the internet communication line is interrupted. Because the application will always read the cache that has contained data as long as it is not synchronized data.