This workflow follows the HTTP Request → Postgres 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 →
{
"active": false,
"activeVersion": null,
"activeVersionId": null,
"connections": {
"When clicking \"Test workflow\"": {
"main": [
[
{
"node": "Postgres",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "se nao tem zendesk user id",
"type": "main",
"index": 0
}
]
]
},
"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria": {
"main": [
[
{
"node": "Cria o ticket de entrada da volunt\u00e1ria pela API do Zendesk1",
"type": "main",
"index": 0
}
]
]
},
"Postgres": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"busca tickets": {
"main": [
[
{
"node": "se existe tickets",
"type": "main",
"index": 0
}
]
]
},
"Zendesk": {
"main": [
[
{
"node": "encontrou a volunt\u00e1ria no zendesk",
"type": "main",
"index": 0
}
]
]
},
"encontrou a volunt\u00e1ria no zendesk": {
"main": [
[
{
"node": "Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"se existe tickets": {
"main": [
[
{
"node": "Separa a lista de tickets",
"type": "main",
"index": 0
}
],
[
{
"node": "Zendesk",
"type": "main",
"index": 0
}
]
]
},
"Separa a lista de tickets": {
"main": [
[
{
"node": "Filtra os tickets gerados em 25/09",
"type": "main",
"index": 0
}
]
]
},
"Filtra os tickets gerados em 25/09": {
"main": [
[
{
"node": "Re\u00fane os tickets filtrados",
"type": "main",
"index": 0
}
]
]
},
"Se n\u00e3o tem nenhum ticket do dia 25/": {
"main": [
[
{
"node": "Zendesk1",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Cria o ticket de entrada da volunt\u00e1ria pela API do Zendesk1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Re\u00fane os tickets filtrados": {
"main": [
[
{
"node": "Se n\u00e3o tem nenhum ticket do dia 25/",
"type": "main",
"index": 0
}
]
]
},
"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria1": {
"main": [
[
{
"node": "Cria o ticket de entrada da volunt\u00e1ria pela API do Zendesk",
"type": "main",
"index": 0
}
]
]
},
"Zendesk1": {
"main": [
[
{
"node": "encontrou a volunt\u00e1ria no zendesk1",
"type": "main",
"index": 0
}
]
]
},
"encontrou a volunt\u00e1ria no zendesk1": {
"main": [
[
{
"node": "Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria1",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Cria o ticket de entrada da volunt\u00e1ria pela API do Zendesk": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"se nao tem zendesk user id": {
"main": [
[
{
"node": "busca tickets",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2024-09-26T12:44:50.223Z",
"description": null,
"id": "gPErKVtIDsDWfGaw",
"isArchived": false,
"meta": {
"templateCredsSetupCompleted": true
},
"name": "[PROD] Criar ticket volunt\u00e1ria cadastrada",
"nodes": [
{
"parameters": {},
"id": "8e4340be-4671-4424-a101-0a82544a7678",
"name": "When clicking \"Test workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-160,
240
]
},
{
"parameters": {
"options": {}
},
"id": "b389b97d-605c-4b2e-8424-fb0989db930d",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
520,
240
]
},
{
"parameters": {
"amount": 2
},
"id": "f5742b26-9027-426f-a424-d5f6f35c2934",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
760,
260
],
"onError": "continueRegularOutput"
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field\n// called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n if (item.json.organzation_id == 360269610652) {\n \titem.json.subject =`[Advogada] ${item.json.name.trim()} - ${item.json.user_fields.registration_number}`;\n\n } else {\n item.json.subject =`[Psic\u00f3loga] ${item.json.name.trim()} - ${item.json.user_fields.registration_number}`;\n \n }\n}\n\nreturn $input.all();"
},
"id": "16e02c27-315b-46c7-84a9-148bb5b742f8",
"name": "Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria",
"type": "n8n-nodes-base.code",
"typeVersion": 1,
"position": [
2680,
300
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "SELECT id, concat(first_name, ' ', last_name) as name, first_name email,zendesk_user_id, occupation,condition,register_number, created_at, updated_at\nFROM volunteers WHERE condition = 'cadastrada' and created_at < '2024-09-24'\nand updated_at < '2024-09-30' order by created_at",
"options": {}
},
"id": "b4110de1-d65d-43a4-a0eb-95baeb8d5f8d",
"name": "Postgres",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.4,
"position": [
100,
240
],
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "=https://mapadoacolhimento.zendesk.com/api/v2/users/{{ $json[\"zendesk_user_id\"] }}/tickets/requested",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "zendeskApi",
"options": {}
},
"id": "f99ca6e3-00c4-42ca-ad00-6c0a5efdb461",
"name": "busca tickets",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 3,
"position": [
1200,
240
],
"credentials": {
"zendeskApi": {
"name": "<your credential>"
}
},
"onError": "continueRegularOutput"
},
{
"parameters": {
"resource": "user",
"operation": "get",
"id": "={{ $('Postgres').item.json.zendesk_user_id }}"
},
"id": "748e158f-9705-419e-9b52-3529d71cd924",
"name": "Zendesk",
"type": "n8n-nodes-base.zendesk",
"typeVersion": 1,
"position": [
1920,
280
],
"credentials": {
"zendeskApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "bdc016e9-a31a-46f6-aa69-e58479cf9168",
"leftValue": "={{ $json.email }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
}
},
{
"id": "1f91d1a8-349d-473e-a095-d15f6e624cfd",
"leftValue": "",
"rightValue": "",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "fe202ac3-1da4-4bb3-bb36-009382a15311",
"name": "encontrou a volunt\u00e1ria no zendesk",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
2300,
300
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "b41211fb-5b6e-4d77-8ffe-c7dce6417c2f",
"leftValue": "={{ $json.count }}",
"rightValue": 0,
"operator": {
"type": "number",
"operation": "gt"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "d649759d-d09f-4453-b85e-7a4b86daf107",
"name": "se existe tickets",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
1440,
260
],
"onError": "continueRegularOutput"
},
{
"parameters": {
"authentication": "oAuth2",
"select": "user",
"user": {
"__rl": true,
"value": "U06CP90UD1U",
"mode": "list",
"cachedResultName": "adriele473"
},
"text": "Fluxo finalizado",
"otherOptions": {}
},
"id": "97075cbe-64a2-4efa-967a-9cb7b7564e26",
"name": "Slack",
"type": "n8n-nodes-base.slack",
"typeVersion": 2.1,
"position": [
820,
-360
],
"credentials": {
"slackOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"fieldToSplitOut": "=tickets",
"options": {}
},
"id": "ddefbd3b-d6da-4cca-9ace-bcdd99ba633c",
"name": "Separa a lista de tickets",
"type": "n8n-nodes-base.splitOut",
"typeVersion": 1,
"position": [
1700,
-400
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "ed7cccb2-c9ad-44b7-88da-239d3736e152",
"leftValue": "={{ $json.description }}",
"rightValue": "Via cadastro.",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
},
{
"id": "7674835e-011b-4896-9783-d8212db24173",
"leftValue": "={{ $json.description }}",
"rightValue": "Importado via N8N",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "or"
},
"options": {}
},
"id": "701a3001-a373-49d8-8d12-e77ea5c8c420",
"name": "Filtra os tickets gerados em 25/09",
"type": "n8n-nodes-base.filter",
"typeVersion": 2,
"position": [
2020,
-400
],
"alwaysOutputData": true
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "8c26321b-b74e-4893-b6e8-031ba1f5acdb",
"leftValue": "={{ $json.tickets[0]}}",
"rightValue": 0,
"operator": {
"type": "object",
"operation": "empty",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "f99fd977-94a8-4432-a738-4ae5c87a2f0a",
"name": "Se n\u00e3o tem nenhum ticket do dia 25/",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
2660,
-380
]
},
{
"parameters": {
"method": "POST",
"url": "=https://mapadoacolhimento.zendesk.com/api/v2/tickets/",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "zendeskApi",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"ticket\": {\n\t\t\"requester_id\": {{ $node[\"Zendesk\"].json['id'] }},\n\t\t\"organization_id\": {{ $node[\"Zendesk\"].json['organization_id'] }},\n\t\t\"description\":\"Importado via N8N\",\n\t\t\"subject\": \"{{ $node[\"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria\"].json[\"subject\"] }}\",\n\t\t\"comment\": {\n\t\t\t\"body\": \"Cadastrada\",\n\t\t\t\"public\": false\n\t\t},\n\t\t\"status\": \"pending\",\n\t\t\"custom_fields\": [\n\t\t\t\n\t\t\t{\n\t\t\t\t\"id\": 360016631592, \n\t\t\t\t\"value\": \"{{ $node[\"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria\"].json[\"name\"] }}\"\n\t\t\t},\n\t\t\t{\n\t\t\t\t\"id\": 360021665652, \n\t\t\t\t\"value\": \"{{ $node[\"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria\"].json['user_fields'][\"condition\"] }}\"\n\t\t\t}\n\n\t\t]\n\t}\n}",
"options": {}
},
"id": "be2ae4d8-27f2-4436-aee0-af0d4ef944d6",
"name": "Cria o ticket de entrada da volunt\u00e1ria pela API do Zendesk1",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 3,
"position": [
3100,
380
],
"credentials": {
"zendeskApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "tickets",
"options": {}
},
"id": "498a8904-fea2-48f4-b9d5-7caaab304b97",
"name": "Re\u00fane os tickets filtrados",
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2320,
-400
]
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field\n// called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n if (item.json.organzation_id == 360269610652) {\n \titem.json.subject =`[Advogada] ${item.json.name.trim()} - ${item.json.user_fields.registration_number}`;\n\n } else {\n item.json.subject =`[Psic\u00f3loga] ${item.json.name.trim()} - ${item.json.user_fields.registration_number}`;\n \n }\n}\n\nreturn $input.all();"
},
"id": "689c297a-d331-4015-a065-0ba202019d35",
"name": "Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria1",
"type": "n8n-nodes-base.code",
"typeVersion": 1,
"position": [
3700,
-300
]
},
{
"parameters": {
"resource": "user",
"operation": "get",
"id": "={{ $('Postgres').item.json.zendesk_user_id }}"
},
"id": "449fee66-21f6-472f-8b40-811cf2d62702",
"name": "Zendesk1",
"type": "n8n-nodes-base.zendesk",
"typeVersion": 1,
"position": [
3000,
-360
],
"credentials": {
"zendeskApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "bdc016e9-a31a-46f6-aa69-e58479cf9168",
"leftValue": "={{ $json.email }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
}
},
{
"id": "1f91d1a8-349d-473e-a095-d15f6e624cfd",
"leftValue": "",
"rightValue": "",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "a5c2a864-5e84-42e7-be83-138f8d1758ec",
"name": "encontrou a volunt\u00e1ria no zendesk1",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
3380,
-280
]
},
{
"parameters": {
"method": "POST",
"url": "=https://mapadoacolhimento.zendesk.com/api/v2/tickets/",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "zendeskApi",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"ticket\": {\n\t\t\"requester_id\": {{ $node[\"Zendesk1\"].json['id'] }},\n\t\t\"organization_id\": {{ $node[\"Zendesk1\"].json['organization_id'] }},\n\t\t\"description\":\"Importado via N8N\",\n\t\t\"subject\": \"{{ $node[\"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria1\"].json[\"subject\"] }}\",\n\t\t\"comment\": {\n\t\t\t\"body\": \"Cadastrada\",\n\t\t\t\"public\": false\n\t\t},\n\t\t\"status\": \"pending\",\n\t\t\"custom_fields\": [\n\t\t\t\n\t\t\t{\n\t\t\t\t\"id\": 360016631592, \n\t\t\t\t\"value\": \"{{ $node[\"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria1\"].json[\"name\"] }}\"\n\t\t\t},\n\t\t\t{\n\t\t\t\t\"id\": 360021665652, \n\t\t\t\t\"value\": \"{{ $node[\"Monta o assunto do ticket de acordo com a organiza\u00e7\u00e3o da volunt\u00e1ria1\"].json['user_fields'][\"condition\"] }}\"\n\t\t\t}\n\n\t\t]\n\t}\n}",
"options": {}
},
"id": "45ca5ceb-9605-42f2-a829-38642b233e4d",
"name": "Cria o ticket de entrada da volunt\u00e1ria pela API do Zendesk",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 3,
"position": [
3940,
-80
],
"credentials": {
"zendeskApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"id": "3ab881c3-38f2-4a4e-ace2-daf716f85852",
"leftValue": "={{ $json.zendesk_user_id }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "2b951023-acf7-427c-b1d9-1576f36fb9f5",
"name": "se nao tem zendesk user id",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
980,
260
]
}
],
"settings": {
"executionOrder": "v1"
},
"shared": [
{
"updatedAt": "2024-09-26T12:44:50.226Z",
"createdAt": "2024-09-26T12:44:50.226Z",
"role": "workflow:owner",
"workflowId": "gPErKVtIDsDWfGaw",
"projectId": "rfgBK87HsySgxYKT",
"project": {
"updatedAt": "2024-11-15T08:07:36.637Z",
"createdAt": "2024-11-15T08:07:36.637Z",
"id": "rfgBK87HsySgxYKT",
"name": "Desenvolvimento Mapa <dev@mapa.org.br>",
"type": "personal",
"icon": null,
"description": null,
"projectRelations": [
{
"updatedAt": "2024-11-15T08:07:36.637Z",
"createdAt": "2024-11-15T08:07:36.637Z",
"userId": "6e437c36-d4e0-42f4-bbc3-d9b5ac96e474",
"projectId": "rfgBK87HsySgxYKT",
"user": {
"updatedAt": "2026-06-20T23:13:04.000Z",
"createdAt": "2024-01-09T22:21:28.810Z",
"id": "6e437c36-d4e0-42f4-bbc3-d9b5ac96e474",
"email": "dev@mapa.org.br",
"firstName": "Desenvolvimento",
"lastName": "Mapa",
"personalizationAnswers": null,
"settings": {
"userActivated": true,
"firstSuccessfulWorkflowId": "sMoToF9HauyKvsFJ",
"isOnboarded": true,
"userActivatedAt": 1731658062996,
"npsSurvey": {
"waitingForResponse": true,
"ignoredCount": 1,
"lastShownAt": 1781616956799
},
"easyAIWorkflowOnboarded": true
},
"disabled": false,
"mfaEnabled": false,
"lastActiveAt": "2026-06-20",
"isPending": false
}
}
]
}
}
],
"staticData": null,
"tags": [],
"triggerCount": 0,
"updatedAt": "2024-10-01T13:47:33.000Z",
"versionCounter": 1,
"versionId": "f0b83d6f-f67b-4bb7-95ae-605308a6e90c"
}
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.
postgresslackOAuth2ApizendeskApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
[PROD] Criar ticket voluntária cadastrada. Uses postgres, httpRequest, zendesk, slack. Event-driven trigger; 20 nodes.
Source: https://github.com/mapadoacolhimento/n8n-workflows/blob/c144f9465076611ebb802ee5d8c17ce3789d2a3e/[PROD]_Criar_ticket_voluntaria_cadastrada — 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.
[STG] Match Diário. Uses slack, httpRequest, postgres, zendesk. Scheduled trigger; 24 nodes.
Slack, HTTP Request, Postgres +2
[STG] Match Diário. Uses slack, httpRequest, postgres, zendesk. Scheduled trigger; 24 nodes.
Slack, HTTP Request, Postgres +2
[STG] Match Diário. Uses slack, httpRequest, postgres, zendesk. Scheduled trigger; 24 nodes.
Slack, HTTP Request, Postgres +2
[STG] Match Diário. Uses slack, httpRequest, postgres, zendesk. Scheduled trigger; 24 nodes.
Slack, HTTP Request, Postgres +2
[STG] Match Diário. Uses slack, httpRequest, postgres, zendesk. Scheduled trigger; 24 nodes.
Slack, HTTP Request, Postgres +2