GPT-4 を使って ClickUp から Slack および Gmail への毎日の朝報を自動化
上級
これは自動化ワークフローで、27個のノードを含みます。主にIf, Code, Gmail, Slack, ClickUpなどのノードを使用。 ClickUpからGPT-4oを使って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: Compose Brief Data",
"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: Generate Brief",
"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: Post Brief",
"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: Catch Failures",
"type": "n8n-nodes-base.errorTrigger",
"position": [
-3344,
256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "865225c0-7954-4202-b893-f798b465d889",
"name": "Slack: Error Alert",
"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 Driveへ毎日レポートを生成
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
Jira のタスク整理レポートをSlack、Gmail、AIで自動化
Slack、Gmail そして GPT-4 を使った Jira タスク整理とレポートの自動化
If
Set
Jira
+
If
Set
Jira
31 ノードRahul Joshi
リリースノートをよくある質問用に変換（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で表示 →
このワークフローを共有