Track Hourly Weather Conditions with OpenWeatherMap → Google Sheets

{
  "id": "1yA5mcestRYljmFM",
  "meta": {
    "instanceId": "3fed23de697c60307f3b4f5caeafbeffabaf7bbd62c1b20ae70d5faf5a9806b4",
    "templateCredsSetupCompleted": true
  },
  "name": "Track Hourly Weather Conditions with OpenWeatherMap → 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": {
          "id": "zezjM010IlXk8xFU",
          "name": "Google Service Account training"
        }
      },
      "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,
  "pinData": {},
  "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
          }
        ]
      ]
    }
  }
}