This workflow follows the Error Trigger → Google Sheets 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": "get-orders-api-001",
"name": "Get Orders API",
"nodes": [
{
"parameters": {
"httpMethod": "GET",
"path": "orders",
"options": {
"responseCode": 200,
"responseMode": "onReceived"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
],
"id": "a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d",
"name": "Webhook"
},
{
"parameters": {
"operation": "read",
"documentId": {
"__rl": true,
"value": "1kc9-7I13kjpdDsCFp63_GHsLUUi6xLANeuqXYV7D4Sk",
"mode": "list",
"cachedResultName": "8n8 analize",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kc9-7I13kjpdDsCFp63_GHsLUUi6xLANeuqXYV7D4Sk/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "orders",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kc9-7I13kjpdDsCFp63_GHsLUUi6xLANeuqXYV7D4Sk/edit#gid=0"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
300,
0
],
"id": "c3d4e5f6-a7b8-4c9d-0e1f-2a3b4c5d6e7f",
"name": "Read Sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"onError": "continueErrorOutput"
},
{
"parameters": {
"respondWith": "json",
"responseBody": "={{ { success: true, data: $input.all(), timestamp: $now.toISOString(), count: $input.all().length } }}"
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1,
"position": [
600,
0
],
"id": "d4e5f6a7-b8c9-4d0e-1f2a-3b4c5d6e7f8a",
"name": "Respond to Webhook"
},
{
"parameters": {
"respondWith": "json",
"responseBody": "={{ { success: false, error: 'Failed to read data from Google Sheets', message: $json.error?.message || 'Unknown error occurred', timestamp: $now.toISOString() } }}",
"options": {
"responseCode": 500
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1,
"position": [
600,
200
],
"id": "e5f6a7b8-c9d0-4e1f-2a3b-4c5d6e7f8a9b",
"name": "Error Response"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "condition-1",
"leftValue": "={{ $input.all().length }}",
"rightValue": 0,
"operator": {
"type": "number",
"operation": "gt"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
450,
0
],
"id": "f6a7b8c9-d0e1-4f2a-3b4c-5d6e7f8a9b0c",
"name": "Has Data?"
},
{
"parameters": {
"respondWith": "json",
"responseBody": "={{ { success: true, data: [], message: 'No orders found', timestamp: $now.toISOString(), count: 0 } }}"
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1,
"position": [
600,
100
],
"id": "a7b8c9d0-e1f2-4a3b-4c5d-6e7f8a9b0c1d",
"name": "Empty Response"
},
{
"parameters": {},
"type": "n8n-nodes-base.errorTrigger",
"typeVersion": 1,
"position": [
-200,
200
],
"id": "b8c9d0e1-f2a3-4b4c-5d6e-7f8a9b0c1d2e",
"name": "Error Trigger"
},
{
"parameters": {
"values": {
"string": [
{
"name": "errorType",
"value": "={{ $json.error?.name || 'WorkflowError' }}"
},
{
"name": "errorMessage",
"value": "={{ $json.error?.message || 'An unexpected error occurred in the workflow' }}"
},
{
"name": "timestamp",
"value": "={{ $now.toISOString() }}"
},
{
"name": "workflowName",
"value": "Get Orders API"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
0,
200
],
"id": "c9d0e1f2-a3b4-4c5d-6e7f-8a9b0c1d2e3f",
"name": "Set Error Details"
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "Read Sheet",
"type": "main",
"index": 0
}
]
]
},
"Read Sheet": {
"main": [
[
{
"node": "Has Data?",
"type": "main",
"index": 0
}
],
[
{
"node": "Error Response",
"type": "main",
"index": 0
}
]
]
},
"Has Data?": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
],
[
{
"node": "Empty Response",
"type": "main",
"index": 0
}
]
]
},
"Error Trigger": {
"main": [
[
{
"node": "Set Error Details",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"errorWorkflow": "get-orders-api-001"
},
"meta": {
"templateCredsSetupCompleted": true
}
}
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
Get Orders API. Uses googleSheets, errorTrigger. Webhook trigger; 8 nodes.
Source: https://github.com/kiwabc123/Order-Product-Calculator/blob/2d7766883fd0533a7e164ff38f6e9775731c5064/n8n/get-orders-api.json — 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.
Kindwork Client Onboarding - Enterprise Edition. Uses slack, googleDrive, notion, sendGrid. Webhook trigger; 25 nodes.
Meeting Notes Generator. Uses httpRequest, slack, notion, googleSheets. Webhook trigger; 17 nodes.
Support Ticket Classifier. Uses httpRequest, slack, googleSheets, notion. Webhook trigger; 15 nodes.
This workflow is a fully automated AI video production pipeline. It accepts a raw script or topic via webhook, uses Claude AI to break the script into optimized video scenes, generates AI images for e
This n8n template helps you automatically analyze URLs for phishing and malicious activity using VirusTotal’s multi-engine threat intelligence platform. It validates incoming URLs, submits them for sc