自动化每日天气数据获取和存储

• •Airtable API Key
• •可能需要目标 API 的认证凭证

{
  "id": "PHp3gKoyYfSztbTB",
  "meta": {
    "instanceId": "14e4c77104722ab186539dfea5182e419aecc83d85963fe13f6de862c875ebfa",
    "templateCredsSetupCompleted": true
  },
  "name": "自动化每日天气数据获取和存储",
  "tags": [
    {
      "id": "uScnF9NzR3PLIyvU",
      "name": "Published",
      "createdAt": "2025-03-21T07:22:28.491Z",
      "updatedAt": "2025-03-21T07:22:28.491Z"
    }
  ],
  "nodes": [
    {
      "id": "871fd9fd-de44-4c9f-aef4-0c731c5685f1",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        40,
        100
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 10
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "0b721c2a-6301-4a08-9602-990598d0f7a3",
      "name": "存储天气数据",
      "type": "n8n-nodes-base.airtable",
      "notes": "Store weather data in table\n",
      "position": [
        480,
        100
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "appKtypfMptBIKStp",
          "cachedResultUrl": "",
          "cachedResultName": "WeatherData"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblfb3sJ84eQUlYJd",
          "cachedResultUrl": "",
          "cachedResultName": "Data"
        },
        "columns": {
          "value": {
            "Temp": "={{ $json.main.temp }}",
            "Humidity": "={{ $json.main.humidity }}",
            "Location": "={{ $json.name }}",
            "Timezone": "={{ $json.timezone }}",
            "Wind Speed": "={{ $json.wind.speed }}"
          },
          "schema": [
            {
              "id": "Location",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Timezone",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Timezone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Temp",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Temp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Wind Speed",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Wind Speed",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Humidity",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Humidity",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": []
        },
        "options": {},
        "operation": "create"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "",
          "name": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.1
    },
    {
      "id": "052a47c1-d167-432c-93f2-117a1c129c51",
      "name": "获取天气数据",
      "type": "n8n-nodes-base.httpRequest",
      "notes": "Fetching the weather data",
      "position": [
        260,
        100
      ],
      "parameters": {
        "url": "https://api.openweathermap.org/data/2.5/weather?lat=23.0059&lon=72.5547",
        "options": {},
        "sendQuery": true,
        "authentication": "genericCredentialType",
        "genericAuthType": "httpQueryAuth",
        "queryParameters": {
          "parameters": [
            {
              "name": "units",
              "value": "metric"
            }
          ]
        }
      },
      "credentials": {
        "httpBasicAuth": {
          "id": "zowZrB19NtOy4lxp",
          "name": "OpenWeatherAPi"
        },
        "httpQueryAuth": {
          "id": "OVXHUjaqzUxECHEG",
          "name": "OpenWeatherMap Query Auth"
        },
        "httpHeaderAuth": {
          "id": "glJ33a6G5lqhm1CW",
          "name": "Shopify GraphQL Cred"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "525f3e92-c620-47f2-b97e-53cb98d63406",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 6,
        "width": 680,
        "height": 320,
        "content": "自动化每日天气数据获取和存储"
      },
      "typeVersion": 1
    },
    {
      "id": "cff8dbb0-3639-45a6-a06d-9ab63b2dfce8",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        340
      ],
      "parameters": {
        "color": 6,
        "width": 680,
        "height": 120,
        "content": "此工作流使用 OpenWeatherMap API 每日获取天气数据，并将天气信息存储在 Airtable 中。数据可包括当前温度、湿度、风速和其他相关天气详情。此自动化确保天气数据每天更新并存储以供将来参考，提供易于访问的天气模式历史记录。"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "ef874403-4189-4b92-a963-a02fc585cb77",
  "connections": {
    "Get Weather Data": {
      "main": [
        [
          {
            "node": "Store Weather Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Weather Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}