n8n Review Intelligence Workflow: OpenAI + Gmail + Sheets

Turn customer reviews into ready-to-post marketing content—automatically

This n8n Review Intelligence Workflow: OpenAI + Gmail + Sheets captures a customer review via an n8n Form, uses OpenAI to analyze and score it, and then either generates a 7-piece content pack emailed to you—or sends a short “below threshold” note—while logging everything in Google Sheets.

What this workflow does

• Collects the review through an n8n Form (review text, reviewer details, and your business info).
• Extracts “review intelligence” with OpenAI, including structured insights such as tone, transformation, best quote, and credibility signals—then assigns a content opportunity score.
• Routes based on a threshold: if the score is 7+, it proceeds with content generation.
• Generates a 7-piece content pack using OpenAI, including:
  • LinkedIn long post
  • LinkedIn short post
  • X post
  • Website testimonial
  • Newsletter feature
  • Thank-you email
  • Case study invite
• Logs every submission to Google Sheets (tab: Review Content Log), appending the key fields and whether content was generated.
• Emails the results via Gmail to your configured recipient:
  • High-scoring (7+): sends the full compiled content package.
  • Below-threshold: logs “not generated” and emails brief guidance on improving the testimonial.

Use cases

• Automatically repurpose customer feedback into SaaS marketing assets without manual rewriting.
• Prioritize only high-quality reviews using an OpenAI scoring threshold.
• Maintain an audit-friendly review history in Google Sheets for reporting and iteration.

Technical details

• OpenAI: used for both review analysis (“review intelligence”) and content generation.
• n8n Form: review intake trigger.
• Google Sheets: writes to the Review Content Log tab (requires OAuth2 + headers).
• Gmail: sends the generated pack or below-threshold note.
• Control flow nodes include if, set, and code (plus supporting nodes such as sticky note).