Automate CSAT surveys with Freshdesk & store responses in Google Sheets
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on a schedule (every hour) (plus 2 other triggers). Along the way it connects Freshdesk and Google Sheets.
How it runs
Trigger: On a schedule (every hour) (plus 2 other triggers).
- Set your data (Edit Fields (Set)): sets 5 fields: your name, Your email, your company name…
- Save survey to google sheet (Google Sheets): append
- get existing tickets (Google Sheets): uses Google Sheets
- get tickets (Freshdesk): get many
- If: checks a condition and branches into true / false
- Updates status (Google Sheets): append or update
- get client (Freshdesk): get (contact)
- Create the email text (Edit Fields (Set)): sets 2 fields: subject, body
- Convert the email text to HTML (Markdown): converts between Markdown and HTML
- Send Email: sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - If
n8n-nodes-base.if - Send Email
n8n-nodes-base.emailSend - Freshdesk
n8n-nodes-base.freshdesk - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - n8n Form Trigger
n8n-nodes-base.formTrigger - Markdown
n8n-nodes-base.markdown
From the author
Never forget to send a satisfaction survey again! This workflow helps you automatically send CSAT surveys when a Freshdesk ticket is marked “Resolved” – and logs every response in Google Sheets for easy analysis, reporting, and escalation workflows. 💡 Built…