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.
01 — Lead Capture → AI Scoring → CRM Pipeline. Uses openAi, gmail, airtable, slack. Webhook trigger; 20 nodes.
What it does: Initializes Google Sheets tabs: jobs, slides, events Creates a Google Drive root folder for optimizer jobs Reads slide images from a Google Drive input folder Sends each image to gpt-ima