Sync Zendesk how-to tickets to Google Sheets knowledge base
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Zendesk and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Fetch All Zendesk Tickets (Zendesk): get many
- Format Error Details (Code): runs custom JavaScript code
- Filter HowTo Tickets Only (If): checks a condition and branches into true / false
- Log Error to Sheet (Google Sheets): append
- Get Requester User Info (Zendesk): get (user)
- Send Error Notification (Send Email): sends an email over SMTP
- Update Knowledge Base Sheet (Google Sheets): append or update
- Success Summary (Code): runs custom JavaScript code
- Log Successful Execution (Google Sheets): append
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Error Trigger
n8n-nodes-base.errorTrigger - If
n8n-nodes-base.if - Zendesk
n8n-nodes-base.zendesk - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend
From the author
Description: Keep your customer knowledge base up to date with this n8n automation template. The workflow connects Zendesk with Google Sheets, automatically fetching tickets tagged as “howto,” enriching them with requester details, and saving them into a…