Freshdesk CSAT Automation with Google Sheets

Want to send post-ticket surveys automatically — without juggling tools?

This automation tracks resolved tickets in Freshdesk and instantly sends out a personalized survey email when the moment’s right. No duplicates. No manual work. Just clean, centralized feedback delivered straight to your Google Sheet — ready to trigger alerts or reports.

What it does:

📨 Monitors Freshdesk tickets on a schedule or manual trigger
📋 Checks for new ticket resolutions (status ID 4 = "Resolved")
📌 Prevents duplicate emails with built-in tracking via Google Sheets
📧 Sends personalized survey emails using ticket data
🧾 Converts Markdown to HTML for branded, clean formatting
📊 Logs all responses in a Google Sheet for easy analysis
🚨 Optionally triggers Slack alerts for low scores

✅ Setup guide & importable automation included
🎯 Built for CS teams, ops leads & automation-first workflows

Need help setting it up? We offer full configuration and testing for a one-time fee.