Zendesk pending ticket follow-up system with Gmail, Google Sheets & ClickUp
Needs changesWhat this workflow does
This workflow has 8 nodes and runs on a schedule (legacy Cron node). Along the way it connects Zendesk, Google Sheets, ClickUp and Gmail.
How it runs
Trigger: On a schedule (legacy Cron node).
- Get Pending Tickets (Zendesk): get many
- Filter Pending Tickets (If): checks a condition and branches into true / false
- Format Ticket Data (Code): runs custom JavaScript code
- Log to Google Sheets (Google Sheets): append or update
- Generate Follow-up Emails (Code): runs custom JavaScript code
- Create ClickUp Task (ClickUp): uses ClickUp
- Send Follow-up Email (Gmail): work with message
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Schedule Trigger: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Schedule Trigger | Schedule Trigger |
Nodes used (7)
- Cron
n8n-nodes-base.cron - Zendesk
n8n-nodes-base.zendesk - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - ClickUp
n8n-nodes-base.clickUp - Gmail
n8n-nodes-base.gmail
From the author
Description Automate Zendesk ticket follow-up management by fetching pending tickets daily, enriching and logging them into Google Sheets, creating ClickUp tasks for team reminders, and sending professional follow-up emails to customers. Keeps your support…