{"product_id":"n8n-review-intelligence-workflow-openai-gmail-sheets","title":"n8n Review Intelligence Workflow: OpenAI + Gmail + Sheets","description":"\u003ch3\u003eTurn customer reviews into ready-to-post marketing content—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Review Intelligence Workflow: OpenAI + Gmail + Sheets\u003c\/strong\u003e captures a customer review via an n8n Form, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to analyze and score it, and then either generates a \u003cstrong\u003e7-piece content pack\u003c\/strong\u003e emailed to you—or sends a short “below threshold” note—while logging everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects the review\u003c\/strong\u003e through an \u003cstrong\u003en8n Form\u003c\/strong\u003e (review text, reviewer details, and your business info).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts “review intelligence” with OpenAI\u003c\/strong\u003e, including structured insights such as tone, transformation, best quote, and credibility signals—then assigns a \u003cstrong\u003econtent opportunity score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes based on a threshold\u003c\/strong\u003e: if the score is \u003cstrong\u003e7+\u003c\/strong\u003e, it proceeds with content generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a 7-piece content pack\u003c\/strong\u003e using OpenAI, including:\n    \u003cul\u003e\n      \u003cli\u003eLinkedIn long post\u003c\/li\u003e\n      \u003cli\u003eLinkedIn short post\u003c\/li\u003e\n      \u003cli\u003eX post\u003c\/li\u003e\n      \u003cli\u003eWebsite testimonial\u003c\/li\u003e\n      \u003cli\u003eNewsletter feature\u003c\/li\u003e\n      \u003cli\u003eThank-you email\u003c\/li\u003e\n      \u003cli\u003eCase study invite\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every submission to Google Sheets\u003c\/strong\u003e (tab: \u003cstrong\u003eReview Content Log\u003c\/strong\u003e), appending the key fields and whether content was generated.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the results via Gmail\u003c\/strong\u003e to your configured recipient:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eHigh-scoring (7+)\u003c\/strong\u003e: sends the full compiled content package.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eBelow-threshold\u003c\/strong\u003e: logs “not generated” and emails brief guidance on improving the testimonial.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically repurpose customer feedback into \u003cstrong\u003eSaaS marketing assets\u003c\/strong\u003e without manual rewriting.\u003c\/li\u003e\n  \u003cli\u003ePrioritize only high-quality reviews using an \u003cstrong\u003eOpenAI scoring threshold\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eMaintain an audit-friendly review history in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for reporting and iteration.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: used for both review analysis (“review intelligence”) and content generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Form\u003c\/strong\u003e: review intake trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: writes to the \u003cstrong\u003eReview Content Log\u003c\/strong\u003e tab (requires OAuth2 + headers).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends the generated pack or below-threshold note.\u003c\/li\u003e\n  \u003cli\u003eControl flow nodes include \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003ecode\u003c\/strong\u003e (plus supporting nodes such as sticky note).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081371537587,"sku":"N8N-19893","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RmNf6TX7zxnRudaZxyqKf_PlB2yY8m.png?v=1790240518","url":"https:\/\/buyflowscripts.com\/products\/n8n-review-intelligence-workflow-openai-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}