Automate Change Request Workflow: Monday.com to Jira with Slack & Sheets — n8n 工作流

中 复杂度⏰ 定时12 个节点🏷️ Project Management作者：Rahul Joshi

概览

📊 Description Streamline IT and operations change management by automating approval routing, Jira issue creation, audit logging, and real-time Slack alerts. This workflow ensures faster reviews, traceable approvals, and transparent communication across systems. 🚀💼 What This Template Does Step 1: Triggers automatically every weekday at 3:00 AM to fetch new or updated change requests from Monday.com. ⏰ Step 2: Extracts key fields (request name, component, risk level, approvers, and description) fo

使用的节点

Google SheetsSlackJira SoftwareMonday.comGmail

工作流预览

🎯 Change Request Approval Workflow
Automated change management system that routes requests
What it does:
- Fetches change requests from Monday.com daily
- Rout
⏰ Daily Schedule
Runs weekdays at 3:00 AM to process change requests.
Schedule: Mon-Fri at 03:00
Cron: `0 3 * * 1-5`
Customize: Adjust timing based on your team's timezone
📋 Fetch Requests
Setup Required:
1. Replace `YOUR_BOARD_ID` with your Monday.com board I
2. Update `groupId` if using different group
3. Connect Monday.com credentials
Fetches: All chang
🔄 Data Transformation
Extracts and maps Monday.com columns to clean fields.
Mapped Fields:
- ID, Name, Status
- Component affected
- Approvers
🔀 Status Router
Routes requests based on status.
True Branch: Status = "Pending"
- Sends notification to stakeholders
False Branch: Status = "Approved" or "Rejected"
- Continues to next
💬 Slack Alert - Pending
Setup Required:
1. Replace `YOUR_CHANNEL_ID` with Slack channel ID
2. Connect Slack API credentials
Sends: Notification for pending approvals with all requ
✅ Approved Router
True Branch: Status = "Approved"
- Creates Jira ticket
- Logs to Google Sheets
False Branch: Status = "Rejected"
- Handles resubmission flow
🎫 Create Jira Issue
Setup Required:
1. Replace `YOUR_PROJECT_ID` with Jira project ID
2. Update issue type if needed
3. Connect Jira credentials
Creates: Task with request name and descri
📊 Audit Trail
Setup Required:
1. Replace `YOUR_SHEET_ID` with Google Sheets document
2. Replace `YOUR_SHEET_GID` with sheet tab ID
3. Connect Google OAuth2 credentials
Logs: All approv
💬 Slack Alert - Approved
Setup Required:
1. Use same Slack channel ID
2. Same credentials as pending notification
Sends: Confirmation with Jira ticket key for approved r
📧 Email Confirmation
Setup Required:
1. Replace `[email protected]` with recipient
2. Connect Gmail OAuth2 credentials
Sends: Professional confirmation email with Jira ticket
❌ Rejected Router
True Branch: Status = "Rejected"
- Creates resubmission item in Monday.com
False Branch: No action
- End of workflow for other statuses
🔄 Resubmission Handler
Setup Required:
1. Use same board ID as fetch node
2. Same Monday.com credentials
Creates: New item prefixed with "Resubmission:" for rej
⚡
S
Schedule Trigger
Fetch Change Requests
E
Extract Request Data
F
Filter Pending Requests
Notify Pending Request
F
Filter Approved Requests
Create Jira Ticket
Log to Google Sheets
Notify Approval
Send Confirmation Email
F
Filter Rejected Requests
Create Resubmission Item
12 nodes11 edges

工作原理

  1. 1

    触发器

    工作流由 定时 触发器启动，按预定计划运行。

  2. 2

    处理

    数据流经 12 个节点, connecting gmail, googlesheets, if。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (12)

GO

Google Sheets

googleSheets

#1
SL

Slack

slack

#2
JI

Jira Software

jira

#3
MO

Monday.com

mondayCom

#4
GM

Gmail

gmail

#5

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
  3. 3选择下载的 automate-change-request-workflow-mondaycom-to-jira-with-slack-sheets 文件并点击导入。
  4. 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
  5. 5点击 测试工作流 验证一切正常，然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴：

{ "name": "Automate Change Request Workflow: Monday.com to Jira with Slack & Sheets", "nodes": [...], ...}

集成

gmailgooglesheetsifjiramondaycomscheduletriggersetslack

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点12
复杂度medium
触发器scheduled
分类Project Management

创建者

Rahul Joshi

Rahul Joshi

@rahul08

标签

gmailgooglesheetsifjiramondaycomscheduletriggersetslack
⚡

n8n 新手？

n8n 是一款免费开源的工作流自动化工具，支持自托管或使用云版本。

免费获取 n8n →