서비스 후 평가 수집기

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

{
  "id": "HpfD2OfzgRMPn3Jf",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "Post-Service Review Collector",
  "tags": [],
  "nodes": [
    {
      "id": "5ad55032-d22a-4bf5-8107-0de7a4b18d57",
      "name": "'워크플로 실행' 클릭 시",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -576,
        -96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d3590ccb-048d-45a7-b3df-fb0d73c58206",
      "name": "딜 조회 성공 검증",
      "type": "n8n-nodes-base.if",
      "position": [
        48,
        -96
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "e2adb005-2b3c-4d1e-8445-442df1fe925a",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.id }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "f7322a5c-5d60-491d-8bf2-f9c86cdf6a08",
      "name": "Google 시트에 오류 기록",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        368,
        480
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "error_id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "error_id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "error",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "error",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "error_id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1338537721,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Uldk_4BxWbdZTDZxFUeohIfeBmGHHqVEl9Ogb0l6R8Y/edit#gid=1338537721",
          "cachedResultName": "error log sheet"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Uldk_4BxWbdZTDZxFUeohIfeBmGHHqVEl9Ogb0l6R8Y",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Uldk_4BxWbdZTDZxFUeohIfeBmGHHqVEl9Ogb0l6R8Y/edit?usp=drivesdk",
          "cachedResultName": "Interviewer Brief Pack "
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "kpPEOLCGn963qpoh",
          "name": "automations@techdome.ai"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "9ba98d72-ea5f-48f3-a68b-51e888202b77",
      "name": "HighLevel에서 모든 성사된 딜 가져오기",
      "type": "n8n-nodes-base.highLevel",
      "position": [
        -224,
        -96
      ],
      "parameters": {
        "filters": {
          "status": "won"
        },
        "resource": "opportunity",
        "operation": "getAll",
        "requestOptions": {}
      },
      "credentials": {
        "highLevelOAuth2Api": {
          "id": "5QWHSi134dLIBEsC",
          "name": "HighLevel account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "f1c517f9-a54d-4691-ac3f-e7815fe4378b",
      "name": "개인화된 리뷰 요청 이메일 생성 (AI)",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        448,
        -112
      ],
      "parameters": {
        "text": "=Generate an HTML-formatted review-request email for a client who has just completed a project with our agency.  \nUse the following deal data to personalize the message:\n{{JSON.stringify($json)}}\n\nThe email should:\n1. Address the client by name.  \n2. Thank them for working with our agency.  \n3. Politely ask for their feedback and a quick public review.  \n4. Include two call-to-action buttons:\n   - One leading to the Google Review page: https://share.google/W3i4ulISiqRONADvO  \n   - Another leading to the internal Google Form: https://docs.google.com/forms/d/e/1FAIpQLScot2dbxFrx7jS8oTbQa3HZy9SSUtuB0iYch5U83UNNEwB9_g/viewform?usp=publish-editor  \n5. End with a warm closing line from the Techdome team.  \nKeep the tone professional, grateful, and concise.  \nReturn only the HTML email body—no markdown or explanations.\n",
        "options": {
          "systemMessage": "=You are an AI email writer for a client-success automation system.  \nYour task is to generate short, professional, visually clear HTML emails for clients after their project or service is completed.  \nThe tone should be friendly and appreciative, encouraging them to share feedback and public reviews.  \nAlways include clickable buttons styled with simple inline CSS (rounded corners, Techdome blue #1263ff).  \nDo not use markdown, return only HTML output.\n"
        },
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "643e6cad-4045-45f6-833b-1571769bc48e",
      "name": "GPT-4o 모델 설정",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        448,
        80
      ],
      "parameters": {
        "model": "gpt-4o",
        "options": {}
      },
      "credentials": {
        "azureOpenAiApi": {
          "id": "C3WzT18XqF8OdVM6",
          "name": "Azure Open AI account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5f536653-7ba9-449e-a79c-31fefe83c811",
      "name": "고객에게 리뷰 요청 이메일 전송",
      "type": "n8n-nodes-base.gmail",
      "position": [
        848,
        -112
      ],
      "webhookId": "0c82c299-6938-42ed-bda6-5007d79af34f",
      "parameters": {
        "sendTo": "=newscctv22@gmail.com",
        "message": "={{ $json.output }}",
        "options": {},
        "subject": "=Thank You for Working with Techdome .\n"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "RchiXdmY8WaQhOSJ",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "2c27e2a5-0daa-40a3-9a89-306166bb2e3f",
      "name": "응답 이메일 스레드 검색",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1312,
        -112
      ],
      "webhookId": "ffb3a844-8c8b-4f17-a6e9-98e0371f4214",
      "parameters": {
        "options": {},
        "resource": "thread",
        "threadId": "={{ $json.threadId }}",
        "operation": "get"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "RchiXdmY8WaQhOSJ",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "c33cb722-a2ef-400e-b593-4322e9b7a946",
      "name": "GPT-4o 모델1 설정",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        1568,
        128
      ],
      "parameters": {
        "model": "gpt-4o",
        "options": {}
      },
      "credentials": {
        "azureOpenAiApi": {
          "id": "C3WzT18XqF8OdVM6",
          "name": "Azure Open AI account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c9a7bf45-e0ba-4cb5-9374-a05098b89981",
      "name": "다음 작업 전 24시간 대기",
      "type": "n8n-nodes-base.wait",
      "position": [
        1088,
        -112
      ],
      "webhookId": "7475fece-4562-46b3-a702-7a5c5fe88266",
      "parameters": {
        "amount": 24
      },
      "typeVersion": 1
    },
    {
      "id": "4cfc001b-aa03-4a81-b7f4-e3d7ae01ad68",
      "name": "고객 피드백 요약 (AI)",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1568,
        -112
      ],
      "parameters": {
        "text": "=You are an AI assistant that summarizes client feedback threads for internal Slack updates.\n\nGiven the following Gmail thread JSON:\n{{JSON.stringify($json)}}\n\nCreate a short Slack message in this format:\n\n---\n🎉 *New Client Review Received!*\n\n*Client:* {{ $('Fetch All Won Deals from HighLevel').item.json.name }}\n*Feedback:* {{ $json.messages[1].snippet }}\n*Sentiment:* {{positive/neutral/negative}}  \n\n\n---\n\nKeep it concise, human-readable, and formatted for Slack (use Markdown formatting). Do not include HTML or JSON — return plain text formatted for Slack.\n",
        "options": {
          "systemMessage": "=You are a client-success AI summarizer. \nYour goal is to turn raw Gmail thread data (including “Thank you” replies) into short, clean, Slack-ready summaries. \nFocus on identifying who replied (client name), what they said, and the tone (positive/neutral/negative).\n"
        },
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "544bd495-5eb1-49e5-9a5f-b0d1a2ddf709",
      "name": "Slack에 리뷰 요약 공지",
      "type": "n8n-nodes-base.slack",
      "position": [
        1952,
        -112
      ],
      "webhookId": "ddaa7632-9e35-4bd3-82d6-572d5cae84cc",
      "parameters": {
        "text": "={{ $json.output }}",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": "U09HMPVD466",
          "cachedResultName": "newscctv22"
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "rNqvWj9TfChPVRYY",
          "name": "Slack account vivek"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "12cf47f3-4f3a-4146-a898-e15971639c97",
      "name": "스티키 노트",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        -912
      ],
      "parameters": {
        "width": 608,
        "height": 576,
        "content": "## How it works\nThis workflow automates the client-review process after a deal is marked as “Won” in HighLevel CRM.  \nIt starts manually or on trigger, retrieves the latest won deals, validates them, and uses Azure OpenAI GPT-4o to create a personalized HTML review-request email.  \nThe email thanks the client, includes links to leave a Google Review and fill an internal feedback form, and sends it automatically through Gmail.  \nAfter 24 hours, the workflow checks the client’s reply thread, summarizes the feedback tone using GPT-4o, and posts a concise Slack update for the internal team.  \nAny API or data errors are recorded in Google Sheets for transparency and debugging.\n\n## Setup steps\n1. Connect these credentials:\n   - HighLevel API  \n   - Azure OpenAI (GPT-4o)  \n   - Gmail  \n   - Slack  \n   - Google Sheets  \n2. Replace Sheet IDs and Slack user/channel references.  \n3. Update email subject, sender, and review links if needed.  \n4. Optionally schedule automatic triggers instead of manual runs.  \n5. Test once with a dummy “Won” deal to verify end-to-end flow.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "3524ab6d-22b6-4abd-abfa-33073738457a",
      "name": "스티키 노트1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        -304
      ],
      "parameters": {
        "color": 7,
        "width": 624,
        "height": 416,
        "content": "## Deal Fetch & Validation\nFetches all deals with “Won” status from HighLevel and checks for valid data before proceeding.  \nPrevents empty or incomplete deal entries from triggering the AI email generator.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "28f81e01-fbc4-4e12-aa3d-e343df9ef37e",
      "name": "스티키 노트2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        -288
      ],
      "parameters": {
        "color": 7,
        "width": 368,
        "height": 512,
        "content": "## AI-Powered Email Generation\nUses GPT-4o to craft a personalized, HTML review-request email.  \nIncludes thank-you text, brand-styled buttons for Google Reviews and internal feedback, and a warm closing line.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "d3be7c5b-de2b-4b78-9adc-9ab36c1cde69",
      "name": "스티키 노트3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        -336
      ],
      "parameters": {
        "color": 7,
        "height": 544,
        "content": "## Email Delivery\nSends the GPT-generated review-request email through Gmail to the client’s registered address.  \nTracks the sent message for later thread retrieval and analysis.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "6976f94f-eade-4846-8723-5a2eba0e71ac",
      "name": "스티키 노트4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -320
      ],
      "parameters": {
        "color": 7,
        "width": 432,
        "height": 496,
        "content": "## Waiting & Feedback Retrieval\nPauses for 24 hours to give clients time to reply, then fetches the full Gmail thread.  \nEnsures the latest feedback message is available for sentiment analysis.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "31e6f968-061d-4796-863f-9f5617a64f2d",
      "name": "스티키 노트5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1504,
        -352
      ],
      "parameters": {
        "color": 7,
        "width": 368,
        "height": 640,
        "content": "## AI Feedback Summarization\nGPT-4o analyzes the client’s response and creates a short Slack-formatted summary.  \nCaptures client name, key feedback, and overall sentiment (Positive/Neutral/Negative).\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0b0535cf-0afc-44bd-ac14-17ae2f83dd82",
      "name": "스티키 노트6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1888,
        -352
      ],
      "parameters": {
        "color": 7,
        "height": 464,
        "content": "## Slack Announcement\nPosts the summarized client feedback in a Slack channel.  \nNotifies the team in real time and helps track post-service satisfaction trends.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4d6af1bd-b453-42ac-a491-eb8266b74ba4",
      "name": "스티키 노트7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        304
      ],
      "parameters": {
        "color": 7,
        "height": 416,
        "content": "## Error Logging\nAppends any workflow or API issues to a shared Google Sheet.  \nMaintains an audit trail for error resolution and workflow reliability checks.\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a5d94f82-72ae-4824-9d7d-751ff361544f",
  "connections": {
    "643e6cad-4045-45f6-833b-1571769bc48e": {
      "ai_languageModel": [
        [
          {
            "node": "f1c517f9-a54d-4691-ac3f-e7815fe4378b",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "c33cb722-a2ef-400e-b593-4322e9b7a946": {
      "ai_languageModel": [
        [
          {
            "node": "4cfc001b-aa03-4a81-b7f4-e3d7ae01ad68",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "d3590ccb-048d-45a7-b3df-fb0d73c58206": {
      "main": [
        [
          {
            "node": "f1c517f9-a54d-4691-ac3f-e7815fe4378b",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "f7322a5c-5d60-491d-8bf2-f9c86cdf6a08",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4cfc001b-aa03-4a81-b7f4-e3d7ae01ad68": {
      "main": [
        [
          {
            "node": "544bd495-5eb1-49e5-9a5f-b0d1a2ddf709",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9ba98d72-ea5f-48f3-a68b-51e888202b77": {
      "main": [
        [
          {
            "node": "d3590ccb-048d-45a7-b3df-fb0d73c58206",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2c27e2a5-0daa-40a3-9a89-306166bb2e3f": {
      "main": [
        [
          {
            "node": "4cfc001b-aa03-4a81-b7f4-e3d7ae01ad68",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5f536653-7ba9-449e-a79c-31fefe83c811": {
      "main": [
        [
          {
            "node": "c9a7bf45-e0ba-4cb5-9374-a05098b89981",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5ad55032-d22a-4bf5-8107-0de7a4b18d57": {
      "main": [
        [
          {
            "node": "9ba98d72-ea5f-48f3-a68b-51e888202b77",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c9a7bf45-e0ba-4cb5-9374-a05098b89981": {
      "main": [
        [
          {
            "node": "2c27e2a5-0daa-40a3-9a89-306166bb2e3f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f1c517f9-a54d-4691-ac3f-e7815fe4378b": {
      "main": [
        [
          {
            "node": "5f536653-7ba9-449e-a79c-31fefe83c811",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}