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. 2n8n ์ธ์Šคํ„ด์Šค๋ฅผ ์—ด๊ณ  ์›Œํฌํ”Œ๋กœ โ†’ ์ƒˆ๋กœ ๋งŒ๋“ค๊ธฐ โ†’ ํŒŒ์ผ์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค.
  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 ๋ฌด๋ฃŒ๋กœ ์‹œ์ž‘ํ•˜๊ธฐ โ†’