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).