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. --- 👤 Who is it for? This workflow is ideal for: - Operations teams monitoring weather-sensitive logistics - Researchers collecting climate data - Developers and hobbyists learning how to connect APIs with Google Sheets --- 🗂️ Google Sheet Structure Your Google Sheet should have the following columns: - city (string) - temperature (K) (number) - humidity (number) - conditions (string) - status (string) --- ⚙️ Setup Instructions - Create a Google Sheet with the above columns. - Set up your Google Service Account credentials in n8n. - Replace the API key in the HTTP Request node with your own OpenWeatherMap credential. - Specify your target city and ensure your OpenWeatherMap account is active. - Adjust the frequency in the Schedule Trigger as needed (default: every hour).