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