AI Feedback Summary Agent for Google Sheets

Unlock Automated Insights with this AI Agent

Stop manually sifting through hundreds of feedback form responses. This AI Agent for n8n acts as your personal data analyst. It connects directly to a Google Sheet (perfect for Google Forms output), aggregates all the raw text feedback, and then uses the power of OpenAI's GPT-4 to generate a nuanced, structured summary. The agent's abilities include 'data analysis' and 'report creation', delivering a clean HTML report directly to your inbox, saving you hours of tedious work and highlighting the key takeaways you need to act on.

Key Features & Benefits

• Direct Google Sheets Integration: Reads feedback responses directly from any Google Sheet, eliminating manual data export.
• Intelligent Data Aggregation: Automatically groups responses by question, preparing the data for effective AI analysis.
• AI-Powered Summarization: Leverages OpenAI's GPT-4 to understand sentiment, identify trends, and create human-like summaries from qualitative data.
• Automated Report Delivery: Converts the AI-generated summary into a clean HTML email and sends it to specified stakeholders, keeping everyone in the loop effortlessly.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to a GPT-4 model.
• Google credentials (OAuth2) with permissions for Google Sheets and Gmail.
• A Google Sheet containing your feedback data, with clear column headers.

1. Import the workflow JSON into your n8n instance.
2. Configure the 'Get Google Sheets records' node: Authenticate your Google account, then select your spreadsheet and the specific sheet containing the feedback.
3. Update the 'Aggregate responses into arrays' node: Ensure the fieldToAggregate values exactly match the column header names in your Google Sheet.
4. Configure the 'Summarize via GPT model' node: Add your OpenAI API Key. You can also customize the system prompt to change the report's tone or analysis instructions.
5. Configure the 'Send via Gmail' node: Authenticate your Gmail account and set the recipient's email address in the 'Send To' field.
6. Activate the workflow. You can run it manually or replace the trigger with a Cron node for scheduled, recurring reports.