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 append

Help me set up the n8n workflow "Track Hourly Weather Conditions with OpenWeatherMap and Google Sheets" (https://n8n.io/workflows/4066). It uses: Google Sheets, HTTP Request. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.