I have a connected device that logs temperature data to Google Sheets. Does anyone know how I can pull the current temperature from Google Sheets make Smartthings think it is the current temperature for a thermostat? This would allow me to bypass IFTTT to run notifications and automations.
I also have this requirement. I have a google sheet which logs my variable energy tariff and consumption every 30mins. I’d like to be able to trigger some automations into SmartThings if the energy price is high or consumption is high (and turn things off).
Is this possible?