n8n-农产品
初级
这是一个Other领域的自动化工作流，包含 4 个节点。主要使用 SplitOut, HttpRequest, GoogleSheets, ManualTrigger 等节点。 TW-请求-农业数据开放平台-每日市场羊价
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "ziJG3tgG91Gkbina",
"meta": {
"instanceId": "fddb3e91967f1012c95dd02bf5ad21f279fc44715f47a7a96a33433621caa253"
},
"name": "n8n-農產品",
"tags": [
{
"id": "YaVjRtdJOQvaEnU3",
"name": "testing",
"createdAt": "2024-12-29T07:47:44.069Z",
"updatedAt": "2024-12-29T07:47:44.069Z"
}
],
"nodes": [
{
"id": "07d7241d-480b-4d53-96ba-485d1dc469f6",
"name": "点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "02dfaea7-be8c-49fd-a869-39cccf6e6dde",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
0
],
"parameters": {
"url": "https://data.moa.gov.tw/api/v1/SheepQuotation",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "Start_time",
"value": "2024/12/01"
},
{
"name": "End_time",
"value": "2024/12/31"
},
{
"name": "MarketName",
"value": "台北二"
},
{
"name": "api_key",
"value": "3AFID4BGE9PDQ2WTFDO1X61H4RNQLE"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "69a1d5c6-a59f-4b4b-9e51-d75f319a75c6",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
440,
0
],
"parameters": {
"options": {},
"fieldToSplitOut": "Data"
},
"typeVersion": 1
},
{
"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": "https://docs.google.com/spreadsheets/d/17EJTOetBsfoGkzADCUHPoXaQW7FLQziYmQxKNJNnDIU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "17EJTOetBsfoGkzADCUHPoXaQW7FLQziYmQxKNJNnDIU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17EJTOetBsfoGkzADCUHPoXaQW7FLQziYmQxKNJNnDIU/edit?usp=drivesdk",
"cachedResultName": "n8n爬蟲-農產品"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "atsKA0m2aQXeL6i6",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "b7991044-da7e-425f-a2ea-692e3d8d642b",
"connections": {
"Split Out": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
初级 - 其他
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
模板演示-chatgpt-图片-1-带-drive-和-sheet副本
使用GPT-image-1生成图像并存储到Google Drive，包含成本跟踪
Set
Split Out
Aggregate
+8
16 节点darrell_tw
设计
n8napi-检查使用哪个模型的工作流
检查工作流中使用的AI模型
N8n
Set
Filter
+5
12 节点darrell_tw
人工智能
YT AI新闻播放列表创建器/AI新闻表单更新器
使用Google Sheets创建每日YouTube播放列表，并在Telegram中接收通知
Filter
You Tube
Split Out
+6
23 节点Dustin
其他
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
将Shopify所有订单获取到Google表格
将Shopify所有订单获取到Google表格
If
Set
Code
+6
11 节点bangank36
其他
同步 Shopify 客户到 Google Sheets + Squarespace 兼容 CSV
将 Shopify 客户数据同步到 Google Sheets 并生成 Squarespace 兼容的 CSV
If
Set
Code
+7
13 节点bangank36
销售
工作流信息
难度等级
初级
节点数量4
分类1
节点类型4
作者
darrell_tw
@darrelltwMartech Engineer with automation. here is my website: https://www.darrelltw.com/
外部链接
在 n8n.io 查看 →
分享此工作流