About this recipe
A recipe for Ai Customer Feedback Sentiment Analysis
Recipe Template
{
"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
}
]
]
}
}
}How to Use an n8n Template
1
Create a New Workflow
Click "New Workflow" in your n8n dashboard to get started.
2
Copy & Paste Template
First, copy this template:
Click here to copy the JSON
.
Then, in n8n, click the three dots (···) → "Import from file" and paste the JSON code.
3
Customize the Nodes
Go through each node in the workflow to update inputs like spreadsheet IDs, email addresses, or message content. Adjust field mappings to match your data.
4
Grant Access
For nodes that connect to external apps (like Google Sheets or Slack), you'll need to grant access. Connect your accounts using OAuth or an API key and save the credentials in the node.
5
Test It
Run the workflow by clicking "Execute Node" for each step or "Run Once" for the whole thing. Check the right sidebar to inspect data and debug any errors (they'll show up in red).
6
Activate Workflow
Once everything works as expected, click the "Activate" toggle to turn your workflow on. You're all set!