ist00dent This workflow corresponds to n8n.io template #4066 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "1yA5mcestRYljmFM",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Track Hourly Weather Conditions with OpenWeatherMap \u2192 Google Sheets",
"tags": [
{
"id": "F1KjxL3SjfvVqZqo",
"name": "training-n8n",
"createdAt": "2025-04-29T10:40:13.332Z",
"updatedAt": "2025-04-29T10:40:13.332Z"
}
],
"nodes": [
{
"id": "472b4930-ac62-4adc-af65-4a3e46e18cac",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "a0fe192b-1b84-48d3-8896-c21f0fe26855",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
900,
-140
],
"parameters": {
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "id",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "7cc21aa3-69bc-40d8-bea2-aee3bc27920c",
"name": "Get Weather Data from OpenWeatherMap",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
0
],
"parameters": {
"url": "=https://api.openweathermap.org/data/2.5/weather?q=Pasay,ph&APPID={{ $credentials.openWeatherMap.apiKey }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "373b6f87-cc09-412d-9293-c18c889c4f0a",
"name": "If is raining",
"type": "n8n-nodes-base.if",
"position": [
400,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "c593374b-7a9f-4c8d-aa6c-3dfa2c11bbcc",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $json.main.temp }}",
"rightValue": 303
},
{
"id": "24c06a68-c333-45c3-bf0e-0457448d3d2e",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.weather[0].description }}",
"rightValue": "rain"
}
]
}
},
"notesInFlow": true,
"typeVersion": 2.2
},
{
"id": "01f1394c-9d53-4a5a-a4ab-6146b1872a91",
"name": "Format the data",
"type": "n8n-nodes-base.set",
"position": [
640,
-140
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a62d02e7-0baf-429a-bbf5-e5028020d723",
"name": "city",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "0951f83b-578f-4300-97fd-464ac0a3152b",
"name": "temperature (K)",
"type": "string",
"value": "={{ $json.main.temp }}"
},
{
"id": "27f2d8f9-a841-4c38-bc68-ba1f5c8a716e",
"name": "humidity",
"type": "string",
"value": "={{ $json.main.humidity }}"
},
{
"id": "b0571687-07fa-432e-acd6-86c671f96875",
"name": "conditions",
"type": "string",
"value": "={{ $json.weather[0].description }}"
},
{
"id": "98f115fc-a91c-434d-b5d7-bab39aac8e98",
"name": "status",
"type": "string",
"value": "higher than average temperature"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "33cb4c1b-d10c-4010-b49c-057469ec20f3",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-80
],
"parameters": {
"width": 380,
"height": 260,
"content": "### Get Weather information and see if it is raining"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "a481a1a4-3b62-44d4-ad25-94debc8b353c",
"connections": {
"Google Sheets": {
"main": [
[]
]
},
"If is raining": {
"main": [
[
{
"node": "Format the data",
"type": "main",
"index": 0
}
],
[]
]
},
"Format the data": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get Weather Data from OpenWeatherMap",
"type": "main",
"index": 0
}
]
]
},
"Get Weather Data from OpenWeatherMap": {
"main": [
[
{
"node": "If is raining",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
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…
Source: https://n8n.io/workflows/4066/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo
YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.
This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev
ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.
Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs fo