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
n8n-農產品. Uses manualTrigger, httpRequest, splitOut, googleSheets. Event-driven trigger; 4 nodes.
Source: https://github.com/Zie619/n8n-workflows — 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.