AI Feedback Summarizer: Google Sheets to OpenAI Email Reports

Unlock Actionable Insights from Your Feedback with this AI Agent

This AI-driven workflow streamlines the tedious process of sifting through customer, user, or event feedback. It acts as an AI Agent specializing in Feedback Analysis & Summarization. It connects to your Google Sheet (often populated by Google Forms or other data sources), fetches new feedback entries, intelligently aggregates responses to key questions, and then employs OpenAI's GPT-4 model to generate a comprehensive yet concise summary. The final report, formatted in clean HTML, is automatically emailed to you, saving hours of manual processing and surfacing key takeaways quickly.

This agent is particularly useful for understanding sentiment, identifying common themes, and pinpointing actionable improvement suggestions from raw textual feedback.

For very large datasets or extremely long forms, consider strategies like batch processing or breaking down the summarization task within n8n for optimal performance.

Key Features & Benefits

• Automated Feedback Ingestion: Directly pulls data from your specified Google Sheet, eliminating manual data collection.
• Intelligent Aggregation: Combines multiple responses for each feedback question into a structured format, perfect for AI processing.
• AI-Powered Summarization: Leverages OpenAI's GPT-4 (e.g., gpt-4-turbo-preview) to understand nuances, identify key themes, overall sentiment, and actionable improvement suggestions from raw feedback.
• Customizable AI Prompts: Tailor the system and user prompts in the OpenAI node to guide the AI's analysis based on your specific feedback structure and desired output.
• Markdown to HTML Conversion: Ensures the AI-generated summary (typically requested in Markdown for clarity) is presented as a well-formatted HTML email.
• Automated Email Reporting: Delivers the feedback summary directly to your inbox via Gmail, keeping stakeholders informed.
• Significant Time Savings: Drastically reduces manual effort in collecting, collating, and analyzing feedback.
• Faster Actionable Insights: Provides clear, AI-driven summaries to help you make informed decisions and respond to feedback more effectively.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to a GPT-4 model (e.g., gpt-4-turbo-preview or a suitable alternative).
• Google Sheets API credentials configured in n8n.
• Gmail API credentials configured in n8n (for sending the summary email).
• A Google Sheet containing form responses. The template uses columns like 'What went great?', 'How can we improve?', and 'What is the chance of recommending our event?', but you can adapt it to your specific questions.

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure 'Get Google Sheets records' node:
   • Select your Google Sheets credential.
   • Enter the Document ID of your Google Sheet.
   • Specify the Sheet Name (e.g., 'Form Responses 1') containing the feedback. You can use the provided Google Sheets template as a starting point.
4. Review 'Aggregate responses into arrays' node:
   • Ensure the fieldToAggregate expressions (e.g., ['What went great?']) correctly match your Google Sheet column headers for the feedback questions you want to summarize.
5. Configure 'Summarize via GPT model' (OpenAI) node:
   • Select your OpenAI credential.
   • Review and customize the system prompt to instruct the AI on how to analyze your specific feedback. The default prompt is for three questions; adapt it if yours differ.
   • Verify the user prompt correctly injects the aggregated data using expressions like {{ $json['Your Question Header'].join(' | ') }}.
   • Ensure an appropriate chatModel (e.g., gpt-4-turbo-preview) is selected and that your API key has access to it.
6. 'Convet from Markdown to HTML' node: This node usually requires no changes if the OpenAI node is configured to reply in Markdown (as per the default prompt).
7. Configure 'Send via Gmail' node:
   • Select your Gmail credential.
   • Set the sendTo email address where the summary report should be delivered.
   • Customize the subject line for the summary email (e.g., "Weekly Feedback Summary").
8. Test each node individually by running them with sample data to ensure correct configuration, then test the entire workflow using the 'Test workflow' button.
9. Once satisfied, activate the workflow. Consider changing the 'When clicking "Test workflow"' (Manual Trigger) node to a 'Schedule' trigger (e.g., daily, weekly) if you want automated, recurring summaries.