8
n8n 中文网amn8n.com

使用 Monday.com、Jira、Slack 和 Google Sheets 自动化变更请求审批

高级

这是一个Project Management领域的自动化工作流，包含 25 个节点。主要使用 If, Set, Jira, Gmail, Slack 等节点。 使用Monday.com、Jira、Slack和Google Sheets自动化变更请求审批

前置要求
  • •Google 账号和 Gmail API 凭证
  • •Slack Bot Token 或 Webhook URL
  • •Google Sheets API 凭证

使用的节点 (25)

If
Set
Jira
Gmail
Slack
MondayCom
StickyNote
GoogleSheets
ScheduleTrigger

分类

项目管理
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "qcrbyv2z8OnQhJ8F",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "使用 Monday.com、Jira、Slack 和 Google Sheets 自动化变更请求审批",
  "tags": [],
  "nodes": [
    {
      "id": "4415994b-5b1d-4277-9089-201f714d2770",
      "name": "工作流概览",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2400,
        160
      ],
      "parameters": {
        "color": 4,
        "width": 389,
        "height": 829,
        "content": "## 🎯 变更请求审批工作流"
      },
      "typeVersion": 1
    },
    {
      "id": "c051e25e-ccee-4210-a131-6ba155486876",
      "name": "注意 - 调度",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1936,
        112
      ],
      "parameters": {
        "width": 262,
        "height": 253,
        "content": "## ⏰ 每日计划"
      },
      "typeVersion": 1
    },
    {
      "id": "7a86c05e-6d0f-4996-a558-6b0c744715c5",
      "name": "注意 - 提取",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1520,
        96
      ],
      "parameters": {
        "width": 262,
        "height": 293,
        "content": "## 📄 数据转换"
      },
      "typeVersion": 1
    },
    {
      "id": "5c37acc1-3bc0-49af-8949-b0a816783513",
      "name": "注意 - 待处理 Slack",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1056,
        80
      ],
      "parameters": {
        "width": 262,
        "height": 258,
        "content": "## 💬 Slack 提醒 - 待处理"
      },
      "typeVersion": 1
    },
    {
      "id": "6543192f-0aed-4e37-b6a8-476c11079bd6",
      "name": "注意 - 已批准路由",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        656
      ],
      "parameters": {
        "width": 262,
        "height": 258,
        "content": "## ✅ 已批准路由器"
      },
      "typeVersion": 1
    },
    {
      "id": "d9053b68-9c61-42e1-a7ec-260daea118f6",
      "name": "注意 - Jira",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        32
      ],
      "parameters": {
        "width": 262,
        "height": 237,
        "content": "## 🎫 创建 Jira 问题"
      },
      "typeVersion": 1
    },
    {
      "id": "b7c1819c-59ec-4f8e-932e-1ef92c45be41",
      "name": "注意 - Sheets",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -768,
        736
      ],
      "parameters": {
        "width": 262,
        "height": 309,
        "content": "## 📊 审计追踪"
      },
      "typeVersion": 1
    },
    {
      "id": "42234c45-21e7-48c2-a9e7-cce57fb83764",
      "name": "注意 - 邮件",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -16
      ],
      "parameters": {
        "width": 262,
        "height": 301,
        "content": "## 📧 邮件确认"
      },
      "typeVersion": 1
    },
    {
      "id": "02732fa9-e577-47b8-a458-fb0cffdd572d",
      "name": "注意 - 已拒绝路由",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -512,
        896
      ],
      "parameters": {
        "width": 262,
        "height": 258,
        "content": "## ❌ 已拒绝路由器"
      },
      "typeVersion": 1
    },
    {
      "id": "602b9d11-71de-4fb2-af67-27962728ff67",
      "name": "注意 - 重新提交",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        880
      ],
      "parameters": {
        "width": 262,
        "height": 285,
        "content": "## 🔄 重新提交处理器"
      },
      "typeVersion": 1
    },
    {
      "id": "d07b2336-0cc0-4a83-a2a0-dbadf6c1bbee",
      "name": "注意 - 已批准 Slack",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        560
      ],
      "parameters": {
        "width": 262,
        "height": 269,
        "content": "## 💬 Slack 提醒 - 已批准"
      },
      "typeVersion": 1
    },
    {
      "id": "e4099998-608c-4273-9d5b-0bc057d83d69",
      "name": "注意 - 状态路由",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1280,
        608
      ],
      "parameters": {
        "width": 262,
        "height": 285,
        "content": "## 🔀 状态路由器"
      },
      "typeVersion": 1
    },
    {
      "id": "0902612f-4be1-4185-b750-c0a868710ded",
      "name": "注意 - 获取",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1584,
        592
      ],
      "parameters": {
        "width": 262,
        "height": 269,
        "content": "## 📋 获取请求"
      },
      "typeVersion": 1
    },
    {
      "id": "cd563c72-6ce4-41ef-81cd-ed6ba950dd65",
      "name": "按风险级别路由",
      "type": "n8n-nodes-base.if",
      "position": [
        -1008,
        400
      ],
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "={{ $json.Status }}",
              "value2": "Pending"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "88ca5e62-8d3d-44c6-bab1-30ea9e73e789",
      "name": "按组件路由高风险",
      "type": "n8n-nodes-base.if",
      "position": [
        -560,
        688
      ],
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "={{ $json.Status }}",
              "value2": "Rejected"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "a7f1bad3-2585-495b-a951-8a2fe767bd8d",
      "name": "按组件路由低风险",
      "type": "n8n-nodes-base.if",
      "position": [
        -784,
        496
      ],
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "={{ $json.Status }}",
              "value2": "Approved"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e209b20d-78f6-458f-af95-bbe964956487",
      "name": "获取多个项目",
      "type": "n8n-nodes-base.mondayCom",
      "position": [
        -1472,
        400
      ],
      "parameters": {
        "boardId": "5013238363",
        "groupId": "topics",
        "resource": "boardItem",
        "operation": "getAll"
      },
      "credentials": {
        "mondayComApi": {
          "id": "Kxmnf2TltEtJLxDA",
          "name": "Monday.com account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "783aa30c-2402-4899-9734-7f05fce7fe02",
      "name": "编辑字段",
      "type": "n8n-nodes-base.set",
      "position": [
        -1232,
        400
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a1970365-569f-4272-a0a1-cfb19592ae14",
              "name": "id",
              "type": "string",
              "value": "={{ $json.id }}"
            },
            {
              "id": "20ee1686-786d-4702-8786-562dd485ae77",
              "name": "name",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "3957374a-b750-40d9-889a-0b8cc320d317",
              "name": "Component affected",
              "type": "string",
              "value": "={{ $json.column_values[4].text }}"
            },
            {
              "id": "7724954e-5ab9-493d-ac12-f8da9754561b",
              "name": "Approvers",
              "type": "string",
              "value": "={{ $json.column_values[5].text }}"
            },
            {
              "id": "c749e528-e47e-4de6-b40a-8ae74acfcb52",
              "name": "Status",
              "type": "string",
              "value": "={{ $json.column_values[1].text }}"
            },
            {
              "id": "c74e1543-2ac9-46dc-aa93-0e45ca8f1dbd",
              "name": "Description",
              "type": "string",
              "value": "={{ $json.column_values[6].text }}"
            },
            {
              "id": "59caec12-5c47-498e-a784-28c3b92a2fb0",
              "name": "Risk Level",
              "type": "string",
              "value": "={{ $json.column_values[3].text }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "6cbf14f0-4022-48af-9f29-0a5b1a3803f7",
      "name": "通知相关方待处理请求",
      "type": "n8n-nodes-base.slack",
      "position": [
        -784,
        304
      ],
      "webhookId": "d987216d-dd09-4518-aacd-01fbda90908f",
      "parameters": {
        "text": "=📢 New Request Requires Your Approval \n\n *Name*{{ $json.name }}\n|*Request:* {{ $json.Description }}\n*Risk Level:* {{ $json['Risk Level'] }}\n*Component:* {{ $json['Component affected'] }}\n*Approver:* {{ $json.Approvers }}\n\nPlease review and update the status in Monday.com",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09GNB90TED",
          "cachedResultName": "general-information"
        },
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "rNqvWj9TfChPVRYY",
          "name": "Slack account vivek"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "39356117-0088-485e-a937-9a6f193f2efe",
      "name": "创建问题",
      "type": "n8n-nodes-base.jira",
      "position": [
        -560,
        304
      ],
      "parameters": {
        "project": {
          "__rl": true,
          "mode": "list",
          "value": "10001",
          "cachedResultName": "Kanban"
        },
        "summary": "={{ $json.name }}",
        "issueType": {
          "__rl": true,
          "mode": "list",
          "value": "10006",
          "cachedResultName": "Task"
        },
        "additionalFields": {
          "description": "={{ $json.Description }}"
        }
      },
      "credentials": {
        "jiraSoftwareCloudApi": {
          "id": "Q6d7sLBVOfGWmaLw",
          "name": "Jira SW Cloud account vivek"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "265a13bd-46ef-4152-8619-e81a7ded2b54",
      "name": "通知相关方审批请求",
      "type": "n8n-nodes-base.slack",
      "position": [
        -336,
        304
      ],
      "webhookId": "d987216d-dd09-4518-aacd-01fbda90908f",
      "parameters": {
        "text": "=📢 Approvals  \n\n*Name*{{ $('Route Low Risk by Component').item.json.name }}\n*Request:* {{ $('Route Low Risk by Component').item.json.Description }}\n*Risk Level:* {{ $('Route Low Risk by Component').item.json[\"Risk Level\"] }}\n*Component:* {{ $('Route Low Risk by Component').item.json[\"Component affected\"] }}\n*Approver:*{{ $('Route Low Risk by Component').item.json.Approvers }}  \n*Issue key:*https://herevivekpatidar.atlassian.net/jira/software/projects/KAN/boards/2?selectedIssue={{ $json.key }}\n\nPlease review it",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09GNB90TED",
          "cachedResultName": "general-information"
        },
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "rNqvWj9TfChPVRYY",
          "name": "Slack account vivek"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "7fd3b533-0233-47ac-ad7e-894157180e65",
      "name": "重新提交请求",
      "type": "n8n-nodes-base.mondayCom",
      "position": [
        -336,
        688
      ],
      "parameters": {
        "name": "=ReSubmission: {{ $json.name }}",
        "boardId": "5013238363",
        "groupId": "topics",
        "resource": "boardItem",
        "additionalFields": {}
      },
      "credentials": {
        "mondayComApi": {
          "id": "Kxmnf2TltEtJLxDA",
          "name": "Monday.com account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6ab4dfe5-ab90-44ff-9e41-f3dc4b7ec317",
      "name": "在表格中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -560,
        496
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Component affected",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Component affected",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Approvers",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Approvers",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Risk Level",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Risk Level",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [
            "id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 783581772,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/17rcNd_ZpUQLm0uWEVbD-NY6GyFUkrD4BglvawlyBygM/edit#gid=783581772",
          "cachedResultName": "Monday.com approved Request"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "17rcNd_ZpUQLm0uWEVbD-NY6GyFUkrD4BglvawlyBygM",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/17rcNd_ZpUQLm0uWEVbD-NY6GyFUkrD4BglvawlyBygM/edit?usp=drivesdk",
          "cachedResultName": "sample_leads_50"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "kpPEOLCGn963qpoh",
          "name": "automations@techdome.ai"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "64da0343-40c7-47bf-b8f5-01eee31f65f0",
      "name": "发送消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -112,
        304
      ],
      "webhookId": "99e219b6-cad9-4b59-a375-b673b065f7da",
      "parameters": {
        "sendTo": "herevivekpatidar@gmail.com",
        "message": "=Your change request has been approved.  \n\nName:{{ $('Route Low Risk by Component').item.json.name }} \nComponent affected:{{ $('Route Low Risk by Component').item.json[\"Component affected\"] }}\n\nJira Ticket: https://herevivekpatidar.atlassian.net/jira/software/projects/KAN/boards/2?selectedIssue={{ $('Create an issue').item.json.key }} \n\n\nPlease proceed with the implementation as planned.",
        "options": {},
        "subject": "Change Request Approved",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "gEIaWCTvGfYjMSb3",
          "name": "Gmail credentials"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "7de45a65-1eb9-48d5-b786-d55a9634ed0b",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1760,
        400
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 3 * * 1-5"
            }
          ]
        }
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "aa9aba93-360e-4986-be02-11313973c18f",
  "connections": {
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Route by Risk Level",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get many items": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create an issue": {
      "main": [
        [
          {
            "node": "Notify Stackholder Approval Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get many items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route by Risk Level": {
      "main": [
        [
          {
            "node": "Notify Stackholder Pending Request",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Route Low Risk by Component",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route Low Risk by Component": {
      "main": [
        [
          {
            "node": "Create an issue",
            "type": "main",
            "index": 0
          },
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Route High Risk by Component",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route High Risk by Component": {
      "main": [
        [
          {
            "node": "Resubmission Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notify Stackholder Approval Request": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

高级 - 项目管理

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

从 Monday.com 到 Jira、Slack 和 Google Sheets 的简化变更请求审查
自动化变更请求工作流：从Monday.com到Jira，集成Slack和Sheets
If
Set
Jira
+6
25 节点Rahul Joshi
使用 Slack、Gmail 和 AI 自动化 Jira 待办事项整理和报告
通过 Slack、Gmail 和 GPT-4 实现 Jira 待办事项整理与报告的自动化
If
Set
Jira
+9
31 节点Rahul Joshi
从Monday.com和Jira到Outlook的AI驱动反馈分类与报告
使用Azure GPT-4、Jira任务和Outlook报告分析来自Monday.com的客户反馈
Set
Code
Jira
+12
27 节点Rahul Joshi
GoHighLevel管道速度跟踪器和自动化停滞交易提醒
使用GoHighLevel、Gmail和Slack分析管道速度并提醒停滞交易
If
Code
Gmail
+5
25 节点Rahul Joshi
内容创作
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
文档提取
从 GoHighLevel 自动发送客户续约提醒到 Gmail 和 Slack
从GoHighLevel自动发送客户续约提醒到Gmail、Slack和Google Sheets
If
Code
Gmail
+7
19 节点Rahul Joshi
客户关系管理
工作流信息
难度等级
高级
节点数量25
分类1
节点类型9
难度说明

适合高级用户，包含 16+ 个节点的复杂工作流

作者
Rahul Joshi

Rahul Joshi

@rahul08

Rahul 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 查看 →

分享此工作流