FM
FlowMarket
Email & Outreach Intermediate ⚑ 10 n8n Nodes

Extract marketing testimonials from feedback with Gemini AI and

Extract Marketing Testimonials from Feedback with Gemini AI and Google Sheets 🌍 Overview This workflow automatically extracts short emotional testimonials f...

πŸ”Œ Nodes & Integrations Used (5)

Google Sheets Trigger Chain Llm Lm Chat Google Gemini Google Sheets Gmail

πŸ“– Implementation & Setup Guide

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

---

⚑ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Extract_marketing_testimonials_from_feedback_with_Gemini_AI_and.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Email & Outreach Workflows

View All in Email & Outreach β†’