Workflow: 1256_Openai_Form_Automation_Triggered
Integrations: formTrigger, googleSheets, merge, openAi, stickyNote

{"meta": {"instanceId": "82a17fa4a0b8e81bf77e5ab999d980f392150f2a9541fde626dc5f74857b1f54"}, "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}, {"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}, {"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: https://docs.google.com/spreadsheets/d/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4/edit?usp=sharing. You can download it to your account."}, "typeVersion": 1}, {"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}, {"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}, {"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": "https://docs.google.com/spreadsheets/d/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4/edit#gid=0", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4/edit?usp=drivesdk", "cachedResultName": "CustomerFeedback"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "3", "name": "Google Sheets account"}}, "typeVersion": 4.1}, {"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}, {"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}, {"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}], "connections": {"Classify feedback with OpenAI": {"main": [[{"node": "Merge sentiment with form content", "type": "main", "index": 0}]]}, "Merge sentiment with form content": {"main": [[{"node": "Add customer feedback to Google Sheets", "type": "main", "index": 0}]]}, "Submit form with customer feedback": {"main": [[{"node": "Classify feedback with OpenAI", "type": "main", "index": 0}, {"node": "Merge sentiment with form content", "type": "main", "index": 1}]]}}}