Track hourly weather conditions with OpenWeatherMap and Google Sheets

This n8n template allows you to monitor hourly weather conditions in a specific city using OpenWeatherMap and log the results to a Google Sheet. It’s perfect for anyone needing periodic weather tracking—whether you're managing logistics, travel planning, or environmental monitoring.

---

🔧 How it works - A Schedule Trigger activates the workflow every hour.

- The Get Weather Data from OpenWeatherMap node fetches real-time weather details using the city name you specify.

- An IF node checks if the weather description contains "rain" or the temperature is below a set threshold.

- If the condition is true, the data is formatted with city, temperature, humidity, and conditions.

- The Google Sheets node appends this formatted information to your designated sheet.

---