Track Hourly Weather Conditions with OpenWeatherMap

Log weather alerts automatically — no manual checks required.

This automation checks your local weather every hour and logs important conditions like rain or low temperatures. If it detects rain or cold weather, it records key details in Google Sheets — giving you a running log of weather alerts without lifting a finger.

Perfect for operations teams, facility managers, or anyone needing weather-based tracking.

What it does:

⏰ Runs hourly via a Schedule Trigger
🌤️ Fetches real-time weather from OpenWeatherMap
🌧️ Checks for rain or temperatures below your set threshold
📄 Formats city, temperature, humidity & conditions
🗂️ Appends weather data to a Google Sheet

✅ Setup guide & importable automation included

Need help setting it up? We offer full configuration and testing for a one-time fee.