AI/ML
n8n Workflow Guide: Customer Feedback Automation
Overview
n8n detects resolved tickets in Zendesk, sends a Google Forms survey link via Gmail and logs responses.
Prerequisites
- n8n installed.
- Zendesk account with API access.
- Google Forms with webhook support.
- Gmail account with API key.
Workflow Setup
1. Prepare n8n Environment
Navigate to http://localhost:5678 (or your n8n URL) and log in with your credentials. In the sidebar, click “Workflows,” then select “+ New” and name it (e.g., “Feedback Collection”). Click “+” on the canvas to open the node selector.
2. Trigger Node: Zendesk
- Node: Zendesk
- Settings:
- Credentials: Zendesk API token
- Resource: Ticket
- Operation: Get Many
- Query: status:solved updated<1hour
Output: Recently resolved tickets (e.g., {{ $json.tickets[0].id }}).
3. Send Survey Node: Gmail
Node: Gmail
Settings:
- To: {{ $node["Zendesk"].json.tickets[0].requester.email }}
- Subject: How Did We Do?
- Body: Please share your feedback on ticket #{{ $node["Zendesk"].json.tickets[0].id }}: <Google Form link>
Output: Survey email sent.
4. Collect Response Node: Webhook
Node: Webhook
Settings:
- Path: feedback-response
- Google Forms Webhook: https://<n8n-host>/webhook/feedback-response
Output: Feedback data (e.g., {{ $json.body.form_response.answers[0].text }}).
5. Log Feedback Node: Google Sheets
Node: Google Sheets
Settings:
- Operation: Append
- Spreadsheet ID: Feedback sheet
- Range: A:B
- Values: {{ [$node["Webhook"].json.body.form_response.answers[0].text, $node["Webhook"].json.body.form_response.submitted_at] }}
Output: Feedback logged.
Workflow Summary
- Flow: Zendesk → Gmail → Webhook → Google Sheets.
- Execution: ~10 seconds per ticket.
Benefits
- Saves ~15 minutes/ticket on feedback.
- Provides insights for improvement.
- Enhances customer engagement.
Troubleshooting
- Zendesk Error: Verify query syntax.
- Webhook Fail: Check Google Forms URL.
Ready to transform your business with our technology solutions? Contact Us today to Leverage Our AI/ML Expertise.
Comment