Track support performance metrics across Zendesk & Freshdesk with Sheets, Slack & Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 12 nodes and runs on a schedule (legacy Cron node). Along the way it connects Slack, Gmail, Zendesk and Google Sheets and 1 more.
How it runs
Trigger: On a schedule (legacy Cron node).
- Fetch Tickets From Zendesk (Zendesk): get many
- Fetch Tickets From Freshdesk (Freshdesk): get many
- Merge: merges the data from its input branches
- Format Ticket Data (Zendesk & Freshdesk) (Code): runs custom JavaScript code
- Log KPIs in Google Sheets (Google Sheets): append or update
- Calculate Support KPIs (Code): runs custom JavaScript code
- Evaluate Alerts (If): checks a condition and branches into true / false
- Generate Slack Alert Message (Code): runs custom JavaScript code
- Generate Weekly HTML Report (Code): runs custom JavaScript code
- Send Slack Alert (Slack): uses Slack
…plus 1 more step. See the full node list below.
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 Weekly Trigger: replace with Schedule Trigger.
| Removed in 3.0 | Replace with |
|---|---|
| Cron Weekly Trigger | Schedule Trigger |
Nodes used (9)
- Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Cron
n8n-nodes-base.cron - Zendesk
n8n-nodes-base.zendesk - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Freshdesk
n8n-nodes-base.freshdesk
From the author
Description Automatically consolidate Zendesk and Freshdesk ticket data into a unified performance dashboard with KPI calculations, Google Sheets logging, real-time Slack alerts, and weekly Gmail email reports. Provides complete visibility into support…