I have my dumb electricity meter sending my electric usage to google sheets every one minute
I used an ESP32 with a very basic light sensor, the sensor was blue tacked over the 1000th/Kwatt LED (this blinks 1000 times per unit of electricity used) the info is sent it over my wifi to google sheets
it also records the sum per hour indefinately, or until google sheets complains