Monitor multi-city weather with OpenWeatherMap, GPT-4o-mini, and Discord

Go to Workflow
0 views
Built by 荒城直也 荒城直也
Created on June 13, 2026

Description


Weather Monitoring Across Multiple Cities with OpenWeatherMap, GPT-4o-mini, and Discord

This workflow provides an automated, intelligent solution for global weather monitoring. It goes beyond simple data fetching by calculating a custom "Comfort Index" and using AI to provide human-like briefings and activity recommendations. Whether you are managing remote teams or planning travel, this template centralizes complex environmental data into actionable insights.

Who’s it for
Remote Team Leads:** Keep an eye on environmental conditions for team members across different time zones.
Frequent Travelers & Event Planners:** Monitor weather risks and comfort levels for multiple destinations simultaneously.
Smart Home/Life Enthusiasts:** Receive daily morning briefings on air quality and weather alerts directly in Discord.

How it works
Schedule Trigger: The workflow runs every 6 hours (customizable) to ensure data is up to date.
Data Collection: It loops through a list of cities, fetching current weather, 5-day forecasts, and Air Quality Index (AQI) data via the OpenWeatherMap node and HTTP Request node.
Smart Processing: A Code node calculates a "Comfort Index" (based on temperature and humidity) and flags specific alerts (e.g., extreme heat, high winds, or poor AQI).
AI Analysis: The OpenAI node (using GPT-4o-mini) analyzes the aggregated data to compare cities and recommend the best location for outdoor activities.
Conditional Routing: An If node checks for active weather alerts. Urgent alerts are routed to a specific Discord notification, while routine briefings are sent normally.
Archiving: All processed data is appended to Google Sheets for historical tracking and future analysis.

How to set up
Credentials: Connect your OpenWeatherMap, OpenAI, Discord (Webhook), and Google Sheets accounts.
Locations: Open the 'Set Monitoring Locations' node and edit the JSON array with the cities, latitudes, and longitudes you wish to track.
Google Sheets: Configure the 'Log to Google Sheets' node with your specific Spreadsheet ID and Sheet Name.
Discord: Ensure your Webhook URL is correctly pasted into the Discord nodes.

Requirements
OpenWeatherMap API Key** (Free tier is sufficient).
OpenAI API Key** (Configured for GPT-4o-mini).
Discord Webhook URL**.
Google Sheet** with headers ready for logging.

How to customize
Adjust Alert Thresholds:** Modify the logic in the 'Process and Analyze Data' Code node to change what triggers a "High Wind" or "Extreme Heat" alert.
Refine AI Persona:** Edit the System Prompt in the 'AI Weather Analysis' node to change the tone or focus of the weather briefing.
Change Frequency:** Adjust the Schedule Trigger to run once a day or every hour depending on your needs.

Nodes Used (5)

Code
n8n-nodes-base.code
Discord
n8n-nodes-base.discord
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
OpenWeatherMap
n8n-nodes-base.openWeatherMap