Sending data to googlesheets with webhooks

I’ve been thinking about this a bit more, and re-read your earlier posts.
It sounds like your irrigation system, swimming pool system and weather station could be the tip of the iceberg as far as your ‘home automation’ projects are concerned. Are you using solar power at all, be cause if you are then that could be another area where Blynk could be useful.

I actually use Blynk in a very different way to most people, and it’s a way that works very well for Home Automation systems where you have a collection of physically remote sensors and MCUs that need to be controlled together, and potentially interact with each other (don’t water the garden of its just rained for example).
My system uses lots of ESP8266/NodeMCU devices that all talk to a central Raspberry Pi, using a messaging system called MQTT. The Pi runs software called Node-Red, that’s a graphical programming/workflow/rules engine system. Node-Red talks to Blynk, and vice versa, via a Blynk plug-in.
Coincidentally, Node-Red also has plug-ins that allow data to be pushed/pulled from Google Sheets, if you still feel the need to do that, and also has a plug-in for Oregon Scientific weather stations.
I use my system for home automation at home in London, and at our holiday home in Spain - where I’ve just installed a solar panel, charge controller and MQTT interface to allow me to run our garden lighting from solar power and control it, and monitor the state of the batteries, via Blynk.

Before you go too much further with your existing project, you should think about this other type of architecture, as it can simplify things considerably when you start working with multiple devices.

More info on my way of doing things here:

Pete.