FM
FlowMarket
General Automation Beginner ⚡ 6 n8n Nodes

Track hourly weather conditions with OpenWeatherMap and Google S

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

🔌 Nodes & Integrations Used (1)

n8n Core Logic

📖 Implementation & Setup Guide

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

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Track_hourly_weather_conditions_with_OpenWeatherMap_and_Google_S.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related General Automation Workflows

View All in General Automation →