Get Started
Back to Templates

Process Testimonials with GPT-4 & Auto-Generate Social Media Cards with Google Sheets

Created by

Created by: Jitesh Dugar || jiteshdugar

Jitesh Dugar

Last update

Last update 14 hours ago

Categories

Share

Automated AI-Powered Testimonial Processing & Social Media Workflow

Overview:

This comprehensive workflow automates the entire testimonial collection and publishing process, from submission to social media-ready content. It uses AI to enhance testimonials, generates beautiful branded cards, and implements an approval system before posting.

Key Features:

  • ✅ Webhook-based submission - Accept testimonials via API
  • 🤖 AI Enhancement - GPT-4 polishes grammar while maintaining authenticity
  • 🎨 Automated Design - Generates professional 800x600px testimonial cards
  • ☁️ Cloud Storage - Uploads to Google Drive with organized naming
  • 📊 Database Logging - Tracks all testimonials in Google Sheets
  • 🔔 Team Notifications - Slack alerts for new and approved testimonials
  • ✅ Approval Workflow - Manual review before social media posting
  • 🔄 Scheduled Checker - Auto-detects approved testimonials every 5 minutes

Workflow Steps:

Main Flow (Testimonial Processing):

  1. Receives testimonial via webhook (POST request)
  2. Validates and cleans data (name, testimonial, photo, email)
  3. Enhances testimonial using GPT-4 Turbo
  4. Generates HTML template with customer details
  5. Converts HTML to PNG image (800x600px)
  6. Uploads image to Google Drive
  7. Logs all data to Google Sheets with "Pending Approval" status
  8. Sends Slack notification to review team

Approval Flow (Scheduled Check):

  1. Runs every 5 minutes automatically
  2. Checks Google Sheets for approved testimonials
  3. Filters testimonials not yet posted
  4. Sends ready-to-post Slack notification with formatted text
  5. Marks testimonial as processed in database

Use Cases:

  • SaaS companies collecting customer feedback
  • Marketing agencies managing client testimonials
  • E-commerce businesses showcasing reviews
  • Course creators featuring student success stories
  • Any business automating social proof collection

What Makes This Workflow Special:

  • Zero manual design work - Beautiful cards generated automatically
  • AI-powered quality - Professional grammar enhancement
  • Audit trail - Complete tracking in Google Sheets
  • Approval control - Review before publishing
  • Duplicate prevention - Smart matching by Drive ID
  • Flexible input - Accepts multiple field name variations

🔧 Required Integrations:

  1. OpenAI API (GPT-4 Turbo) - AI testimonial enhancement
  2. HTML/CSS to Image API - Screenshot generation
  3. Google Drive OAuth2 - Image storage
  4. Google Sheets OAuth2 - Database management
  5. Slack API - Team notifications

📋 Prerequisites:

🚀 Setup Instructions:

1. Import Workflow

  • Download the JSON file
  • Import into your n8n instance
  • Replace placeholder credentials (see below)

2. Configure Credentials

Add these credentials in n8n:

  • OpenAI API - Your API key
  • htmlcsstoimgApi - User ID and API key
  • Google Drive OAuth2 - Configure OAuth app
  • Google Sheets OAuth2 - Same Google Cloud project
  • Slack API - Create Slack app with chat:write scope

3. Update Configuration

Replace in the JSON:

  • Google Drive Folder ID - Your testimonial storage folder
  • Google Sheets ID - Your database spreadsheet
  • Slack Channel ID - Your notification channel

4. Test the Workflow

Send a POST request to your webhook URL:

{
    "name": "Sarah Johnson",
    "designation": "Marketing Director",
    "photo_url": "https://i.pravatar.cc/400?img=5",
    "testimonial_text": "Working with this team was amazing!",
    "email": "[email protected]"
}

📊 Google Sheets Setup:

Create a Google Sheet with these columns:

  • Timestamp
  • Name
  • Designation
  • Original Testimonial
  • Testimonial (Enhanced)
  • Image Link
  • Drive ID
  • Status
  • Email
  • Original Length
  • Enhanced
  • Source
  • Posted to Social
  • Posted At

🎨 Customization Options:

  • Modify AI prompt for different enhancement styles
  • Change HTML template colors/design
  • Add more validation rules
  • Integrate with Twitter/LinkedIn APIs for auto-posting
  • Add email notifications instead of Slack
  • Include rating/score system
  • Add custom approval fields

🆘 Troubleshooting:

Webhook not receiving data:

  • Check webhook URL is correct
  • Verify HTTP method is POST
  • Ensure Content-Type is application/json

AI enhancement failing:

  • Verify OpenAI API key is valid
  • Check API usage limits
  • Ensure sufficient credits

Image not generating:

  • Confirm htmlcsstoimg credentials are correct
  • Check HTML template has no errors
  • Verify you haven't exceeded free tier limit

Google Drive upload failing:

  • Re-authenticate OAuth2 connection
  • Check folder ID is correct
  • Verify folder permissions

🏆 Perfect For:

  • Marketing teams
  • Customer success teams
  • Product managers
  • Social media managers
  • Growth hackers
  • Agency owners

⚖️ License:

Free to use and modify for personal and commercial projects.