Trelloベースの自動化サポートトケット管理と顧客通知システム

• •Googleアカウント + Gmail API認証情報
• •Slack Bot Token または Webhook URL

{
  "id": "9J2FyWzcbT7QeUy7",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae"
  },
  "name": "Automated Support Ticket & Customer Notification System with Trello",
  "tags": [],
  "nodes": [
    {
      "id": "d2d907c4-727e-4fbb-9ba5-4154c7f8327e",
      "name": "サポート受信箱を監視",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "filters": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        }
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "QFfaHpKmgq4YPiRN",
          "name": "temp"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "883b7b88-46af-419e-adf2-602d86696244",
      "name": "新規サポートチケット作成",
      "type": "n8n-nodes-base.trello",
      "position": [
        208,
        0
      ],
      "parameters": {
        "name": "=New Support Request from {{ $json.from }}",
        "listId": "YOUR_INCOMING_LIST_ID",
        "description": "=Subject: {{ $json.subject }} \nBody: {{ $json.body }}",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "sKY3UCBX3DQ86cOC",
          "name": "temp"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "bbd0b5a9-9916-464a-b2ae-fd810bdf21a5",
      "name": "自動確認メール送信",
      "type": "n8n-nodes-base.gmail",
      "position": [
        416,
        0
      ],
      "webhookId": "6bd6375f-c270-475d-8330-7356e42f39dd",
      "parameters": {
        "sendTo": "={{ $json.from }}",
        "message": "Hi there, thanks for reaching out. We've received your request and have created a new ticket. Our team will get back to you shortly.",
        "options": {},
        "subject": "=Re: {{ $json.subject }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "QFfaHpKmgq4YPiRN",
          "name": "temp"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "e86342f8-f202-46b4-8f19-537b59f13ae0",
      "name": "サポートチームへ通知",
      "type": "n8n-nodes-base.slack",
      "position": [
        624,
        0
      ],
      "webhookId": "31d46455-c6a7-4850-bc3f-7bec30c5a783",
      "parameters": {
        "text": "=*New Support Ticket!* A new ticket from *{{ $json.from }}* has been created in Trello.",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_SUPPORT_CHANNEL_ID"
        },
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "AFKF0YsguyhsagR0",
          "name": "temp"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "087529b4-b2d1-480b-9fff-67ca6b8e5365",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -64
      ],
      "parameters": {
        "width": 928,
        "height": 256,
        "content": "## Flow"
      },
      "typeVersion": 1
    },
    {
      "id": "12cd4344-0050-49d4-8a85-618c8d54c3a3",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        256
      ],
      "parameters": {
        "color": 3,
        "width": 912,
        "height": 1136,
        "content": "# Workflow Note: Automated Support Ticket & Customer Notification System\n\n---\n\n### **Problem**\nUnorganized support emails are a major source of friction for small to medium-sized businesses. Without a proper system, customer inquiries can get lost, leading to delayed response times and customer frustration. The lack of an automated confirmation for the customer leaves them in the dark, which can severely damage trust and brand reputation.\n\n### **Solution**\nThis is a straightforward but powerful n8n workflow designed to professionalize your customer support process. By integrating your support email with a project management or ticketing tool, the system ensures that every incoming support email is automatically converted into a trackable ticket. Simultaneously, it sends an instant, personalized confirmation email to the customer, providing them with peace of mind that their request has been received and is being handled.\n\n### **For Whom**\nThis workflow is ideal for **small businesses, e-commerce stores, and startups** that are growing their customer base and need a simple, effective way to manage support inquiries. It's a perfect solution for teams that want to transition from a messy shared inbox to an organized, responsive ticketing system without investing in an expensive, complex platform.\n\n### **Scope**\n* **What it includes:**\n    * An instant trigger for every new email sent to your support inbox.\n    * Automatic creation of a new ticket (e.g., a Trello card) with all the email details.\n    * An immediate, automated email reply to the customer confirming their message was received.\n    * Optional real-time notifications to your support team on Slack.\n\n* **What it excludes:**\n    * Advanced ticket routing or assignment logic.\n    * Automated follow-up sequences.\n    * Integration with a knowledge base or FAQ system.\n\n### **How to Set Up**\n\n1.  **Prerequisites:** You will need an n8n instance and accounts for **Gmail**, **Trello** (or a similar tool), and optionally **Slack**.\n2.  **Workflow Import:** Import the workflow's `.json` file into your n8n instance.\n3.  **Credential Configuration:**\n    * Set up credentials for **Gmail**, **Trello**, and **Slack** within n8n.\n4.  **Node-Specific Configuration:**\n    * **`Gmail Trigger`:** Specify the email address that will be monitored for new support requests.\n    * **`Trello` Node:** Enter your `Board ID` and the `List ID` where you want new tickets to be created.\n    * **`Gmail` Node:** Customize the automated confirmation email's subject and body to reflect your brand's voice.\n    * **`Slack` Node (Optional):** Enter the `Channel ID` for your support team's communication channel.\n5.  **Activation:** After all configurations are complete, click **\"Save\"** and then **\"Active\"**. The workflow is now live and will automatically manage your support inquiries."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d5b794f7-109b-4fbd-b416-dcbae272ad79",
  "connections": {
    "d2d907c4-727e-4fbb-9ba5-4154c7f8327e": {
      "main": [
        [
          {
            "node": "883b7b88-46af-419e-adf2-602d86696244",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "883b7b88-46af-419e-adf2-602d86696244": {
      "main": [
        [
          {
            "node": "bbd0b5a9-9916-464a-b2ae-fd810bdf21a5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bbd0b5a9-9916-464a-b2ae-fd810bdf21a5": {
      "main": [
        [
          {
            "node": "e86342f8-f202-46b4-8f19-537b59f13ae0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}