Arduino NANO ➝ MQTT Broker ➝ GoogleSheet (2 days) ➝ WordPress
This page documents NANO-022, the second Nano 33 IoT device publishing data to the web. It went live on 03/17/25 and is physically labeled as “Google2” (pictured below). The six OLED displays in the background show real-time MQTT data handled by NANO-014, which is housed just beneath NANO-022.
NANO-022 captures 22 MQTT data points — first introduced in Sandbox 1 — and pushes updates once per minute. It maintains a 2-day rolling buffer (2,880 points) in FIFO (First-In, First-Out) format. “These 22 data points include temperatures (OA, infrared, boiler loops, space zones), power metrics (PV, inverter, battery), burner runtime, projections, and more.”
Sheet1 displays the most recent values along with a rolling 6-hour Sparkline trend for each data point. Sheet2 contains the full minute-by-minute time series dataset. The Charts tab offers a visual snapshot via two sample plots. For more information, read From Sensor to Sandbox: Inside EnergyLab’s Real-Time Data Flow.