Sensify: Cloud Storage with AI Analytics Smart Sensing, Sharper Decisions

In modern IoT ecosystems, the ability to efficiently collect, store, and analyze real-time sensor data is essential for enabling timely and data-driven decision-making. Traditional cloud database solutions often involve complex configurations, recurring maintenance burdens, and high deployment costs, making them unsuitable for lightweight, scalable, or educational IoT applications. To address these limitations, this project presents Sensify, a fully automated cloud-based data acquisition and analytics framework built using Google Sheets and Google Apps Script. The system enables seamless sensor data ingestion through a custom API, which accepts JSON-based payloads and appends the readings to a dynamically managed spreadsheet acting as a cloud storage layer. Automated routines periodically convert accumulated data into CSV format, transmit the file to external endpoints via HTTP POST, and reset the sheet for uninterrupted operation, thereby eliminating manual intervention and reducing backend infrastructure requirements.
To enhance the interpretability and decision-making capability of the stored data, AI-driven analytical modules are integrated to compute statistical summaries, detect anomalies, and identify emerging trends across environmental parameters such as temperature, humidity, light intensity, and air quality. These insights are visualized through correlation plots, time-series analyses, and distribution characteristics, enabling users to observe patterns, diagnose sensor issues, and monitor environmental behaviour effectively. The proposed system offers a low-cost, scalable, and highly accessible solution suitable for IoT monitoring, educational deployments, research applications, and lightweight cloud analytics. By combining real-time ingestion, automated processing, and intelligent analytics, the framework demonstrates a robust approach for building practical, maintenance-free IoT data pipelines that support rapid insights and reliable long-term operation.

cloud storage, Google Sheets API, IoT data logging, automated CSV export, AI-driven analytics, anomaly detection, real-time monitoring, sensor data pipeline, lightweight cloud database, Google Apps Script.

1. S. K. Sharma and R. Patel, “Real-Time IoT Data Logging Using Google Sheets and Apps Script,” International Journal of Emerging Trends in Engineering Research, vol. 8, no. 5, pp. 150–155, 2021. [Google Scholar] [Crossref]

2. M. R. Hassan and D. Kim, “Automated Cloud-Based Data Export and Processing for IoT Systems,” IEEE Access, vol. 9, pp. 11023–11031, 2021. [Google Scholar] [Crossref]

3. A. B. Chavan and P. Kulkarni, “Cloud Automation Techniques for Efficient IoT Data Management,” International Journal of Computer Applications, vol. 176, no. 32, pp. 12–18, 2020. [Google Scholar] [Crossref]

4. J. Singh and A. Verma, “AI-Enhanced IoT Analytics Using Cloud-Integrated Frameworks,” IEEE Internet of Things Journal, vol. 7, no. 11, pp. 10745–10753, 2020. [Google Scholar] [Crossref]

5. L. Thomas and F. Rodriguez, “Secure Data Transmission in IoT Applications Using HTTP-based Workflows,” International Conference on Communication and Computing Systems (ICCCS), pp. 214–219, 2022. [Google Scholar] [Crossref]

6. K. Narayanan and S. Rao, “Evaluating Serverless Architectures for IoT Data Processing Using Google Apps Script,” Proceedings of the 2021 IEEE Cloud Computing Conference, pp. 89–95, 2021. [Google Scholar] [Crossref]

7. S. R. Moosavi, T. N. Gia, A. Rahmani, et al., “End-to-End Security Scheme for Mobility Enabled Healthcare Internet of Things,” IEEE Access, vol. 4, pp. 4525–4541, 2016. [Google Scholar] [Crossref]

8. S. K. Routray and S. K. Dash, “A Cloud-Based Sensor Data Management System Using Google Firebase,” in Proc. IEEE ICCCNT, 2020. [Google Scholar] [Crossref]

9. M. A. Al-Garadi, A. Mohamed, and A. K. Malik, “A Survey of Machine Learning Algorithms for IoT Data Analysis,” IEEE Communications Surveys & Tutorials, vol. 22, no. 3, pp. 1646–1685, 2020. [Google Scholar] [Crossref]

10. P. D. Nguyen, T. T. Nguyen, and M. V. Nguyen, “Real-Time Environmental Monitoring Using IoT and Cloud Computing,” in Proc. IEEE ATC, 2019. [Google Scholar] [Crossref]

• Communication Strategies among Promoters During MATTA Fair 2025
• An Examination of Colleen Ballinger’s Experience in Social Media: Cancel Culture Chronicle
• Communication Patterns in Conflict Interactions in Premarital Couples Who Are in Abusive Relationships
• Social Media Use on Mental Health Outcomes among Adolescents and Young Adults in Port Harcourt City
• (Un)Successful Error Repairs in L2 Communication