Workflow: Automated Daily Weather Data Fetcher and Storage
Integrations: airtable, httpRequest, scheduleTrigger, stickyNote

{"id": "PHp3gKoyYfSztbTB", "meta": {"instanceId": "workflow-9bc356da", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:46.430202", "updatedAt": "2025-09-29T07:07:46.430209", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Automated Daily Weather Data Fetcher and Storage", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "871fd9fd-de44-4c9f-aef4-0c731c5685f1", "name": "Schedule Trigger", "type": "n8n-nodes-base.scheduleTrigger", "position": [40, 100], "parameters": {"rule": {"interval": [{"triggerAtHour": 10}]}}, "typeVersion": 1.2, "notes": "This scheduleTrigger node performs automated tasks as part of the workflow."}, {"id": "0b721c2a-6301-4a08-9602-990598d0f7a3", "name": "Store Weather Data", "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": "Get Weather Data", "type": "n8n-nodes-base.httpRequest", "notes": "Fetching the weather data", "position": [260, 100], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {}, "sendQuery": true, "authentication": "{{ $credentials.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": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [0, 0], "parameters": {"color": 6, "width": 680, "height": 320, "content": "Automated Daily Weather Data Fetcher and Storage\n\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "cff8dbb0-3639-45a6-a06d-9ab63b2dfce8", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [0, 340], "parameters": {"color": 6, "width": 680, "height": 120, "content": "This workflow fetches weather data daily using the OpenWeatherMap API and stores the weather information in Airtable. The data can include current temperature, humidity, wind speed, and other relevant weather details. This automation ensures that the weather data is updated every day and stored for future reference, providing an easy-to-access historical record of the weather patterns."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "ef874403-4189-4b92-a963-a02fc585cb77", "connections": {"052a47c1-d167-432c-93f2-117a1c129c51": {"main": [[{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-2324ae57", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-31e57ec2", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-04771aa7", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-ad1d8665", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-2e2edcfc", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-45f43901", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-af3e512c", "type": "main", "index": 0}], [{"node": "error-handler-052a47c1-d167-432c-93f2-117a1c129c51-e416cc1a", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Automated Daily Weather Data Fetcher and Storage. This workflow integrates 5 different services: stickyNote, httpRequest, airtable, scheduleTrigger, stopAndError. It contains 7 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Automated Daily Weather Data Fetcher and Storage. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}