{
  "name": "Zendesk pending ticket follow-up system with Gmail, Google Sheets & ClickUp",
  "nodes": [
    {
      "id": "616e5acf-cab7-4ef6-a01a-68f158495148",
      "name": "Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -912,
        -80
      ],
      "parameters": {
        "width": 300,
        "height": 304,
        "content": "## 🎯 Workflow Overview\n\nThis workflow automates Zendesk support ticket management:\n- Fetches pending tickets daily\n- Logs them to Google Sheets for tracking\n- Sends follow-up emails to customers\n- Cre"
      }
    },
    {
      "id": "4023e848-11cd-4b1e-aa2c-591c83a337cb",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.cron",
      "position": [
        -576,
        -16
      ]
    },
    {
      "id": "8033211b-22c8-4cc8-89cf-863df591cbfc",
      "name": "Data Retrieval Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        144
      ],
      "parameters": {
        "width": 280,
        "height": 240,
        "content": "## 📊 Data Retrieval\n\nFetches all pending tickets from Zendesk using the API.\n\n**Configuration Required**:\n- Zendesk API credentials\n- Filter: status = 'pending'\n- Returns all matching tickets"
      }
    },
    {
      "id": "59b8a5f0-f5be-4e72-b06e-db5eb64d2047",
      "name": "Get Pending Tickets",
      "type": "n8n-nodes-base.zendesk",
      "position": [
        -352,
        -16
      ]
    },
    {
      "id": "39631916-8779-4cf8-b25b-28d0a6aec0ff",
      "name": "Filtering Logic",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        -288
      ],
      "parameters": {
        "width": 280,
        "height": 256,
        "content": "## 🔍 Smart Filtering\n\nFilters tickets based on status and age:\n- Only processes 'pending' status tickets\n- Helps reduce noise and focus on actionable items\n\n**Logic**: status === 'pending'"
      }
    },
    {
      "id": "47f63b74-86d7-4548-80ce-dedacbe5c2e8",
      "name": "Filter Pending Tickets",
      "type": "n8n-nodes-base.if",
      "position": [
        -128,
        -16
      ]
    },
    {
      "id": "d536f781-1ad8-45e5-a935-76bf15893c32",
      "name": "Data Processing",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        128
      ],
      "parameters": {
        "width": 280,
        "height": 256,
        "content": "## 🛠️ Data Processing\n\nFormats and enriches ticket data:\n- Standardizes field names\n- Calculates ticket age and priority levels\n- Adds computed fields for better analysis\n- Prepares data for downstrea"
      }
    },
    {
      "id": "41703a6c-69a3-4b5b-ad23-8c3355a4dee1",
      "name": "Format Ticket Data",
      "type": "n8n-nodes-base.code",
      "position": [
        96,
        -16
      ]
    },
    {
      "id": "2525d374-d35a-4c26-8cb0-8b73dcb5c26c",
      "name": "Data Logging",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        -368
      ],
      "parameters": {
        "width": 280,
        "height": 240,
        "content": "## 📊 Data Logging\n\nLogs formatted ticket data to Google Sheets:\n- Maintains historical record\n- Enables reporting and analytics\n- Updates existing tickets or creates new entries\n- Uses Ticket ID as ma"
      }
    },
    {
      "id": "9a884edc-ba8b-43db-954b-3af4a9787af9",
      "name": "Log to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        -112
      ]
    },
    {
      "id": "5cf6fc3f-4ee4-4819-8b41-1f39281acaa3",
      "name": "Task Management",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        -352
      ],
      "parameters": {
        "width": 280,
        "height": 224,
        "content": "## ✅ Task Management\n\nCreates ClickUp tasks for ticket tracking:\n- One task per pending ticket\n- Due date based on ticket priority\n- Tags from Zendesk are preserved\n- Helps team track follow-ups"
      }
    },
    {
      "id": "a382eefa-941b-45d1-9936-6ce29cd751cd",
      "name": "Create ClickUp Task",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        544,
        -112
      ]
    },
    {
      "id": "dbc754e3-990a-430d-b3fc-8b5b5a2dd3c9",
      "name": "Email Generation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        224
      ],
      "parameters": {
        "width": 280,
        "height": 240,
        "content": "## 📧 Email Generation\n\nGenerates personalized follow-up emails:\n- Groups tickets by customer email\n- Creates professional HTML emails\n- Includes ticket details and next steps\n- Maintains brand consist"
      }
    },
    {
      "id": "b2d57a93-f5ec-4058-b2d7-f24d232c2432",
      "name": "Generate Follow-up Emails",
      "type": "n8n-nodes-base.code",
      "position": [
        448,
        80
      ]
    },
    {
      "id": "69c121ab-d596-4f78-abb3-7f31528400d5",
      "name": "Email Delivery",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        864,
        224
      ],
      "parameters": {
        "width": 280,
        "height": 288,
        "content": "## 📤 Email Delivery\n\nSends professional follow-up emails via Gmail:\n- Uses HTML formatted emails\n- Personalizes content per customer\n- Includes all relevant ticket information\n- Maintains professional"
      }
    },
    {
      "id": "63310af9-28b6-45b7-99ef-638490caf9e1",
      "name": "Send Follow-up Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        800,
        80
      ]
    }
  ],
  "connections": {
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Pending Tickets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Ticket Data": {
      "main": [
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate Follow-up Emails",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pending Tickets": {
      "main": [
        [
          {
            "node": "Filter Pending Tickets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Google Sheets": {
      "main": [
        [
          {
            "node": "Create ClickUp Task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Pending Tickets": {
      "main": [
        [
          {
            "node": "Format Ticket Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Follow-up Emails": {
      "main": [
        [
          {
            "node": "Send Follow-up Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}