Automate CSAT Surveys: Freshdesk to Google Sheets

This n8n workflow automates the process of sending Customer Satisfaction (CSAT) surveys immediately after a Freshdesk ticket is marked as 'Resolved'. It triggers on a schedule, fetches recent tickets from Freshdesk, checks against a Google Sheet to prevent duplicate surveys, and sends personalized HTML emails with survey links. Responses are captured via a form trigger and logged directly into the same Google Sheet, enabling quick analysis, reporting, and follow-up actions like Slack alerts for low scores.

Key benefits include timely feedback collection while experiences are fresh, centralized data storage without manual entry, scalability for high-volume support teams, and no-code setup for ops and CS leaders. It eliminates manual survey management, reduces oversights, and provides actionable insights to improve customer service.

Ideal for customer support teams using Freshdesk, businesses seeking feedback loops, and automation enthusiasts. Use cases: Track satisfaction trends, escalate poor scores, generate reports, or integrate with other tools for advanced workflows. Built with duplicate prevention, personalization, and seamless Freshdesk-Google Sheets integration.