darrell_tw This workflow corresponds to n8n.io template #2687 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
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 →
{
"id": "ziJG3tgG91Gkbina",
"name": "n8n-\u8fb2\u7522\u54c1",
"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": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "02dfaea7-be8c-49fd-a869-39cccf6e6dde",
"name": "HTTP Request",
"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": "\u53f0\u5317\u4e8c"
},
{
"name": "api_key",
"value": "3AFID4BGE9PDQ2WTFDO1X61H4RNQLE"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "69a1d5c6-a59f-4b4b-9e51-d75f319a75c6",
"name": "Split Out",
"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\u722c\u87f2-\u8fb2\u7522\u54c1"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
}
],
"active": false,
"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 \u2018Test workflow\u2019": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
}
}
}
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.
googleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow automates the process of fetching agricultural transaction data from the Taiwan Agricultural Products Open Data Platform and storing it in a Google Sheets document for further analysis. Manual Trigger: Allows manual execution of the workflow to control when data is…
Source: https://n8n.io/workflows/2687/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
An automated workflow that scrapes Shopify store information and product data using the Shopify Scraper API from RapidAPI, triggered by a user submitting a website URL, then logs data into Google Shee
This workflow automatically searches multiple flight booking websites to find the cheapest flights for your desired routes. It leverages web scraping to compare prices across platforms, helping you sa
This workflow automatically collects weather data from multiple sources and compiles it into comprehensive reports. It helps you make informed decisions based on accurate weather forecasts without man
Push Json Data Into An App Or To Spreadsheet File. Uses httpRequest, spreadsheetFile, stickyNote, manualTrigger. Event-driven trigger; 8 nodes.
This workflow template shows how to load JSON data into a workflow and push that data into an App or convert it into a Spreadsheet file.