{
  "name": "Automate payment tracking with Google Sheets, ClickUp, Gmail and Slack",
  "nodes": [
    {
      "id": "236c90c5-3595-47b5-9bf2-7e7766676448",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1456,
        176
      ]
    },
    {
      "id": "8e57d952-3ec9-4057-8483-a428df6598d2",
      "name": "Fetch Lead Data from Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1232,
        176
      ]
    },
    {
      "id": "0f136a95-2d90-403b-bd4a-841ba94e1428",
      "name": "Check if Status is Open",
      "type": "n8n-nodes-base.if",
      "position": [
        -1008,
        176
      ]
    },
    {
      "id": "d99cde05-65db-4582-a8ea-f5aa83843c2d",
      "name": "Send Slack Notification (Status Not Open)",
      "type": "n8n-nodes-base.slack",
      "position": [
        -784,
        272
      ]
    },
    {
      "id": "8cc8639f-3d31-4694-be81-b8ddc2812304",
      "name": "Create ClickUp Task for Payment Verification",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        -784,
        80
      ]
    },
    {
      "id": "0f880546-766b-4e42-9e50-dba597a6196b",
      "name": "Send Email Confirmation to Task Watcher",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -560,
        80
      ]
    },
    {
      "id": "c54a5c22-56a7-4c97-97df-773990617a5d",
      "name": "Sticky Note - Workflow Start",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1648,
        -80
      ],
      "parameters": {
        "width": 293.0894308943089,
        "height": 229.73441734417344,
        "content": "## 🚀 Workflow Start\n\nThis workflow is triggered manually by clicking the 'Execute Workflow' button.\n\nUse this when you want to process payment verification data from the Google Sheet."
      }
    },
    {
      "id": "ba1c9640-f01f-4536-910b-f96b32369bdf",
      "name": "Sticky Note - Google Sheets",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        336
      ],
      "parameters": {
        "width": 322.734375,
        "height": 368.6718750000001,
        "content": "## 📊 Fetch Lead Data\n\n**Purpose:** Retrieves all rows from Google Sheets containing lead information\n\n**Sheet:** GHL form submission (Responses)\n\n**Data Retrieved:**\n- Lead Name\n- Company Name\n- Payme"
      }
    },
    {
      "id": "798c619c-b3ef-4567-ac2f-7f81deb6615a",
      "name": "Sticky Note - Condition Check",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        -224
      ],
      "parameters": {
        "width": 322.734375,
        "height": 380.02343750000006,
        "content": "## ✅ Status Filter\n\n**Condition:** Checks if Status = \"Open\"\n\n**True Path (Status = Open):**\n→ Creates ClickUp task\n→ Sends email confirmation\n\n**False Path (Status ≠ Open):**\n→ Sends Slack notificati"
      }
    },
    {
      "id": "38bdcc63-85a3-4e36-a3c3-0cb91b4b6987",
      "name": "Sticky Note - Email",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        48
      ],
      "parameters": {
        "width": 293.0894308943089,
        "height": 335.00000000000006,
        "content": "## ✉️ Email Notification\n\n**Purpose:** Sends confirmation email after task creation\n\n**Recipient:** First watcher of the ClickUp task\n\n**Content:**\n- Task name\n- Task ID\n- Link to verify the task\n\nThi"
      }
    },
    {
      "id": "8bdefd3a-4a00-4807-8812-18998de3f710",
      "name": "Sticky Note - ClickUp",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        -352
      ],
      "parameters": {
        "width": 293.0894308943089,
        "height": 403.75,
        "content": "## 📋 Create ClickUp Task\n\n**Purpose:** Creates a task in ClickUp for payment verification follow-up\n\n**Task Details:**\n- Team: Payment Team\n- Space: Payment Processing\n- List: Payment Verifications\n\n*"
      }
    },
    {
      "id": "7963a0c9-b2f0-4364-a7d1-81f0530f4e39",
      "name": "Sticky Note - Slack",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        448
      ],
      "parameters": {
        "width": 293.0894308943089,
        "height": 335.00000000000006,
        "content": "## 💬 Slack Alert\n\n**Purpose:** Notifies team via Slack when status is NOT open\n\n**Channel:** n8n_workspace\n\n**Message Format:**\nLead: [Lead Name]'s Payment Verification is: [Status]\n\nThis is a fallbac"
      }
    }
  ],
  "connections": {
    "Check if Status is Open": {
      "main": [
        [
          {
            "node": "Create ClickUp Task for Payment Verification",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Slack Notification (Status Not Open)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Lead Data from Google Sheets": {
      "main": [
        [
          {
            "node": "Check if Status is Open",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Fetch Lead Data from Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create ClickUp Task for Payment Verification": {
      "main": [
        [
          {
            "node": "Send Email Confirmation to Task Watcher",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}