# Extract emotional quotes from Google Form feedback and send via email
This automation turns raw user feedback into powerful marketing assets without manual processing. Every new response in Google Forms is instantly analyzed by Google Gemini, which extracts a short, emotionally compelling quote—perfect for ads, social media, or websites. Designed for teams that collect feedback systematically and want to leverage it as social proof.
## Who it´s for
- Marketers collecting testimonials for advertising
- Product owners implementing social proof collection
- SaaS companies with feedback forms
- Customer experience managers automating feedback processing
## What the automation does
- Triggers on new row addition in Google Sheets (form response)
- Sends feedback text to Google Gemini via LangChain for analysis
- Extracts a concise, emotionally strong quote from the text
- Writes the quote into a dedicated column in the sheet
- Sends a notification with the quote to the marketing team’s email
- Accumulates approved quotes in a central table for reuse
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on new Google Sheets rows
- Integrations with Google Sheets, Gmail, Google Gemini API, and LangChain
- Basic text guide for setup and adaptation
## Requirements for setup
- n8n account (cloud or self-hosted)
- Access to a Google Sheet linked to a feedback form
- Google Cloud project with Gemini API access enabled
- Configured OAuth credentials for Google Sheets and Gmail
- Email account with sending permissions via Gmail API
## Benefits and outcomes
- Saves hours previously spent manually scanning feedback
- Improves marketing content quality using authentic customer emotions
- Continuous stream of fresh quotes for campaigns and social media
- Centralized storage of best testimonials in one spreadsheet
- Faster response to positive feedback — quotes go straight to marketers
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet