Automatiser la génération de rapports matinaux quotidiens de ClickUp vers Slack et Gmail avec GPT-4

• •Compte Google et informations d'identification Gmail API
• •Token Bot Slack ou URL Webhook
• •Clé API OpenAI

{
  "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": "Note : Aperçu du workflow",
      "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": "Note : Déclencheur planifié",
      "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": "Déclencheur : Planification matinale",
      "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": "Note : Récupérer les sprints",
      "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": "Obtenir toutes les listes (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": "Note : Valider les données",
      "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": "Vérifier l'existence des listes",
      "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": "Note : Logique des sprints",
      "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": "Trouver le sprint le plus récent",
      "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": "Note : Récupération des tâches",
      "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": "Obtenir les tâches du dernier sprint",
      "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": "Note : Traitement des données",
      "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 : Composer les données du briefing",
      "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": "Note : Traitement IA",
      "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 : Générer le briefing",
      "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": "Analyseur de sortie structurée",
      "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 Modèle de chat",
      "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": "Mémoire simple",
      "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": "Note : Constructeur d'email",
      "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": "Note : Intégration Slack",
      "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 : Publier le briefing",
      "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": "Note : Envoi de l'email",
      "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": "Note : Gestion des erreurs",
      "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": "Déclencheur d'erreur : Capturer les échecs",
      "type": "n8n-nodes-base.errorTrigger",
      "position": [
        -3344,
        256
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "865225c0-7954-4202-b893-f798b465d889",
      "name": "Slack : Alerte d'erreur",
      "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": "Formater les données pour l'email",
      "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": "Envoyer l'email du briefing matinal",
      "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
          }
        ]
      ]
    }
  }
}