{"product_id":"n8n-workflow-summarize-google-sheets-form-feedback-with-openai-gpt-4","title":"n8n Workflow: Summarize Google Sheets Form Feedback with OpenAI GPT-4","description":"\u003ch3\u003eTurn Google Form feedback into an executive-ready summary—automatically—using OpenAI GPT-4 in n8n.\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand:\u003c\/strong\u003e Triggered manually by clicking \u003cem\u003eTest workflow\u003c\/em\u003e in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls feedback from Google Sheets:\u003c\/strong\u003e The \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e node retrieves the form responses for the event.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates answers by question:\u003c\/strong\u003e The \u003cstrong\u003eAggregate\u003c\/strong\u003e node combines all responses for each question into arrays, structuring the data for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes sentiment and suggestions with GPT-4:\u003c\/strong\u003e The \u003cstrong\u003eOpenAI\u003c\/strong\u003e node uses a system prompt to review the aggregated responses and generate a Markdown summary that includes overall sentiment and constructive improvement recommendations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts report format and delivers by email:\u003c\/strong\u003e A \u003cstrong\u003eMarkdown\u003c\/strong\u003e node converts the Markdown output to HTML, and the \u003cstrong\u003eGmail\u003c\/strong\u003e node sends the email to a specified address.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePost-event debriefs: Summarize attendee feedback from a Google Form\/Google Sheets setup and send a turnaround email.\u003c\/li\u003e\n  \u003cli\u003eProduct or experience improvements: Identify constructive suggestions per question and share them with your team.\u003c\/li\u003e\n  \u003cli\u003eSaaS ops reporting: Create consistent, repeatable feedback summaries without manual copy-pasting into docs.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers: Use as a clear reference workflow combining \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n nodes \u0026amp; integrations)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (retrieve event form responses)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregate\u003c\/strong\u003e (combine responses into per-question arrays)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e (GPT-4 analysis with a system prompt for sentiment + recommendations)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarkdown\u003c\/strong\u003e (Markdown → HTML)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (send HTML-formatted email)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e (workflow guidance\/annotations)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764338974899,"sku":"N8N-2164","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/l3Dzy8tafc0DHvt6I53ws_EuyX4EJa.png?v=1786007827","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-summarize-google-sheets-form-feedback-with-openai-gpt-4","provider":"N8N Commerce","version":"1.0","type":"link"}