AI Testimonial Extractor: Agent Feedback to Marketing Gold

This n8n workflow automates the process of extracting valuable testimonials from customer feedback and prepares them for marketing use. It listens for new feedback entries in a Google Sheet, processes them with an AI model to identify testimonial-worthy content, and then writes the extracted testimonials back to another Google Sheet, while also notifying a marketing team via Gmail.

What it does

1. Monitors Google Sheet for New Feedback: The workflow is triggered whenever a new row is added to a specified Google Sheet, which is assumed to contain customer feedback or agent performance reviews.
2. Extracts Testimonials using AI: It sends the new feedback entry to a Google Gemini Chat Model via a Basic LLM Chain, which is configured to identify and extract positive, marketing-ready testimonials.
3. Records Extracted Testimonials: The AI-generated testimonial is then written to a designated "Testimonials" Google Sheet, making it readily available for marketing teams.
4. Notifies Marketing Team: An email notification is sent to a specified marketing email address via Gmail, informing them about the new testimonial and its content.

Prerequisites/Requirements

• n8n Instance: A running n8n instance (cloud or self-hosted).
• Google Account: A Google account with access to Google Sheets and Gmail.
  • Google Sheets Credentials: Configured n8n credentials for Google Sheets (OAuth 2.0 recommended).
  • Gmail Credentials: Configured n8n credentials for Gmail (OAuth 2.0 recommended).
• Google Gemini API Key: Access to the Google Gemini API, configured within the "Google Gemini Chat Model" node.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Google Sheets Trigger:
   • Open the "Google Sheets Trigger" node.
   • Select your Google Sheets credential.
   • Specify the "Spreadsheet ID" and "Sheet Name" where your raw customer feedback is entered.
   • Choose the "On New Row" trigger event.
   • Activate the workflow.
3. Configure Basic LLM Chain:
   • Open the "Basic LLM Chain" node.
   • Ensure the "Google Gemini Chat Model" is correctly linked.
   • Review and adjust the prompt if necessary to fine-tune testimonial extraction.
4. Configure Google Gemini Chat Model:
   • Open the "Google Gemini Chat Model" node.
   • Select your Google Gemini API key credential.
   • No further configuration is typically needed here unless you want to adjust model parameters (e.g., temperature).
5. Configure Google Sheets (Write Testimonials):
   • Open the "Google Sheets" node.
   • Select your Google Sheets credential.
   • Specify the "Spreadsheet ID" and "Sheet Name" where you want to store the extracted testimonials.
   • Ensure the "Operation" is set to "Append Row" or "Add Row".
   • Map the output of the "Basic LLM Chain" node to the appropriate column(s) in your testimonials sheet. For example, if the LLM outputs testimonialText, you would map that to a column like Testimonial.
6. Configure Gmail:
   • Open the "Gmail" node.
   • Select your Gmail credential.
   • Enter the "To" email address for your marketing team.
   • Customize the "Subject" and "Body" of the email to include the extracted testimonial. You can use expressions like {{ $json.testimonialText }} to dynamically insert the testimonial content.
7. Activate the Workflow: Once all nodes are configured, activate the workflow. It will now automatically process new feedback entries in your specified Google Sheet.