WordPressお問い合わせフォーム（CF7）に応対してカテゴリ分類
上級
これはSales, Marketing分野の自動化ワークフローで、24個のノードを含みます。主にSet, Gmail, Webhook, GoogleSheets, ChainLlmなどのノードを使用。 Geminiを使って、WordPressお問い合わせフォーム（CF7）の返信と分類を自動化
前提条件
- •Googleアカウント + Gmail API認証情報
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •Google Sheets API認証情報
- •Google Gemini API Key
使用ノード (24)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "fvgP264GysfRJXdr",
"meta": {
"instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
"templateCredsSetupCompleted": true
},
"name": "WordPress Contact Form (CF7) Responses and Classification",
"tags": [],
"nodes": [
{
"id": "789a4732-c652-45b5-9019-4aa082cd3a29",
"name": "From Wordpress",
"type": "n8n-nodes-base.webhook",
"position": [
-500,
-120
],
"webhookId": "61858d25-af82-4cab-bb1b-68bea4989e15",
"parameters": {
"path": "61858d25-af82-4cab-bb1b-68bea4989e15",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "958507a3-d9ac-430f-8d3d-701544e995a0",
"name": "フィールド設定",
"type": "n8n-nodes-base.set",
"position": [
-240,
-120
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c2fb7eb9-898e-47ab-ae67-b3d2dcd9ac0e",
"name": "first_name",
"type": "string",
"value": "={{ $json.body.first_name }}"
},
{
"id": "8fb2afd5-aef8-4118-b760-ea21f0d3da95",
"name": "last_name",
"type": "string",
"value": "={{ $json.body.last_name }}"
},
{
"id": "292727f0-f08c-48a1-ada6-9437a056662d",
"name": "email",
"type": "string",
"value": "={{ $json.body.email }}"
},
{
"id": "394aec5f-2553-4210-8d37-b109772ac083",
"name": "phone",
"type": "string",
"value": "={{ $json.body.phone }}"
},
{
"id": "db9a1211-3aa5-4421-9ede-5231a2017c8a",
"name": "message",
"type": "string",
"value": "={{ $json.body.message }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "00b0653e-34a1-434e-abb5-ed3d4995ae58",
"name": "Google Gemini チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
-40,
80
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash"
},
"credentials": {
"googlePalmApi": {
"id": "0p34rXqIqy8WuoPg",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "55e80a8c-7c44-4324-bd79-024ab494177e",
"name": "メッセージ分類器",
"type": "@n8n/n8n-nodes-langchain.textClassifier",
"position": [
-20,
-120
],
"parameters": {
"options": {
"fallback": "other",
"systemPromptTemplate": "Please classify the text provided by the user into one of the following categories: {categories}, and use the provided formatting instructions below. Don't explain, and only output the json."
},
"inputText": "={{ $json.message }}",
"categories": {
"categories": [
{
"category": "Product Info",
"description": "Product information request"
},
{
"category": "Order Info",
"description": "Request information on the order placed"
}
]
}
},
"typeVersion": 1
},
{
"id": "44c87bc8-7b6d-4d0b-8f34-b3ab1150e5e1",
"name": "Google Gemini チャットモデル1",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
520,
420
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "0p34rXqIqy8WuoPg",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "a66b653e-7df1-4f69-b37e-71a064d975be",
"name": "メール下書き - その他情報",
"type": "n8n-nodes-base.gmail",
"position": [
980,
220
],
"webhookId": "37831ee6-2a6e-4036-a567-ed839ab4276e",
"parameters": {
"message": "={{ $json.output.text }}\n\n---\n\nFirst Name: {{ $('Set Fields').item.json.first_name }}\nLast Name: {{ $('Set Fields').item.json.last_name }}\nEmail: {{ $('Set Fields').item.json.email }}\nPhone: {{ $('Set Fields').item.json.phone }}\n\nMessage:\n{{ $('Set Fields').item.json.message }}",
"options": {
"sendTo": "={{ $('Message Classifier').item.json.email }}"
},
"subject": "={{ $json.output.subject }}",
"resource": "draft"
},
"credentials": {
"gmailOAuth2": {
"id": "nyuHvSX5HuqfMPlW",
"name": "Gmail account (n3w.it)"
}
},
"typeVersion": 2.1
},
{
"id": "adc0baaa-f265-4912-9a2a-0f5c6f5a15db",
"name": "メール作成者（その他）",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
540,
220
],
"parameters": {
"text": "=This is the message you received that you need to reply to:\n\nFirst Name: {{ $('Set Fields').item.json.first_name }}\nLast Name: {{ $('Set Fields').item.json.last_name }}\nEmail: {{ $('Set Fields').item.json.email }}\nPhone: {{ $('Set Fields').item.json.phone }}\n\nMessage:\n{{ $('Set Fields').item.json.message }}",
"messages": {
"messageValues": [
{
"message": "=# System Prompt for Form Response AI Agent\n\nYou are an AI assistant specialized in creating professional responses to customers who have filled out a form on the company website. Your purpose is to analyze the data received from the form and prepare a professional, courteous, and helpful draft response.\n\n## Basic Behavior\n- Carefully analyze all fields of the received form.\n- Generate a personalized response based on the information provided by the customer.\n- Maintain a professional yet friendly tone.\n- If crucial information is missing, insert a placeholder in square brackets [example: status of order #12345].\n- Adapt the response style according to the nature of the request (information request, complaint, technical support, etc.).\n\n## Response Structure\n1. **Header**: Appropriate greeting with the customer's name if available.\n2. **Acknowledgment**: Thank the customer for contacting the company.\n3. **Body**: Detailed response to the specific request, with all relevant details.\n4. **Action**: Clearly indicate what steps will be taken or what actions are required from the customer.\n5. **Closing**: Professional farewell formula with an offer of further assistance.\n6. **Signature**: Company name and relevant department.\n\n## Handling Specific Scenarios\n\n### Product/Service Information Requests\n- Provide precise details about requested products/services.\n- Include links to relevant pages on the website when appropriate.\n- Offer complementary options if relevant.\n\n### Order Status Requests\n- Confirm receipt of the request.\n- Insert order information if available or use placeholders [current status of order #12345].\n- Indicate expected delivery or completion times.\n\n### Complaints\n- Show empathy and understanding for the inconvenience.\n- Summarize the problem to demonstrate attentiveness.\n- Propose a concrete solution to the exposed problem.\n- Offer compensation when appropriate.\n\n### Technical Support\n- Confirm understanding of the technical issue.\n- Provide clear, step-by-step instructions.\n- Propose alternative solutions if necessary.\n- Offer a direct channel for continued assistance.\n\n## Personalization\n- Use the customer's name when available.\n- Reference previous interactions if mentioned.\n- Adapt technical language to the customer's apparent level of expertise.\n\n## Tone of Voice\n- Professional but not detached\n- Empathetic without being overly informal\n- Solution-oriented and action-focused\n- Clear and concise, avoiding ambiguity\n\nRemember: Each response must best represent the company image and leave the customer with a positive feeling of being heard and receiving competent assistance.\n\nToday is {{ $now }}"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "a700a2c9-0d12-48fb-92f0-c060ae656010",
"name": "Google Gemini チャットモデル2",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
520,
40
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "0p34rXqIqy8WuoPg",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "19887247-2d04-4f25-8610-c57dd5a6d0b7",
"name": "Google Gemini チャットモデル3",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
540,
-300
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "0p34rXqIqy8WuoPg",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "92a70faa-673d-4354-9146-4a533e096969",
"name": "メール作成者（注文情報）",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
540,
-120
],
"parameters": {
"text": "=This is the message you received that you need to reply to:\n\nFirst Name: {{ $('Set Fields').item.json.first_name }}\nLast Name: {{ $('Set Fields').item.json.last_name }}\nEmail: {{ $('Set Fields').item.json.email }}\nPhone: {{ $('Set Fields').item.json.phone }}\n\nMessage:\n{{ $('Set Fields').item.json.message }}",
"messages": {
"messageValues": [
{
"message": "=# System Prompt for Form Response AI Agent\n\nYou are an AI assistant specialized in creating professional responses to customers who have filled out a form on the company website. Your purpose is to analyze the data received from the form and prepare a professional, courteous, and helpful draft response.\n\n## Basic Behavior\n- Carefully analyze all fields of the received form.\n- Generate a personalized response based on the information provided by the customer.\n- Maintain a professional yet friendly tone.\n- If crucial information is missing, insert a placeholder in square brackets [example: status of order #12345].\n- Adapt the response style according to the nature of the request (information request, complaint, technical support, etc.).\n\n## Response Structure\n1. **Header**: Appropriate greeting with the customer's name if available.\n2. **Acknowledgment**: Thank the customer for contacting the company.\n3. **Body**: Detailed response to the specific request, with all relevant details.\n4. **Action**: Clearly indicate what steps will be taken or what actions are required from the customer.\n5. **Closing**: Professional farewell formula with an offer of further assistance.\n6. **Signature**: Company name and relevant department.\n\n## Handling Specific Scenarios\n\n### Product/Service Information Requests\n- Provide precise details about requested products/services.\n- Include links to relevant pages on the website when appropriate.\n- Offer complementary options if relevant.\n\n### Order Status Requests\n- Confirm receipt of the request.\n- Insert order information if available or use placeholders [current status of order #12345].\n- Indicate expected delivery or completion times.\n\n### Complaints\n- Show empathy and understanding for the inconvenience.\n- Summarize the problem to demonstrate attentiveness.\n- Propose a concrete solution to the exposed problem.\n- Offer compensation when appropriate.\n\n### Technical Support\n- Confirm understanding of the technical issue.\n- Provide clear, step-by-step instructions.\n- Propose alternative solutions if necessary.\n- Offer a direct channel for continued assistance.\n\n## Personalization\n- Use the customer's name when available.\n- Reference previous interactions if mentioned.\n- Adapt technical language to the customer's apparent level of expertise.\n\n## Tone of Voice\n- Professional but not detached\n- Empathetic without being overly informal\n- Solution-oriented and action-focused\n- Clear and concise, avoiding ambiguity\n\nRemember: Each response must best represent the company image and leave the customer with a positive feeling of being heard and receiving competent assistance.\n\nToday is {{ $now }}"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "1def4974-d267-4b6d-9256-412a6d02d6ba",
"name": "メール作成者（製品情報）",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
540,
-480
],
"parameters": {
"text": "=This is the message you received that you need to reply to:\n\nFirst Name: {{ $('Set Fields').item.json.first_name }}\nLast Name: {{ $('Set Fields').item.json.last_name }}\nEmail: {{ $('Set Fields').item.json.email }}\nPhone: {{ $('Set Fields').item.json.phone }}\n\nMessage:\n{{ $('Set Fields').item.json.message }}",
"messages": {
"messageValues": [
{
"message": "=# System Prompt for Form Response AI Agent\n\nYou are an AI assistant specialized in creating professional responses to customers who have filled out a form on the company website. Your purpose is to analyze the data received from the form and prepare a professional, courteous, and helpful draft response.\n\n## Basic Behavior\n- Carefully analyze all fields of the received form.\n- Generate a personalized response based on the information provided by the customer.\n- Maintain a professional yet friendly tone.\n- If crucial information is missing, insert a placeholder in square brackets [example: status of order #12345].\n- Adapt the response style according to the nature of the request (information request, complaint, technical support, etc.).\n\n## Response Structure\n1. **Header**: Appropriate greeting with the customer's name if available.\n2. **Acknowledgment**: Thank the customer for contacting the company.\n3. **Body**: Detailed response to the specific request, with all relevant details.\n4. **Action**: Clearly indicate what steps will be taken or what actions are required from the customer.\n5. **Closing**: Professional farewell formula with an offer of further assistance.\n6. **Signature**: Company name and relevant department.\n\n## Handling Specific Scenarios\n\n### Product/Service Information Requests\n- Provide precise details about requested products/services.\n- Include links to relevant pages on the website when appropriate.\n- Offer complementary options if relevant.\n\n### Order Status Requests\n- Confirm receipt of the request.\n- Insert order information if available or use placeholders [current status of order #12345].\n- Indicate expected delivery or completion times.\n\n### Complaints\n- Show empathy and understanding for the inconvenience.\n- Summarize the problem to demonstrate attentiveness.\n- Propose a concrete solution to the exposed problem.\n- Offer compensation when appropriate.\n\n### Technical Support\n- Confirm understanding of the technical issue.\n- Provide clear, step-by-step instructions.\n- Propose alternative solutions if necessary.\n- Offer a direct channel for continued assistance.\n\n## Personalization\n- Use the customer's name when available.\n- Reference previous interactions if mentioned.\n- Adapt technical language to the customer's apparent level of expertise.\n\n## Tone of Voice\n- Professional but not detached\n- Empathetic without being overly informal\n- Solution-oriented and action-focused\n- Clear and concise, avoiding ambiguity\n\nRemember: Each response must best represent the company image and leave the customer with a positive feeling of being heard and receiving competent assistance.\n\nToday is {{ $now }}"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "16be317a-c0ef-4603-913d-8bc5ad141d29",
"name": "メール下書き - 製品情報",
"type": "n8n-nodes-base.gmail",
"position": [
980,
-480
],
"webhookId": "37831ee6-2a6e-4036-a567-ed839ab4276e",
"parameters": {
"message": "={{ $json.output.text }}\n\n---\n\nFirst Name: {{ $('Set Fields').item.json.first_name }}\nLast Name: {{ $('Set Fields').item.json.last_name }}\nEmail: {{ $('Set Fields').item.json.email }}\nPhone: {{ $('Set Fields').item.json.phone }}\n\nMessage:\n{{ $('Set Fields').item.json.message }}",
"options": {
"sendTo": "={{ $('Message Classifier').item.json.email }}"
},
"subject": "={{ $json.output.subject }}",
"resource": "draft"
},
"credentials": {
"gmailOAuth2": {
"id": "nyuHvSX5HuqfMPlW",
"name": "Gmail account (n3w.it)"
}
},
"typeVersion": 2.1
},
{
"id": "9cc28565-e0e6-49ca-80f0-98f6eafe15e3",
"name": "メール下書き - 注文情報",
"type": "n8n-nodes-base.gmail",
"position": [
980,
-120
],
"webhookId": "37831ee6-2a6e-4036-a567-ed839ab4276e",
"parameters": {
"message": "={{ $json.output.text }}\n\n---\n\nFirst Name: {{ $('Set Fields').item.json.first_name }}\nLast Name: {{ $('Set Fields').item.json.last_name }}\nEmail: {{ $('Set Fields').item.json.email }}\nPhone: {{ $('Set Fields').item.json.phone }}\n\nMessage:\n{{ $('Set Fields').item.json.message }}",
"options": {
"sendTo": "={{ $('Message Classifier').item.json.email }}"
},
"subject": "={{ $json.output.subject }}",
"resource": "draft"
},
"credentials": {
"gmailOAuth2": {
"id": "nyuHvSX5HuqfMPlW",
"name": "Gmail account (n3w.it)"
}
},
"typeVersion": 2.1
},
{
"id": "098f2af1-8596-43e0-84cf-8271da85d63f",
"name": "シートに保存（製品）",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-480
],
"parameters": {
"columns": {
"value": {
"DATE": "={{ $now.format('dd/MM/yyyy') }}",
"DRAFT": "={{ $('Email writer (Product info)').item.json.output.text }}",
"PHONE": "={{ $('Set Fields').item.json.phone }}",
"EMAIL ": "={{ $('Set Fields').item.json.email }}",
"MESSAGE": "={{ $('Set Fields').item.json.message }}",
"LAST NAME": "={{ $('Set Fields').item.json.last_name }}",
"CLASSIFIED": "Other request",
"FIRST NAME": "={{ $('Set Fields').item.json.first_name }}"
},
"schema": [
{
"id": "DATE",
"type": "string",
"display": true,
"required": false,
"displayName": "DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FIRST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "FIRST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LAST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "LAST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL ",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PHONE",
"type": "string",
"display": true,
"required": false,
"displayName": "PHONE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MESSAGE",
"type": "string",
"display": true,
"required": false,
"displayName": "MESSAGE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLASSIFIED",
"type": "string",
"display": true,
"required": false,
"displayName": "CLASSIFIED",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DRAFT",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "DRAFT",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4/edit?usp=drivesdk",
"cachedResultName": "Contact Form 7"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "545afc6a-b6b1-445f-856a-cde7d8a0f2f6",
"name": "シートに保存（注文）",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-120
],
"parameters": {
"columns": {
"value": {
"DATE": "={{ $now.format('dd/MM/yyyy') }}",
"DRAFT": "={{ $('Email writer (Order info)').item.json.output.text }}",
"PHONE": "={{ $('Set Fields').item.json.phone }}",
"EMAIL ": "={{ $('Set Fields').item.json.email }}",
"MESSAGE": "={{ $('Set Fields').item.json.message }}",
"LAST NAME": "={{ $('Set Fields').item.json.last_name }}",
"CLASSIFIED": "Other request",
"FIRST NAME": "={{ $('Set Fields').item.json.first_name }}"
},
"schema": [
{
"id": "DATE",
"type": "string",
"display": true,
"required": false,
"displayName": "DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FIRST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "FIRST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LAST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "LAST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL ",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PHONE",
"type": "string",
"display": true,
"required": false,
"displayName": "PHONE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MESSAGE",
"type": "string",
"display": true,
"required": false,
"displayName": "MESSAGE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLASSIFIED",
"type": "string",
"display": true,
"required": false,
"displayName": "CLASSIFIED",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DRAFT",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "DRAFT",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4/edit?usp=drivesdk",
"cachedResultName": "Contact Form 7"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "6a8fb3a0-f31a-4177-98cb-de607e412772",
"name": "シートに保存（その他）",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
220
],
"parameters": {
"columns": {
"value": {
"DATE": "={{ $now.format('dd/MM/yyyy') }}",
"DRAFT": "={{ $('Email writer (Others)').item.json.output.text }}",
"PHONE": "={{ $('Set Fields').item.json.phone }}",
"EMAIL ": "={{ $('Set Fields').item.json.email }}",
"MESSAGE": "={{ $('Set Fields').item.json.message }}",
"LAST NAME": "={{ $('Set Fields').item.json.last_name }}",
"CLASSIFIED": "Other request",
"FIRST NAME": "={{ $('Set Fields').item.json.first_name }}"
},
"schema": [
{
"id": "DATE",
"type": "string",
"display": true,
"required": false,
"displayName": "DATE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FIRST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "FIRST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LAST NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "LAST NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL ",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PHONE",
"type": "string",
"display": true,
"required": false,
"displayName": "PHONE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MESSAGE",
"type": "string",
"display": true,
"required": false,
"displayName": "MESSAGE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLASSIFIED",
"type": "string",
"display": true,
"required": false,
"displayName": "CLASSIFIED",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DRAFT",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "DRAFT",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18nEagLwTPmJUN9UAJ2rEqZKB9C6LLD18bUpuY5vdOw4/edit?usp=drivesdk",
"cachedResultName": "Contact Form 7"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "bec108fe-4a5c-4d75-b589-1d74245f4bb9",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-360
],
"parameters": {
"color": 6,
"width": 800,
"height": 140,
"content": "## PRELIMINARY STEP\n- Download the Wordpress Plugin [CF7 to Webhook](https://wordpress.org/plugins/cf7-to-zapier/) and install it\n- Go to webhook tab on Wordpress and set the url of the n8n Webhook trigger\n- Set the POST request"
},
"typeVersion": 1
},
{
"id": "e82d4a99-0839-4ef3-a89f-25c1fdcfd636",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-180
],
"parameters": {
"width": 360,
"height": 200,
"content": "Set your own classification categories"
},
"typeVersion": 1
},
{
"id": "6e9967e0-21ca-4307-9fbc-e846e63e03ac",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
-600
],
"parameters": {
"width": 320,
"height": 1140,
"content": "Create the draft of the reply email by dividing it into subject and text ready to be sent"
},
"typeVersion": 1
},
{
"id": "7390f9c8-d243-4d15-b887-ab8c61c32948",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
940,
-600
],
"parameters": {
"width": 180,
"height": 1140,
"content": "send the draft to the correct department's company email"
},
"typeVersion": 1
},
{
"id": "002e8fc9-92f2-4453-bc16-58068f372bf4",
"name": "件名と本文",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
720,
-300
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\n\t\t\"subject\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"text\": {\n\t\t\t\"type\": \"string\"\n\t\t}\n\t}\n}"
},
"typeVersion": 1.2
},
{
"id": "c5b3690c-47c2-4faa-90fd-84556658f4a5",
"name": "件名と本文2",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
720,
20
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\n\t\t\"subject\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"text\": {\n\t\t\t\"type\": \"string\"\n\t\t}\n\t}\n}"
},
"typeVersion": 1.2
},
{
"id": "d1498232-9ecd-4abd-ae84-f8936bcbb2b8",
"name": "件名と本文3",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
740,
420
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\n\t\t\"subject\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n\t\t\"text\": {\n\t\t\t\"type\": \"string\"\n\t\t}\n\t}\n}"
},
"typeVersion": 1.2
},
{
"id": "05fa4b16-4328-49f0-bb31-6b2a0f4b1df4",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-680
],
"parameters": {
"color": 3,
"width": 800,
"height": 280,
"content": "# WordPress Contact Form (CF7) Responses and Classification \n\nThis workflow optimizes the management of inquiries received through a contact form on a WordPress site, automating the process of classification, response drafting, and data storage.\n\nThis workflow is particularly useful for businesses that receive multiple daily inquiries and want to improve their efficiency in managing customer communications. "
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "0c27484c-95ca-45c4-89cb-eada3117c9a3",
"connections": {
"958507a3-d9ac-430f-8d3d-701544e995a0": {
"main": [
[
{
"node": "55e80a8c-7c44-4324-bd79-024ab494177e",
"type": "main",
"index": 0
}
]
]
},
"789a4732-c652-45b5-9019-4aa082cd3a29": {
"main": [
[
{
"node": "958507a3-d9ac-430f-8d3d-701544e995a0",
"type": "main",
"index": 0
}
]
]
},
"002e8fc9-92f2-4453-bc16-58068f372bf4": {
"ai_outputParser": [
[
{
"node": "1def4974-d267-4b6d-9256-412a6d02d6ba",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"55e80a8c-7c44-4324-bd79-024ab494177e": {
"main": [
[
{
"node": "1def4974-d267-4b6d-9256-412a6d02d6ba",
"type": "main",
"index": 0
}
],
[
{
"node": "92a70faa-673d-4354-9146-4a533e096969",
"type": "main",
"index": 0
}
],
[
{
"node": "adc0baaa-f265-4912-9a2a-0f5c6f5a15db",
"type": "main",
"index": 0
}
]
]
},
"c5b3690c-47c2-4faa-90fd-84556658f4a5": {
"ai_outputParser": [
[
{
"node": "92a70faa-673d-4354-9146-4a533e096969",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"d1498232-9ecd-4abd-ae84-f8936bcbb2b8": {
"ai_outputParser": [
[
{
"node": "adc0baaa-f265-4912-9a2a-0f5c6f5a15db",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"adc0baaa-f265-4912-9a2a-0f5c6f5a15db": {
"main": [
[
{
"node": "a66b653e-7df1-4f69-b37e-71a064d975be",
"type": "main",
"index": 0
}
]
]
},
"9cc28565-e0e6-49ca-80f0-98f6eafe15e3": {
"main": [
[
{
"node": "545afc6a-b6b1-445f-856a-cde7d8a0f2f6",
"type": "main",
"index": 0
}
]
]
},
"a66b653e-7df1-4f69-b37e-71a064d975be": {
"main": [
[
{
"node": "6a8fb3a0-f31a-4177-98cb-de607e412772",
"type": "main",
"index": 0
}
]
]
},
"00b0653e-34a1-434e-abb5-ed3d4995ae58": {
"ai_languageModel": [
[
{
"node": "55e80a8c-7c44-4324-bd79-024ab494177e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"92a70faa-673d-4354-9146-4a533e096969": {
"main": [
[
{
"node": "9cc28565-e0e6-49ca-80f0-98f6eafe15e3",
"type": "main",
"index": 0
}
]
]
},
"44c87bc8-7b6d-4d0b-8f34-b3ab1150e5e1": {
"ai_languageModel": [
[
{
"node": "adc0baaa-f265-4912-9a2a-0f5c6f5a15db",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"a700a2c9-0d12-48fb-92f0-c060ae656010": {
"ai_languageModel": [
[
{
"node": "92a70faa-673d-4354-9146-4a533e096969",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"19887247-2d04-4f25-8610-c57dd5a6d0b7": {
"ai_languageModel": [
[
{
"node": "1def4974-d267-4b6d-9256-412a6d02d6ba",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"16be317a-c0ef-4603-913d-8bc5ad141d29": {
"main": [
[
{
"node": "098f2af1-8596-43e0-84cf-8271da85d63f",
"type": "main",
"index": 0
}
]
]
},
"1def4974-d267-4b6d-9256-412a6d02d6ba": {
"main": [
[
{
"node": "16be317a-c0ef-4603-913d-8bc5ad141d29",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
WordPressブログ記事をAIで最適化する究極のガイド
AIとGoogle Sheetsを使ったWordPress記事のSEO最適化の自動化
Set
Wordpress
Http Request
+
Set
Wordpress
Http Request
21 ノードDavide
人工知能
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
自動化された毎日の顧客回復活動と AI オファー
AI併用による毎日の顧客挽回活動の自動化
If
Set
Gmail
+
If
Set
Gmail
17 ノードOnur
サポート
毎日のニュース要約：RSSフィードをScrapeGraphAIで集めてメール/テレグラムに送信
GPTとGeminiを用いてRSSフィードからパーソナライズされたニュースサマリー作成し、メール/Telegramへ送信
Set
Gmail
Limit
+
Set
Gmail
Limit
22 ノードDavide
コンテンツ作成
ScrapeGraph AIを使用してn8nコミュニティで最近追加されたワ流を抽出
ScrapeGraphAI、Geminiを使ってn8nコミュニティで最近追加されたワークフローを抽出・保存する
Set
Merge
Split Out
+
Set
Merge
Split Out
21 ノードDavide
その他
AIメール分诊与GPT-4警报系统及Telegram通知
AIメール分诊与GPT-4警报系统及Telegram通知
If
Set
Gmail
+
If
Set
Gmail
104 ノードPeter Joslyn
サポート
ワークフロー情報
難易度
上級
ノード数24
カテゴリー2
ノードタイプ9
作成者
Davide
@n3witaliaFull-stack Web Developer based in Italy specialising in Marketing & AI-powered automations. For business enquiries, send me an email at info@n3w.it or add me on Linkedin.com/in/davideboizza
外部リンク
n8n.ioで表示 →
このワークフローを共有