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
At a glance
Track hourly weather conditions with OpenWeatherMap and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 5
- Price
- Free
- Version
- v1.0

About this workflow
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 n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create a Reply.io contact from a new row in a Google Sheets spreadsheet and push it to a sequence
Create or Update Iterable users from new Google Sheets spreadsheet rows
Build lists of profiles from any platform using Airtop and Google Sheets
Create Tadabase records for new Google Sheets rows
Log and analyze job postings with Telegram, Claude, and Google Sheets
Collect leads with a conversational GPT-4.1 chatbot and Google Sheets
Analyze Telegram messages with OpenAI and send notifications via Gmail & Telegram
Set DevOps infrastructure with Docker, K3s, Jenkins & Grafana for Linux servers
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you