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