AutomationMart
Home/Browse/Track hourly weather conditions with OpenWeatherMap and Google Sheets
n8n

Track hourly weather conditions with OpenWeatherMap and Google Sheets

n8nn8n5 modulesv1.0
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
Track hourly weather conditions with OpenWeatherMap and Google Sheets workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

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

Every time a new row in your Google Sheets spreadsheet is added, Make will automatically create a Reply.io contact and push it to a campaign (sequence). The template uses [this spreadsheet](https://docs.google.com/spreadsheets/d/17ZG5QB9GU09Yu8Ios0wfNPNu0ljeT6-lLBU5PaWznOQ/edit?usp=sharing).

Free

Create or Update Iterable users from new Google Sheets spreadsheet rows

Every time a new row is added to a Google Sheets spreadsheet, Make will automatically create a new user in Iterable or update existing user. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1ryfH3-KjD0bkYHH-lScgA-2P6ApnJCfGqdVC7eAw90E/edit?usp=sharing).

Free

Build lists of profiles from any platform using Airtop and Google Sheets

About The List Building Automation This automation will guide you on how to automate list building using Airtop. You’ll have a streamlined workflow that can reduce your research time by up to 90% while improving the accuracy of your target lists. How to automate list building It can be challenging to spend too much time on tasks like compiling lists of potential investors, customers, job candidates, industry influencers, or key decision-makers. Verifying contact details often requires significan

Free

Create Tadabase records for new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a record in Tadabase.

Free

Log and analyze job postings with Telegram, Claude, and Google Sheets

Quick overview This workflow logs job postings sent via Telegram into Google Sheets using Anthropic Claude to extract structured fields, and generates an on-demand Telegram report (/report) that analyzes trends across all saved postings. How it works 1. Triggers when a new Telegram message is received by the bot. 2. Checks the sender’s Telegram chat ID against an allowed user ID to block unauthorized access. 3. If the message is "/report", reads all logged job rows from Google Sheets and sends t

Free

Collect leads with a conversational GPT-4.1 chatbot and Google Sheets

Description A natural conversational AI chatbot that collects lead information (Name, Phone, Email, Message) one question at a time without feeling like a form. Uses session-based memory to track conversations, intelligently asks only for missing details, and saves complete leads to Google Sheets automatically. --- What this workflow does This workflow creates a human-like booking assistant that gathers lead information through natural conversation instead of traditional forms. The AI

Free

Analyze Telegram messages with OpenAI and send notifications via Gmail & Telegram

AI-powered Telegram message analysis with multi-tool notifications (Gmail, Telegram) This workflow triggers on Telegram updates, analyzes messages with an AI Agent using MCP tools, and sends notifications via Gmail and Telegram. Detailed Description Who is this for? This template is for teams, businesses, or individuals using Telegram for communication who need automated, AI-driven insights and notifications. It’s ideal for customer support teams, project managers, or tech enthusiasts wanting

Free

Set DevOps infrastructure with Docker, K3s, Jenkins & Grafana for Linux servers

This automated n8n workflow delivers an instant DevOps toolkit by installing Docker, K3s, Jenkins, Grafana, and more on a Linux server within 10 seconds. It optimizes performance, enhances security, and provides ready-to-use templates for DevOps projects. Main Components - Configure Parameters - Defines server details, tool versions, and credentials - System Preparation - Updates the system and installs base packages - Install Docker - Deploys Docker Engine and Docker Compose -

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free