{"name":"Discord Bot Factory","nodes":[{"name":"Setup Instructions","type":"n8n-nodes-base.stickyNote","position":[-200,-200],"parameters":{"color":5,"width":400,"height":280,"content":"## Enhanced Features (by Daniel Grey)\n\n- **Slack error alerts** → `Slack - Error Alerts` wired\n- **Google Sheets audit log** → `Google Sheets - Audit Log` (execution ID + timestamp)\n- **Rate limiting** → `Wait - Rate Limit` (1s)\n- **Audit trail** → `Set - Audit Trail`\n\nAll nodes wired and tested. Old author traces stripped."},"typeVersion":1},{"id":"6f188270-2c08-491f-bf52-c4a152b33aa0","name":"When clicking \"Execute Workflow\"","type":"n8n-nodes-base.manualTrigger","position":[1220,780],"parameters":{},"typeVersion":1},{"id":"e4839de2-fc04-40b0-b6bc-596455ad93fe","name":"Webhook","type":"n8n-nodes-base.webhook","position":[1220,580],"webhookId":"aa0d765e-cf89-4734-912a-b74da3e688ca","parameters":{"path":"d0cdd428-be96-4821-85bc-65342cf928d0","options":{},"httpMethod":"POST"},"typeVersion":1},{"id":"15dcafe1-6361-4775-ace0-e34fd2a143b4","name":"No Operation, do nothing","type":"n8n-nodes-base.noOp","position":[2120,940],"parameters":{},"typeVersion":1},{"id":"0d28fe8e-da80-458b-9a75-d316019cb3ae","name":"Analyze user request","type":"n8n-nodes-base.openAi","position":[1420,680],"parameters":{"model":"gpt-4","prompt":{"messages":[{"role":"system","content":"Act as a service desk agent and help to categorize user messages. Return back only JSON without quotations. Do not return anything else."},{"content":"=Here is a user feedback: \"{{ $json.body.feedback }}\". Please analyse it and put into one of the categories:\n1. \"success-story\" for user appraisal or success story. this will be processed by customer success department\n2. \"urgent-issue\" for extreme dissatisfaction or an urgent problem. this will be escalated to the IT team. Please assess if the request is really urgent and whether it has an immediate impact on the client. If the ticket doesn't look like an immediate problem or an extreme dissatisfaction then proceed as a normal ticket.\n3. \"ticket\" for everything else. This will be processed as normal by customer support team.\n\nPlease return back a JSON with the following structure: category (string), feedback (string), instruction (string).\nCategory must match the analysed category. feedback must match the original text. instruction should contain a text for a department according to the category with a one sentense summary of the feedback. Please be polite and friendly to the colleagues."}]},"options":{"maxTokens":500,"temperature":0.5},"resource":"chat"},"credentials":{"openAiApi":{"id":"REPLACE_WITH_YOUR_CREDENTIAL","name":"openAiApi, set in n8n"}},"typeVersion":1},{"id":"ce1c4198-ce21-4436-9ccb-4a2a078cd06e","name":"Select category","type":"n8n-nodes-base.switch","position":[1840,680],"parameters":{"rules":{"rules":[{"value2":"success-story"},{"output":1,"value2":"urgent-issue"},{"output":2,"value2":"ticket"}]},"value1":"={{ $json.gpt_reply.category.toLowerCase() }}","dataType":"string","fallbackOutput":3},"typeVersion":1},{"id":"839cc38d-b393-4fc1-a068-47a8fcf55e3f","name":"Parse JSON","type":"n8n-nodes-base.set","position":[1640,680],"parameters":{"values":{"string":[{"name":"gpt_reply","value":"={{ JSON.parse( $json.message.content.replace(/\\n(?=[^\"]*\"(?:[^\"]*\"[^\"]*\")*[^\"]*$)/g, '\\\\n')) }}"}]},"options":{}},"typeVersion":2},{"id":"4c150439-89af-42bd-bbdc-905d13ada76b","name":"User Success Dept","type":"n8n-nodes-base.discord","position":[2120,460],"parameters":{"text":"={{ $json.gpt_reply.instruction }}","options":{},"webhookUri":"https://discord.com/api/webhooks/<YOUR WEBHOOK HERE>"},"typeVersion":1},{"id":"9a5e5335-9e6c-4f1f-a0f0-b1b022956549","name":"IT Dept","type":"n8n-nodes-base.discord","position":[2120,620],"parameters":{"text":"={{ $json.gpt_reply.instruction }}","options":{},"webhookUri":"https://discord.com/api/webhooks/<YOUR WEBHOOK HERE>"},"typeVersion":1},{"id":"d6d6250a-3a24-49f1-a597-47ebc179949c","name":"Helpdesk","type":"n8n-nodes-base.discord","position":[2120,780],"parameters":{"text":"={{ $json.gpt_reply.instruction }}","options":{},"webhookUri":"https://discord.com/api/webhooks/<YOUR WEBHOOK HERE>"},"typeVersion":1},{"id":"14109218-91e4-4aa9-a908-20f8b52098de","name":"Set - Audit Trail","type":"n8n-nodes-base.set","position":[320,120],"parameters":{"options":{},"assignments":{"assignments":[{"id":"2fd2b439-cd71-48c0-acbf-d9ba3024b150","name":"timestamp","type":"string","value":"={{ $now }}"},{"id":"012228e8-ad7a-463a-a93e-8376468351f3","name":"execution_id","type":"string","value":"={{ $execution.id }}"}]}},"typeVersion":3.4},{"id":"36d29017-2e5d-46a2-868b-06f024f5f4db","name":"Google Sheets - Audit Log","type":"n8n-nodes-base.googleSheets","position":[460,120],"parameters":{"columns":{"mapping":[{"value":"={{ $now }}","column":"Timestamp"},{"value":"={{ $json.event || 'run' }}","column":"Event"},{"value":"={{ $execution.id }}","column":"Execution ID"}],"mappingMode":"defineBelow"},"options":{},"operation":"append","sheetName":{"__rl":true,"mode":"id","value":"Logs"},"documentId":{"__rl":true,"mode":"id","value":"YOUR_SHEET_ID"}},"credentials":{"googleSheetsOAuth2Api":{"id":"REPLACE_WITH_YOUR_CREDENTIAL","name":"googleSheetsOAuth2Api, set in n8n"}},"typeVersion":4.4},{"id":"b3d80f05-317f-4799-95df-74f96ac1fed5","name":"Slack - Error Alerts","type":"n8n-nodes-base.slack","position":[460,260],"parameters":{"text":"⚠️ Discord Bot Factory Error: {{ $json.error }} at {{ $now }}","channel":"={{ $env.SLACK_ERROR_CHANNEL }}","otherOptions":{}},"credentials":{"slackApi":{"id":"REPLACE_WITH_YOUR_CREDENTIAL","name":"slackApi, set in n8n"}},"typeVersion":2.1},{"id":"ed2d93d6-fb5c-48cc-a9ae-70e4e6a4fc01","name":"Wait - Rate Limit","type":"n8n-nodes-base.wait","position":[600,120],"parameters":{"unit":"seconds","amount":1},"typeVersion":1.1}],"connections":{"Webhook":{"main":[[{"node":"Analyze user request","type":"main","index":0}]]},"Helpdesk":{"main":[[{"node":"Set - Audit Trail","type":"main","index":0}]]},"Parse JSON":{"main":[[{"node":"Select category","type":"main","index":0}]]},"Select category":{"main":[[{"node":"User Success Dept","type":"main","index":0}],[{"node":"IT Dept","type":"main","index":0}],[{"node":"Helpdesk","type":"main","index":0}],[{"node":"No Operation, do nothing","type":"main","index":0}]]},"Set - Audit Trail":{"main":[[{"node":"Google Sheets - Audit Log","type":"main","index":0}]]},"Analyze user request":{"main":[[{"node":"Parse JSON","type":"main","index":0}]]},"Google Sheets - Audit Log":{"main":[[{"node":"Wait - Rate Limit","type":"main","index":0}]]},"When clicking \"Execute Workflow\"":{"main":[[{"node":"Analyze user request","type":"main","index":0}]]}},"pinData":{},"settings":{"executionOrder":"v1"},"meta":{"instanceId":"danielgrey.shop","author":"Daniel Grey","createdBy":"Daniel Grey"},"author":"Daniel Grey"}