n8n Workflow: Summarize Google Sheets Form Feedback with OpenAI GPT-4

Turn Google Form feedback into an executive-ready summary—automatically—using OpenAI GPT-4 in n8n.

This n8n workflow collects responses from an event Google Form stored in Google Sheets, analyzes the feedback with OpenAI GPT-4, and emails you a polished, HTML-formatted sentiment + improvement report via Gmail.

What this workflow does

• Runs on demand: Triggered manually by clicking Test workflow in n8n.
• Pulls feedback from Google Sheets: The Google Sheets node retrieves the form responses for the event.
• Aggregates answers by question: The Aggregate node combines all responses for each question into arrays, structuring the data for analysis.
• Analyzes sentiment and suggestions with GPT-4: The OpenAI node uses a system prompt to review the aggregated responses and generate a Markdown summary that includes overall sentiment and constructive improvement recommendations.
• Converts report format and delivers by email: A Markdown node converts the Markdown output to HTML, and the Gmail node sends the email to a specified address.

Use cases

• Post-event debriefs: Summarize attendee feedback from a Google Form/Google Sheets setup and send a turnaround email.
• Product or experience improvements: Identify constructive suggestions per question and share them with your team.
• SaaS ops reporting: Create consistent, repeatable feedback summaries without manual copy-pasting into docs.
• Automation engineers: Use as a clear reference workflow combining Google Sheets, OpenAI, and Gmail.

Technical details (n8n nodes & integrations)

• Google Sheets (retrieve event form responses)
• Aggregate (combine responses into per-question arrays)
• OpenAI (GPT-4 analysis with a system prompt for sentiment + recommendations)
• Markdown (Markdown → HTML)
• Gmail (send HTML-formatted email)
• Sticky Note (workflow guidance/annotations)