Home Recipes Ai Customer Feedback Sentiment Analysis

Ai Customer Feedback Sentiment Analysis

1 Tools

Explore Tool Categories

Find Agencies for This Project

Know a Better Recipe?

Help the community by sharing your proven tool combinations.

Submit a Recipe

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!

Frequently Asked Questions

How long does it take to implement this development recipe?

This recipe typically takes 30 minutes to implement, depending on your experience level with the tools involved.

What tools do I need for this recipe?

You'll need: n8n. All tools are linked above with setup instructions.

Is this recipe free to use?

This recipe uses a mix of free and paid tools. Check individual tool pricing above.

Do I need coding experience for this recipe?

Most tools in this recipe are no-code or low-code solutions, making them accessible to beginners. Each tool includes difficulty level indicators.

Can I customize this recipe?

Absolutely! This recipe provides a foundation that you can adapt to your specific needs. Feel free to add or remove tools based on your requirements.

What if I get stuck implementing this recipe?

Each tool includes documentation links and support resources. You can also reach out to our community or consider hiring one of our verified agencies for assistance.