AI Feedback Sentiment Analyzer using n8n, OpenAI & Google Sheets

Unlock Valuable Customer Insights with this AI Agent

This n8n workflow acts as an intelligent AI Agent designed to streamline your customer feedback loop. When a customer submits feedback through a customizable n8n form (or your existing form connected via webhook), the agent automatically forwards the core feedback text to OpenAI. OpenAI's powerful language models then perform sentiment analysis, classifying the feedback (e.g., positive, negative, neutral). The agent then merges this AI-generated sentiment with the original submission details (like name, contact, feedback category) and meticulously logs everything into a designated Google Sheet. This provides an organized, enriched dataset, enabling you to quickly gauge customer opinions, identify trends, and respond proactively.

Key Features & Benefits

• Automated Feedback Collection: Triggers via a simple n8n form or can be adapted for other form submission webhooks.
• AI-Powered Sentiment Analysis: Leverages OpenAI's LLMs to accurately determine the sentiment of customer feedback.
• Centralized Data Logging: Automatically organizes all feedback and its sentiment in a Google Sheet for easy access and analysis.
• Customizable Setup: Easily adapt form fields, feedback categories, and the OpenAI prompt for specific needs.
• Actionable Insights: Transforms raw feedback into structured data, helping you understand customer perception and prioritize actions.
• Time-Saving Automation: Frees up your team from manually processing and categorizing feedback.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key and Organization ID (if applicable for your OpenAI account setup).
• Google Sheets API credentials configured in n8n.
• A Google Sheet prepared to receive the feedback data. You can use the example sheet by duplicating it: https://docs.google.com/spreadsheets/d/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4/edit?usp=sharing

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'Submit form with customer feedback' (Form Trigger) node: customize form fields, title, description, and submission message as needed. Copy the 'Form URL' to share or embed.
4. In the 'Classify feedback with OpenAI' node, select or create your OpenAI credentials by providing your API Key (and Organization ID if required).
5. In the 'Add customer feedback to Google Sheets' node, select or create your Google Sheets credentials.
6. In the same Google Sheets node, ensure the 'Document ID' points to your Google Sheet and the 'Sheet Name' (e.g., 'Sheet1' or your custom name like 'gid=0') is correct. The workflow is pre-configured for the example sheet structure.
7. If you're using a different Google Sheet structure, adjust the 'Columns' mapping in the 'Add customer feedback to Google Sheets' node to match your column names.
8. Activate the workflow. New form submissions will now be processed automatically.