Block 1 - When clicking ‘Execute workflow’
- Type / Role
- n8n-nodes-base.manualTrigger - manualTrigger
- Config choices
- Version 1
Sync open Zendesk tickets to Google Sheets with Zendesk and Google Sheets
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
Description: Stay on top of your support pipeline with this Ticket Status Digest automation for Zendesk. Built in n8n, this workflow automatically fetches tickets from Zendesk, filters only open on...
Best for
- Content Creation automation workflows
- Ticket Management automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.manualtrigger, n8n-nodes-base.stickynote, n8n-nodes-base.set, n8n-nodes-base.if, n8n-nodes-base.googlesheets, n8n-nodes-base.code, n8n-nodes-base.slack, n8n-nodes-base.zendesk
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Rahul Joshi.
Original n8n.io source1.1 Workflow description
- Title
- Sync open Zendesk tickets to Google Sheets with Zendesk and Google Sheets
- Workflow name
- Sync open Zendesk tickets to Google Sheets with Zendesk and Google Sheets
Description:
Stay on top of your support pipeline with this Ticket Status Digest automation for Zendesk. Built in n8n, this workflow automatically fetches tickets from Zendesk, filters only open ones, enriches them with requester details, and saves them into Google Sheets. 📊
Instead of manually checking Zendesk, you get a real-time digest of pending tickets with full customer details—perfect for support leads who need a quick snapshot of unresolved cases. Whether you’re tracking team workload, prioritizing open issues, or preparing daily status reports, this automation ensures your support data is always structured, centralized, and up to date. 🚀
What This Template Does (Step-by-Step)
🔔 Trigger – Manual Start (or Schedule)
- Begin workflow with a manual trigger (ideal for testing).
- Can be switched to scheduled runs (daily, hourly) for automated digests. 🎫 Fetch All Tickets (Zendesk)
- Pulls all tickets from Zendesk API.
- Captures ticket ID, subject, description, status, priority, tags, and timestamps. 🔍 Filter Open Tickets Only
- Includes only tickets where status = open.
- Skips closed, solved, or pending tickets. 👤 User Information Enrichment
- Looks up requester details (name, email, organization).
- Converts raw IDs into human-readable contact info. 📊 Save to Google Sheets
- Appends/updates ticket rows in “Ticket status dummy → Sheet1”.
- Columns: Ticket No. | Description | Status | Owner | Email | Tag.
Required Integrations:
- Zendesk API (OAuth or API Key)
- Google Sheets (OAuth2 credentials)
Best For:
🧑💼 Support leads monitoring unresolved tickets 📈 Managers building daily ticket status dashboards 🤝 Teams that need centralized visibility of customer issues ⏱️ Anyone tired of manual Zendesk data exports
Key Benefits:
✅ Automated ticket sync to Google Sheets ✅ Real-time visibility of open issues ✅ Centralized view with enriched requester details ✅ Reduces manual tracking and reporting ✅ Scalable for daily, weekly, or custom digest runs
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Sticky Note - Enhanced Overview
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 3 - Sticky Note - Data Fetching
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 4 - Sticky Note - User Details
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 5 - Sticky Note - Enrichment
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 6 - Enrich with Calculated Fields
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 7 - Sticky Note - Alert Logic
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 8 - Check for Priority Alerts
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 9 - Sticky Note - Main Sheet
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 10 - Save to Google Sheets - Main Data
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.6
Block 11 - Sticky Note - Statistics
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 12 - Calculate Summary Statistics
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 13 - Sticky Note - Dashboard
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 14 - Update Dashboard Sheet
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.6
Block 15 - Sticky Note - Slack Alerts
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 16 - Format Slack Message
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 17 - Send Slack Alert
- Type / Role
- n8n-nodes-base.slack - slack
- Config choices
- Version 2.2
Block 18 - Sticky Note - Scheduling
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 19 - Sticky Note - Error Handling
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 20 - Fetch All Zendesk Tickets1
- Type / Role
- n8n-nodes-base.zendesk - zendesk
- Config choices
- Version 1
Block 21 - Sticky Note - Filter Logic1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 22 - Filter Open Tickets Only1
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 23 - Get Ticket Requester Details1
- Type / Role
- n8n-nodes-base.zendesk - zendesk
- Config choices
- Version 1
3. Summary Table
| Workflow | Sync open Zendesk tickets to Google Sheets with Zendesk and Google Sheets |
|---|---|
| Complexity | advanced |
| Nodes | 23 |
| Categories | Content Creation, Ticket Management |
| Author | Rahul Joshi |
| Published | 19 Sept 2025 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/8745/8745.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Sync open Zendesk tickets to Google Sheets with Zendesk and Google Sheets do?
Description: Stay on top of your support pipeline with this Ticket Status Digest automation for Zendesk. Built in n8n, this workflow automatically fetches tickets from Zendesk, filters only open on...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Ticket Management use case.