Extract Marketing Testimonials from Feedback with Gemini AI & Sheets

This n8n workflow transforms raw customer feedback into ready-to-use marketing testimonials. It monitors a Google Sheet linked to feedback forms every minute for new entries. Gemini AI then analyzes the feedback to identify emotionally engaging phrases, extract short quotable testimonials, and filter out irrelevant content, preserving the authentic customer voice.

Extracted testimonials are automatically appended to a dedicated 'Testimony' column in the same or another Google Sheet, building a searchable database for marketing campaigns. An email notification is sent instantly to the team with the new testimonial, ensuring quick utilization of social proof.

Ideal for businesses collecting feedback via Google Forms, this workflow saves hours of manual review, boosts marketing efficiency, and scales with growing feedback volume. Use cases include e-commerce reviews, SaaS user feedback, service industry surveys, and any scenario needing customer quotes for ads, websites, or social media.