Automate Change Request Approvals with Monday.com, Jira, Slack & Google 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) for

使用的节点

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
- Rou
⏰ 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
📄 Data Transformation
Extracts and maps Monday.com columns to clean fields.
Mapped Fields:
- ID, Name, Status
- Component affected
- Approvers
💬 Slack Alert - Pending
Setup Required:
1. Replace channel ID with your 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. Select your Jira project from the dropdown
2. Update issue type if needed
3. Connect Jira credentials
Creates: Task with request name and descripti
📊 Audit Trail
Setup Required:
1. Select your Google Sheets document from the dropdown
2. Select the sheet tab to log data
3. Connect Google OAuth2 credentials
Logs: All approved requests
📧 Email Confirmation
Setup Required:
1. Replace email address 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
💬 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
🔀 Status Router
Routes requests based on status.
True Branch: Status = "Pending"
- Sends notification to stakeholders
False Branch: Status = "Approved" or "Rejected"
- Continues to nex
📋 Fetch Requests
Setup Required:
1. Replace board ID with your Monday.com board ID
2. Update groupId if using different group
3. Connect Monday.com credentials
Fetches: All change reques
R
Route by Risk Level
R
Route High Risk by Compo…
R
Route Low Risk by Compon…
Get many items
E
Edit Fields
Notify Stackholder Pendi…
Create an issue
Notify Stackholder Appro…
Resubmission Request
Append or update row in …
Send a message
⚡
S
Schedule Trigger
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-approvals-with-mondaycom-jira-slack-google-sheets 文件并点击导入。
  4. 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
  5. 5点击 测试工作流 验证一切正常，然后激活它。

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

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

集成

gmailgooglesheetsifjiramondaycomscheduletriggersetslack

获取此工作流

一键下载并导入

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

创建者

Rahul Joshi

Rahul Joshi

@rahul08

标签

gmailgooglesheetsifjiramondaycomscheduletriggersetslack
⚡

n8n 新手？

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

免费获取 n8n →