Automatisierte Erstellung täglicher Morgenberichte von ClickUp nach Slack und Gmail mit GPT-4

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

{
  "id": "GUsJXoE0d02fP7ii",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "Automate Daily Morning Brief Generation from ClickUp to Slack and Gmail using GPT-4",
  "tags": [],
  "nodes": [
    {
      "id": "2bf648b3-58dc-4003-b682-9d35749f3c9f",
      "name": "Notiz: Workflow-Übersicht",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4032,
        -384
      ],
      "parameters": {
        "color": 4,
        "width": 454,
        "height": 794,
        "content": "## 🌅 Automate Daily Morning Brief Generation from ClickUp to Slack and Gmail using GPT-4\nThis workflow automatically generates a comprehensive morning brief from your ClickUp tasks and sends it to Slack and Email every morning.\n\n### **What it does:**\n- Fetches the latest active sprint from ClickUp\n- Retrieves all tasks due today and in-progress items\n- Uses AI to generate an executive summary\n- Sends formatted briefs to Slack and Gmail\n- Handles errors with notifications\n\n### **Use Case:**\nPerfect for teams using ClickUp for sprint management who want automated daily stand-up reports with:\n- Today's priorities and due tasks\n- In-progress work status\n- Team member assignments\n- Blockers and issues\n\n### **Setup Requirements:**\n1. ClickUp OAuth2 credentials\n2. Slack API credentials\n3. Gmail OAuth2 credentials  \n4. Azure OpenAI API credentials\n5. Update Team ID, Space ID, and Folder ID in ClickUp nodes\n6. Configure Slack channel IDs\n7. Set recipient email address\n\n### **Schedule:**\nRuns daily at 9:15 AM (customizable in Schedule Trigger node)\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "92a7dff2-bade-4ad8-884c-c6d6d78276c8",
      "name": "Notiz: Zeitplan-Trigger",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3488,
        -512
      ],
      "parameters": {
        "width": 276,
        "height": 362,
        "content": "## ⏰ Schedule Trigger\n\n**Purpose:** Triggers the workflow every morning at 9:15 AM\n\n**Configuration:**\n- Uses cron expression: `15 9 * * *`\n- Runs Monday through Sunday\n- Timezone: Server default\n\n**To Customize:**\n- Change hour/minute in cron expression\n- Add day-of-week restrictions if needed"
      },
      "typeVersion": 1
    },
    {
      "id": "351c23ff-37f5-4305-888b-9d41cd6af400",
      "name": "Trigger: Morgen-Zeitplan",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -3344,
        -80
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "15 9 * * *"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "788b9c85-c74a-4533-8552-7f1b6523516b",
      "name": "Notiz: Sprints abrufen",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3168,
        -576
      ],
      "parameters": {
        "width": 285,
        "height": 451,
        "content": "## 📋 Fetch Sprint Lists\n\n**Purpose:** Retrieves all sprint lists from ClickUp\n\n**Configuration Required:**\n- **Team ID:** Replace `9016683627` with your team ID\n- **Space ID:** Replace `90162844741` with your space ID  \n- **Folder ID:** Replace `90164394824` with your folder ID\n\n**How to find IDs:**\n1. Open ClickUp in browser\n2. Navigate to your space/folder\n3. Copy IDs from URL\n\n**Output:** List of all sprints with metadata"
      },
      "typeVersion": 1
    },
    {
      "id": "22bc18f9-01ab-4674-ba53-c72f7c71685c",
      "name": "Alle Listen abrufen (Sprints)",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        -3120,
        -80
      ],
      "parameters": {
        "team": "YOUR_TEAM_ID",
        "limit": 100,
        "space": "YOUR_SPACE_ID",
        "folder": "YOUR_FOLDER_ID",
        "filters": {},
        "resource": "list",
        "operation": "getAll",
        "authentication": "oAuth2"
      },
      "credentials": {
        "clickUpOAuth2Api": {
          "id": "6UikDwF6BMx3ln9O",
          "name": "ClickUp account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "cfc16d55-b75a-4801-8620-cc5aab3acf46",
      "name": "Notiz: Daten validieren",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2816,
        -512
      ],
      "parameters": {
        "width": 249,
        "height": 367,
        "content": "## ✅ Validation Check\n\n**Purpose:** Ensures sprint lists were retrieved successfully\n\n**Logic:**\n- Checks if response is not empty\n- Only proceeds if lists exist\n\n**Error Handling:**\n- If no lists found, workflow stops\n- Prevents downstream errors"
      },
      "typeVersion": 1
    },
    {
      "id": "ff0eb47a-246d-4aed-8760-a09020487bbb",
      "name": "Listen-Existenz prüfen",
      "type": "n8n-nodes-base.if",
      "position": [
        -2896,
        -80
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 1,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "condition1",
              "operator": {
                "type": "boolean",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.isNotEmpty() }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "4c9545e5-eda5-444e-bceb-6d61d7f06648",
      "name": "Notiz: Sprint-Logik",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2736,
        96
      ],
      "parameters": {
        "width": 263,
        "height": 388,
        "content": "## 🔍 Find Active Sprint\n\n**Purpose:** Identifies the current active sprint or most recent one\n\n**Logic:**\n1. Checks for sprints where current time falls between start and due dates\n2. If active sprint exists, selects it\n3. If no active sprint, selects most recent by start date\n\n**Output:**\n- Sprint ID, name, dates\n- Active status flag\n- Total sprint count"
      },
      "typeVersion": 1
    },
    {
      "id": "997dcb26-240f-4ed0-86bb-9bcb302aaa47",
      "name": "Neuesten Sprint finden",
      "type": "n8n-nodes-base.code",
      "position": [
        -2672,
        -80
      ],
      "parameters": {
        "jsCode": "// Get currently active sprint or the latest one\nconst lists = $input.all();\nconst now = Date.now();\n\n// First, try to find active sprints (current time between start and due date)\nconst activeSprints = lists.filter(list => {\n  const startDate = parseInt(list.json.start_date);\n  const dueDate = parseInt(list.json.due_date);\n  return startDate <= now && now <= dueDate;\n});\n\nlet latestSprint;\n\nif (activeSprints.length > 0) {\n  // If we have active sprints, get the most recent one by start date\n  latestSprint = activeSprints.sort((a, b) => \n    parseInt(b.json.start_date) - parseInt(a.json.start_date)\n  )[0];\n} else {\n  // No active sprints, get the most recent by start date (could be future sprint)\n  latestSprint = lists.sort((a, b) => \n    parseInt(b.json.start_date) - parseInt(a.json.start_date)\n  )[0];\n}\n\nreturn {\n  json: {\n    latest_sprint_id: latestSprint.json.id,\n    latest_sprint_name: latestSprint.json.name,\n    latest_sprint_start_date: latestSprint.json.start_date,\n    latest_sprint_due_date: latestSprint.json.due_date,\n    is_currently_active: activeSprints.length > 0,\n    total_sprints_found: lists.length\n  }\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "46cc6963-ea8a-4bb5-ac09-de10816754e9",
      "name": "Notiz: Aufgabenabruf",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2544,
        -560
      ],
      "parameters": {
        "width": 259,
        "height": 390,
        "content": "## 📥 Get Sprint Tasks\n\n**Purpose:** Fetches all tasks from the active sprint\n\n**Filters Applied:**\n- Tasks due today (midnight to 11:59 PM)\n- Includes subtasks and checklist items\n\n**Note:** Team/Space/Folder IDs are dynamically pulled from previous node\n\n**Output:** Complete task data with assignees, status, priorities, and subtasks"
      },
      "typeVersion": 1
    },
    {
      "id": "18dd7a8f-caad-4a73-b334-6d6140638834",
      "name": "Aufgaben aus neuestem Sprint abrufen",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        -2448,
        -80
      ],
      "parameters": {
        "list": "={{ $json.latest_sprint_id }}",
        "team": "YOUR_TEAM_ID",
        "space": "YOUR_SPACE_ID",
        "folder": "={{ $json.latest_sprint_name }}",
        "filters": {
          "subtasks": true,
          "dueDateGt": "={{ new Date().setHours(0, 0, 0, 0) }}",
          "dueDateLt": "={{ new Date().setHours(23, 59, 59, 999) }}"
        },
        "operation": "getAll",
        "authentication": "oAuth2"
      },
      "credentials": {
        "clickUpOAuth2Api": {
          "id": "6UikDwF6BMx3ln9O",
          "name": "ClickUp account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2d279459-7101-408e-8a79-10030d627705",
      "name": "Notiz: Datenverarbeitung",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2304,
        96
      ],
      "parameters": {
        "width": 264,
        "height": 313,
        "content": "## 📊 Format Task Data\n\n**Purpose:** Transforms raw ClickUp data into structured format for AI processing\n\n**Processing:**\n- Extracts checklist items as subtasks\n- Categorizes tasks by status and priority\n- Groups in-progress, urgent, high, and normal priority tasks\n- Identifies blockers\n- Calculates status summaries\n\n**Output:** Structured JSON with task categorizations and metadata"
      },
      "typeVersion": 1
    },
    {
      "id": "d76873cc-ba60-4cbe-9163-05e7b90baf26",
      "name": "Format: Kurzberichtsdaten zusammenstellen",
      "type": "n8n-nodes-base.code",
      "position": [
        -2224,
        -80
      ],
      "parameters": {
        "jsCode": "// Get all inputs dynamically\nconst allInputs = $input.all();\n\n// Extract ClickUp data from all items\nconst clickupData = allInputs.map(item => item.json).filter(item => item && item.id);\n\nconst highPriority = [];\nconst normalPriority = [];\nconst blockers = [];\nconst urgentTasks = [];\nconst inProgress = [];\n\nclickupData.forEach(task => {\n  // Extract checklist items as subtasks\n  const subtasks = [];\n  if (task.checklists && task.checklists.length > 0) {\n    task.checklists.forEach(checklist => {\n      if (checklist.items && checklist.items.length > 0) {\n        checklist.items.forEach(item => {\n          subtasks.push({\n            name: item.name,\n            resolved: item.resolved,\n            assignee: item.assignee ? 'Assigned' : 'Unassigned'\n          });\n        });\n      }\n    });\n  }\n\n  const taskInfo = {\n    name: task.name || 'Untitled',\n    status: task.status?.status || 'Unknown',\n    statusType: task.status?.type || 'unknown',\n    priority: task.priority?.priority || 'normal',\n    url: task.url || '',\n    assignees: task.assignees?.map(a => a.username).join(', ') || 'Unassigned',\n    list: task.list?.name || '',\n    folder: task.folder?.name || task.project?.name || '',\n    dueDate: task.due_date ? new Date(parseInt(task.due_date)).toLocaleDateString('en-US', { month: 'short', day: 'numeric' }) : 'No due date',\n    timeSpent: task.time_spent ? `${Math.floor(task.time_spent / 60000)} min` : null,\n    description: task.description ? (task.description.length > 100 ? task.description.substring(0, 100) + '...' : task.description) : null,\n    subtasks: subtasks,\n    subtasksSummary: subtasks.length > 0 ? `${subtasks.filter(s => s.resolved).length}/${subtasks.length} completed` : null\n  };\n  \n  // Categorize by status first (in progress)\n  if (task.status?.status?.toLowerCase().includes('progress')) {\n    inProgress.push(taskInfo);\n  }\n  // Check for blockers\n  else if (task.status?.status?.toLowerCase().includes('block')) {\n    blockers.push(taskInfo);\n  } \n  // Then by priority\n  else if (task.priority?.priority === 'urgent') {\n    urgentTasks.push(taskInfo);\n  } \n  else if (task.priority?.priority === 'high') {\n    highPriority.push(taskInfo);\n  } \n  else {\n    normalPriority.push(taskInfo);\n  }\n});\n\n// Dynamically get board URL from first task\nconst firstTask = clickupData[0];\nconst boardUrl = firstTask?.list?.id \n  ? `https://app.clickup.com/${firstTask.team_id}/v/li/${firstTask.list.id}`\n  : firstTask?.space?.id \n  ? `https://app.clickup.com/${firstTask.team_id}/v/s/${firstTask.space.id}`\n  : 'https://app.clickup.com';\n\n// Count status types\nconst statusSummary = {\n  backlogs: clickupData.filter(t => t.status?.status === 'backlogs').length,\n  inProgress: clickupData.filter(t => t.status?.status?.toLowerCase().includes('progress')).length,\n  completed: clickupData.filter(t => t.status?.type === 'closed').length\n};\n\nconst summary = {\n  date: new Date().toLocaleDateString('en-US', { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' }),\n  inProgressTasks: inProgress,\n  urgentTasks: urgentTasks,\n  highPriorityTasks: highPriority,\n  normalPriorityTasks: normalPriority,\n  blockers: blockers,\n  clickupBoardUrl: boardUrl,\n  totalTasks: clickupData.length,\n  listName: firstTask?.list?.name || 'Tasks',\n  folderName: firstTask?.folder?.name || firstTask?.project?.name || 'Board',\n  statusSummary: statusSummary,\n  teamId: firstTask?.team_id || null\n};\n\nreturn { json: summary };"
      },
      "typeVersion": 2
    },
    {
      "id": "d1a1920b-f54d-4172-9b8c-b17054b3a39d",
      "name": "Notiz: KI-Verarbeitung",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2080,
        -480
      ],
      "parameters": {
        "width": 385,
        "height": 396,
        "content": "## 🤖 AI Brief Generation\n\n**Purpose:** Uses Azure OpenAI to generate executive summary\n\n**Components:**\n- **LLM:** GPT-4o model\n- **Memory:** Buffer window for context\n- **Parser:** Structured JSON output\n\n**Input:** Formatted task data\n**Output:** Executive summary with priorities, team focus, and blockers\n\n**Setup Required:**\n- Configure Azure OpenAI credentials\n- Model should be GPT-4o or equivalent"
      },
      "typeVersion": 1
    },
    {
      "id": "e5fae6c6-9533-46b3-be91-0441dc52ad08",
      "name": "OpenAI: Kurzbericht generieren",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -1936,
        -80
      ],
      "parameters": {
        "text": "=Create a comprehensive Morning Brief for {{ $json.date }}.\n\n## CURRENT DATE\n{{ $json.date }}\n\n## SPRINT OVERVIEW\n- **List:** {{ $json.listName }}\n- **Total Tasks:** {{ $json.totalTasks }}\n- **Status Breakdown:** {{ $json.statusSummary.backlogs }} Backlogs | {{ $json.statusSummary.inProgress }} In Progress | {{ $json.statusSummary.completed }} Completed\n\n## IN PROGRESS TASKS ({{ $json.inProgressTasks.length }})\n{{ $json.inProgressTasks.map(t => `- **${t.name}** (${t.assignees}) - Due: ${t.dueDate}${t.timeSpent ? ' | Time Spent: ' + t.timeSpent : ''}${t.subtasksSummary ? ' | Subtasks: ' + t.subtasksSummary : ''}`).join('\\n') || 'None' }}\n\n## HIGH PRIORITY TASKS\n{{ $json.highPriorityTasks.map(t => `- **${t.name}** (${t.assignees}) - Due: ${t.dueDate} - ${t.priority.toUpperCase()}`).join('\\n') || 'None' }}\n\n## NORMAL PRIORITY TASKS\n{{ $json.normalPriorityTasks.map(t => `- **${t.name}** (${t.assignees}) - Due: ${t.dueDate}${t.subtasksSummary ? ' | ' + t.subtasksSummary : ''}`).join('\\n') || 'None' }}\n\n## BLOCKERS ({{ $json.blockers.length }})\n{{ $json.blockers.map(t => `- **${t.name}** (${t.assignees}) - Status: ${t.status}`).join('\\n') || 'None - All Clear!' }}\n\n## ALL TEAM MEMBERS\n{{ [...new Set([...$json.inProgressTasks, ...$json.highPriorityTasks, ...$json.normalPriorityTasks].map(t => t.assignees).join(', ').split(', '))].join(', ') }}\n\n---\n\n**Instructions:**\nToday's date is: {{ $json.date }}\n\nAnalyze the tasks above and identify which ones are due TODAY based on the dueDate field.\n\nReturn ONLY valid JSON with this exact structure:\n{\n  \"title\": \"Morning Brief - {{ $json.date }}\",\n  \"executiveSummary\": \"2-3 sentence overview highlighting key priorities and team focus for TODAY\",\n  \"inProgressHighlights\": \"Brief summary of active in-progress tasks and their status\",\n  \"todaysPriorities\": \"List ALL tasks due TODAY. Format as bullet points with task name and assignee. If no tasks due today, state 'No tasks due today - focus on in-progress items'\",\n  \"teamFocus\": \"For each team member, list what they are working on TODAY. Focus on tasks due today or in-progress tasks. Group by person name.\",\n  \"blockers\": \"{{ $json.blockers.length > 0 ? 'List blockers' : 'All Clear' }}\",\n  \"clickupBoardUrl\": \"{{ $json.clickupBoardUrl }}\",\n  \"metrics\": {\n    \"totalTasks\": {{ $json.totalTasks }},\n    \"dueToday\": \"COUNT how many tasks are due today\",\n    \"inProgress\": {{ $json.statusSummary.inProgress }},\n    \"backlogs\": {{ $json.statusSummary.backlogs }}\n  }\n}\n\nCRITICAL: \n- Look at the dueDate field for each task\n- In \"todaysPriorities\", list ONLY tasks due today\n- In \"teamFocus\", mention what each person is working on\n- Be specific and actionable",
        "options": {
          "systemMessage": "=You are a professional executive assistant creating detailed morning briefs for a team.\nYour response must:\n- Be structured, actionable, and team-focused\n- Highlight in-progress tasks and blockers prominently\n- Group tasks by assignee/team member\n- Show clear priorities with due dates\n- Include subtask progress where available\n- Be concise but comprehensive\n- Focus on TODAY's tasks and priorities\n- Use the exact date provided in the input data\n\nAlways output valid JSON matching the exact schema provided.\nNever add markdown fences, code blocks, or explanatory text."
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2.1
    },
    {
      "id": "357b93df-c039-4fde-90f3-6fec91193d32",
      "name": "Strukturierter Ausgabe-Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -1744,
        160
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"title\": \"\",\n  \"executiveSummary\": \"\",\n  \"inProgressHighlights\": \"\",\n  \"todaysPriorities\": \"\",\n  \"teamFocus\": \"\",\n  \"blockers\": \"\",\n  \"clickupBoardUrl\": \"\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "d1af24e4-dd4f-4e6b-bca7-340f1280624c",
      "name": "Azure OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        -2000,
        160
      ],
      "parameters": {
        "model": "gpt-4o",
        "options": {}
      },
      "credentials": {
        "azureOpenAiApi": {
          "id": "C3WzT18XqF8OdVM6",
          "name": "Azure Open AI account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f336c158-207b-4ec0-8bf9-917a1ad7aabc",
      "name": "Einfacher Speicher",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -1872,
        160
      ],
      "parameters": {
        "sessionKey": "\"lead_intent_classifier\"",
        "sessionIdType": "customKey",
        "contextWindowLength": 7
      },
      "typeVersion": 1.3
    },
    {
      "id": "1d5d6d60-31ef-4cb8-bee0-c781bf54a0ca",
      "name": "Notiz: E-Mail-Erstellung",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1584,
        192
      ],
      "parameters": {
        "width": 256,
        "height": 349,
        "content": "## 📧 Email Formatting\n\n**Purpose:** Converts AI output to beautiful HTML email\n\n**Features:**\n- Professional gradient header\n- Responsive table design\n- Priority task numbering\n- Team member cards\n- Blocker status indicators\n- Mobile-friendly layout\n\n**Output:** HTML and plain text versions"
      },
      "typeVersion": 1
    },
    {
      "id": "0a16b85f-c088-48f4-a4a5-4f236a0a875b",
      "name": "Notiz: Slack Integration",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1488,
        -480
      ],
      "parameters": {
        "width": 246,
        "height": 299,
        "content": "## 💬 Slack Notification\n\n**Purpose:** Posts brief summary to Slack channel\n\n**Configuration Required:**\n- **Channel ID:** Replace `C09GNB90TED` with your channel ID\n- Get channel ID from Slack channel details\n\n**Features:**\n- Markdown formatting\n- Clickable ClickUp board link\n- Concise summary format\n\n**Setup:** Configure Slack OAuth2 credentials"
      },
      "typeVersion": 1
    },
    {
      "id": "e62daaeb-4688-42d1-92d1-663418816d80",
      "name": "Slack: Kurzbericht veröffentlichen",
      "type": "n8n-nodes-base.slack",
      "position": [
        -1536,
        -176
      ],
      "webhookId": "f9ae2b0d-06b5-46e2-9e4f-6133473fc6e4",
      "parameters": {
        "text": "=**Morning Brief** - {{ $('Format: Compose Brief Data').item.json.date }}**\n\n**Summary** - {{ $json.output.executiveSummary }}\n\n**Today's Priority** - {{ $json.output.todaysPriorities }} \n\n**Team's Focus** - {{ $json.output.teamFocus }}\n\nlink: <{{ $('Format: Compose Brief Data').item.json.clickupBoardUrl }}|View ClickUp Today Board>",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_SLACK_CHANNEL_ID"
        },
        "otherOptions": {
          "mrkdwn": true
        }
      },
      "credentials": {
        "slackApi": {
          "id": "rNqvWj9TfChPVRYY",
          "name": "Slack account vivek"
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "03f81896-e5e6-42a5-9b1f-cd7102b0091c",
      "name": "Notiz: E-Mail-Zustellung",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1168,
        48
      ],
      "parameters": {
        "width": 256,
        "height": 421,
        "content": "## 📨 Gmail Delivery\n\n**Purpose:** Sends formatted HTML email via Gmail\n\n**Configuration Required:**\n- **Recipient Email:** Replace `herevivekpatidar@gmail.com` with recipient\n- Can send to multiple recipients (comma-separated)\n\n**Email Content:**\n- HTML version with styling\n- Plain text fallback\n- Dynamic subject line\n\n**Setup:** Configure Gmail OAuth2 credentials"
      },
      "typeVersion": 1
    },
    {
      "id": "518dbe59-a863-444c-b34f-fa15529ade86",
      "name": "Notiz: Fehlerbehandlung",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3472,
        416
      ],
      "parameters": {
        "width": 379,
        "height": 329,
        "content": "## 🚨 Error Handling System\n\n**Purpose:** Catches workflow failures and sends alerts\n\n**Error Trigger:**\n- Activates when any node fails\n- Captures error details and context\n\n**Slack Alert:**\n- Posts to dedicated error channel\n- Includes error message, failed node name, and timestamp\n- Allows quick debugging"
      },
      "typeVersion": 1
    },
    {
      "id": "6213ae5c-d856-4db2-9dd2-fece957df490",
      "name": "Fehler-Trigger: Fehler abfangen",
      "type": "n8n-nodes-base.errorTrigger",
      "position": [
        -3344,
        256
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "865225c0-7954-4202-b893-f798b465d889",
      "name": "Slack: Fehlerbenachrichtigung",
      "type": "n8n-nodes-base.slack",
      "position": [
        -3120,
        256
      ],
      "webhookId": "9625246c-14d5-41a7-a11f-3162e1ad650b",
      "parameters": {
        "text": "=🚨 **Morning Brief Workflow Failed**\n\n*Error:* {{ $json.error.message }}\n*Node:* {{ $json.error.node.name }}\n*Time:* {{ $json.error.timestamp }}\n\nPlease check the workflow and retry manually.",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_ERROR_CHANNEL_ID",
          "cachedResultName": "errors"
        },
        "otherOptions": {
          "mrkdwn": true
        }
      },
      "credentials": {
        "slackApi": {
          "id": "rNqvWj9TfChPVRYY",
          "name": "Slack account vivek"
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "952212b7-d531-4d9e-ba24-49101e309aaa",
      "name": "Daten für E-Mail formatieren",
      "type": "n8n-nodes-base.code",
      "position": [
        -1536,
        32
      ],
      "parameters": {
        "jsCode": "// N8N Code Node - Enhanced Morning Brief HTML Email Formatter\nconst inputData = $input.all()[0].json.output;\n\n// Helper function to parse priorities into structured data\nfunction parsePriorities(text) {\n    const lines = text.split('\\n').filter(line => line.trim().startsWith('-'));\n    return lines.map(line => {\n        const cleanLine = line.replace(/^-\\s*/, '').trim();\n        const match = cleanLine.match(/^(.+?)\\s*\\(([^)]+)\\)$/);\n        if (match) {\n            return { task: match[1].trim(), assignee: match[2].trim() };\n        }\n        return { task: cleanLine, assignee: '' };\n    });\n}\n\n// Helper function to parse team focus by person\nfunction parseTeamFocus(text) {\n    const sections = text.split(/(?=[A-Z][a-z]+\\s+[A-Z][a-z]+:)/);\n    return sections.filter(s => s.trim()).map(section => {\n        const [name, ...tasks] = section.split(':');\n        return {\n            name: name.trim(),\n            tasks: tasks.join(':').trim()\n        };\n    });\n}\n\nconst priorities = parsePriorities(inputData.todaysPriorities);\nconst teamMembers = parseTeamFocus(inputData.teamFocus);\n\nconst html = `\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <title>${inputData.title}</title>\n    <!--[if mso]>\n    <style type=\"text/css\">\n        body, table, td {font-family: Arial, sans-serif !important;}\n    </style>\n    <![endif]-->\n</head>\n<body style=\"margin: 0; padding: 0; background-color: #f4f4f4;\">\n    <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"background-color: #f4f4f4;\">\n        <tr>\n            <td align=\"center\" style=\"padding: 20px 0;\">\n                \n                <!-- Main Container -->\n                <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"700\" style=\"background-color: #ffffff; border-radius: 8px; box-shadow: 0 2px 8px rgba(0,0,0,0.1);\">\n                    \n                    <!-- Header Section -->\n                    <tr>\n                        <td style=\"background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); padding: 30px; border-radius: 8px 8px 0 0;\">\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\">\n                                <tr>\n                                    <td>\n                                        <h1 style=\"margin: 0; color: #ffffff; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif; text-shadow: 0 2px 4px rgba(0,0,0,0.2);\">\n                                            📋 ${inputData.title}\n                                        </h1>\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                    \n                    <!-- Executive Summary Section -->\n                    <tr>\n                        <td style=\"padding: 30px 30px 20px 30px;\">\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"border-left: 4px solid #667eea; background-color: #f8f9ff; border-radius: 4px;\">\n                                <tr>\n                                    <td style=\"padding: 20px;\">\n                                        <h2 style=\"margin: 0 0 12px 0; color: #667eea; font-size: 16px; font-weight: bold; font-family: Arial, sans-serif; text-transform: uppercase; letter-spacing: 0.5px;\">\n                                            📊 EXECUTIVE SUMMARY\n                                        </h2>\n                                        <p style=\"margin: 0; color: #2d3748; font-size: 14px; line-height: 1.7; font-family: Arial, sans-serif;\">\n                                            ${inputData.executiveSummary}\n                                        </p>\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                    \n                    <!-- Today's Priorities Section -->\n                    <tr>\n                        <td style=\"padding: 10px 30px 20px 30px;\">\n                            <h2 style=\"margin: 0 0 15px 0; color: #2d3748; font-size: 18px; font-weight: bold; font-family: Arial, sans-serif; border-bottom: 3px solid #f56565; padding-bottom: 10px;\">\n                                🎯 TODAY'S PRIORITIES (${priorities.length} Tasks)\n                            </h2>\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"border-collapse: collapse; border: 1px solid #e2e8f0; border-radius: 4px; overflow: hidden;\">\n                                <tr>\n                                    <td width=\"60\" align=\"center\" style=\"background-color: #f56565; color: #ffffff; font-weight: bold; padding: 12px 8px; font-family: Arial, sans-serif; font-size: 13px;\">\n                                        #\n                                    </td>\n                                    <td style=\"background-color: #f56565; color: #ffffff; font-weight: bold; padding: 12px 15px; font-family: Arial, sans-serif; font-size: 13px;\">\n                                        Task Description\n                                    </td>\n                                    <td width=\"150\" style=\"background-color: #f56565; color: #ffffff; font-weight: bold; padding: 12px 15px; font-family: Arial, sans-serif; font-size: 13px;\">\n                                        Assigned To\n                                    </td>\n                                </tr>\n                                ${priorities.map((priority, index) => `\n                                <tr>\n                                    <td align=\"center\" style=\"background-color: ${index % 2 === 0 ? '#ffffff' : '#f7fafc'}; padding: 14px 8px; font-family: Arial, sans-serif; font-size: 14px; border-top: 1px solid #e2e8f0; font-weight: bold; color: #f56565;\">\n                                        ${index + 1}\n                                    </td>\n                                    <td style=\"background-color: ${index % 2 === 0 ? '#ffffff' : '#f7fafc'}; padding: 14px 15px; font-family: Arial, sans-serif; font-size: 13px; line-height: 1.5; border-top: 1px solid #e2e8f0; color: #2d3748;\">\n                                        ${priority.task}\n                                    </td>\n                                    <td style=\"background-color: ${index % 2 === 0 ? '#ffffff' : '#f7fafc'}; padding: 14px 15px; font-family: Arial, sans-serif; font-size: 13px; border-top: 1px solid #e2e8f0; color: #4a5568; font-weight: 600;\">\n                                        ${priority.assignee}\n                                    </td>\n                                </tr>\n                                `).join('')}\n                            </table>\n                        </td>\n                    </tr>\n                    \n                    <!-- In Progress Highlights Section -->\n                    <tr>\n                        <td style=\"padding: 10px 30px 20px 30px;\">\n                            <h2 style=\"margin: 0 0 15px 0; color: #2d3748; font-size: 18px; font-weight: bold; font-family: Arial, sans-serif; border-bottom: 3px solid #ed8936; padding-bottom: 10px;\">\n                                ⚡ IN PROGRESS HIGHLIGHTS\n                            </h2>\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"border-left: 4px solid #ed8936; background-color: #fffaf0; border-radius: 4px;\">\n                                <tr>\n                                    <td style=\"padding: 18px;\">\n                                        <p style=\"margin: 0; color: #2d3748; font-size: 14px; line-height: 1.7; font-family: Arial, sans-serif;\">\n                                            ${inputData.inProgressHighlights}\n                                        </p>\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                    \n                    <!-- Team Focus Section -->\n                    <tr>\n                        <td style=\"padding: 10px 30px 20px 30px;\">\n                            <h2 style=\"margin: 0 0 15px 0; color: #2d3748; font-size: 18px; font-weight: bold; font-family: Arial, sans-serif; border-bottom: 3px solid #48bb78; padding-bottom: 10px;\">\n                                👥 TEAM FOCUS & ASSIGNMENTS\n                            </h2>\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"border-collapse: collapse;\">\n                                ${teamMembers.map((member, index) => `\n                                <tr>\n                                    <td style=\"padding: ${index > 0 ? '15' : '0'}px 0 0 0;\">\n                                        <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"border: 2px solid #48bb78; border-radius: 6px; overflow: hidden; background-color: #f0fff4;\">\n                                            <tr>\n                                                <td style=\"background-color: #48bb78; padding: 12px 18px;\">\n                                                    <p style=\"margin: 0; color: #ffffff; font-size: 14px; font-weight: bold; font-family: Arial, sans-serif;\">\n                                                        👤 ${member.name}\n                                                    </p>\n                                                </td>\n                                            </tr>\n                                            <tr>\n                                                <td style=\"padding: 15px 18px;\">\n                                                    <p style=\"margin: 0; color: #2d3748; font-size: 13px; line-height: 1.7; font-family: Arial, sans-serif;\">\n                                                        ${member.tasks}\n                                                    </p>\n                                                </td>\n                                            </tr>\n                                        </table>\n                                    </td>\n                                </tr>\n                                `).join('')}\n                            </table>\n                        </td>\n                    </tr>\n                    \n                    <!-- Blockers Section -->\n                    <tr>\n                        <td style=\"padding: 10px 30px 20px 30px;\">\n                            <h2 style=\"margin: 0 0 15px 0; color: #2d3748; font-size: 18px; font-weight: bold; font-family: Arial, sans-serif; border-bottom: 3px solid ${inputData.blockers.toLowerCase().includes('all clear') ? '#48bb78' : '#f56565'}; padding-bottom: 10px;\">\n                                ${inputData.blockers.toLowerCase().includes('all clear') ? '✅' : '⚠️'} BLOCKERS & ISSUES\n                            </h2>\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"border-left: 4px solid ${inputData.blockers.toLowerCase().includes('all clear') ? '#48bb78' : '#f56565'}; background-color: ${inputData.blockers.toLowerCase().includes('all clear') ? '#f0fff4' : '#fff5f5'}; border-radius: 4px;\">\n                                <tr>\n                                    <td style=\"padding: 18px;\">\n                                        <p style=\"margin: 0; color: #2d3748; font-size: 15px; font-weight: ${inputData.blockers.toLowerCase().includes('all clear') ? 'bold' : 'normal'}; font-family: Arial, sans-serif; line-height: 1.6;\">\n                                            ${inputData.blockers}\n                                        </p>\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                    \n                    <!-- Action Button -->\n                    <tr>\n                        <td align=\"center\" style=\"padding: 25px 30px 35px 30px;\">\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                                <tr>\n                                    <td align=\"center\" style=\"background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); padding: 16px 45px; border-radius: 6px; box-shadow: 0 4px 6px rgba(0,0,0,0.1);\">\n                                        <a href=\"${inputData.clickupBoardUrl}\" style=\"color: #ffffff; text-decoration: none; font-weight: bold; font-size: 14px; font-family: Arial, sans-serif; display: block; letter-spacing: 0.5px;\">\n                                            🔗 VIEW FULL BOARD ON CLICKUP\n                                        </a>\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                    \n                    <!-- Footer -->\n                    <tr>\n                        <td style=\"background-color: #f7fafc; padding: 25px 30px; border-top: 1px solid #e2e8f0; border-radius: 0 0 8px 8px;\">\n                            <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\">\n                                <tr>\n                                    <td align=\"center\">\n                                        <p style=\"margin: 0; color: #718096; font-size: 12px; line-height: 1.6; font-family: Arial, sans-serif;\">\n                                            🤖 This brief was automatically generated by N8N Automation<br>\n                                            <strong style=\"color: #4a5568;\">Have a productive day! 🚀</strong>\n                                        </p>\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                    \n                </table>\n                \n            </td>\n        </tr>\n    </table>\n</body>\n</html>\n`;\n\n// Enhanced plain text version\nconst plainText = `${inputData.title}\n\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n📊 EXECUTIVE SUMMARY\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${inputData.executiveSummary}\n\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n🎯 TODAY'S PRIORITIES (${priorities.length} Tasks)\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${priorities.map((p, i) => `${i + 1}. ${p.task} → ${p.assignee}`).join('\\n')}\n\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n⚡ IN PROGRESS HIGHLIGHTS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${inputData.inProgressHighlights}\n\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n👥 TEAM FOCUS & ASSIGNMENTS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${teamMembers.map(m => `👤 ${m.name}\\n   ${m.tasks}`).join('\\n\\n')}\n\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${inputData.blockers.toLowerCase().includes('all clear') ? '✅' : '⚠️'} BLOCKERS & ISSUES\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${inputData.blockers}\n\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\nView Full Board: ${inputData.clickupBoardUrl}\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━`;\n\nreturn {\n  json: {\n    html: html,\n    subject: `📋 ${inputData.title}`,\n    plainText: plainText\n  }\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "78494f7e-40da-4c02-aa89-62dc1a3783e4",
      "name": "Morgen-Kurzbericht per E-Mail senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -1312,
        32
      ],
      "webhookId": "9e36fe20-bb0c-4c0a-8421-2f57096e79d7",
      "parameters": {
        "sendTo": "YOUR_EMAIL@example.com",
        "message": "={{ $json.html }}",
        "options": {},
        "subject": "={{ $json.subject }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "gEIaWCTvGfYjMSb3",
          "name": "Gmail credentials"
        }
      },
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "36a5ec42-fd1c-4215-9a66-eb98c6bc60c3",
  "connections": {
    "f336c158-207b-4ec0-8bf9-917a1ad7aabc": {
      "ai_memory": [
        [
          {
            "node": "e5fae6c6-9533-46b3-be91-0441dc52ad08",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "ff0eb47a-246d-4aed-8760-a09020487bbb": {
      "main": [
        [
          {
            "node": "997dcb26-240f-4ed0-86bb-9bcb302aaa47",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "997dcb26-240f-4ed0-86bb-9bcb302aaa47": {
      "main": [
        [
          {
            "node": "18dd7a8f-caad-4a73-b334-6d6140638834",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "952212b7-d531-4d9e-ba24-49101e309aaa": {
      "main": [
        [
          {
            "node": "78494f7e-40da-4c02-aa89-62dc1a3783e4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e5fae6c6-9533-46b3-be91-0441dc52ad08": {
      "main": [
        [
          {
            "node": "e62daaeb-4688-42d1-92d1-663418816d80",
            "type": "main",
            "index": 0
          },
          {
            "node": "952212b7-d531-4d9e-ba24-49101e309aaa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d1af24e4-dd4f-4e6b-bca7-340f1280624c": {
      "ai_languageModel": [
        [
          {
            "node": "e5fae6c6-9533-46b3-be91-0441dc52ad08",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "22bc18f9-01ab-4674-ba53-c72f7c71685c": {
      "main": [
        [
          {
            "node": "ff0eb47a-246d-4aed-8760-a09020487bbb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "357b93df-c039-4fde-90f3-6fec91193d32": {
      "ai_outputParser": [
        [
          {
            "node": "e5fae6c6-9533-46b3-be91-0441dc52ad08",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "351c23ff-37f5-4305-888b-9d41cd6af400": {
      "main": [
        [
          {
            "node": "22bc18f9-01ab-4674-ba53-c72f7c71685c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d76873cc-ba60-4cbe-9163-05e7b90baf26": {
      "main": [
        [
          {
            "node": "e5fae6c6-9533-46b3-be91-0441dc52ad08",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "18dd7a8f-caad-4a73-b334-6d6140638834": {
      "main": [
        [
          {
            "node": "d76873cc-ba60-4cbe-9163-05e7b90baf26",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6213ae5c-d856-4db2-9dd2-fece957df490": {
      "main": [
        [
          {
            "node": "865225c0-7954-4202-b893-f798b465d889",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}