アフターサービスレビューコレクター
上級
これはCRM, Multimodal AI分野の自動化ワークフローで、20個のノードを含みます。主にIf, Wait, Gmail, Slack, HighLevelなどのノードを使用。 振り返り収集と感情分析:HighLevel、GPT-4o、Gmail、Slack
前提条件
- •Googleアカウント + Gmail API認証情報
- •Slack Bot Token または Webhook URL
- •Google Sheets API認証情報
- •OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"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": "Deal取得成功の検証",
"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から獲得済みDealを取得",
"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
}
]
]
}
}
}よくある質問
このワークフローの使い方は?
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか?
上級 - 顧客管理, マルチモーダルAI
有料ですか?
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。
関連ワークフロー
営業担当パフォーマンストラッカー
HighLevel CRM、GPT-4o、Notion、そしてSlackを使った自動化のな営業ランキング
If
Code
Slack
+
If
Code
Slack
21 ノードRahul Joshi
顧客管理
提案生成_草稿保存の自動化
Azure GPT-4o を使ってビジネスプレゼンションを生成して Sheets から Gmail ダスクトに保存
If
Code
Gmail
+
If
Code
Gmail
16 ノードRahul Joshi
顧客管理
Stripe決済から自動テンプレートを顧客に配送
Stripe、GPT-4o、Gmailを使った自動テンプレート配信システム
If
Code
Gmail
+
If
Code
Gmail
44 ノードRahul Joshi
顧客管理
リリースノートをよくある質問用に変換(Jira/ClickUp)
GPT-4oによるClickUpからの自動記事作成とNotion及びSlackへの配信
If
Code
Gmail
+
If
Code
Gmail
20 ノードRahul Joshi
エンジニアリング
顧客オンボーディングのヘルプリクエスト(Typeform → Gmail → Sheets)
顧客エントリヘルプリクエスト(Typeform → Gmail → Sheets)
If
Code
Gmail
+
If
Code
Gmail
28 ノードRahul Joshi
コンテンツ作成
API速率制限と認証に関するFAQテスト
GPT-4o-mini、Googleスプレッドシート、Slackアラートを使用したAPIよくある質問品質テストの自動化
If
Set
Code
+
If
Set
Code
19 ノードRahul Joshi
文書抽出
ワークフロー情報
難易度
上級
ノード数20
カテゴリー2
ノードタイプ10
作成者
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で表示 →
このワークフローを共有