Initial searching yielded much less-than-expected G Sheets integration. And so “how tough could it be?” took over and it mushroomed way beyond reason. After much GPT-ing this is a pretty solid version of what I was after. Spreadsheets are not my native environment, logic gaps are likely and feedback is welcome. Meanwhile, it’s fun to out-geek my rain gauge neighbor.
I work with people on ladders so wind and lightning (both common and sometimes violent in my area) are important. The rain info will someday inform the Rachio sprinkler, but Rome wasn’t built in a day and GPT needs a rest.
Expected was some existing code with examples that would make getting started pretty easy. Didn’t find that. People! Is this not 2025?! Unit conversion (kph to mph) was nit-picky, maybe part of initial setup?
I have a single tempest banded to a plumbing vent above the roofline. Somebody wants to charge $30 for the Rachio integration, that tells me there are still some tech-types that haven’t heard of the network effect.
So, get your API Key and go to town!
