Monday.com から Jira、Slack、Google Sheets へ変更要求レビューの簡略化
上級
これは自動化ワークフローで、25個のノードを含みます。主にIf, Set, Jira, Gmail, Slackなどのノードを使用。 変更依頼ワークフローを自動化:Monday.com から Jira へ、Slack と Sheets を統合
前提条件
- •Googleアカウント + Gmail API認証情報
- •Slack Bot Token または Webhook URL
- •Google Sheets API認証情報
カテゴリー
-
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "qcrbyv2z8OnQhJ8F",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "Streamline Change Request Reviews from Monday.com to Jira, Slack, and Google Sheets",
"tags": [],
"nodes": [
{
"id": "b8a91ff9-d449-45c9-b706-61e83d030052",
"name": "ワークフロー概要",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1440,
-512
],
"parameters": {
"color": 4,
"width": 389,
"height": 535,
"content": "## 🎯 Change Request Approval Workflow\n\nAutomated change management system that routes requests based on risk level and status.\n\n**What it does:**\n- Fetches change requests from Monday.com daily\n- Routes by status (Pending/Approved/Rejected)\n- Creates Jira tickets for approved requests\n- Logs approved requests to Google Sheets\n- Sends Slack notifications to stakeholders\n- Handles resubmissions for rejected requests\n\n**Use Case:** Perfect for IT teams managing change requests with approval workflows and risk-YOUR_OPENAI_KEY_HERE routing.\n\n**Required Setup:**\n- Monday.com board with change requests\n- Jira project for approved changes\n- Google Sheets for audit trail\n- Slack workspace for notifications\n- Gmail for email confirmations"
},
"typeVersion": 1
},
{
"id": "0bdc7dc2-9c82-4244-ac4b-705a9614327f",
"name": "スケジュールトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-880,
-240
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 3 * * 1-5"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "7d410d1e-b7c0-4437-a1bd-a3204182b655",
"name": "注記 - スケジュール",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1024,
-512
],
"parameters": {
"width": 262,
"height": 253,
"content": "## ⏰ Daily Schedule\n\nRuns weekdays at 3:00 AM to process change requests.\n\n**Schedule:** Mon-Fri at 03:00\n**Cron:** `0 3 * * 1-5`\n\n**Customize:** Adjust timing based on your team's timezone and workflow needs."
},
"typeVersion": 1
},
{
"id": "a88be726-9d70-4b65-b27e-8f6de2aa6000",
"name": "変更要求を取得",
"type": "n8n-nodes-base.mondayCom",
"position": [
-688,
-240
],
"parameters": {
"boardId": "YOUR_BOARD_ID",
"groupId": "topics",
"resource": "boardItem",
"operation": "getAll"
},
"typeVersion": 1
},
{
"id": "82495c67-2b53-4687-9403-d149fae710b6",
"name": "注記 - 取得",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-96
],
"parameters": {
"width": 262,
"height": 269,
"content": "## 📋 Fetch Requests\n\n**Setup Required:**\n1. Replace `YOUR_BOARD_ID` with your Monday.com board ID\n2. Update `groupId` if using different group\n3. Connect Monday.com credentials\n\n**Fetches:** All change request items from board"
},
"typeVersion": 1
},
{
"id": "34f52f17-bcae-4ee9-91b2-21bcf735715b",
"name": "要求データを抽出",
"type": "n8n-nodes-base.set",
"position": [
-464,
-240
],
"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": "711aebae-2618-4900-8b45-220ca132c4ba",
"name": "注記 - 抽出",
"type": "n8n-nodes-base.stickyNote",
"position": [
-592,
-544
],
"parameters": {
"width": 262,
"height": 293,
"content": "## 🔄 Data Transformation\n\nExtracts and maps Monday.com columns to clean fields.\n\n**Mapped Fields:**\n- ID, Name, Status\n- Component affected\n- Approvers\n- Description\n- Risk Level\n\n**Note:** Adjust column indices if your board structure differs"
},
"typeVersion": 1
},
{
"id": "5f7bbae1-47bd-4093-809b-0a108e4dd5fd",
"name": "保留中の要求をフィルタリング",
"type": "n8n-nodes-base.if",
"position": [
-240,
-240
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.Status }}",
"value2": "Pending"
}
]
}
},
"typeVersion": 1
},
{
"id": "67a96247-6ade-4425-b15d-a27dbc97945a",
"name": "注記 - ステータスルート",
"type": "n8n-nodes-base.stickyNote",
"position": [
-352,
-80
],
"parameters": {
"width": 262,
"height": 285,
"content": "## 🔀 Status Router\n\nRoutes requests based on status.\n\n**True Branch:** Status = \"Pending\"\n- Sends notification to stakeholders\n\n**False Branch:** Status = \"Approved\" or \"Rejected\"\n- Continues to next routing node"
},
"typeVersion": 1
},
{
"id": "7334c79d-6312-4102-878b-e71e6c74a391",
"name": "保留中の要求を通知",
"type": "n8n-nodes-base.slack",
"position": [
-16,
-336
],
"webhookId": "4d3540d3-4828-43ec-a1b9-570a9b02f187",
"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": "YOUR_CHANNEL_ID",
"cachedResultName": "change-requests"
},
"otherOptions": {}
},
"typeVersion": 2
},
{
"id": "7e709062-4468-4156-8d6b-e5924dcd055d",
"name": "注記 - 保留中Slack",
"type": "n8n-nodes-base.stickyNote",
"position": [
-176,
-608
],
"parameters": {
"width": 262,
"height": 258,
"content": "## 💬 Slack Alert - Pending\n\n**Setup Required:**\n1. Replace `YOUR_CHANNEL_ID` with Slack channel ID\n2. Connect Slack API credentials\n\n**Sends:** Notification for pending approvals with all request details"
},
"typeVersion": 1
},
{
"id": "19f26741-55e1-4414-82e1-7e18eb2a25c6",
"name": "承認済み要求をフィルタリング",
"type": "n8n-nodes-base.if",
"position": [
-16,
-144
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.Status }}",
"value2": "Approved"
}
]
}
},
"typeVersion": 1
},
{
"id": "2e1b935e-9a0d-4ae6-8683-1aa981086636",
"name": "注記 - 承認済みルート",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
0
],
"parameters": {
"width": 262,
"height": 258,
"content": "## ✅ Approved Router\n\n**True Branch:** Status = \"Approved\"\n- Creates Jira ticket\n- Logs to Google Sheets\n\n**False Branch:** Status = \"Rejected\"\n- Handles resubmission flow"
},
"typeVersion": 1
},
{
"id": "38e773fd-a193-4768-a5b9-a08e09d995e5",
"name": "Jiraチケットを作成",
"type": "n8n-nodes-base.jira",
"position": [
224,
-336
],
"parameters": {
"project": {
"__rl": true,
"mode": "list",
"value": "YOUR_PROJECT_ID",
"cachedResultName": "Change Management"
},
"summary": "={{ $json.name }}",
"issueType": {
"__rl": true,
"mode": "list",
"value": "10006",
"cachedResultName": "Task"
},
"additionalFields": {
"description": "={{ $json.Description }}"
}
},
"typeVersion": 1
},
{
"id": "3b269183-16cb-472e-ad53-55eec45dcb7a",
"name": "注記 - Jira",
"type": "n8n-nodes-base.stickyNote",
"position": [
112,
-592
],
"parameters": {
"width": 262,
"height": 237,
"content": "## 🎫 Create Jira Issue\n\n**Setup Required:**\n1. Replace `YOUR_PROJECT_ID` with Jira project ID\n2. Update issue type if needed\n3. Connect Jira credentials\n\n**Creates:** Task with request name and description"
},
"typeVersion": 1
},
{
"id": "5c7ae18a-9006-4fe2-965b-9158dc97a071",
"name": "Google Sheetsに記録",
"type": "n8n-nodes-base.googleSheets",
"position": [
224,
-144
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Component affected",
"type": "string",
"display": true,
"required": false,
"displayName": "Component affected",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Approvers",
"type": "string",
"display": true,
"required": false,
"displayName": "Approvers",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Risk Level",
"type": "string",
"display": true,
"required": false,
"displayName": "Risk Level",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"id"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "YOUR_SHEET_GID",
"cachedResultName": "Approved Requests"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_SHEET_ID",
"cachedResultName": "Change Request Log"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "sOplQNr4zvwQul4A",
"name": "jyothi"
}
},
"typeVersion": 4.7
},
{
"id": "e9131c3a-0780-4327-a6aa-5dfa1b78c6f5",
"name": "注記 - Sheets",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
176
],
"parameters": {
"width": 262,
"height": 309,
"content": "## 📊 Audit Trail\n\n**Setup Required:**\n1. Replace `YOUR_SHEET_ID` with Google Sheets document ID\n2. Replace `YOUR_SHEET_GID` with sheet tab ID\n3. Connect Google OAuth2 credentials\n\n**Logs:** All approved requests for compliance tracking"
},
"typeVersion": 1
},
{
"id": "20d32c52-d750-46b6-96b9-de5973da359d",
"name": "承認を通知",
"type": "n8n-nodes-base.slack",
"position": [
448,
-336
],
"webhookId": "ec9807fb-4b9f-44be-869e-c8b47998bd34",
"parameters": {
"text": "=🔔 Request Approved\n\n*Name:* {{ $('Filter Approved Requests').item.json.name }}\n*Request:* {{ $('Filter Approved Requests').item.json.Description }}\n*Risk Level:* {{ $('Filter Approved Requests').item.json[\"Risk Level\"] }}\n*Component:* {{ $('Filter Approved Requests').item.json[\"Component affected\"] }}\n*Approver:* {{ $('Filter Approved Requests').item.json.Approvers }}\n*Jira Ticket:* {{ $json.key }}\n\nPlease proceed with implementation.",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "YOUR_CHANNEL_ID",
"cachedResultName": "change-requests"
},
"otherOptions": {}
},
"typeVersion": 2
},
{
"id": "f09cf9cc-1a82-4c7e-92f1-ee4c289d10da",
"name": "注記 - 承認済みSlack",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
-224
],
"parameters": {
"width": 262,
"height": 269,
"content": "## 💬 Slack Alert - Approved\n\n**Setup Required:**\n1. Use same Slack channel ID\n2. Same credentials as pending notification\n\n**Sends:** Confirmation with Jira ticket key for approved requests"
},
"typeVersion": 1
},
{
"id": "aeb63837-91ff-4cc6-bc41-8535632dfef5",
"name": "確認メールを送信",
"type": "n8n-nodes-base.gmail",
"position": [
672,
-336
],
"webhookId": "01e06999-8949-4cea-8b71-03196adf5bb9",
"parameters": {
"sendTo": "YOUR_EMAIL@example.com",
"message": "=Your change request has been approved.\n\nName: {{ $('Filter Approved Requests').item.json.name }}\nComponent affected: {{ $('Filter Approved Requests').item.json[\"Component affected\"] }}\n\nJira Ticket: {{ $('Create Jira Ticket').item.json.key }}\n\nPlease proceed with the implementation as planned.",
"options": {},
"subject": "Change Request Approved",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "70f5n8rPahCANHs7",
"name": "jyothi"
}
},
"typeVersion": 2.1
},
{
"id": "0af472d6-740a-4fba-9c8e-1048ae537732",
"name": "注記 - メール",
"type": "n8n-nodes-base.stickyNote",
"position": [
864,
-576
],
"parameters": {
"width": 262,
"height": 301,
"content": "## 📧 Email Confirmation\n\n**Setup Required:**\n1. Replace `YOUR_EMAIL@example.com` with recipient\n2. Connect Gmail OAuth2 credentials\n\n**Sends:** Professional confirmation email with Jira ticket link"
},
"typeVersion": 1
},
{
"id": "201bb8ec-0ef7-4477-b0f1-1e1edb305b1f",
"name": "却下された要求をフィルタリング",
"type": "n8n-nodes-base.if",
"position": [
224,
64
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.Status }}",
"value2": "Rejected"
}
]
}
},
"typeVersion": 1
},
{
"id": "b95b46e2-6495-4588-951a-d26e914460e1",
"name": "注記 - 却下ルート",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
224
],
"parameters": {
"width": 262,
"height": 258,
"content": "## ❌ Rejected Router\n\n**True Branch:** Status = \"Rejected\"\n- Creates resubmission item in Monday.com\n\n**False Branch:** No action\n- End of workflow for other statuses"
},
"typeVersion": 1
},
{
"id": "03d9109c-b8ed-4946-904f-0623d2460088",
"name": "再提出項目を作成",
"type": "n8n-nodes-base.mondayCom",
"position": [
448,
64
],
"parameters": {
"name": "=Resubmission: {{ $json.name }}",
"boardId": "YOUR_BOARD_ID",
"groupId": "topics",
"resource": "boardItem",
"additionalFields": {}
},
"typeVersion": 1
},
{
"id": "041490e8-5ad2-4333-8428-615b07fb2677",
"name": "注記 - 再提出",
"type": "n8n-nodes-base.stickyNote",
"position": [
736,
64
],
"parameters": {
"width": 262,
"height": 285,
"content": "## 🔄 Resubmission Handler\n\n**Setup Required:**\n1. Use same board ID as fetch node\n2. Same Monday.com credentials\n\n**Creates:** New item prefixed with \"Resubmission:\" for rejected requests"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ad65aef6-ec63-402b-b1b9-eac62f2064c3",
"connections": {
"20d32c52-d750-46b6-96b9-de5973da359d": {
"main": [
[
{
"node": "aeb63837-91ff-4cc6-bc41-8535632dfef5",
"type": "main",
"index": 0
}
]
]
},
"0bdc7dc2-9c82-4244-ac4b-705a9614327f": {
"main": [
[
{
"node": "a88be726-9d70-4b65-b27e-8f6de2aa6000",
"type": "main",
"index": 0
}
]
]
},
"38e773fd-a193-4768-a5b9-a08e09d995e5": {
"main": [
[
{
"node": "20d32c52-d750-46b6-96b9-de5973da359d",
"type": "main",
"index": 0
}
]
]
},
"34f52f17-bcae-4ee9-91b2-21bcf735715b": {
"main": [
[
{
"node": "5f7bbae1-47bd-4093-809b-0a108e4dd5fd",
"type": "main",
"index": 0
}
]
]
},
"a88be726-9d70-4b65-b27e-8f6de2aa6000": {
"main": [
[
{
"node": "34f52f17-bcae-4ee9-91b2-21bcf735715b",
"type": "main",
"index": 0
}
]
]
},
"5f7bbae1-47bd-4093-809b-0a108e4dd5fd": {
"main": [
[
{
"node": "7334c79d-6312-4102-878b-e71e6c74a391",
"type": "main",
"index": 0
}
],
[
{
"node": "19f26741-55e1-4414-82e1-7e18eb2a25c6",
"type": "main",
"index": 0
}
]
]
},
"19f26741-55e1-4414-82e1-7e18eb2a25c6": {
"main": [
[
{
"node": "38e773fd-a193-4768-a5b9-a08e09d995e5",
"type": "main",
"index": 0
},
{
"node": "5c7ae18a-9006-4fe2-965b-9158dc97a071",
"type": "main",
"index": 0
}
],
[
{
"node": "201bb8ec-0ef7-4477-b0f1-1e1edb305b1f",
"type": "main",
"index": 0
}
]
]
},
"201bb8ec-0ef7-4477-b0f1-1e1edb305b1f": {
"main": [
[
{
"node": "03d9109c-b8ed-4946-904f-0623d2460088",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は?
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか?
上級
有料ですか?
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。
関連ワークフロー
Monday.com、Jira、Slack、Google Sheets を使用した変更要求承認の自動化
Monday.com、Jira、Slack、Google Sheetsを使用して変更依頼承認を自動化
If
Set
Jira
+
If
Set
Jira
25 ノードRahul Joshi
プロジェクト管理
Jira のタスク整理レポートをSlack、Gmail、AIで自動化
Slack、Gmail そして GPT-4 を使った Jira タスク整理とレポートの自動化
If
Set
Jira
+
If
Set
Jira
31 ノードRahul Joshi
Monday.comやJiraからOutlookまでAI駆動のフィードバック分類とレポート
Azure GPT-4、Jiraタスク、Outlookレポートを使ってMonday.comからの顧客フィードバックを分析
Set
Code
Jira
+
Set
Code
Jira
27 ノードRahul Joshi
GoHighLevelパイプライン速度追跡ツールと自動化された停滞トランザクションアラート
GoHighLevel、Gmail、Slackを使用してパイプライン速度を分析し、停滞取引にアラートを発する
If
Code
Gmail
+
If
Code
Gmail
25 ノードRahul Joshi
コンテンツ作成
API速率制限と認証に関するFAQテスト
GPT-4o-mini、Googleスプレッドシート、Slackアラートを使用したAPIよくある質問品質テストの自動化
If
Set
Code
+
If
Set
Code
19 ノードRahul Joshi
文書抽出
GoHighLevel から顧客の续约リマインドを自動のに Gmail と Slack へ送信
GoHighLevelからGmail、Slack、Google Sheetsへ顧客更新の自動リマインダーを送信
If
Code
Gmail
+
If
Code
Gmail
19 ノードRahul Joshi
顧客管理
ワークフロー情報
難易度
上級
ノード数25
カテゴリー-
ノードタイプ9
作成者
Rahul Joshi
@rahul08Rahul 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で表示 →
このワークフローを共有