{
  "name": "Create Zendesk tickets from Gmail and Slack with Google Sheets tracking",
  "nodes": [
    {
      "id": "91c501b2-e134-406d-9e38-679bc5581337",
      "name": "Slack Trigger",
      "type": "n8n-nodes-base.slackTrigger",
      "position": [
        -944,
        240
      ]
    },
    {
      "id": "a7f78052-276b-41ee-baa2-0cc21f2a13ec",
      "name": "Normalize Gmail Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -752,
        32
      ]
    },
    {
      "id": "842db600-6d49-4afb-adc3-b72f9b3acc76",
      "name": "Normalize Slack Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -736,
        240
      ]
    },
    {
      "id": "ae0220a2-b337-4b0a-81dd-fd7f54a739dc",
      "name": "Merge Channels",
      "type": "n8n-nodes-base.merge",
      "position": [
        -512,
        160
      ]
    },
    {
      "id": "feb43b04-c0df-4d59-9c5c-fc7301f1bb04",
      "name": "Create Zendesk Ticket",
      "type": "n8n-nodes-base.zendesk",
      "position": [
        -304,
        160
      ]
    },
    {
      "id": "3dd320b0-6361-44e7-a26f-4a7683aa2749",
      "name": "Format Sheet Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -112,
        160
      ]
    },
    {
      "id": "f5cdbfd3-cbbf-44ba-921a-2a548cd40ff6",
      "name": "Check for Errors",
      "type": "n8n-nodes-base.if",
      "position": [
        304,
        160
      ]
    },
    {
      "id": "318484c7-855b-47e0-a1e2-53747341ad21",
      "name": "Send Error Notification",
      "type": "n8n-nodes-base.slack",
      "position": [
        512,
        48
      ]
    },
    {
      "id": "e25ad08b-3f0c-4223-a56f-a46f412d2d0c",
      "name": "Send Success Notification",
      "type": "n8n-nodes-base.slack",
      "position": [
        512,
        256
      ]
    },
    {
      "id": "e8cca88f-ed70-4516-856f-ab4fdce16c57",
      "name": "Gmail Trigger",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -944,
        32
      ]
    },
    {
      "id": "5ba8c867-8a8c-4369-98f2-6ae1eb9c6596",
      "name": "Log to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        112,
        160
      ]
    },
    {
      "id": "b16b8403-30f4-4025-b923-a8a6f3013165",
      "name": "Sticky Note - Gmail Trigger",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        -224
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "486cf6fe-1d02-406a-a888-78d322f85f11",
      "name": "Sticky Note - Slack Trigger",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        288
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "cc9dabe4-d29b-4d1b-ad53-365439a3c617",
      "name": "Sticky Note - Gmail Normalize",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -784,
        -304
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "fe405bc0-d531-43ca-b8eb-c95f888b6f2e",
      "name": "Sticky Note - Slack Normalize",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        368
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "ec0da8ad-fcae-4d36-9210-6d7bc79f863d",
      "name": "Sticky Note - Merge",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -480,
        -224
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "696e38f7-ca0d-4ff2-8bd4-a4bd99cd18cb",
      "name": "Sticky Note - Zendesk",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        304
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "7a239694-a538-451a-a873-64dbdbd9b095",
      "name": "Sticky Note - Format",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -112,
        -192
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "f21ddbd7-dc00-47a2-960c-c831566241c8",
      "name": "Sticky Note - Sheets",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        320
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "45f1c868-c6eb-40a7-a0a2-37e5323caa1b",
      "name": "Sticky Note - Error Check",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        -208
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "b40978bd-3de8-430c-9322-2a419d482685",
      "name": "Sticky Note - Error Notify",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        -272
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "cbff4d0d-ab6e-42e5-8fb8-d960337ce93e",
      "name": "Sticky Note - Success Notify",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        384
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "Gmail Trigger": {
      "main": [
        [
          {
            "node": "Normalize Gmail Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack Trigger": {
      "main": [
        [
          {
            "node": "Normalize Slack Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Channels": {
      "main": [
        [
          {
            "node": "Create Zendesk Ticket",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check for Errors": {
      "main": [
        [
          {
            "node": "Send Error Notification",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Success Notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Sheet Data": {
      "main": [
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Google Sheets": {
      "main": [
        [
          {
            "node": "Check for Errors",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Gmail Data": {
      "main": [
        [
          {
            "node": "Merge Channels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Slack Data": {
      "main": [
        [
          {
            "node": "Merge Channels",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Create Zendesk Ticket": {
      "main": [
        [
          {
            "node": "Format Sheet Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}