使用 Slack、Gmail 和 AI 自动化 Jira 待办事项整理和报告
高级
这是一个自动化工作流，包含 31 个节点。主要使用 If, Set, Jira, Gmail, Slack 等节点。 通过 Slack、Gmail 和 GPT-4 实现 Jira 待办事项整理与报告的自动化
前置要求
- •Google 账号和 Gmail API 凭证
- •Slack Bot Token 或 Webhook URL
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (31)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "0zvZIMYoz7Yavdpc",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "使用 Slack、Gmail 和 AI 自动化 Jira 待办事项整理和报告",
"tags": [],
"nodes": [
{
"id": "2c632cb2-a465-48a1-8615-646ae004a906",
"name": "工作流概览",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2208,
-672
],
"parameters": {
"color": 4,
"width": 389,
"height": 564,
"content": "## 🎯 待办事项整理与自动梳理"
},
"typeVersion": 1
},
{
"id": "ef8e559f-6e94-42c5-a70e-6cfd6ddea13f",
"name": "每日计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1680,
-416
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 9 * * 1-5"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "30388334-2118-4d6d-a355-cc01ecf97bf5",
"name": "注意 - 计划",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1760,
-272
],
"parameters": {
"width": 262,
"height": 237,
"content": "## ⏰ 工作日早晨"
},
"typeVersion": 1
},
{
"id": "c5ac2613-c23e-40c3-b0ff-0bb805b876e1",
"name": "获取 Jira 待办事项",
"type": "n8n-nodes-base.jira",
"position": [
-1456,
-416
],
"parameters": {
"options": {
"jql": "project = YOUR_PROJECT_KEY AND status in (\"Backlog\") ORDER BY created DESC"
},
"operation": "getAll",
"returnAll": true
},
"typeVersion": 1
},
{
"id": "c56145cd-e7bd-47f2-945d-331c491d2eab",
"name": "注意 - 获取",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1600,
-704
],
"parameters": {
"width": 262,
"height": 269,
"content": "## 📋 获取待办事项"
},
"typeVersion": 1
},
{
"id": "79cc28a5-7047-40ee-816e-ea61635ad230",
"name": "提取 Jira 字段",
"type": "n8n-nodes-base.set",
"position": [
-1232,
-416
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "65a9ad90-fc3a-4b15-a5db-57040972f1eb",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "a6e676d7-d345-4805-8947-c89246e250cb",
"name": "Status",
"type": "string",
"value": "={{ $json.fields.status.name }}"
},
{
"id": "329be7f5-f4b6-4c2d-8633-f4cc5c600f5a",
"name": "Last Updated",
"type": "string",
"value": "={{ $json.fields.updated }}"
},
{
"id": "6074d876-e5d4-4292-bdcc-dacce44367e9",
"name": "Created",
"type": "string",
"value": "={{ $json.fields.created }}"
},
{
"id": "f45794be-a5a2-4267-8959-6b3a628bdf33",
"name": "Assignee",
"type": "string",
"value": "={{ $json.fields.reporter?.displayName || 'Unassigned' }}"
},
{
"id": "d45594fe-3f25-4deb-9a33-1ae5da08a62a",
"name": "Due Date",
"type": "string",
"value": "={{ $json.fields.duedate || '' }}"
},
{
"id": "255fac2f-a504-4937-bfbb-4ab6d11ab85c",
"name": "Priority",
"type": "string",
"value": "={{ $json.fields.priority?.name || '' }}"
},
{
"id": "d1b9ba34-6836-470d-a4f8-06b50426f570",
"name": "key",
"type": "string",
"value": "={{ $json.key }}"
},
{
"id": "6df7df50-6844-498f-acad-125d0aac25e7",
"name": "email",
"type": "string",
"value": "={{ $json.fields.creator?.emailAddress || '' }}"
},
{
"id": "a4ffc18e-cc88-408d-bd22-fd915092b8c3",
"name": "Summary",
"type": "string",
"value": "={{ $json.fields.summary || $json.fields.issuetype.description }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "cfe06dcd-cc9d-4eaf-898c-0aa823aa9d2a",
"name": "注意 - 提取",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1296,
-256
],
"parameters": {
"width": 262,
"height": 309,
"content": "## 🔄 字段提取"
},
"typeVersion": 1
},
{
"id": "4c294ed5-4ae4-4d24-97f9-575cca486366",
"name": "记录到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1008,
-368
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Updated",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Updated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created",
"type": "string",
"display": true,
"required": false,
"displayName": "Created",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Assignee",
"type": "string",
"display": true,
"required": false,
"displayName": "Assignee",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Due Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Due Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Priority",
"type": "string",
"display": true,
"required": false,
"displayName": "Priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "key",
"type": "string",
"display": true,
"required": false,
"displayName": "key",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"id"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultName": "Backlogs"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_SHEET_ID",
"cachedResultName": "Backlog Audit Log"
}
},
"typeVersion": 4.7
},
{
"id": "684448c6-3f51-401c-8e3c-3e40db0b6ce2",
"name": "注意 - Sheets",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1056,
-480
],
"parameters": {
"width": 262,
"height": 285,
"content": "## 📊 审计追踪"
},
"typeVersion": 1
},
{
"id": "ef72046f-dd55-429d-be00-c9324dbccaf1",
"name": "检查逾期任务",
"type": "n8n-nodes-base.if",
"position": [
-1008,
-704
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c92605e8-e7aa-494b-86ba-ca0d20244af8",
"operator": {
"type": "dateTime",
"operation": "before"
},
"leftValue": "={{ $json[\"Due Date\"] }}",
"rightValue": "={{ new Date(Date.now())}}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b27e44f5-db46-4885-9f4a-c65ebecaeff7",
"name": "注意 - 逾期检查",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1152,
-992
],
"parameters": {
"width": 262,
"height": 261,
"content": "## ⏰ 逾期过滤器"
},
"typeVersion": 1
},
{
"id": "11751464-7ff3-40fa-8dd1-c78b008a0dd2",
"name": "通知问题负责人",
"type": "n8n-nodes-base.jira",
"position": [
-720,
-896
],
"parameters": {
"issueKey": "={{ $json.key }}",
"resource": "issue",
"operation": "notify",
"jiraVersion": "cloud",
"jsonParameters": false,
"additionalFields": {
"subject": "Overdue Task: {{ $json.Summary }}",
"textBody": "This issue is overdue and requires immediate attention. Please review and update the status or due date."
},
"notificationRecipientsUi": {
"notificationRecipientsValues": {
"users": [],
"groups": [],
"voters": false,
"assignee": true,
"reporter": true,
"watchers": false
}
},
"notificationRecipientsRestrictionsUi": {}
},
"typeVersion": 1
},
{
"id": "d52caf19-6f96-4565-be5d-ed34d3f55158",
"name": "注意 - Jira 通知",
"type": "n8n-nodes-base.stickyNote",
"position": [
-832,
-1168
],
"parameters": {
"width": 262,
"height": 253,
"content": "## 📧 Jira 通知"
},
"typeVersion": 1
},
{
"id": "ef9c4252-1781-4ee0-b0c7-583765206a89",
"name": "Slack 警报 - 逾期",
"type": "n8n-nodes-base.slack",
"position": [
-720,
-704
],
"webhookId": "2a85d9b8-5e35-4003-800d-670563648534",
"parameters": {
"text": "=🔴 *Overdue Backlog Item*\n\n*Summary:* {{ $json.Summary }}\n*Issue:* {{ $json.key }}\n*Due Date:* {{ $json['Due Date'] }}\n*Assignee:* {{ $json.Assignee }}\n*Status:* {{ $json.Status }}\n\nThis item is overdue and needs immediate attention.",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "YOUR_CHANNEL_ID",
"cachedResultName": "backlog-alerts"
},
"otherOptions": {}
},
"typeVersion": 2.3
},
{
"id": "30057434-63d2-4d55-a527-a7f20d9233c3",
"name": "注意 - Slack 逾期",
"type": "n8n-nodes-base.stickyNote",
"position": [
-736,
-752
],
"parameters": {
"width": 262,
"height": 221,
"content": "## 💬 Slack - 逾期"
},
"typeVersion": 1
},
{
"id": "1e90d54a-7e05-4cce-859c-ddd62cb498d6",
"name": "检查缺失优先级",
"type": "n8n-nodes-base.if",
"position": [
-720,
-512
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "630bf2fe-1811-4058-846e-04563f4d8530",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Priority }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "198c9966-323e-45a6-bdef-3dadb6c01105",
"name": "注意 - 优先级检查",
"type": "n8n-nodes-base.stickyNote",
"position": [
-768,
-320
],
"parameters": {
"width": 262,
"height": 309,
"content": "## 🏷️ 优先级检查"
},
"typeVersion": 1
},
{
"id": "cfca36aa-3f46-4027-8d29-5ef5137e338c",
"name": "标记为 'Needs-Priority'",
"type": "n8n-nodes-base.jira",
"position": [
-432,
-608
],
"parameters": {
"issueKey": "={{ $json.key }}",
"operation": "update",
"updateFields": {
"labels": "={{ [\"Needs-Priority\"] }}"
}
},
"typeVersion": 1
},
{
"id": "f02e8cae-0ec8-4779-a5b2-6a48ede692ea",
"name": "注意 - 标记",
"type": "n8n-nodes-base.stickyNote",
"position": [
-448,
-832
],
"parameters": {
"width": 262,
"height": 205,
"content": "## 🏷️ 自动标记问题"
},
"typeVersion": 1
},
{
"id": "11cc0368-975c-4bc0-a2ef-c467df83569d",
"name": "Slack 警报 - 缺失优先级",
"type": "n8n-nodes-base.slack",
"position": [
-432,
-416
],
"webhookId": "dfb76a4c-86f2-4812-87e9-f5c841be4336",
"parameters": {
"text": "=⚠️ *Missing Priority*\n\n*Summary:* {{ $json.Summary }}\n*Issue:* {{ $json.key }}\n*Assignee:* {{ $json.Assignee }}\n*Status:* {{ $json.Status }}\n*Due Date:* {{ $json['Due Date'] }}\n\nThis issue has been tagged with \"Needs-Priority\" label. Please assign a priority.",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "YOUR_CHANNEL_ID",
"cachedResultName": "backlog-alerts"
},
"otherOptions": {}
},
"typeVersion": 2.3
},
{
"id": "39461f27-b8b4-4d4c-baa9-bbc5f4ed29cc",
"name": "注意 - Slack 优先级",
"type": "n8n-nodes-base.stickyNote",
"position": [
-272,
-416
],
"parameters": {
"width": 262,
"height": 221,
"content": "## 💬 Slack - 优先级"
},
"typeVersion": 1
},
{
"id": "be03f5d0-6e99-44a8-8d3c-3c293fe58602",
"name": "聚合所有项目",
"type": "n8n-nodes-base.aggregate",
"position": [
-1008,
-176
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "5a04bac2-e1c5-4715-8413-776e5cd7f846",
"name": "注意 - 聚合",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1152,
64
],
"parameters": {
"width": 262,
"height": 258,
"content": "##"
},
"typeVersion": 1
},
{
"id": "289d850d-aeb2-475e-a810-822204ac98a6",
"name": "Generate AI Digest",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-784,
-176
],
"parameters": {
"text": "=Analyze the following Jira backlog items and generate an email for the project manager.\n\nEach item includes: issue ID, key, assignee, status, due date, priority, and summary.\n\nYour goal:\n- Identify overdue tasks (due date before today).\n- Highlight items with missing priority.\n- Summarize the overall backlog health.\n- Suggest 2-3 actionable steps to improve backlog hygiene.\n- Mention how many issues fall into each category.\n\nBacklog data:\n{{ JSON.stringify($json) }}",
"options": {
"systemMessage": "You are an automation assistant for project management and engineering teams.\nYour role is to analyze Jira backlog data and generate a professional HTML email for a project or engineering manager that summarizes the backlog health and highlights key actions.\n\nOutput Requirements:\n- The output must be a valid JSON object with two keys:\n {\n \"Subject\": \"<email subject line>\",\n \"Body\": \"<HTML formatted email body>\"\n }\n\nFormatting & Tone Guidelines:\n- Maintain a clear, concise, and professional business tone.\n- Use semantic HTML tags such as <p>, <ul>, <li>, <strong>, <em>, and <table> for readability.\n- Do not include any Markdown or code formatting.\n- The HTML should be visually structured and ready to send directly via email.\n- Always start with a short greeting (e.g., \"Dear Project Manager,\").\n- Follow with a summary paragraph that states the purpose of the email (e.g., \"Here's the latest Jira backlog summary for this week.\").\n- Include clearly formatted sections for:\n 1. Overdue Tasks\n 2. Missing Priorities\n 3. General Backlog Health\n- Add an HTML table if helpful for listing issue details (Key, Summary, Assignee, Due Date, Priority).\n- End the email with an \"Actionable Recommendations\" section listing 2-3 clear next steps.\n- Close politely (e.g., \"Regards, Backlog Hygiene Assistant\").\n- Keep the email content under 300 words.\n\nBehavior:\n- Analyze patterns and highlight areas needing attention.\n- Summarize counts of overdue, missing priority, or stale issues.\n- Suggest actionable next steps to improve backlog hygiene.\n- The output must be clean, valid JSON and contain no Markdown or triple backticks."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "3a297cb4-3dde-4a58-88a1-a127062b3fca",
"name": "Note - AI Analysis",
"type": "n8n-nodes-base.stickyNote",
"position": [
-864,
32
],
"parameters": {
"width": 262,
"height": 309,
"content": "## 🤖 AI Analysis Engine\n\n**What it does:**\n- Analyzes all backlog items using AI\n- Identifies patterns and trends\n- Generates structured JSON output with Subject and HTML Body\n\n**Requires:** Azure OpenAI credentials and structured output parser"
},
"typeVersion": 1
},
{
"id": "53379a85-d8d5-4be5-bf67-e8df4e4098d7",
"name": "Azure OpenAI Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
-768,
64
],
"parameters": {
"model": "gpt-4o-mini",
"options": {}
},
"typeVersion": 1
},
{
"id": "c78017ec-f5b1-48ce-8586-fef3d75e35a3",
"name": "Note - Azure",
"type": "n8n-nodes-base.stickyNote",
"position": [
-960,
-176
],
"parameters": {
"width": 262,
"height": 237,
"content": "## 🔗 AI Model Config\n\n**Setup Required:**\n1. Replace credential ID with your Azure OpenAI credentials\n2. Model: gpt-4o-mini (cost-effective)\n\n**Connects:** To AI agent for language processing"
},
"typeVersion": 1
},
{
"id": "6364596e-43e2-402a-a285-1740094c475f",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-640,
64
],
"parameters": {
"jsonSchemaExample": "{\n\t\"Subject\": \"\",\n\t\"Body\": \"\"\n}"
},
"typeVersion": 1.3
},
{
"id": "8a53abde-9f29-41c7-9917-ccee228748a4",
"name": "Note - Parser",
"type": "n8n-nodes-base.stickyNote",
"position": [
-592,
64
],
"parameters": {
"width": 262,
"height": 205,
"content": "## 📋 Output Parser\n\nEnsures AI returns valid JSON with:\n- Subject: Email subject line\n- Body: HTML formatted email\n\n**No setup required** - connects to AI agent automatically"
},
"typeVersion": 1
},
{
"id": "32153f43-2620-40d6-98d9-7793d756d206",
"name": "Email Weekly Digest",
"type": "n8n-nodes-base.gmail",
"position": [
-432,
-176
],
"webhookId": "0ce2113a-ca08-405d-8a8b-58218e48cc02",
"parameters": {
"sendTo": "YOUR_EMAIL@example.com",
"message": "={{ $json.output.Body }}",
"options": {},
"subject": "={{ $json.output.Subject }}"
},
"typeVersion": 2.1
},
{
"id": "e71a8d4b-aff9-457c-bcbb-b521f9333bd2",
"name": "Note - Email",
"type": "n8n-nodes-base.stickyNote",
"position": [
-288,
-80
],
"parameters": {
"width": 262,
"height": 301,
"content": "## 📧 Send AI Digest\n\n**Setup Required:**\n1. Replace `YOUR_EMAIL@example.com` with manager's email\n2. Connect Gmail OAuth2 credentials\n\n**Sends:** AI-generated HTML email with backlog summary and actionable recommendations"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a3faef09-d8b1-4083-baab-1ec097f35b4e",
"connections": {
"Azure OpenAI Model": {
"ai_languageModel": [
[
{
"node": "Generate AI Digest",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Fetch Jira Backlog": {
"main": [
[
{
"node": "Extract Jira Fields",
"type": "main",
"index": 0
}
]
]
},
"Generate AI Digest": {
"main": [
[
{
"node": "Email Weekly Digest",
"type": "main",
"index": 0
}
]
]
},
"Aggregate All Items": {
"main": [
[
{
"node": "Generate AI Digest",
"type": "main",
"index": 0
}
]
]
},
"Check Overdue Tasks": {
"main": [
[
{
"node": "Notify Issue Owner",
"type": "main",
"index": 0
},
{
"node": "Slack Alert - Overdue",
"type": "main",
"index": 0
}
],
[
{
"node": "Check Missing Priority",
"type": "main",
"index": 0
}
]
]
},
"Extract Jira Fields": {
"main": [
[
{
"node": "Aggregate All Items",
"type": "main",
"index": 0
},
{
"node": "Check Overdue Tasks",
"type": "main",
"index": 0
},
{
"node": "Log to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Check Missing Priority": {
"main": [
[
{
"node": "Tag with 'Needs-Priority'",
"type": "main",
"index": 0
},
{
"node": "Slack Alert - Missing Priority",
"type": "main",
"index": 0
}
]
]
},
"Daily Schedule Trigger": {
"main": [
[
{
"node": "Fetch Jira Backlog",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Generate AI Digest",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
从Monday.com和Jira到Outlook的AI驱动反馈分类与报告
使用Azure GPT-4、Jira任务和Outlook报告分析来自Monday.com的客户反馈
Set
Code
Jira
+12
27 节点Rahul Joshi
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
文档提取
使用 Monday.com、Jira、Slack 和 Google Sheets 自动化变更请求审批
使用Monday.com、Jira、Slack和Google Sheets自动化变更请求审批
If
Set
Jira
+6
25 节点Rahul Joshi
项目管理
从 Monday.com 到 Jira、Slack 和 Google Sheets 的简化变更请求审查
自动化变更请求工作流：从Monday.com到Jira，集成Slack和Sheets
If
Set
Jira
+6
25 节点Rahul Joshi
从 Stripe 支付自动交付模板给客户
使用Stripe、GPT-4o和Gmail的自动化模板交付系统
If
Code
Gmail
+12
44 节点Rahul Joshi
客户关系管理
客户入职帮助请求（Typeform 到 Gmail 和 Sheets）
客户入职帮助请求（Typeform 到 Gmail 和 Sheets）
If
Code
Gmail
+10
28 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量31
分类-
节点类型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 查看 →
分享此工作流