GPT-4를 사용하여 ClickUp에서 Slack과 Gmail로 일일 아침 뉴스 생성 자동화
고급
이것은자동화 워크플로우로, 27개의 노드를 포함합니다.주로 If, Code, Gmail, Slack, ClickUp 등의 노드를 사용하며. GPT-4o를 사용하여 ClickUp에서 AI 주도 아침 뉴스 생성하고 Slack, Gmail에 전송
사전 요구사항
- •Google 계정 및 Gmail API 인증 정보
- •Slack Bot Token 또는 Webhook URL
- •OpenAI API Key
사용된 노드 (27)
카테고리
-
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"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: 워크플로우 개요",
"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: 스케줄 트리거",
"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: 아침 스케줄",
"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: 스프린트 가져오기",
"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": "Get All Lists (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: 데이터 검증",
"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": "Check Lists Exist",
"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: 스프린트 로직",
"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": "Find Latest Sprint",
"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: 작업 항목 조회",
"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": "Get Task From Latest 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: 데이터 처리",
"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: 간략 데이터 구성",
"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: AI 처리",
"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: 보고서 생성",
"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": "Structured Output 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": "Simple Memory",
"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: 이메일 빌더",
"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: 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: 보고서 게시",
"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: 이메일 전송",
"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: 오류 관리",
"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": "Error Trigger: 오류 감지",
"type": "n8n-nodes-base.errorTrigger",
"position": [
-3344,
256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "865225c0-7954-4202-b893-f798b465d889",
"name": "Slack: 오류 알림",
"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": "Format Data For 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": "Send Morning Brief Email",
"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
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
고객 입사 도움 요청 (Typeform → Gmail 및 Sheets)
고객 입사 도움 요청 (Typeform에서 Gmail과 Sheets로)
If
Code
Gmail
+
If
Code
Gmail
28 노드Rahul Joshi
콘텐츠 제작
ClickUp와 GoHighLevel에서 자동으로 Slack, 이메일, Google 클라우드 스토리지로 일일 종료 보고서 생성
ClickUp과 GoHighLevel을 사용하여 AI 주도 일일 종료 보고서 생성
If
Code
Merge
+
If
Code
Merge
29 노드Rahul Joshi
Monday.com 및 Jira에서 Outlook으로의 AI 기반 피드백 분류 및 보고
Azure GPT-4, Jira 작업, Outlook 보고서를 사용한 Monday.com의 고객 피드백 분석
Set
Code
Jira
+
Set
Code
Jira
27 노드Rahul Joshi
Slack, Gmail 및 AI를 사용한 Jira 백로그 정리 및 보고 자동화
Slack, Gmail 및 GPT-4를 통한 Jira 할 일 정리 및 보고 자동화
If
Set
Jira
+
If
Set
Jira
31 노드Rahul Joshi
릴리스 노트를 FAQ 스텁으로 변환(Jira/ClickUp)
GPT-4o를 사용한 ClickUp에서 Notion 및 Slack으로 릴리스 노트 자동 생성
If
Code
Gmail
+
If
Code
Gmail
20 노드Rahul Joshi
엔지니어링
Stripe 결제에서 고객에게 템플릿 자동 전달
사용Stripe、GPT-4o및Gmail의자동화模板交付系统
If
Code
Gmail
+
If
Code
Gmail
44 노드Rahul Joshi
고객관계관리
워크플로우 정보
난이도
고급
노드 수27
카테고리-
노드 유형12
저자
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
외부 링크
n8n.io에서 보기 →
이 워크플로우 공유