Schedule Weather Data to DataTable

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 →

{
  "name": "Weer",
  "nodes": [
    {
      "parameters": {
        "cityName": "Kleine-Brogel",
        "language": "nl"
      },
      "type": "n8n-nodes-base.openWeatherMap",
      "typeVersion": 1,
      "position": [
        16,
        -272
      ],
      "id": "1aff5819-ff5b-4b75-acf6-ebe651caf76c",
      "name": "OpenWeatherMap",
      "credentials": {
        "openWeatherMapApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "dataTableId": {
          "__rl": true,
          "value": "arkLHkqoe5sSPEua",
          "mode": "list",
          "cachedResultName": "MijnResultaten",
          "cachedResultUrl": "/projects/ty3wcTBALsISkukj/datatables/arkLHkqoe5sSPEua"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "minTemp": "={{ $json.main.temp_min }}",
            "MaxTemp": "={{ $json.main.temp_max }}",
            "Output": "={{ $json.main.temp }}"
          },
          "matchingColumns": [],
          "schema": [
            {
              "id": "Output",
              "displayName": "Output",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "readOnly": false,
              "removed": false
            },
            {
              "id": "minTemp",
              "displayName": "minTemp",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "number",
              "readOnly": false,
              "removed": false
            },
            {
              "id": "MaxTemp",
              "displayName": "MaxTemp",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "readOnly": false,
              "removed": false
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {}
      },
      "type": "n8n-nodes-base.dataTable",
      "typeVersion": 1,
      "position": [
        224,
        -272
      ],
      "id": "567af20a-afca-4efc-a0be-f9f1a4b976fc",
      "name": "Insert row"
    },
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 7
            }
          ]
        }
      },
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        -224,
        -272
      ],
      "id": "d486e5f5-c7b6-46bf-bf29-65ff142ecb37",
      "name": "Schedule Trigger"
    }
  ],
  "connections": {
    "OpenWeatherMap": {
      "main": [
        [
          {
            "node": "Insert row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "OpenWeatherMap",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "6fd5316c-56bc-4a30-8627-fa44c54f7cf5",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "id": "U56LBhsNJz1bSK6Q",
  "tags": []
}

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.

• openWeatherMapApi

About this workflow

Weer. Uses openWeatherMap, dataTable. Scheduled trigger; 3 nodes.

Source: https://github.com/BartTho/Thomas-More-DevOps/blob/7593df130ce9224baebf0a64e2c5f74c797b2b68/n8n/Weer.json — original creator credit. Request a take-down →

More General workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.