Automatisierung ausstehender Zahlungen - ClickUp-Integration

• •Google-Konto + Gmail API-Anmeldedaten
• •Slack Bot Token oder Webhook URL
• •Google Sheets API-Anmeldedaten

{
  "id": "AjxolVhM49WYCeRP",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "Payment Pending Automation - ClickUp Integration",
  "tags": [],
  "nodes": [
    {
      "id": "236c90c5-3595-47b5-9bf2-7e7766676448",
      "name": "Bei Klick auf 'Workflow ausführen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1456,
        176
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8e57d952-3ec9-4057-8483-a428df6598d2",
      "name": "Lead-Daten aus Google Sheets abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1232,
        176
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1810805257,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19Uq4JB_oKG1s-0S6kKNwJtGWBRXVtpwo9DDCM0Hlg5I/edit#gid=1810805257",
          "cachedResultName": "Sheet2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19Uq4JB_oKG1s-0S6kKNwJtGWBRXVtpwo9DDCM0Hlg5I",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19Uq4JB_oKG1s-0S6kKNwJtGWBRXVtpwo9DDCM0Hlg5I/edit?usp=drivesdk",
          "cachedResultName": "GHL form submission (Responses)"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "0f136a95-2d90-403b-bd4a-841ba94e1428",
      "name": "Prüfen, ob Status 'Open' ist",
      "type": "n8n-nodes-base.if",
      "position": [
        -1008,
        176
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "5e5dda7c-e7e5-45bd-8ef9-cb5715ba23f2",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json[\"Status \"] }}",
              "rightValue": "Open"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "d99cde05-65db-4582-a8ea-f5aa83843c2d",
      "name": "Slack-Benachrichtigung senden (Status nicht Open)",
      "type": "n8n-nodes-base.slack",
      "position": [
        -784,
        272
      ],
      "webhookId": "4683a528-3acf-4b59-a19f-f800931080a9",
      "parameters": {
        "text": "=Lead: {{ $json[\"Lead Name\"] }}'s Payment Verfication is :{{ $json[\"Payement verification\"] }}",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": "U09E375JZPA",
          "cachedResultName": "n8n_workspace"
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "rNqvWj9TfChPVRYY",
          "name": "Slack account vivek"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "8cc8639f-3d31-4694-be81-b8ddc2812304",
      "name": "ClickUp-Task für Zahlungsverifikation erstellen",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        -784,
        80
      ],
      "parameters": {
        "list": "901611225386",
        "name": "={{ $json[\"Lead Name\"] }} {{ $json[\"Company Name\"] }} Payment verfication is {{ $json[\"Payement verification\"] }}",
        "team": "90161261705",
        "space": "90165174252",
        "folderless": true,
        "additionalFields": {}
      },
      "credentials": {
        "clickUpApi": {
          "id": "mcOAWijv7qCSnkNx",
          "name": "ClickUp account-test anuj"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0f880546-766b-4e42-9e50-dba597a6196b",
      "name": "E-Mail-Bestätigung an Task-Beobachter senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -560,
        80
      ],
      "webhookId": "a0893b15-8f0d-4503-ad96-47112f4ba17b",
      "parameters": {
        "sendTo": "={{ $json.watchers[0].email }}",
        "message": "=Clickup Task is created with id:{{ $json.id }}. Please check",
        "options": {},
        "subject": "={{ $json.name }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "RchiXdmY8WaQhOSJ",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "c54a5c22-56a7-4c97-97df-773990617a5d",
      "name": "Haftnotiz - Workflow-Start",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1648,
        -80
      ],
      "parameters": {
        "color": 4,
        "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."
      },
      "typeVersion": 1
    },
    {
      "id": "ba1c9640-f01f-4536-910b-f96b32369bdf",
      "name": "Haftnotiz - Google Sheets",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        336
      ],
      "parameters": {
        "color": 5,
        "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- Payment Verification Status\n- Status (Open/Closed)\n\nThis node pulls all pending payment verifications that need to be processed."
      },
      "typeVersion": 1
    },
    {
      "id": "798c619c-b3ef-4567-ac2f-7f81deb6615a",
      "name": "Haftnotiz - Bedingungsprüfung",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        -224
      ],
      "parameters": {
        "color": 6,
        "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 notification only\n\nThis ensures we only create tasks for active/open payment verifications."
      },
      "typeVersion": 1
    },
    {
      "id": "38bdcc63-85a3-4e36-a3c3-0cb91b4b6987",
      "name": "Haftnotiz - E-Mail",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        48
      ],
      "parameters": {
        "color": 5,
        "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\nThis keeps stakeholders informed about new payment verification tasks."
      },
      "typeVersion": 1
    },
    {
      "id": "8bdefd3a-4a00-4807-8812-18998de3f710",
      "name": "Haftnotiz - ClickUp",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        -352
      ],
      "parameters": {
        "color": 7,
        "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**Task Name Format:**\n[Lead Name] [Company Name] Payment verification is [Status]\n\nThis centralizes all payment verification tasks in one place for the team."
      },
      "typeVersion": 1
    },
    {
      "id": "7963a0c9-b2f0-4364-a7d1-81f0530f4e39",
      "name": "Haftnotiz - Slack",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        448
      ],
      "parameters": {
        "color": 3,
        "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 fallback notification for non-open statuses that don't require task creation."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "0d6c906d-0058-4452-9ce6-1bacd6724f60",
  "connections": {
    "0f136a95-2d90-403b-bd4a-841ba94e1428": {
      "main": [
        [
          {
            "node": "8cc8639f-3d31-4694-be81-b8ddc2812304",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "d99cde05-65db-4582-a8ea-f5aa83843c2d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8e57d952-3ec9-4057-8483-a428df6598d2": {
      "main": [
        [
          {
            "node": "0f136a95-2d90-403b-bd4a-841ba94e1428",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "236c90c5-3595-47b5-9bf2-7e7766676448": {
      "main": [
        [
          {
            "node": "8e57d952-3ec9-4057-8483-a428df6598d2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8cc8639f-3d31-4694-be81-b8ddc2812304": {
      "main": [
        [
          {
            "node": "0f880546-766b-4e42-9e50-dba597a6196b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}