{"meta":{"instanceId":"workflow-9c1b07a6","versionId":"1.0.0","createdAt":"2025-09-29T07:07:51.229744","updatedAt":"2025-09-29T07:07:51.229759","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"nodes":[{"id":"4ea39a4f-d8c1-438f-9738-bfbb906a3d7a","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[1200,1020],"parameters":{"width":253,"height":342,"content":"## Send customer feedback to OpenAI for sentiment analysis"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"6962ea41-7d15-4932-919f-21ac94fa1269","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[1960,1180],"parameters":{"width":253,"height":342,"content":"## Add new feedback to google sheets"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"4c8a8984-2d8e-4139-866b-6f3536aced07","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[800,1600],"parameters":{"width":1407,"height":254,"content":"## Instructions\n1. Connect Google sheets\n2. Connect your OpenAi account (api key + org Id)\n3. Create a customer feedback form, use an existing one or use the one below as example. \nAll set!\n\n\n- Here is the example google sheet being used in this workflow: {{ $env.WEBHOOK_URL }} You can download it to your account."},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"d43a9574-626d-4817-87ba-d99bdd6f41dc","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[800,1160],"parameters":{"width":253,"height":342,"content":"## Feedback form is submitted"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"76dab2dc-935f-416e-91aa-5a1b7017ec1b","name":"Sticky Note6","type":"n8n-nodes-base.stickyNote","position":[1600,1180],"parameters":{"width":253,"height":342,"content":"## Merge form data and OpenAI result"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"9772eac1-8df2-4305-9b2c-265d3c5a9a4a","name":"Add customer feedback to Google Sheets","type":"n8n-nodes-base.googleSheets","position":[2020,1320],"parameters":{"columns":{"value":{"Category":"={{ $json['What is your feedback about?'] }}","Sentiment":"={{ $json.text }}","Timestamp":"={{ $json.submittedAt }}","Entered by":"=Form","Customer Name":"={{ $json.Name }}","Customer contact":"={{ $json['How do we get in touch with you?'] }}","Customer Feedback":"={{ $json['Your feedback'] }}"},"schema":[{"id":"Timestamp","type":"string","display":true,"required":false,"displayName":"Timestamp","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Category","type":"string","display":true,"required":false,"displayName":"Category","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Customer Feedback","type":"string","display":true,"required":false,"displayName":"Customer Feedback","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Customer Name","type":"string","display":true,"required":false,"displayName":"Customer Name","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Customer contact","type":"string","display":true,"required":false,"displayName":"Customer contact","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Entered by","type":"string","display":true,"required":false,"displayName":"Entered by","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Urgent?","type":"string","display":true,"required":false,"displayName":"Urgent?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Sentiment","type":"string","display":true,"required":false,"displayName":"Sentiment","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":[]},"options":{},"operation":"append","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"list","value":"1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"CustomerFeedback"}},"credentials":{"googleSheetsOAuth2Api":{"id":"{{ $credentials.googleSheetsOAuth2Api.id }}","name":"Google Sheets account"}},"typeVersion":4.1,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"12084971-c81b-4a0e-814e-120867562642","name":"Merge sentiment with form content","type":"n8n-nodes-base.merge","position":[1680,1320],"parameters":{"mode":"combine","options":{},"combinationMode":"multiplex"},"typeVersion":2.1,"notes":"This merge node performs automated tasks as part of the workflow."},{"id":"235edf5b-7724-4712-8dc5-d8327a0620b8","name":"Classify feedback with OpenAI","type":"n8n-nodes-base.openAi","position":[1280,1180],"parameters":{"prompt":"=Classify the sentiment in the following customer feedback:  {{ $json['Your feedback'] }}","options":{}},"credentials":{"openAiApi":{"id":"s2iucY0IctjYNbrb","name":"OpenAi account"}},"typeVersion":1,"notes":"This openAi node performs automated tasks as part of the workflow."},{"id":"af4b22aa-0925-40b1-a9ac-298f9745a98e","name":"Submit form with customer feedback","type":"n8n-nodes-base.formTrigger","position":[860,1340],"webhookId":"e7bf682e-48e8-40de-9815-cd180cdd1480","parameters":{"options":{"formSubmittedText":"Your response has been recorded"},"formTitle":"Customer Feedback","formFields":{"values":[{"fieldLabel":"Name","requiredField":true},{"fieldType":"dropdown","fieldLabel":"What is your feedback about?","fieldOptions":{"values":[{"option":"Product"},{"option":"Service"},{"option":"Other"}]},"requiredField":true},{"fieldType":"textarea","fieldLabel":"Your feedback","requiredField":true},{"fieldLabel":"How do we get in touch with you?"}]},"formDescription":"Please give feedback about our company orproducts."},"typeVersion":1,"notes":"This formTrigger node performs automated tasks as part of the workflow."},{"id":"error-9ad7cdd0","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"connections":{"Add customer feedback to Google Sheets":{"main":[[]]},"Classify feedback with OpenAI":{"main":[[]]}},"name":"Stickynote Workflow","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"description":"Automated workflow: Stickynote Workflow. This workflow integrates 6 different services: stickyNote, formTrigger, merge, stopAndError, googleSheets. It contains 11 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Stickynote Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}