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

🚀 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