Automate Hourly Weather Tracking with OpenWeatherMap and Google Sheets
This n8n workflow automates the process of monitoring hourly weather conditions in a specified city using OpenWeatherMap, and logs the data into a Google Sheet. Ideal for logistics, travel planning, or environmental monitoring, it helps track weather changes efficiently.
The workflow triggers every hour to fetch real-time weather data from OpenWeatherMap for a specified city. It checks if the weather conditions meet certain criteria, such as rain or temperature below a threshold. If conditions are met, the data is formatted and appended to a Google Sheet, providing a structured and automated way to monitor weather conditions over time.
- Platform
- n8n
- Category
- Travel
- Price
- $4.99
- Creator
- Yara Mansour
- training-n8n
- if
- set
- stickyNote
- httpRequest
- googleSheets
- scheduleTrigger
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Travel workflows
- Webhook Filter Sync for Accommodation Booking$6.99
- Automate Flight Searches and Recommendations with DeepSeek AI and Google Flights$4.99
- Daily Weather Forecast Emails with MeteoSource and Gmail$4.99
- Automate Airbnb Searches via Telegram with AI and Voice Support$9.99
- Automate Daily Weather Updates via Telegram Using OpenWeatherMap$9.99
- Automate Flight Price Tracking with Bright Data and n8n$9.99
More from Yara Mansour
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.