{"product_id":"n8n-feedback-form-to-google-sheets-gemini-reports-via-gmail","title":"n8n Feedback Form to Google Sheets + Gemini Reports via Gmail","description":"\u003ch3\u003eTurn every customer feedback into Google Sheets records, instant low-rating alerts, and AI-powered Gemini trend reports\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures feedback from a form, saves every response to Google Sheets exactly as submitted, automatically flags low ratings (≤ your threshold) for immediate action, and uses Google Gemini to generate weekly or monthly trend reports packed with real quotes—delivered by Gmail to your inbox.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives new feedback:\u003c\/strong\u003e When the n8n feedback form is submitted, the workflow normalizes the answers (including the submitted date and week) and appends a new row to your selected Google Sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects low ratings:\u003c\/strong\u003e It compares the submitted rating to your configured threshold. For ratings at or below \u003cstrong\u003e2 (or your configured threshold)\u003c\/strong\u003e, it drafts a short suggested reply using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an urgent email:\u003c\/strong\u003e A high-priority \u003cstrong\u003eGmail\u003c\/strong\u003e message is sent to the business owner with the customer’s contact details, the full feedback, the suggested reply, and a link to the Google Sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates trend reports daily:\u003c\/strong\u003e On a schedule, it decides whether to produce a \u003cstrong\u003eweekly report (Mondays)\u003c\/strong\u003e or a \u003cstrong\u003emonthly report (1st of the month)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional on-demand reporting:\u003c\/strong\u003e An optional “\u003cstrong\u003eGet Report Now\u003c\/strong\u003e” request generates a report for a user-selected period (last 7 days, last 30 days, this month, or all time).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes feedback from Sheets:\u003c\/strong\u003e It reads the feedback rows, calculates response counts and rating stats for the chosen period, and compiles anonymized response text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini-powered insights:\u003c\/strong\u003e Gemini extracts \u003cstrong\u003ethemes\u003c\/strong\u003e, pulls \u003cstrong\u003ereal customer quotes\u003c\/strong\u003e, and recommends \u003cstrong\u003ethree actions\u003c\/strong\u003e, then sends the report as an HTML email via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCustomer feedback tracking for SaaS teams that want structured reporting in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFast recovery workflows for unhappy customers using \u003cstrong\u003eGmail\u003c\/strong\u003e alerts and AI-generated replies.\u003c\/li\u003e\n  \u003cli\u003eWeekly\/monthly Voice-of-Customer summaries with \u003cstrong\u003eGemini\u003c\/strong\u003e trend analysis.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and a form \u003cstrong\u003etrigger\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as the data store and reporting source\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for suggested replies and AI-generated HTML reports\u003c\/li\u003e\n  \u003cli\u003eReports are sent via \u003cstrong\u003eGmail\u003c\/strong\u003e on daily scheduling with weekly\/monthly logic\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSEO keywords:\u003c\/strong\u003e n8n feedback form, Google Sheets automation, Gmail alerts, Google Gemini reports, customer feedback workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146322923699,"sku":"N8N-20248","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/I4JeVSFst-mqeuUMLT3va_X9LXn6bO.png?v=1790846006","url":"https:\/\/buyflowscripts.com\/products\/n8n-feedback-form-to-google-sheets-gemini-reports-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}