Workflow: n8n-農產品
Integrations: googleSheets, httpRequest, manualTrigger, splitOut

{"id": "ziJG3tgG91Gkbina", "meta": {"instanceId": "workflow-9379ea43", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:50.809828", "updatedAt": "2025-09-29T07:07:50.809842", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "n8n-\u8fb2\u7522\u54c1", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "07d7241d-480b-4d53-96ba-485d1dc469f6", "name": "When clicking \u2018Test workflow\u2019", "type": "n8n-nodes-base.manualTrigger", "position": [0, 0], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"id": "02dfaea7-be8c-49fd-a869-39cccf6e6dde", "name": "HTTP Request", "type": "n8n-nodes-base.httpRequest", "position": [220, 0], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {}, "sendQuery": true, "sendHeaders": true, "queryParameters": {"parameters": [{"name": "Start_time", "value": "2024/12/01"}, {"name": "End_time", "value": "2024/12/31"}, {"name": "MarketName", "value": "\u53f0\u5317\u4e8c"}, {"name": "api_key", "value": "3AFID4BGE9PDQ2WTFDO1X61H4RNQLE"}]}, "headerParameters": {"parameters": [{"name": "accept", "value": "application/json"}]}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "69a1d5c6-a59f-4b4b-9e51-d75f319a75c6", "name": "Split Out", "type": "n8n-nodes-base.splitOut", "position": [440, 0], "parameters": {"options": {}, "fieldToSplitOut": "Data"}, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow."}, {"id": "082828e0-4cc6-465c-bfe4-561f8e4e3c50", "name": "Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [660, 0], "parameters": {"columns": {"value": {}, "schema": [{"id": "TransDate", "type": "string", "display": true, "required": false, "displayName": "TransDate", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "TcType", "type": "string", "display": true, "required": false, "displayName": "TcType", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "CropCode", "type": "string", "display": true, "required": false, "displayName": "CropCode", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "CropName", "type": "string", "display": true, "required": false, "displayName": "CropName", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "MarketCode", "type": "string", "display": true, "required": false, "displayName": "MarketCode", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "MarketName", "type": "string", "display": true, "required": false, "displayName": "MarketName", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Upper_Price", "type": "string", "display": true, "required": false, "displayName": "Upper_Price", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Middle_Price", "type": "string", "display": true, "required": false, "displayName": "Middle_Price", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Lower_Price", "type": "string", "display": true, "required": false, "displayName": "Lower_Price", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Avg_Price", "type": "string", "display": true, "required": false, "displayName": "Avg_Price", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "Trans_Quantity", "type": "string", "display": true, "required": false, "displayName": "Trans_Quantity", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "autoMapInputData", "matchingColumns": []}, "options": {}, "operation": "append", "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "17EJTOetBsfoGkzADCUHPoXaQW7FLQziYmQxKNJNnDIU", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "n8n\u722c\u87f2-\u8fb2\u7522\u54c1"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "atsKA0m2aQXeL6i6", "name": "Google Sheets account"}}, "typeVersion": 4.5, "notes": "This googleSheets 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": "b7991044-da7e-425f-a2ea-692e3d8d642b", "connections": {"02dfaea7-be8c-49fd-a869-39cccf6e6dde": {"main": [[{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-0fa73412", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-9e4d8f20", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-b9fe8975", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-2ec98397", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-2f8b22c7", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-a96aeb4b", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-fb9ce79a", "type": "main", "index": 0}], [{"node": "error-handler-02dfaea7-be8c-49fd-a869-39cccf6e6dde-accf12e5", "type": "main", "index": 0}]]}, "082828e0-4cc6-465c-bfe4-561f8e4e3c50": {"main": [[{"node": "error-handler-082828e0-4cc6-465c-bfe4-561f8e4e3c50-6dda2d4a", "type": "main", "index": 0}]]}}, "description": "Automated workflow: n8n-\u8fb2\u7522\u54c1. This workflow processes data and performs automated tasks.", "notes": "Excellent quality workflow: n8n-\u8fb2\u7522\u54c1. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}