Templates / Sync Zendesk how-to tickets to Google Sheets knowledge base

Sync Zendesk how-to tickets to Google Sheets knowledge base

Ready for 3.0

by Rahul Joshi ✓ · 205 views · created 2025-09-22 · Document Extraction

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Fetch All Zendesk Tickets (Zendesk): get many
  2. Format Error Details (Code): runs custom JavaScript code
  3. Filter HowTo Tickets Only (If): checks a condition and branches into true / false
  4. Log Error to Sheet (Google Sheets): append
  5. Get Requester User Info (Zendesk): get (user)
  6. Send Error Notification (Send Email): sends an email over SMTP
  7. Update Knowledge Base Sheet (Google Sheets): append or update
  8. Success Summary (Code): runs custom JavaScript code
  9. Log Successful Execution (Google Sheets): append

Services it uses

ZendeskGoogle Sheets

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)

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…

Excerpt from Rahul Joshi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.