CloudCost Automation

Zero-cloud-cost IoT smart load control using ESP32 + NRF24L01 + Google Apps Script. Offline Bluetooth fallback, phase control, and real-time logging to Google Sheets.

Source Code Demo Video Project Files

Technologies Used

ESP32 Master NRF24L01 RF Triac Load Control Google Apps Script Google Sheets Bluetooth Fallback Triac Phase Control Offline Sync Automated Logging

Started: February 1, 2025

Completed: April 15, 2025

Duration: 2.5 Months

Technical Specifications

Master

ESP32

Communication

NRF24L01 + BT

Load Control

Triac Phase

Storage

Google Sheets

Project Overview

A cost-optimized IoT automation system using ESP32 master-slave architecture. Slaves control loads via TRIACs over NRF24L01 RF. Data syncs to Google Sheets using Apps Script — no cloud fees. Bluetooth ensures offline control.

Architecture

Master ESP32

Wi-Fi, Bluetooth, RF gateway

NRF24L01 Slaves

Load control via TRIAC

Google Apps Script

Free cloud backend

Key Features

Feature Description
Low-Cost ESP32 + NRF24L01 + TRIAC under $10/unit
Cloud-Free Sync Google Sheets via Apps Script (no AWS/Azure)
Offline Fallback Bluetooth control when Wi-Fi down
Manual Sync Physical switch state auto-updates cloud
Phase Control Dimmer & fan speed via TRIAC
Scalable Add unlimited slaves with unique IDs

Key Learnings

Zero-Cost Cloud Backend

Used Google Apps Script + Sheets as free scalable server.

RF + BT Hybrid Control

Combined NRF24L01 reliability with Bluetooth redundancy.

TRIAC Phase Modulation

Implemented zero-cross detection for smooth dimming.

Use Cases & Future

  • Home & industrial automation
  • Energy usage analytics & prediction
  • Voice assistant integration (Google Home)
  • OTA firmware updates
  • Solar-powered remote deployment

Target Audience

  • Budget-conscious IoT developers
  • Home automation enthusiasts
  • Industrial control engineers
  • Educational & research labs