GoHighLevel、Gmail、Notionを使ったNPS調査の自動収集と応答処理

• •Googleアカウント + Gmail API認証情報
• •Notion API Key
• •ターゲットAPIの認証情報が必要な場合あり

{
  "id": "6l4TRFLY8lVlID78",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "Automate NPS Survey Collection & Response Handling with GoHighLevel, Gmail, and Notion",
  "tags": [],
  "nodes": [
    {
      "id": "98ddd287-3cf1-4455-b0b7-359d6dd0c408",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        -512
      ],
      "parameters": {
        "color": 5,
        "width": 389,
        "height": 656,
        "content": "## 📋 NPS Survey Automation Workflow\n\n### What This Workflow Does:\nThis workflow automatically sends NPS (Net Promoter Score) surveys to clients when their deals are marked as \"won\" in GoHighLevel CRM, then processes responses and takes action based on feedback scores.\n\n### Key Features:\n- ✅ Automatically detects completed deals from GHL\n- 📧 Sends beautiful NPS survey emails to clients\n- 📊 Collects and parses NPS responses\n- 🎯 Routes feedback based on score (Promoters vs Detractors)\n- 📝 Logs all feedback in Notion database\n- 🔄 Updates GHL custom fields to prevent duplicate surveys\n\n### Setup Requirements:\n1. GoHighLevel account with OAuth2 credentials\n2. Gmail account for sending/receiving emails\n3. Notion account with NPS database\n4. Custom fields in GHL: `nps_survey_sent`, `nps_sent_date`\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "5612db2f-264b-4b9e-b193-f045eb140c40",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        -512
      ],
      "parameters": {
        "width": 300,
        "height": 320,
        "content": "## 🔍 Fetch Won Opportunities\n\nThis node retrieves all opportunities with status=\"won\" from GoHighLevel.\n\n**Important:** Make sure your GHL account has:\n- Custom field: `nps_survey_sent` (boolean)\n- Custom field: `nps_sent_date` (date)\n\n**Runs:** Every hour via schedule trigger"
      },
      "typeVersion": 1
    },
    {
      "id": "6a69ad15-0e00-4ea9-9bed-f84133477e5a",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -448
      ],
      "parameters": {
        "width": 280,
        "height": 256,
        "content": "## ✅  Filter & Validate Deals\n\nFilters deals to find:\n- Status = \"won\"\n- NPS survey NOT yet sent\n- Valid email address exists\n\nSkips deals without email or already surveyed."
      },
      "typeVersion": 1
    },
    {
      "id": "a76c0b72-99be-4acc-a5b6-6abd68e51cf4",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -528
      ],
      "parameters": {
        "width": 280,
        "height": 308,
        "content": "## 📧  Send NPS Survey\n\nSends a beautiful HTML email with:\n- 0-10 rating scale\n- Mailto links for easy response\n- Client personalization\n- Deal information embedded\n\n**Note:** Responses come back via email with pre-filled data"
      },
      "typeVersion": 1
    },
    {
      "id": "35b277ef-863e-4642-a183-9ff78db51609",
      "name": "付箋4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -928,
        384
      ],
      "parameters": {
        "width": 300,
        "height": 312,
        "content": "## 📥  Collect Responses\n\nWeekly schedule checks Gmail for:\n- Unread NPS response emails\n- Received after Oct 1, 2025\n- Extracts score and feedback\n\n**Categorizes as:**\n- Promoter: 9-10\n- Passive: 7-8\n- Detractor: 0-6"
      },
      "typeVersion": 1
    },
    {
      "id": "3f201e66-dc0b-48ce-84d0-444315c29bfd",
      "name": "付箋5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        320
      ],
      "parameters": {
        "width": 320,
        "height": 316,
        "content": "## 🎯  Route Based on Score\n\n**If Score > 7 (Promoter/Passive):**\n- Log in Notion as positive feedback\n- Send thank you email\n- Request testimonial/review\n\n**If Score ≤ 7 (Detractor):**\n- Create support ticket in Notion\n- Alert team via email\n- Priority follow-up within 24h"
      },
      "typeVersion": 1
    },
    {
      "id": "02919d71-92cf-40f1-9ab7-357cd411e8f4",
      "name": "GHLから獲得済み商談を取得",
      "type": "n8n-nodes-base.highLevel",
      "position": [
        -272,
        -176
      ],
      "parameters": {
        "filters": {
          "status": "won"
        },
        "resource": "opportunity",
        "operation": "getAll",
        "returnAll": true,
        "requestOptions": {}
      },
      "credentials": {
        "highLevelOAuth2Api": {
          "id": "5QWHSi134dLIBEsC",
          "name": "HighLevel account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "97d39aee-3ed7-483d-98b2-fc145ca2fd7e",
      "name": "トリガー：1時間ごとにチェック",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -496,
        -176
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "90f67410-7777-4a7f-a764-7bffc0b83da1",
      "name": "未調査完了商談のフィルタリング",
      "type": "n8n-nodes-base.code",
      "onError": "continueErrorOutput",
      "position": [
        -48,
        -176
      ],
      "parameters": {
        "jsCode": "// Filter deals with status = 'won' and not yet surveyed\nconst deals = $input.all();\nconst completedDeals = [];\n\nfor (const deal of deals) {\n  const data = deal.json;\n  \n  // Check if deal status is 'won' (completed in GHL)\n  if (data.status && data.status.toLowerCase() === 'won') {\n    \n    // Check if NPS survey was already sent\n    let npsSent = false;\n    if (data.customFields && Array.isArray(data.customFields)) {\n      const npsField = data.customFields.find(field => field.key === 'nps_survey_sent');\n      npsSent = npsField ? npsField.value === true || npsField.value === 'true' : false;\n    }\n    \n    // Only process deals where survey hasn't been sent\n    if (!npsSent) {\n      // Extract contact details\n      const contact = data.contact || {};\n      const email = contact.email || '';\n      const phone = contact.phone || '';\n      \n      // Skip if no email (can't send survey)\n      if (!email) {\n        console.log(`Skipping deal ${data.id} - no email found`);\n        continue;\n      }\n      \n      completedDeals.push({\n        json: {\n          dealId: data.id,\n          clientName: contact.name || 'Client',\n          clientEmail: email,\n          clientPhone: phone,\n          dealValue: data.monetaryValue || 0,\n          completedDate: data.lastStatusChangeAt || new Date().toISOString(),\n          contactId: contact.id || '',\n          companyName: contact.companyName || '',\n          pipelineId: data.pipelineId || '',\n          hasDeals: true\n        }\n      });\n    }\n  }\n}\n\n// Return appropriate response\nif (completedDeals.length === 0) {\n  return [{ json: { hasDeals: false, message: 'No new completed deals found', count: 0 } }];\n}\n\nconsole.log(`Found ${completedDeals.length} completed deals ready for NPS survey`);\nreturn completedDeals;"
      },
      "typeVersion": 2
    },
    {
      "id": "8306f5d0-8a9b-405d-ac4b-55d1397c6f8c",
      "name": "有効な商談の存在確認",
      "type": "n8n-nodes-base.if",
      "position": [
        208,
        -192
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 1,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "13f3a917-bcdf-47a0-bcbc-40349e5b4b64",
              "operator": {
                "type": "boolean",
                "operation": "true",
                "singleValue": true
              },
              "leftValue": "={{ $json.hasDeals }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "10f2bf7b-6360-477d-b3fa-0d4a0f6ea275",
      "name": "メールからNPSスコアを解析",
      "type": "n8n-nodes-base.code",
      "position": [
        -272,
        160
      ],
      "parameters": {
        "jsCode": "// Extract NPS score and details from email snippet\nconst emailData = $input.first().json;\nconst snippet = emailData.snippet || '';\n\n// Extract score from snippet (e.g., \"Score: 2\")\nconst scoreMatch = snippet.match(/Score:\\s*(\\d+)/);\nconst score = scoreMatch ? parseInt(scoreMatch[1]) : 0;\n\n// Extract deal ID from snippet\nconst dealIdMatch = snippet.match(/Deal ID:\\s*([^\\s]+)/);\n\n// Extract client name from snippet\nconst clientMatch = snippet.match(/Client:\\s*([^\\n\\r]+?)(?=\\s*Email:|$)/);\n\n// Extract email from snippet\nconst emailMatch = snippet.match(/Email:\\s*([^\\s]+)/);\n\n// Extract feedback (everything after \"Please share your feedback:\")\nconst feedbackMatch = snippet.match(/Please share your feedback:\\s*([\\s\\S]*)/);\n\nreturn [{\n  json: {\n    dealId: dealIdMatch ? dealIdMatch[1].trim() : '',\n    clientName: clientMatch ? clientMatch[1].trim() : '',\n    clientEmail: emailMatch ? emailMatch[1].trim() : '',\n    npsScore: score,\n    category: score >= 9 ? 'Promoter' : (score >= 7 ? 'Passive' : 'Detractor'),\n    feedback: feedbackMatch ? feedbackMatch[1].trim() : '',\n    timestamp: new Date().toISOString(),\n    historyId: emailData.historyId || '',\n    emailSubject: snippet.substring(0, 50)\n  }\n}];"
      },
      "typeVersion": 2
    },
    {
      "id": "1b044a4c-93e7-490f-8c79-495c90abe4ce",
      "name": "NPS調査メールを送信",
      "type": "n8n-nodes-base.gmail",
      "position": [
        448,
        -208
      ],
      "webhookId": "1ef4b7ef-d4de-44cc-8938-37a29544cce3",
      "parameters": {
        "sendTo": "={{ $json.clientEmail }}",
        "message": "=<html> <head>   <meta charset=\"UTF-8\">   <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">   <style>     body {        font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif;       line-height: 1.6;        color: #333;       margin: 0;       padding: 0;       background-color: #f4f4f4;     }     .email-container {        max-width: 600px;        margin: 20px auto;        background: #ffffff;       border-radius: 12px;       overflow: hidden;       box-shadow: 0 4px 12px rgba(0,0,0,0.1);     }     .header {        background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);       color: white;        padding: 40px 30px;        text-align: center;     }     .header h1 {       margin: 0 0 10px 0;       font-size: 28px;       font-weight: 600;     }     .header p {       margin: 0;       font-size: 16px;       opacity: 0.95;     }     .content {        padding: 40px 30px;       background: #ffffff;     }     .content p {       font-size: 16px;       margin: 0 0 20px 0;       color: #555;     }     .question {       font-size: 18px;       font-weight: 600;       text-align: center;       margin: 30px 0 25px 0;       color: #333;     }     .rating-container {        text-align: center;        margin: 30px 0;       padding: 20px 0;     }     .rating-row {       margin: 15px 0;       display: flex;       justify-content: center;       flex-wrap: wrap;       gap: 8px;     }     .rating-button {        display: inline-block;       width: 52px;       height: 52px;       margin: 4px;       text-decoration: none;       border-radius: 50%;       font-weight: bold;       font-size: 18px;       line-height: 52px;       color: white;       transition: all 0.3s ease;       box-shadow: 0 2px 8px rgba(0,0,0,0.15);     }     .rating-button:hover {        transform: scale(1.1);       box-shadow: 0 4px 12px rgba(0,0,0,0.25);     }     .score-detractor {        background: linear-gradient(135deg, #ff6b6b 0%, #ee5a6f 100%);     }     .score-passive {        background: linear-gradient(135deg, #ffd93d 0%, #ffb830 100%);       color: #333;     }     .score-promoter {        background: linear-gradient(135deg, #6bcf7f 0%, #4caf50 100%);     }     .label-row {       display: flex;       justify-content: space-between;       max-width: 500px;       margin: 20px auto 0 auto;       padding: 0 10px;     }     .label {       font-size: 13px;       color: #666;       font-weight: 500;     }     .info-box {       background: #f8f9fa;       border-left: 4px solid #667eea;       padding: 15px 20px;       margin: 25px 0;       border-radius: 4px;     }     .info-box p {       margin: 8px 0;       font-size: 14px;     }     .footer {        text-align: center;        padding: 30px;       background: #f8f9fa;       color: #999;       font-size: 13px;     }     .footer p {       margin: 5px 0;       color: #999;     }     .highlight {       color: #667eea;       font-weight: 600;     }          @media only screen and (max-width: 600px) {       .email-container {         margin: 0;         border-radius: 0;       }       .header {         padding: 30px 20px;       }       .header h1 {         font-size: 24px;       }       .content {         padding: 30px 20px;       }       .rating-button {         width: 44px;         height: 44px;         line-height: 44px;         font-size: 16px;         margin: 3px;       }     }   </style> </head> <body>   <div class=\"email-container\">     <div class=\"header\">       <h1>Thank You, {{ $json.clientName }}! 🎉</h1>       <p>We appreciate your business with {{ $json.companyName || 'us' }}</p>     </div>          <div class=\"content\">       <p>Hi <strong>{{ $json.clientName }}</strong>,</p>              <p>Thank you for choosing our services! We're grateful for the opportunity to work with you on your recent project valued at <span class=\"highlight\">${{ $json.dealValue }}</span>.</p>              <div class=\"info-box\">         <p>💡 <strong>Your feedback matters!</strong> It takes just 5 seconds and helps us improve our service for everyone.</p>       </div>              <p class=\"question\">How likely are you to recommend us to a friend or colleague?</p>              <div class=\"rating-container\">         <div class=\"rating-row\">           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%200&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%200%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-detractor\">0</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%201&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%201%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-detractor\">1</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%202&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%202%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-detractor\">2</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%203&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%203%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-detractor\">3</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%204&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%204%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-detractor\">4</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%205&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%205%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-detractor\">5</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%206&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%206%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-detractor\">6</a>         </div>                  <div class=\"rating-row\">           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%207&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%207%0A%0APlease%20share%20your%20feedback%3A%0A\" class=\"rating-button score-passive\">7</a>         </div>                  <div class=\"rating-row\">           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%208&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%208%0A%0APlease%20share%20your%20thoughts%3A%0A\" class=\"rating-button score-promoter\">8</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%209&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%209%0A%0APlease%20share%20your%20thoughts%3A%0A\" class=\"rating-button score-promoter\">9</a>           <a href=\"mailto:{{ $env.SENDER_EMAIL }}?subject=NPS%20Response%20-%20Score%2010&body=Deal%20ID%3A%20{{ $json.dealId }}%0AClient%3A%20{{ $json.clientName }}%0AEmail%3A%20{{ $json.clientEmail }}%0AScore%3A%2010%0A%0APlease%20share%20your%20thoughts%3A%0A\" class=\"rating-button score-promoter\">10</a>         </div>                  <div class=\"label-row\">           <span class=\"label\">Not Likely</span>           <span class=\"label\">Very Likely</span>         </div>       </div>              <p style=\"text-align: center; font-size: 14px; color: #888; margin-top: 30px;\">         Simply click your rating above - your email client will open with a pre-filled message. Add any additional comments and hit send!       </p>     </div>          <div class=\"footer\">       <p><strong>Your feedback helps us serve you better</strong></p>       <p>If you have any immediate concerns, feel free to reply directly to this email.</p>       <p style=\"margin-top: 15px; color: #bbb;\">© 2025 Your Company. All rights reserved.</p>     </div>   </div> </body> </html>",
        "options": {},
        "subject": "We'd love your feedback! 🌟"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "gEIaWCTvGfYjMSb3",
          "name": "Gmail credentials"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "23960d58-04aa-4f68-9e6a-f868cb539322",
      "name": "GHL更新 - 調査送信済みマーク",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        672,
        -208
      ],
      "parameters": {
        "url": "=https://services.leadconnectorhq.com/opportunities/{{ $('Check if Valid Deals Exist').item.json.dealId }}",
        "method": "PUT",
        "options": {},
        "jsonBody": "={\n  \"customFields\": [\n    {\n      \"id\": \"nps_survey_sent\",\n      \"value\": true\n    },\n    {\n      \"id\": \"nps_sent_date\",\n      \"value\": \"{{ $now.toISO() }}\"\n    }\n  ]\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "={{ $env.GHL_API_TOKEN }}"
            },
            {
              "name": "Version",
              "value": "2021-07-28"
            },
            {
              "name": "Accept",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "9e7dfb92-e4b4-4cc4-bc26-f1d8ccecf709",
      "name": "スコアによる振り分け（プロモーター vs デトラクター）",
      "type": "n8n-nodes-base.if",
      "position": [
        -64,
        144
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "352d5f37-53af-4d13-8495-ba5f5074e866",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.npsScore }}",
              "rightValue": 7
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "a651447f-dd47-493f-9ccd-5be62e2bde20",
      "name": "Notionにサポートチケットを作成",
      "type": "n8n-nodes-base.notion",
      "position": [
        208,
        256
      ],
      "parameters": {
        "title": "=🚨 Support Needed - {{ $json.clientName }}",
        "options": {},
        "resource": "databasePage",
        "databaseId": {
          "__rl": true,
          "mode": "list",
          "value": "27fd8188-083a-8049-9459-d1fb575a2bc6",
          "cachedResultUrl": "https://www.notion.so/27fd8188083a80499459d1fb575a2bc6",
          "cachedResultName": "NPS Score client "
        },
        "propertiesUi": {
          "propertyValues": [
            {
              "key": "Name|title",
              "title": "={{ $json.clientName }}"
            },
            {
              "key": "Email|rich_text",
              "textContent": "={{ $json.clientEmail }}"
            },
            {
              "key": "Category|rich_text",
              "textContent": "={{ $json.category }}"
            },
            {
              "key": "NPS Score|number",
              "numberValue": "={{ $json.npsScore }}"
            },
            {
              "key": "Subject|rich_text",
              "textContent": "={{ $json.emailSubject }}"
            }
          ]
        }
      },
      "credentials": {
        "notionApi": {
          "id": "E9jA8DFWT2IxdpMU",
          "name": "Notion account Vivek"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "9c9aee11-4754-4cd3-8b2a-be8de417681c",
      "name": "Notionにポジティブフィードバックを記録",
      "type": "n8n-nodes-base.notion",
      "position": [
        208,
        32
      ],
      "parameters": {
        "title": "=⭐ Positive Review - {{ $json.clientName }}",
        "options": {},
        "resource": "databasePage",
        "databaseId": {
          "__rl": true,
          "mode": "list",
          "value": "27fd8188-083a-8049-9459-d1fb575a2bc6",
          "cachedResultUrl": "https://www.notion.so/27fd8188083a80499459d1fb575a2bc6",
          "cachedResultName": "NPS Score client "
        },
        "propertiesUi": {
          "propertyValues": [
            {
              "key": "Name|title",
              "title": "={{ $json.clientName }}"
            },
            {
              "key": "Email|rich_text",
              "textContent": "={{ $json.clientEmail }}"
            },
            {
              "key": "Category|rich_text",
              "textContent": "={{ $json.category }}"
            },
            {
              "key": "NPS Score|number",
              "numberValue": "={{ $json.npsScore }}"
            },
            {
              "key": "Subject|rich_text",
              "textContent": "={{ $json.emailSubject }}"
            }
          ]
        }
      },
      "credentials": {
        "notionApi": {
          "id": "E9jA8DFWT2IxdpMU",
          "name": "Notion account Vivek"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "ac681e09-12fe-41bc-992b-322efa5eede4",
      "name": "感謝メールとレビュー依頼を送信",
      "type": "n8n-nodes-base.gmail",
      "position": [
        432,
        32
      ],
      "webhookId": "e3b7576c-98fa-486c-bb67-630ffe2e26e6",
      "parameters": {
        "sendTo": "={{ $json.clientEmail }}",
        "message": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"UTF-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n  <title>We Value Your Feedback</title>\n</head>\n<body style=\"margin: 0; padding: 0; font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background-color: #f4f4f4;\">\n  <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #f4f4f4; padding: 40px 20px;\">\n    <tr>\n      <td align=\"center\">\n        <table width=\"600\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #ffffff; border-radius: 8px; box-shadow: 0 2px 8px rgba(0,0,0,0.1);\">\n          <tr>\n            <td style=\"background: linear-gradient(135deg, #28a745 0%, #218838 100%); padding: 40px 30px; border-radius: 8px 8px 0 0; text-align: center;\">\n              <h1 style=\"color: #ffffff; margin: 0; font-size: 28px; font-weight: 600;\">\n                We're Glad You Had a Great Experience!\n              </h1>\n            </td>\n          </tr>\n          <tr>\n            <td style=\"padding: 40px 30px;\">\n              <p style=\"color: #333333; font-size: 16px; line-height: 1.6; margin: 0 0 20px;\">\n                Dear <strong>{{ $json.clientName }}</strong>,\n              </p>\n              <p style=\"color: #333333; font-size: 16px; line-height: 1.6; margin: 0 0 20px;\">\n                Thank you for taking the time to share your experience with us. We're delighted to see your positive feedback and truly appreciate your support.\n              </p>\n              <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"margin: 30px 0;\">\n                <tr>\n                  <td style=\"background-color: #d4edda; border-left: 4px solid #28a745; padding: 20px; border-radius: 4px;\">\n                    <p style=\"color: #155724; font-size: 14px; margin: 0 0 10px; font-weight: 600;\">YOUR FEEDBACK SCORE</p>\n                    <p style=\"color: #333333; font-size: 32px; font-weight: bold; margin: 0; line-height: 1;\">{{ $json.npsScore }}/10</p>\n                    <p style=\"color: #155724; font-size: 14px; margin: 10px 0 0; font-style: italic;\">Category: {{ $json.category }}</p>\n                  </td>\n                </tr>\n              </table>\n              <p style=\"color: #333333; font-size: 16px; line-height: 1.6; margin: 0 0 20px;\">\n                We're thrilled to know you had a good experience. Feedback like yours motivates us to keep improving.\n              </p>\n              <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"margin: 30px 0;\">\n                <tr>\n                  <td align=\"center\">\n                    <a href=\"[YOUR_REVIEW_LINK]\" style=\"display: inline-block; background-color: #28a745; color: #ffffff; text-decoration: none; padding: 15px 40px; border-radius: 5px; font-size: 16px; font-weight: 600;\">Share Your Review</a>\n                  </td>\n                </tr>\n              </table>\n            </td>\n          </tr>\n        </table>\n      </td>\n    </tr>\n  </table>\n</body>\n</html>",
        "options": {},
        "subject": "=🌟 Thank you! Share your experience with others"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "gEIaWCTvGfYjMSb3",
          "name": "Gmail credentials"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "dc7d124a-a9e9-43cb-a747-e4d91ae111a6",
      "name": "チームに低スコアを通知",
      "type": "n8n-nodes-base.gmail",
      "position": [
        432,
        256
      ],
      "webhookId": "e3b7576c-98fa-486c-bb67-630ffe2e26e6",
      "parameters": {
        "sendTo": "={{ $env.SUPPORT_TEAM_EMAIL }}",
        "message": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"UTF-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0;\">\n  <title>Low NPS Alert</title>\n</head>\n<body style=\"margin: 0; padding: 0; font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background-color: #f4f4f4;\">\n  <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #f4f4f4; padding: 40px 20px;\">\n    <tr>\n      <td align=\"center\">\n        <table width=\"600\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #ffffff; border-radius: 8px; box-shadow: 0 2px 8px rgba(0,0,0,0.1);\">\n          <tr>\n            <td style=\"background: linear-gradient(135deg, #dc3545 0%, #c82333 100%); padding: 40px 30px; border-radius: 8px 8px 0 0; text-align: center;\">\n              <h1 style=\"color: #ffffff; margin: 0; font-size: 28px; font-weight: 600;\">🚨 Urgent: Low NPS Score Received</h1>\n            </td>\n          </tr>\n          <tr>\n            <td style=\"padding: 40px 30px;\">\n              <p style=\"color: #333333; font-size: 16px; line-height: 1.6; margin: 0 0 20px;\">\n                <strong>Action Required:</strong> A client has submitted a low NPS score indicating dissatisfaction.\n              </p>\n              <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"margin: 20px 0; background-color: #f8d7da; border-left: 4px solid #dc3545; padding: 20px; border-radius: 4px;\">\n                <tr>\n                  <td>\n                    <p style=\"margin: 5px 0;\"><strong>Client:</strong> {{ $json.clientName }}</p>\n                    <p style=\"margin: 5px 0;\"><strong>Email:</strong> {{ $json.clientEmail }}</p>\n                    <p style=\"margin: 5px 0;\"><strong>NPS Score:</strong> {{ $json.npsScore }}/10</p>\n                    <p style=\"margin: 5px 0;\"><strong>Category:</strong> {{ $json.category }}</p>\n                    <p style=\"margin: 5px 0;\"><strong>Deal ID:</strong> {{ $json.dealId }}</p>\n                  </td>\n                </tr>\n              </table>\n              <p style=\"color: #333333; font-size: 16px; line-height: 1.6; margin: 20px 0;\">\n                <strong>Feedback:</strong><br>{{ $json.feedback || 'No additional feedback provided' }}\n              </p>\n              <p style=\"color: #dc3545; font-size: 16px; font-weight: 600; margin: 20px 0;\">\n                ⏰ Please reach out within 24 hours to address their concerns.\n              </p>\n            </td>\n          </tr>\n        </table>\n      </td>\n    </tr>\n  </table>\n</body>\n</html>",
        "options": {},
        "subject": "=🚨 Low NPS Alert - {{ $json.clientName }} (Score: {{ $json.npsScore }})"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "gEIaWCTvGfYjMSb3",
          "name": "Gmail credentials"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "a5d77a43-4cbe-4385-b3fe-fb727242b591",
      "name": "未読NPS回答を取得",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -480,
        160
      ],
      "webhookId": "4b06d341-892d-4439-b24d-63361bd517bc",
      "parameters": {
        "filters": {
          "readStatus": "unread"
        },
        "resource": "thread"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "gEIaWCTvGfYjMSb3",
          "name": "Gmail credentials"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "2e2533c7-a882-48e2-8730-5662ed4fe972",
      "name": "トリガー：回答を毎週チェック",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -752,
        160
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks",
              "triggerAtDay": [
                1
              ],
              "triggerAtHour": 8
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "64c7ec78-08eb-477a-bcff-4592d0ed20e7",
      "name": "付箋6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        -464
      ],
      "parameters": {
        "height": 208,
        "content": "## ✅ Check for Valid Deals\n\nIF condition to confirm whether valid deals exist.\nIf none are found, the workflow stops here."
      },
      "typeVersion": 1
    },
    {
      "id": "2032d832-e055-4279-ac57-01ca277617d1",
      "name": "付箋7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        -464
      ],
      "parameters": {
        "height": 224,
        "content": "## 📧 Send NPS Survey Email\n\nSends a personalized HTML email with rating scale (0–10).\nIncludes mailto links for quick responses and client-specific info."
      },
      "typeVersion": 1
    },
    {
      "id": "e3a332cb-3e87-4e78-85e9-7c1826be396b",
      "name": "付箋8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        928,
        -336
      ],
      "parameters": {
        "height": 272,
        "content": "## 📤 Update GHL - Mark Survey Sent\n\nUpdates custom fields in GHL:\n\nnps_survey_sent = true\n\nnps_sent_date = current timestamp\n\nPrevents duplicate surveys being sent."
      },
      "typeVersion": 1
    },
    {
      "id": "0003c5d1-d6a9-4a17-ba17-899ba70ace5d",
      "name": "付箋9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        400
      ],
      "parameters": {
        "height": 208,
        "content": "## 📬 Fetch Unread NPS Responses\n\nChecks unread Gmail threads for new NPS responses.\nTriggered weekly to process accumulated replies."
      },
      "typeVersion": 1
    },
    {
      "id": "dda3e7ef-c046-422c-ad6c-59ace9defff1",
      "name": "付箋10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -288,
        320
      ],
      "parameters": {
        "height": 368,
        "content": "## 🔎 Parse NPS Score from Email\n\nExtracts from response email:\n\nNPS score (0–10)\n\nClient name & email\n\nDeal ID & subject line\n\nWritten feedback\n\nAutomatically classifies into Promoter, Passive, or Detractor."
      },
      "typeVersion": 1
    },
    {
      "id": "fe709bf9-2770-4ac6-8869-ef82614b528e",
      "name": "付箋11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        608,
        0
      ],
      "parameters": {
        "height": 224,
        "content": "## ⭐ Positive Feedback\n\nLogs promoter response in Notion as a positive entry.\nSends thank-you + review request email to encourage public sharing."
      },
      "typeVersion": 1
    },
    {
      "id": "3508d7f5-2f0a-403b-8b38-d59de6a0a107",
      "name": "付箋12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        336
      ],
      "parameters": {
        "height": 352,
        "content": "## 🚨 Handle Low Scores (Detractors)\n\nFor detractor responses:\n\nCreates a support ticket in Notion\n\nSends urgent alert email to support team\n\nEnsures dissatisfied clients get immediate attention."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "2786a3a2-86a4-41df-9919-90482ca3229c",
  "connections": {
    "1b044a4c-93e7-490f-8c79-495c90abe4ce": {
      "main": [
        [
          {
            "node": "23960d58-04aa-4f68-9e6a-f868cb539322",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "97d39aee-3ed7-483d-98b2-fc145ca2fd7e": {
      "main": [
        [
          {
            "node": "02919d71-92cf-40f1-9ab7-357cd411e8f4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8306f5d0-8a9b-405d-ac4b-55d1397c6f8c": {
      "main": [
        [
          {
            "node": "1b044a4c-93e7-490f-8c79-495c90abe4ce",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a5d77a43-4cbe-4385-b3fe-fb727242b591": {
      "main": [
        [
          {
            "node": "10f2bf7b-6360-477d-b3fa-0d4a0f6ea275",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "10f2bf7b-6360-477d-b3fa-0d4a0f6ea275": {
      "main": [
        [
          {
            "node": "9e7dfb92-e4b4-4cc4-bc26-f1d8ccecf709",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "02919d71-92cf-40f1-9ab7-357cd411e8f4": {
      "main": [
        [
          {
            "node": "90f67410-7777-4a7f-a764-7bffc0b83da1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a651447f-dd47-493f-9ccd-5be62e2bde20": {
      "main": [
        [
          {
            "node": "dc7d124a-a9e9-43cb-a747-e4d91ae111a6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9c9aee11-4754-4cd3-8b2a-be8de417681c": {
      "main": [
        [
          {
            "node": "ac681e09-12fe-41bc-992b-322efa5eede4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2e2533c7-a882-48e2-8730-5662ed4fe972": {
      "main": [
        [
          {
            "node": "a5d77a43-4cbe-4385-b3fe-fb727242b591",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "90f67410-7777-4a7f-a764-7bffc0b83da1": {
      "main": [
        [
          {
            "node": "8306f5d0-8a9b-405d-ac4b-55d1397c6f8c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9e7dfb92-e4b4-4cc4-bc26-f1d8ccecf709": {
      "main": [
        [
          {
            "node": "9c9aee11-4754-4cd3-8b2a-be8de417681c",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "a651447f-dd47-493f-9ccd-5be62e2bde20",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}