Skip to main content

Create Zendesk tickets from Gmail and Slack with Google Sheets tracking

Workflow preview

Workflow preview
100%
Create Zendesk tickets from Gmail and Slack with Google Sheets tracking preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Description Automatically convert Gmail emails and Slack messages into Zendesk support tickets with intelligent priority detection, comprehensive Google Sheets tracking, and real time team notifica...

Best for

  • Content Creation automation workflows
  • Support Chatbot automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.slacktrigger, n8n-nodes-base.code, n8n-nodes-base.merge, n8n-nodes-base.zendesk, n8n-nodes-base.if, n8n-nodes-base.slack, n8n-nodes-base.gmailtrigger, n8n-nodes-base.googlesheets

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 source

1.1 Workflow description

Title
Create Zendesk tickets from Gmail and Slack with Google Sheets tracking
Workflow name
Create Zendesk tickets from Gmail and Slack with Google Sheets tracking

Description

Automatically convert Gmail emails and Slack messages into Zendesk support tickets with intelligent priority detection, comprehensive Google Sheets tracking, and real-time team notifications. Streamlines support workflows with zero manual ticket creation. πŸŽ«πŸ“§

What This Template Does

  • Monitors Gmail inbox for unread emails and Slack support channel for new messages. πŸ“₯
  • Normalizes data from both sources with intelligent content processing and HTML cleanup. 🧼
  • Creates structured Zendesk tickets with proper subject lines, descriptions, and priority tagging. 🎫
  • Generates comprehensive tracking logs in Google Sheets with clickable ticket URLs. πŸ“Š
  • Sends formatted Slack notifications for successful ticket creation or error alerts. πŸ“’

Key Benefits

  • Eliminates manual ticket creation with automated processing. ⏱️
  • Unified support workflow across Gmail and Slack channels. πŸ”„
  • Complete audit trail with Google Sheets tracking. 🧾
  • Real-time team notifications with ticket details and direct links. πŸ“²
  • Intelligent priority detection based on "urgent" keywords. 🚨
  • Error handling with detailed failure notifications. πŸ›‘οΈ

Features

  • Gmail polling every minute for unread email detection. πŸ“§
  • Real-time Slack message monitoring in designated support channel. πŸ’¬
  • Smart data normalization with HTML tag removal and urgency detection. 🧠
  • Automatic Zendesk ticket creation with priority-based tagging. 🏷️
  • Google Sheets logging with ticket URLs, timestamps, and metadata. πŸ“ˆ
  • Formatted Slack notifications with emojis and clickable links. ✨
  • Comprehensive error detection and team alerting system. 🚨

Requirements

  • n8n instance (cloud or self-hosted).
  • Gmail OAuth2 credentials in n8n with inbox access permissions.
  • Slack Bot API credentials with channels:history, chat:write, and webhook capabilities.
  • Zendesk API credentials for ticket creation and management.
  • Google Sheets OAuth2 credentials with spreadsheet write permissions.
  • Designated Slack channel for support requests (e.g., "#post-ticket").

Target Audience

  • Customer support teams automating multi-channel ticket creation. 🎧
  • Help desk operations seeking unified request processing. πŸ†˜
  • Small to medium businesses streamlining support workflows. 🏒
  • IT support teams managing internal and external requests. πŸ’»
  • Service organizations requiring comprehensive audit trails. πŸ“‹
  • Remote teams needing automated workflow notifications. 🌐

Step-by-Step Setup Instructions

  • Connect Gmail, Slack, Zendesk, and Google Sheets credentials in n8n. πŸ”‘
  • Configure Slack channel ID for support message monitoring (default: "#post-ticket"). πŸ“±
  • Set up Google Sheets document for ticket tracking and logging. πŸ“Š
  • Import the workflow and assign all required credentials to respective nodes. πŸ“¦
  • Configure Zendesk subdomain in the "Format Sheet Data" node for proper ticket URLs. πŸ”—
  • Test with a sample email or Slack message to validate end-to-end automation. βœ…

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 1 - Slack Trigger

Type / Role
n8n-nodes-base.slackTrigger - slackTrigger
Config choices
Version 1

Block 2 - Normalize Gmail Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 3 - Normalize Slack Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 4 - Merge Channels

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 2.1

Block 5 - Create Zendesk Ticket

Type / Role
n8n-nodes-base.zendesk - zendesk
Config choices
Version 1

Block 6 - Format Sheet Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 7 - Check for Errors

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2

Block 8 - Send Error Notification

Type / Role
n8n-nodes-base.slack - slack
Config choices
Version 2.1

Block 9 - Send Success Notification

Type / Role
n8n-nodes-base.slack - slack
Config choices
Version 2.1

Block 10 - Gmail Trigger

Type / Role
n8n-nodes-base.gmailTrigger - gmailTrigger
Config choices
Version 1

Block 11 - Log to Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4

Block 12 - Sticky Note - Gmail Trigger

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - Sticky Note - Slack Trigger

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 14 - Sticky Note - Gmail Normalize

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 15 - Sticky Note - Slack Normalize

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 16 - Sticky Note - Merge

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 17 - Sticky Note - Zendesk

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 18 - Sticky Note - Format

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 19 - Sticky Note - Sheets

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 20 - Sticky Note - Error Check

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 21 - Sticky Note - Error Notify

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 22 - Sticky Note - Success Notify

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Create Zendesk tickets from Gmail and Slack with Google Sheets tracking
Complexity advanced
Nodes 22
Categories Content Creation, Support Chatbot
Author Rahul Joshi
Published 19 Sept 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/8750/8750.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 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. 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 Create Zendesk tickets from Gmail and Slack with Google Sheets tracking do?

Description Automatically convert Gmail emails and Slack messages into Zendesk support tickets with intelligent priority detection, comprehensive Google Sheets tracking, and real time team notifica...

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, Support Chatbot use case.