내 워크플로 3

• •Google 계정 및 Gmail API 인증 정보
• •Slack Bot Token 또는 Webhook URL
• •Google Sheets API 인증 정보

{
  "id": "Fcfrid6ngpoXepqq",
  "meta": {
    "instanceId": "1b9b471cfc35c494898c60da53fb540b12dc98f14d03ea21d431e8d5b791e453",
    "templateCredsSetupCompleted": true
  },
  "name": "My workflow 3",
  "tags": [],
  "nodes": [
    {
      "id": "0598aff8-ffec-4b53-93fb-3ac7ceb6e526",
      "name": "메시지 보내기",
      "type": "n8n-nodes-base.gmail",
      "position": [
        440,
        -40
      ],
      "webhookId": "3687c0d7-061d-455c-ae4d-4bb359ad7f02",
      "parameters": {
        "sendTo": "={{ $('Google Sheets Trigger').item.json.Email }}",
        "message": "=Hey  {{ $('Google Sheets Trigger').item.json.Name }}!\n\nWe see tha that your Problem is \"{{ $('Google Sheets Trigger').item.json.Description }}\"We got your query and our team is working on it. We assure you that the problem will be solved Really Soon.\n\nReach out to us in case of any help\n\nThank you\nRegards,\nN8n Team",
        "options": {},
        "subject": "Ticket Created.!",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "ZMzKWeOEZrE9sTaD",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "4c92f186-5abb-469d-bb7a-68acefab039b",
      "name": "메시지 보내기1",
      "type": "n8n-nodes-base.slack",
      "position": [
        220,
        100
      ],
      "webhookId": "ee9e11b2-0985-4109-acde-7d8dd9326c98",
      "parameters": {
        "text": "=> Hello Team,A new entry has been added to the google sheets Node. The details are as follows.\nName : {{ $json.Name }}\nEmail : {{ $json.Email }}\nPhone Number : {{ $json['Phone Number']}}\nProblem Desc : {{ $json.Description }}\n\nPlease handle the client's request as stated in the problem.",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "id",
          "value": "=C095F7HDKUL"
        },
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "OdtF4hNnEI1ZoAeW",
          "name": "Slack account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "63e9d67e-4a0f-41f2-9fd5-209abadbdcc3",
      "name": "Google Sheets 트리거",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -20,
        -40
      ],
      "parameters": {
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xJn861StZtmTop8c2WBqf4SvGziT0use3zVCjT4n9-o/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xJn861StZtmTop8c2WBqf4SvGziT0use3zVCjT4n9-o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xJn861StZtmTop8c2WBqf4SvGziT0use3zVCjT4n9-o/edit?usp=drivesdk",
          "cachedResultName": "Sheet Problem 1"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "nAgyMUqKLfbGhYao",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "81b76d73-f77b-4279-b9ab-a7988a0925ce",
      "name": "연락처 생성",
      "type": "n8n-nodes-base.googleContacts",
      "position": [
        720,
        80
      ],
      "parameters": {
        "givenName": "={{ $('Google Sheets Trigger').item.json.Name }}",
        "familyName": "={{ $('Google Sheets Trigger').item.json.Name }}",
        "additionalFields": {
          "phoneUi": {
            "phoneValues": [
              {
                "type": "mobile",
                "value": "={{ \"\" + $('Google Sheets Trigger').item.json[\"Phone Number\"] }}\n"
              }
            ]
          }
        }
      },
      "credentials": {
        "googleContactsOAuth2Api": {
          "id": "byyhcVKR8Z9Leibf",
          "name": "Google Contacts account"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "3236b95c-d19f-43c3-b0fe-25e64a04f84f",
  "connections": {
    "0598aff8-ffec-4b53-93fb-3ac7ceb6e526": {
      "main": [
        [
          {
            "node": "81b76d73-f77b-4279-b9ab-a7988a0925ce",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4c92f186-5abb-469d-bb7a-68acefab039b": {
      "main": [
        [
          {
            "node": "0598aff8-ffec-4b53-93fb-3ac7ceb6e526",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "63e9d67e-4a0f-41f2-9fd5-209abadbdcc3": {
      "main": [
        [
          {
            "node": "4c92f186-5abb-469d-bb7a-68acefab039b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}