AI を活用したフィードバック処理自動化
中級
これはMarketing分野の自動化ワークフローで、9個のノードを含みます。主にIf, WhatsApp, EmailSend, FormTrigger, GoogleSheetsなどのノードを使用。 フォーム、AI、Googleスプレッドシート、WhatsAppを使って顧客フィードバックを自動分析
前提条件
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "h47UJYYjZeKuBLTn",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "AI Automation in Feedback",
"tags": [],
"nodes": [
{
"id": "553d9f71-a750-4152-84bb-9d2956441aa8",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
260,
220
],
"webhookId": "998e3daa-1e42-4a50-913f-e0dfb10b66b7",
"parameters": {
"options": {
"path": "feedback",
"customCss": "",
"appendAttribution": false
},
"formTitle": "Customer Feedback Questions for IT Services",
"formFields": {
"values": [
{
"fieldLabel": "What is your Name?",
"requiredField": true
},
{
"fieldType": "email",
"fieldLabel": "Email ID",
"requiredField": true
},
{
"fieldLabel": "Contact Number",
"placeholder": "(e.g, +1234567890)",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How satisfied are you with the quality of our IT services or solutions?",
"fieldOptions": {
"values": [
{
"option": "Very Dissatisfied"
},
{
"option": "Dissatisfied"
},
{
"option": "Neutral"
},
{
"option": "Satisfied"
},
{
"option": "Very Satisfied"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Did our team understand your technical requirements clearly?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How would you rate our communication throughout the project/support process?",
"fieldOptions": {
"values": [
{
"option": "Poor"
},
{
"option": "Fair"
},
{
"option": "Good"
},
{
"option": "Excellent"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Was your project/service delivered on time and within the expected timeline?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Did our solution meet your business needs or solve your problem effectively?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How responsive was our support team when you needed assistance?",
"fieldOptions": {
"values": [
{
"option": "Slow"
},
{
"option": "Average"
},
{
"option": "Fast"
},
{
"option": "Very Fast"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "How would you rate the technical expertise of our team?",
"fieldOptions": {
"values": [
{
"option": "1"
},
{
"option": "2"
},
{
"option": "3"
},
{
"option": "4"
},
{
"option": "5"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "What could we do to improve your experience with our IT services?",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Would you recommend our IT services to others?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "=No"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Any additional comments or suggestions?",
"requiredField": true
}
]
}
},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "0f02714d-0da3-4f86-ba62-97ce92883201",
"name": "メールと電話番号の両方が入力されている場合",
"type": "n8n-nodes-base.if",
"position": [
520,
440
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8cc5cb6d-8aee-4547-bb67-aa8465789473",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Phone.toString() }}",
"rightValue": ""
},
{
"id": "2a0ba5ea-f76c-4cf2-9b77-6fc0e2d269da",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2890694e-c503-4eda-825b-b569e7f8831a",
"name": "電話番号のみ入力されている場合",
"type": "n8n-nodes-base.if",
"position": [
520,
640
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "84c363c4-8ae2-4b56-b9f7-a83de196be4b",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Phone.toString() }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "cf9d2612-b582-4352-809e-31a38f4126b5",
"name": "Whatsapp にメッセージを送信",
"type": "n8n-nodes-base.whatsApp",
"notes": "Set the WhatsApp template from the WhatsApp Business Account.",
"position": [
780,
620
],
"webhookId": "857eab1a-f5e2-4937-be2c-90b47bae3947",
"parameters": {
"template": "feedback_n8n|en_US",
"components": {
"component": [
{
"bodyParameters": {
"parameter": [
{
"text": "={{ $('Google Sheets Trigger').item.json.User }}"
}
]
}
}
]
},
"phoneNumberId": "550325331503475",
"recipientPhoneNumber": "={{ $json.Phone.toString() }}"
},
"credentials": {
"whatsAppApi": {
"id": "3hy4gzpVJrY1sFcR",
"name": "WhatsApp account API"
}
},
"typeVersion": 1
},
{
"id": "ce02dda2-111e-4bde-99a9-393547c40435",
"name": "Google Sheets トリガー",
"type": "n8n-nodes-base.googleSheetsTrigger",
"notes": "Set Google Credentials and then select Google Sheets.\nSelect the Sheet on which you want to set the trigger.\n\nIf any changes are made to the selected Sheet. Node will trigger.",
"position": [
200,
520
],
"parameters": {
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "9XWklJMdHOljJ9Ar",
"name": "Google Sheets Trigger account"
}
},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "153adc14-68c1-4b4d-bb93-8dc5204ec7e9",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"notes": "Follow this steps:\n- Set Google Credentials and then select Google Sheets account.\n- Select \"Sheet Within Document\" option in Resource tab.\n- Select \"Append or Update Row\" in Operation tab.\n- In Document tab select your google sheets which you want to update.\n- In Sheets tab select sheet from your google sheets document.\n- In Mapping select \"Map Each Column Manually\"\n- Now from list of colums select colum which you want to match from selected sheet. The column to use when matching rows in Google Sheets to the input items of this node. Usually an ID.\n- Now you can see all colume in \"Values to Send\" section. Here you need to map (using drag and drop) the filed with the form filed name. ",
"position": [
520,
220
],
"parameters": {
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "rgIk6EXVdPbmPYAl",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "65b5cb47-12d0-42a5-bb95-c023710dd310",
"name": "メール",
"type": "n8n-nodes-base.emailSend",
"position": [
780,
420
],
"webhookId": "4f5aacbc-7967-44c0-9e24-00472ec25b48",
"parameters": {
"text": "Please give us your valuable feedback at:\n<<< Your Form Production URL >>>",
"options": {
"appendAttribution": false
},
"subject": "Feedback",
"toEmail": "={{ $json.Email }}",
"fromEmail": "XYZ@gmail.com",
"emailFormat": "text"
},
"credentials": {
"smtp": {
"id": "3QSx1pWoS0BZcK4c",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "457b43d6-fa50-4259-bf56-b637b1819445",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
140
],
"parameters": {
"width": 380,
"height": 600,
"content": "## Google Sheets Integration \n#### Create Google Cloud Credentials\nTo connect Google Sheets to n8n, you need to set up OAuth2 authentication through Google Cloud:\n\n**1. Create a Google Cloud Project:**\n - Go to the Google Cloud Console (https://console.cloud.google.com/).\n - Create a new project or select an existing one.\n - Enable the Google Sheets API under APIs & Services > Library.\n\n**2. Set Up OAuth Consent Screen:**\n - Navigate to APIs & Services > OAuth consent screen.\n - Select External user type and fill in required details (e.g., app name, support email).\n - Add the following scopes: .../auth/spreadsheets (for full access to Google Sheets).\n - Save and proceed.\n\n**3. Create OAuth2 Credentials:**\n - Go to APIs & Services > Credentials > Create Credentials > OAuth 2.0 Client IDs.\n - Choose Web application as the application type.\n - Add an Authorized redirect URI (you’ll get this from n8n in the next step).\n - Save to obtain your Client ID and Client Secret."
},
"typeVersion": 1
},
{
"id": "cc0786b3-2340-4fa1-812b-49dc76a3ef0d",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
20
],
"parameters": {
"width": 380,
"height": 100,
"content": "## Integration Notes\nKindly see the node **notes** in the **setting** tab for more information."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "481b316a-890a-4a24-812a-b402638ff547",
"connections": {
"553d9f71-a750-4152-84bb-9d2956441aa8": {
"main": [
[
{
"node": "153adc14-68c1-4b4d-bb93-8dc5204ec7e9",
"type": "main",
"index": 0
}
]
]
},
"ce02dda2-111e-4bde-99a9-393547c40435": {
"main": [
[
{
"node": "0f02714d-0da3-4f86-ba62-97ce92883201",
"type": "main",
"index": 0
},
{
"node": "2890694e-c503-4eda-825b-b569e7f8831a",
"type": "main",
"index": 0
}
]
]
},
"cf9d2612-b582-4352-809e-31a38f4126b5": {
"main": [
[]
]
},
"2890694e-c503-4eda-825b-b569e7f8831a": {
"main": [
[
{
"node": "cf9d2612-b582-4352-809e-31a38f4126b5",
"type": "main",
"index": 0
}
],
[]
]
},
"0f02714d-0da3-4f86-ba62-97ce92883201": {
"main": [
[
{
"node": "65b5cb47-12d0-42a5-bb95-c023710dd310",
"type": "main",
"index": 0
}
],
[]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
LinkedInからのリーダーミネラブル潰の取り込みとデータ豊富化コピー
Apollo.io、LinkedIn API、Mail.so、GPT-3.5を使ってLinkedInの潜在顧客を生成し、豊富にする
If
Set
Code
+
If
Set
Code
53 ノードJoseph
営業
LinkedIn自動接続とセールス向けパーソナライズドメッセージ
LinkedIn：自動接続と販売パーソナライズドメッセージ
If
Set
Wait
+
If
Set
Wait
32 ノードVansh Arora
営業
🔐 二段階確認メール検証システム（Google Sheets使用）
🔐 Google Sheetsによる二重確認メール検証システム
If
Code
Form
+
If
Code
Form
24 ノードUn tal Camilo Medina
マーケティング
3D製品ビデオ
2D画像からEC店舗向け3D製品動画を生成
If
Code
Wait
+
If
Code
Wait
21 ノードInfyOm Technologies
デザイン
AIマーケティングエージェント：Reddit + OpenRouter + Gmail によるリードジェネレーション
AIマーケティングエージェント：Reddit、OpenRouter、Gmailを活用したリードジェネレーション
If
Set
Code
+
If
Set
Code
23 ノードAri Nakos
営業
AI YouTube分析アシスタント：コメント分析とインサイトレポート
AI YouTube分析アシスタント：コメント分析ツールとインサイトレポート生成ツール
If
Set
Code
+
If
Set
Code
19 ノードYaron Been
人工知能
ワークフロー情報
難易度
中級
ノード数9
カテゴリー1
ノードタイプ7
作成者
OneClick IT Consultancy P Limited
@oneclick-itOneClick is an award-winning offshore software development services company. Clients trust us for quality of service, innovation and AI driven technology solutions.
外部リンク
n8n.ioで表示 →
このワークフローを共有