Summarize Google Sheets Form Feedback with GPT-4

This n8n workflow streamlines the process of collecting and analyzing feedback from Google Forms stored in Google Sheets. Triggered manually, it retrieves all responses, aggregates them by question into structured arrays, and feeds the data into OpenAI's GPT-4 for intelligent summarization. The AI generates a comprehensive report including overall event sentiment, key themes, and actionable improvement suggestions, formatted in Markdown.

The workflow then converts the Markdown summary into polished HTML and sends it via Gmail to a specified recipient. This eliminates manual data processing, saving hours of review time for event organizers or teams handling surveys.

Ideal for post-event feedback, customer satisfaction surveys, or any form-based input. Benefits include AI-powered insights without coding, scalable for large response sets, and easy customization for different prompts or recipients. Setup requires Google Sheets/Form credentials, OpenAI API key, and Gmail access in n8n.