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)
📖 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:
- Click the Direct Download JSON button above to save
Track_hourly_weather_conditions_with_OpenWeatherMap_and_Google_S.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related General Automation Workflows
View All in General Automation →Generate Application Copy
Production-ready n8n automation template for Generate Application Copy built by AhiXLight. Seamlessly connects Execute Workflow Trigger, OpenAI with 4 configured nodes.
2-way sync Google Contacts and Notion
Sync your Google Contacts with your Notion database. You can filter contacts by label or sync all contacts. All contact information is kept in sync between G...
2D Image to 3D Model Automation
Production-ready n8n automation template for 2D Image to 3D Model Automation built by AhiXLight. Seamlessly connects HTTP Request, Google Sheets, Google Drive with 17 configured nodes.
2 way sync assignments completion between Canvas LMS and Notion
Syncs assignments and completion states to and fro between Canvas LMS and a Notion database. Automatically triggers every 2 hours during the schoolday by def...