Skip to main content

Extract marketing testimonials from feedback with Gemini AI and Google Sheets

Workflow preview

Extract marketing testimonials from feedback with Gemini AI and Google Sheets preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

Extract Marketing Testimonials from Feedback with Gemini AI and Google Sheets

🌍 Overview

This workflow automatically extracts short emotional testimonials from Google Form responses. It listens for new feedback in Google Sheets, processes it with AI (Google Gemini), writes back a refined testimonial, and sends an email notification.

Think of it as your testimonial assistantβ€”turning raw customer feedback into marketing-ready quotes.


🟒 Section 1: Trigger – Listen for New Feedback

πŸ”— Nodes:

  • Google Sheets Trigger β†’ Watches for new rows (new form responses).

πŸ’‘ Beginner takeaway: Whenever a customer submits feedback via your form, this trigger wakes up the workflow.

πŸ“ˆ Advantage: No manual checking β€” feedback is instantly processed.


🟦 Section 2: Testimonial Extraction with AI

πŸ”— Nodes:

  • Basic LLM Chain β†’ Runs a custom prompt that tells the AI: β€œExtract a short, emotional testimonial quote from the feedback.”
  • Google Gemini Chat Model β†’ The AI brain that processes and rewrites the testimonial.

πŸ’‘ Beginner takeaway: This part filters out neutral or boring text and produces a catchy, emotional testimonial.

πŸ“ˆ Advantage: Saves you time editing feedback β†’ instantly produces marketing-ready quotes.


🟣 Section 3: Store & Notify

πŸ”— Nodes:

  • Google Sheets (Write Back) β†’ Saves the extracted testimonial into the same Google Sheet.
  • Gmail β†’ Sends an email with the new testimonial to your chosen inbox.

πŸ’‘ Beginner takeaway: The testimonial is both saved for records and shared with your team via email.

πŸ“ˆ Advantage: You get real-time alerts and maintain a growing database of testimonials.


πŸ“Š Final Overview Table

Section Nodes Purpose Benefit
🟒 Trigger Google Sheets Trigger Detect new feedback Automated start
🟦 AI Extraction LLM Chain + Gemini Extract emotional testimonial Marketing-ready quotes
🟣 Store & Notify Google Sheets + Gmail Save + send testimonial Organized + instant alerts

πŸš€ Why This Workflow is Useful

  • Automates testimonial creation β†’ No manual copywriting needed
  • Captures emotions β†’ AI filters for impactful quotes
  • Centralized storage β†’ All testimonials logged in Google Sheets
  • Instant notifications β†’ New testimonials delivered straight to email
  • Beginner-friendly β†’ Just connect your sheet + Gmail and it runs on its own