

Running customer support can feel like juggling flaming torches - especially when you're trying to figure out which customers are happy and which ones are about to explode. But you don't have to read every single ticket to understand how your customers feel.
This guide shows you how to use Latenode and ChatGPT to automatically analyze the mood of your Zendesk tickets and organize everything in a Google Sheet. It's like having a mind reader on your support team!
You sure can! But forget about copying and pasting tickets into ChatGPT's website - that would take forever. Instead, we'll use Latenode to create an automation that connects Zendesk, ChatGPT, and Google Sheets. Everything happens automatically in the background while you focus on actually helping customers.
Here's what you'll need to get started:
Ready? Let's build this thing:
When it activates, it captures all the key information - the ticket ID, the client's email, the text of the message itself - and organizes it into a JSON structure for us. This JSON format makes it easy to move this data from one step to the next within our automated process, ensuring it flows smoothly whether it's heading for analysis by ChatGPT or being recorded directly into Google Sheets.
Open the AI GPT Router integration, which allows you to use ChatGPT. Choose from 100+ models, or stay with the default option - GPT-4.1 Nano.
Write a prompt for analysis of the new Zendesk tickets to classify sentiments however you want - maybe happy," "neutral," or "angry," or even more specific categories that make sense for your business. You can also stay with the sample instructions:
You will receive a message from a customer support ticket.
Please sort it into one of these four categories:
Happy, Frustrated, Mad, or Neutral.
Respond with just one word — exactly as listed above. Do not include any punctuation or extra text.
Here is the ticket message:
[JSON output from the Zendesk Node output]
Every time a new ticket lands in your chosen Zendesk view, your automation wakes up. ChatGPT reads the ticket and figures out the customer's mood. All the details get neatly recorded in your Google Sheet. No more guessing games about customer satisfaction - you'll have real data flowing in automatically!
This automation transforms your support team into sentiment analysis pros without any extra work. You'll save hours of manual review time and actually know which customers need immediate attention. Plus, once everything's in Google Sheets, you can create charts, set up alerts for angry customers, or spot trends that help improve your service.
Want to dive deeper into specific settings? Check out Latenode's official documentation for all the nitty-gritty details about connecting accounts and tweaking your nodes.