Logging Temperature Sensors Every Hour: A Smart Automation Solution

Hey everyone, I’ve been exploring ways to log my temperature sensors into Google Sheets every hour, regardless of whether the temperature changes or not. I have a Philips Hue Outdoor Motion sensor with temperature and two Sensative Strips Temperature Sensors, and I want to track their readings consistently. My initial thought was to create a virtual temperature sensor that updates every hour, but I’m not sure if that’s feasible. Has anyone else tackled this challenge? I’d love to hear your solutions or alternative approaches to achieve this without setting up a local server or Raspberry Pi. Let’s brainstorm together! :brain::sparkles: