カスタマーレビュー収集とGPT-4分析、Jotform、Gmail、Googleスプレッドシート
中級
これは自動化ワークフローで、15個のノードを含みます。主にSet, Code, Gmail, GoogleSheets, JotFormTriggerなどのノードを使用。 Jotform、Gmail、Google テーブルを使用して顧客の評価を収集し、GPT-4 で分析する
前提条件
- •Googleアカウント + Gmail API認証情報
- •Google Sheets API認証情報
- •OpenAI API Key
カテゴリー
-
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "277842713620d9f5554de3b1518b865a152c8c4db680008bd8aec536fc18b4a8"
},
"nodes": [
{
"id": "111a0f7d-7e79-4bce-9499-31f9b05de3c4",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
16
],
"parameters": {
"color": 4,
"width": 360,
"height": 472,
"content": "Customer Testimonial Collector - Purpose: Transform scattered testimonials into organized marketing assets with AI-powered analysis. Key Features: Centralized testimonial submission, AI tone and sentiment detection, Automatic quote extraction, Marketing-ready content log, Automated thank-you with rewards, Social media optimization. Impact: 500 percent increase in testimonial collection, instant marketing assets"
},
"typeVersion": 1
},
{
"id": "7dd98765-6e75-49fb-85d5-0b3c8f4c4a3e",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-384,
-16
],
"parameters": {
"color": 5,
"width": 340,
"height": 524,
"content": "Jotform Testimonial Fields: Customer Name, Customer Email, Company Name, Job Title, Product or Service Used, Testimonial Text, Rating, Permission to Share, Photo Upload, Use Case or Industry. Create your form for free on Jotform\nCreate your form for free on [Jotform using this link](https://www.jotform.com/?partner=mediajade)"
},
"typeVersion": 1
},
{
"id": "296a41d8-94ff-4eb0-9d73-0e192e5a315b",
"name": "テスタモニアルデータ抽出",
"type": "n8n-nodes-base.set",
"position": [
-192,
352
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "customer_name",
"name": "customerName",
"type": "string",
"value": "={{ $json['Customer Name'] }}"
},
{
"id": "customer_email",
"name": "customerEmail",
"type": "string",
"value": "={{ $json['Customer email'] }}"
},
{
"id": "company_name",
"name": "companyName",
"type": "string",
"value": "={{ $json['Company Name'] }}"
},
{
"id": "product_service",
"name": "productService",
"type": "string",
"value": "={{ $json['Product/service'] }}"
},
{
"id": "testimonial_text",
"name": "testimonialText",
"type": "string",
"value": "={{ $json['Testimonial Text'] }}"
},
{
"id": "rating",
"name": "rating",
"type": "number",
"value": "={{ $json.Rating }}"
},
{
"id": "submitted_at",
"name": "submittedAt",
"type": "string",
"value": "={{ $now.toISO() }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "cb2f4ae6-07c1-4441-9634-b719bc13e196",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-16,
0
],
"parameters": {
"color": 6,
"width": 408,
"height": 508,
"content": "AI Testimonial Analysis - AI Analyzes For: Tone and Sentiment, Best Quote Extraction, Key Benefits Mentioned, Emotional Impact Score, Marketing Use Cases, Social Media Optimization. Output: Marketing-ready assets"
},
"typeVersion": 1
},
{
"id": "3019c6a9-0a80-4fda-82dc-3d9f5753c1d0",
"name": "AIテスタモニアル分析",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
0,
304
],
"parameters": {
"text": "Analyze this customer testimonial and extract marketing insights. Customer name, Company, Title, Product, Rating out of 5, and Testimonial text provided. Return JSON with: overallTone, sentimentScore 0-100, emotionalImpact, authenticity, bestQuote max 280 chars, alternateQuotes array, keyBenefitsMentioned array, painPointsAddressed array, specificResults array, marketingUseCase, targetAudience, twitterVersion 280 chars, linkedinVersion 150 words, websiteVersion 50-75 words, headlineVersion 10 words, calloutWords array, marketingPriority high medium or low",
"agent": "conversationalAgent",
"options": {
"systemMessage": "You are a marketing copywriter. Extract compelling elements from testimonials and optimize for marketing channels."
},
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "4dbf0dde-e75d-4e36-9fa5-7482747cd2f2",
"name": "AI分析結果解析",
"type": "n8n-nodes-base.set",
"position": [
272,
304
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "919aa6bf-5541-4f2d-81a0-54fe9b2bf141",
"name": "output",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "b679a227-4334-40a8-b017-f19c6f134fa9",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
-48
],
"parameters": {
"color": 2,
"width": 340,
"height": 524,
"content": "Testimonial Content Log - Google Sheets Database: Complete testimonial details, AI analysis and quotes, Marketing versions, Permission tracking, Searchable library. Enables: Easy marketing access"
},
"typeVersion": 1
},
{
"id": "d30e7007-322b-43c1-9f82-809a3627e365",
"name": "テスタモニアルライブラリに記録",
"type": "n8n-nodes-base.googleSheets",
"position": [
512,
192
],
"parameters": {
"columns": {
"value": {
"email": "={{ $('Jotform Trigger').item.json['Customer email'] }}",
"rating": "={{ $('Jotform Trigger').item.json.Rating }}",
"compnay name": "={{ $('Jotform Trigger').item.json['Company Name'] }}",
"Customer name ": "={{ $('Jotform Trigger').item.json['Customer Name'] }}",
"product/service": "={{ $('Jotform Trigger').item.json['Product/service'] }}",
"testiminial text": "={{ $('Jotform Trigger').item.json['Testimonial Text'] }}"
},
"schema": [
{
"id": "Customer name ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Customer name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rating",
"type": "string",
"display": true,
"required": false,
"displayName": "rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "compnay name",
"type": "string",
"display": true,
"required": false,
"displayName": "compnay name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "testiminial text",
"type": "string",
"display": true,
"required": false,
"displayName": "testiminial text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product/service",
"type": "string",
"display": true,
"required": false,
"displayName": "product/service",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Customer name "
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1K0lqkb-z0fbdb_pEUDtUfl5N2jQ_nT-YEQtylwB4968",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1K0lqkb-z0fbdb_pEUDtUfl5N2jQ_nT-YEQtylwB4968/edit?usp=drivesdk",
"cachedResultName": "Fleet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "fc5e67db-7ab5-4288-a1c4-bcba869b71b7",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
-48
],
"parameters": {
"color": 3,
"width": 340,
"height": 440,
"content": "Customer Thank You - Automated Email: Thank customer, Show usage preview, Exclusive coupon code, Referral incentive, Social share versions. Drives: Loyalty and advocacy"
},
"typeVersion": 1
},
{
"id": "8d2e5076-9867-4ceb-8867-9fcb910e2380",
"name": "クーポンコード生成",
"type": "n8n-nodes-base.code",
"position": [
656,
352
],
"parameters": {
"jsCode": "const jotformData = items[0].json;\nconst customerName = jotformData['Customer Name'] || 'Customer';\nconst rating = parseInt(jotformData.Rating) || 3;\n\nconst namePart = customerName.substring(0, 5).replace(/\\s/g, '');\nconst randomNum = Math.floor(Math.random() * 9999);\nconst couponCode = 'THANKS' + namePart + randomNum;\n\nlet discountPercent = 10;\nif (rating === 5) {\n discountPercent = 20;\n} else if (rating === 4) {\n discountPercent = 15;\n}\n\nconst expiryDate = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString().slice(0, 10);\n\nreturn [{\n json: {\n couponCode: couponCode,\n discountPercent: discountPercent,\n expiryDays: 30,\n expiryDate: expiryDate,\n customerName: customerName,\n customerEmail: jotformData['Customer email'],\n rating: rating\n }\n}];"
},
"typeVersion": 2
},
{
"id": "8126ef33-ad08-47d5-803e-0ec77f1d8233",
"name": "感謝メール送信",
"type": "n8n-nodes-base.gmail",
"position": [
1104,
160
],
"webhookId": "0c1d2859-6662-4712-98d3-4e09ee485278",
"parameters": {
"sendTo": "={{ $json.customerEmail }}",
"message": "Hi there, Thank you for your testimonial! Your feedback means the world to us. As a token of appreciation, here is your exclusive coupon code: CODE with DISCOUNT percent off, valid until EXPIRY. We truly appreciate your support! Best regards, The Team",
"options": {},
"subject": "Thank You for Your Testimonial!"
},
"credentials": {
"gmailOAuth2": {
"id": "",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "2c22739d-2bec-49a6-a606-3341cc26e3ee",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
896,
416
],
"parameters": {
"color": 7,
"width": 320,
"height": 328,
"content": "Marketing Team Alert - Notification Includes: New testimonial available, AI analysis summary, Best quotes, Priority level, Usage recommendations. Enables: Immediate campaign use"
},
"typeVersion": 1
},
{
"id": "9960fab6-6012-4e86-9020-fb83c1949946",
"name": "マーケティングチームに通知",
"type": "n8n-nodes-base.gmail",
"position": [
1088,
576
],
"webhookId": "7f79cc58-9d80-4582-9385-1f2a2597ceee",
"parameters": {
"sendTo": "marketing@yourcompany.com",
"message": "New testimonial available. Customer details and AI analysis included. Please check the testimonial library for full details.",
"options": {},
"subject": "New Testimonial Received"
},
"credentials": {
"gmailOAuth2": {
"id": "",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "411f477b-f50a-4089-b246-6fde5d782e3d",
"name": "Jotformトリガー",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-368,
352
],
"webhookId": "testimonial-submission-webhook",
"parameters": {
"form": "252892971568071"
},
"credentials": {
"jotFormApi": {
"id": "W7O1b225FpOwkwDT",
"name": "Jotform account-Deepanshi"
}
},
"typeVersion": 1
},
{
"id": "780472ed-f2ed-4a0e-8844-2cd3ef4d01de",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
0,
464
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8IkhtT3EbXygnvcr",
"name": "Klinsman OpenAI"
}
},
"typeVersion": 1.2
}
],
"pinData": {},
"connections": {
"411f477b-f50a-4089-b246-6fde5d782e3d": {
"main": [
[
{
"node": "296a41d8-94ff-4eb0-9d73-0e192e5a315b",
"type": "main",
"index": 0
}
]
]
},
"780472ed-f2ed-4a0e-8844-2cd3ef4d01de": {
"ai_languageModel": [
[
{
"node": "3019c6a9-0a80-4fda-82dc-3d9f5753c1d0",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"4dbf0dde-e75d-4e36-9fa5-7482747cd2f2": {
"main": [
[
{
"node": "d30e7007-322b-43c1-9f82-809a3627e365",
"type": "main",
"index": 0
},
{
"node": "8d2e5076-9867-4ceb-8867-9fcb910e2380",
"type": "main",
"index": 0
}
]
]
},
"8d2e5076-9867-4ceb-8867-9fcb910e2380": {
"main": [
[
{
"node": "8126ef33-ad08-47d5-803e-0ec77f1d8233",
"type": "main",
"index": 0
},
{
"node": "9960fab6-6012-4e86-9020-fb83c1949946",
"type": "main",
"index": 0
}
]
]
},
"3019c6a9-0a80-4fda-82dc-3d9f5753c1d0": {
"main": [
[
{
"node": "4dbf0dde-e75d-4e36-9fa5-7482747cd2f2",
"type": "main",
"index": 0
}
]
]
},
"296a41d8-94ff-4eb0-9d73-0e192e5a315b": {
"main": [
[
{
"node": "3019c6a9-0a80-4fda-82dc-3d9f5753c1d0",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
GPT-4を使用してJotFormを活用した退職インタビューによる従業員の離職プロセスの自動化
GPT-4を使用してJotFormの入退社インタビューを活用した従業員離職業務の自動化
If
Set
Code
+
If
Set
Code
20 ノードJitesh Dugar
JotForm、GPT-4o-mini、Google Workspaceを使用した従業員の入社業務の自動化
JotForm、GPT-4o-mini、Google Workspaceを使用した従業員採用業務の自動化
If
Set
Code
+
If
Set
Code
14 ノードJitesh Dugar
Jotform、GPT-4 を使用した貸出前審査の自動化と Gmail による通知
Jotform、GPT-4、アнализローン承認前通知をGmailで自動化
If
Set
Code
+
If
Set
Code
21 ノードJitesh Dugar
GPT-4o-mini、JotForm、Gmailを使って不動産管理リクエストを自動化
GPT-4o-mini、JotForm、Gmailを使用して不動産保守リクエストを自動化
If
Set
Code
+
If
Set
Code
21 ノードJitesh Dugar
車両点検とメンテナンスワークフロー自動化
OpenAI および JotForm を使用した車両点検およびメンテナンス ワーキングフローの自動化
If
Set
Code
+
If
Set
Code
20 ノードJitesh Dugar
GPT-4、JotForm、そしてGoogleスプレッドシートを使った自動企業研修リクエスト
GPT-4、JotForm、Google シートを用いた自動企業研修リクエスト
If
Set
Code
+
If
Set
Code
21 ノードJitesh Dugar
ワークフロー情報
難易度
中級
ノード数15
カテゴリー-
ノードタイプ8
作成者
Jitesh Dugar
@jiteshdugarAI Automation Specialist - OpenAI, CRM & Automation Expert with a solid understanding of various tools that include Zapier, Make, Zoho CRM, Hubspot, Google Sheets, Airtable, Pipedrive, Google Analytics, and more.
外部リンク
n8n.ioで表示 →
このワークフローを共有