ChatGPT Sentiment Analysis for Zendesk Tickets to Google Sheets

This workflow triggers automatically whenever a new ticket appears in a specified Zendesk view (e.g., view ID 360073022411). It extracts the ticket's description and sends it to OpenAI's ChatGPT with a precise prompt to classify the sentiment into one of four categories: Satisfied, Upset, Angry, or None. The response is strictly formatted to ensure clean data output without extra text.

Next, it compiles key ticket information—including sender name, email, subject, description, sentiment classification, and creation date—and inserts a new row into a designated Google Sheet (spreadsheet ID: 1dA0TgkPENaREpdp2_idW0ooOPR7ORNrdkwuMgf6Axq4, sheet index 0). This creates a centralized log for easy tracking and analysis.

Benefits include real-time customer sentiment monitoring, reducing manual review time, enabling proactive support responses, and providing actionable insights for CS teams. Use cases: Support operations for spotting upset customers early, performance dashboards, trend analysis over time, or integrating with BI tools for deeper reporting. Ideal for Zendesk users seeking AI-powered efficiency without coding.