Process testimonials with GPT-4 & auto-generate social media cards with Google Sheets

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