AI Feedback Summarizer Agent: Google Sheets & OpenAI GPT-4

Unlock Actionable Insights from Feedback with this AI Agent

This AI Agent streamlines the often tedious process of sifting through feedback. It connects directly to your Google Sheet (perfect for responses collected via Google Forms or direct entries), intelligently aggregates all the answers, and then employs OpenAI's GPT-4 (specifically, the gpt-4-turbo-preview model by default) to generate a comprehensive yet easy-to-digest summary. The final report, formatted in clean HTML, is automatically emailed to you, allowing for quick understanding and action on customer, event, or team feedback.

Key Features & Benefits

• Automated Data Collection: Directly fetches new feedback entries from your specified Google Sheet, eliminating manual data export/import.
• Intelligent Aggregation: Consolidates all responses for each question into a format ready for AI processing.
• Advanced AI Summarization: Leverages OpenAI's GPT-4 for nuanced and context-aware summaries, identifying key themes, sentiment, and actionable suggestions.
• Markdown to HTML Conversion: The AI's Markdown output is automatically converted into polished HTML, perfect for email readability.
• Email Delivery: Receive the summarized feedback report directly in your inbox via Gmail, ready for review and sharing.
• Time-Saving Automation: Drastically reduces the manual effort and time spent on analyzing feedback forms.
• Customizable AI Prompts: Tailor the OpenAI system and user messages to fine-tune the summarization style and focus according to your specific needs.

• An n8n instance (Cloud or self-hosted).
• An OpenAI API Key with access to a GPT-4 model (e.g., gpt-4-turbo-preview as used in the template, or gpt-4).
• Google Workspace account with access to Google Sheets and Gmail.
• Configured OAuth2 credentials for Google Sheets and Gmail within your n8n instance.
• A Google Sheet prepared with feedback data. The template uses specific column names like 'What went great?', 'How can we improve?', 'What is the chance of recommending our event?'. You can adapt the workflow to your sheet's structure. (Optional: You can use this Google Sheets template as a starting point).

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'Get Google Sheets records' node: a. Select your Google Sheets credential. b. Set 'Document ID' to your Google Sheet containing the feedback. c. Set 'Sheet Name' to the specific sheet with the responses (e.g., 'Form Responses 1').
4. In the 'Aggregate responses into arrays' node: a. Review the 'Fields To Aggregate' section. b. Ensure the fieldToAggregate expressions (e.g., ['What went great?']) exactly match the column headers in your Google Sheet.
5. Configure the 'Summarize via GPT model' (OpenAI) node: a. Select your OpenAI credential and enter your API Key if not already configured. b. Verify the 'Chat Model' (default gpt-4-turbo-preview). c. Customize the system and user messages under 'Prompt' if you want to change how the AI summarizes the feedback or if your sheet has different questions.
6. Configure the 'Send via Gmail' node: a. Select your Gmail credential. b. Enter the recipient email address in the 'Send To' field. c. Optionally, customize the 'Subject' of the email.
7. Test the workflow using the 'Test workflow' button (or by executing the manual trigger node) to ensure data flows correctly and the summary is generated as expected.
8. Activate the workflow. You can change the initial 'When clicking "Test workflow"' node to a 'Schedule' node (Cron) for automated periodic summaries.