毎日の WhatsApp グループ スマート分析：GPT-4.1 による分析と音声メッセージの transcrição
上級
これはMiscellaneous, AI Summarization, Multimodal AI分野の自動化ワークフローで、52個のノードを含みます。主にIf, Set, Code, Wait, Mergeなどのノードを使用。 毎日の WhatsApp グループ インタラクティブ分析：GPT-4.1 分析と音声メッセージ文字起こし
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (52)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "e5475e3f5ea4317f0b981b80d6948e4bd2ba92e8c8af9ecbbaf8d90708882234",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "d3291913-7527-4801-b9d7-045d0411cab2",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1216,
-448
],
"parameters": {
"width": 612,
"height": 1056,
"content": "## WHATSAPP GROUP INTELLIGENCE SYSTEM\n\n\n## What This Workflow Does\nTransforms your WhatsApp group conversations into actionable business intelligence with daily AI-powered summaries.\n\n**Two Main Operations:**\n🔄 **Real-Time Capture**: Monitors WhatsApp groups and stores messages in Google Sheets\n📊 **Daily Analysis**: AI analyzes conversations and sends intelligent summaries\n\n## Who It's For\n- Tech teams monitoring industry trends\n- Business intelligence professionals \n- Community managers tracking discussions\n- Research teams analyzing conversation patterns\n\n## Key Features\n✅ Real-time message capture from multiple groups\n✅ Automatic voice message transcription\n✅ AI-powered content analysis and filtering\n✅ Automated daily summary distribution\n✅ Smart content categorization\n\n## What You'll Get\n- Organized message storage in Google Sheets\n- Daily intelligent summaries focusing on:\n • AI and automation insights\n • Technical solutions and tools\n • Business opportunities\n • Industry trends and comparisons\n\n## Requirements\n- Evolution API (WhatsApp Business integration)\n- Google Sheets for storage\n- OpenRouter API (AI analysis)\n- OpenAI API (voice transcription)\n\n**Setup Time**: 15-20 minutes\n**Difficulty**: Intermediate\n\nReady to turn conversations into intelligence? \nFollow the configuration notes below! 👇"
},
"typeVersion": 1
},
{
"id": "5e098de8-30ec-4083-b2e8-d14c61fc16c5",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1232,
656
],
"parameters": {
"color": 3,
"width": 620,
"height": 368,
"content": "## Find your Groups\nRun this node to find your groups, modify and set your instance."
},
"typeVersion": 1
},
{
"id": "d551f496-15af-43a9-b783-1318a155c7df",
"name": "Webhook-EVO",
"type": "n8n-nodes-base.webhook",
"position": [
-320,
480
],
"webhookId": "0c2a31c8-5291-4fe2-b598-ec6508ff97dc",
"parameters": {
"path": "0c2a31c8-5291-4fe2-b598-ec6508ff97dc",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "a9ff266a-b4d8-408c-baf3-a4d0af5acae5",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
128
],
"parameters": {
"color": 3,
"width": 464,
"height": 588,
"content": "🔴 CRITICAL CONFIGURATION\n\n## Set Your WhatsApp Groups Here\nYou MUST update these group IDs:\n\n📍 grupo_1: Replace with your first group ID\n📍 grupo_2: Replace with your second group ID \n📍 grupo_3: Replace with your third group ID\n\n❓ Don't know your Group IDs?\nExecute the \"Busca tus Grupos\" node first to find them!\n\n⚠️ The workflow won't work without correct group IDs"
},
"typeVersion": 1
},
{
"id": "19318cb3-dea1-4081-b409-d97f0f67e141",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-448,
176
],
"parameters": {
"color": 3,
"width": 380,
"height": 512,
"content": "🔴 WEBHOOK SETUP REQUIRED\n\n## Evolution API Configuration\n1. Copy this webhook URL\n2. In Evolution API, configure:\n ✅ MESSAGES_UPSERT\n ✅ GROUP_PARTICIPANTS_UPDATE\n ❌ Disable IGNORE_GROUPS\n\n⚠️ Without proper webhook setup, \n no messages will be captured!"
},
"typeVersion": 1
},
{
"id": "9de8d3e6-d0b0-4c34-bc38-a71ea9cd11e6",
"name": "情報設定",
"type": "n8n-nodes-base.set",
"position": [
224,
480
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ad7e3078-6fe3-40cb-b82b-4417beb93aea",
"name": "grupo_1",
"type": "string",
"value": "120363385314338356@g.us"
},
{
"id": "41542812-c9d2-4655-b5af-d872d271b557",
"name": "grupo_2",
"type": "string",
"value": "120363419074159638@g.us"
},
{
"id": "ef2b0919-afc7-46c0-b8b3-ef3ae26fd8ea",
"name": "grupo_3",
"type": "string",
"value": "120363422252178175@g.us"
},
{
"id": "450a265d-c325-49b4-96e6-e39721f82c48",
"name": "grupo_recibido",
"type": "string",
"value": "={{ $json.body.data.key.remoteJid }}"
},
{
"id": "7ea6872d-7fa9-49ac-b1ab-f3c14e94bb14",
"name": "mensaje",
"type": "string",
"value": "={{ $json.body.data.message.conversation }}"
},
{
"id": "722e2251-7328-41d3-a75f-11aa8554acc9",
"name": "nombre",
"type": "string",
"value": "={{ $json.body.data.pushName }}"
},
{
"id": "91ec7b09-b97d-4718-92e5-dee3a695ecf7",
"name": "hora",
"type": "string",
"value": "={{ $json.body.date_time }}"
},
{
"id": "7b31d367-b881-4826-babe-cf71834b0b1c",
"name": "mensaje_respondido",
"type": "string",
"value": "={{ $json.body.data.contextInfo.quotedMessage.conversation }}"
},
{
"id": "ad9af313-4adc-4076-ab5c-13ee7297f277",
"name": "caption",
"type": "string",
"value": "={{ $json.body.data.message.imageMessage.caption }}"
},
{
"id": "eaade811-c15a-4a12-8d3f-0bf1443d2963",
"name": "audio",
"type": "string",
"value": "={{ $json.body.data.messageType }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2a2f7841-df24-4803-b64a-d23cb4eafc59",
"name": "要約設定",
"type": "n8n-nodes-base.set",
"position": [
1664,
1616
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b3ff71a2-8cb9-4ab9-a2c2-5ac7b58cbfa5",
"name": "texto",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "79fc1fe9-ef9b-450c-afe8-22cacdc63fd4",
"name": "スイッチ",
"type": "n8n-nodes-base.switch",
"position": [
1120,
448
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Group 1",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "af09b72f-bfa2-4f30-8c08-6b41ed525227",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.received_group }}",
"rightValue": "={{ $json.group_1 }}"
}
]
},
"renameOutput": true
},
{
"outputKey": "Group 2",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b3c4f5c1-3fc7-4bfd-8a6f-5b6227a9c11a",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.received_group }}",
"rightValue": "={{ $json.group_1 }}"
}
]
},
"renameOutput": true
},
{
"outputKey": "Group 3",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fd7a8da2-caaf-4a75-bd1d-767e85d0fffa",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.received_group }}",
"rightValue": "={{ $json.group_3 }}"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "6c29d63f-54a8-4146-b270-55b67073f9b2",
"name": "マージ",
"type": "n8n-nodes-base.merge",
"position": [
720,
1600
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3.2
},
{
"id": "1e226472-85c4-483a-b727-c434d1822b89",
"name": "何もしない",
"type": "n8n-nodes-base.noOp",
"position": [
864,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "81bcf337-856c-4197-9b37-a7cd58994013",
"name": "分割出力",
"type": "n8n-nodes-base.splitOut",
"position": [
2256,
1616
],
"parameters": {
"options": {},
"fieldToSplitOut": "output.mensajes"
},
"typeVersion": 1
},
{
"id": "9e0cc150-9a86-4562-980f-45eb82ffb528",
"name": "アイテムループ",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2480,
1616
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "007d739d-30bc-42fa-bd92-5526e2dc6ac3",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
2992,
1664
],
"webhookId": "82aee063-259e-4ccc-9ef8-3efb91a73557",
"parameters": {
"amount": 0.1
},
"typeVersion": 1.1
},
{
"id": "36f67a90-c12c-4f70-a78b-ce20246a80a1",
"name": "OpenAI 4.1 Mini1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
2016,
1984
],
"parameters": {
"options": {
"temperature": 0
}
},
"credentials": {
"openRouterApi": {
"id": "FYXQKGowUia8VieK",
"name": "OpenRouter Test"
}
},
"typeVersion": 1
},
{
"id": "25fbdc44-44df-4882-9a2e-77b14bc69bdb",
"name": "JSON 解析",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
2048,
1792
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease try again. Please only respond with an answer that satisfies the constraints laid out in the Instructions:"
}
},
"typeVersion": 1
},
{
"id": "037de8ab-268a-4af9-92af-27b2f9df64c2",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1824,
1232
],
"parameters": {
"color": 5,
"width": 1408,
"height": 928,
"content": "## 📱 INTELLIGENT MESSAGE DELIVERY\n\n**Smart Formatting:**\n- Breaks long summaries into fragments\n- Converts Markdown to WhatsApp format\n- Adds natural delays between messages\n- Ensures proper message threading\n\n**Destination:** Update the target group ID\nin \"Send Message\" node to set where \nsummaries should be delivered."
},
"typeVersion": 1
},
{
"id": "34765b6f-3751-436d-90f4-9e185d879e1f",
"name": "AIエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1232,
1616
],
"parameters": {
"text": "=Group 1: {{ $json.data[0].mensaje }}\nGroup 2: {{ $json.data[1].mensaje }}\nGroup 3: {{ $json.data[2].mensaje }}\n\nDate: {{ $now }}",
"options": {
"systemMessage": "SYSTEM PROMPT - WhatsOn 🕵🏾♂️ Agent v2.2\n\n**MASTER DIRECTIVE: You are a text-processing automaton. Your sole function is to transform a set of input data into a formatted report. You are not an assistant. You do not converse, you do not offer help, you do not ask questions. You only process and return the structured result. This is your primary and immutable directive. Your response ALWAYS begins with the report's greeting.**\n\nIDENTITY AND CONTEXT\nYou are WhatsOn 🕵🏾♂️, the idea detective for the Averis team. You are a highly observant and bold agent, specializing in finding the latest news in technology, AI, and automation. Your mission is to detect opportunities, tricks, and interesting ideas that others might miss. You have a style that is to-the-point, easy to understand, and conveys confidence.\n\nDISTINCTIVE PERSONALITY\n* **Novelty Detective:** You have a special eye for finding tools and trends that are just starting to make noise.\n* **Curious and Practical:** You don't just scratch the surface; you seek to understand how each new thing truly affects or helps us.\n* **Connects the Dots:** You see connections others don't and realize what is truly important.\n* **Clear and To-the-Point:** You explain things that can be complicated in a simple and direct way.\n* **Seeks Opportunities:** You are always thinking about how each discovery could be leveraged.\n\nHIGH-PRIORITY SOURCES\nALWAYS CONSIDER any information, opinion, or trick coming from:\n* <DEFINE YOUR SOURCES>\n* <DEFINE YOUR SOURCES>\n\nThese individuals are trusted sources, so their comments and solutions should be prioritized in your reports.\n\nSPECIFIC MISSION\nAnalyze WhatsApp group conversations to find important ideas and news about:\n* **Artificial Intelligence** (new tools, AI models, major changes, and important updates).\n* **Automation and N8N** (useful setups, creative workflows, ingenious solutions).\n* **Servers and Hosting** (VPS, databases, cloud services, optimization tricks).\n* **Tools for better work** (new platforms, software, and ways to be more productive).\n* **Industry Trends** (movements or news that could affect our work).\n* **Comparisons and pricing** that help decide which tool to use.\n* **Smart technical solutions** to common problems.\n\nFILTERING CRITERIA\n**HIGH PRIORITY:**\n* New tools that could be game-changers.\n* Solutions or configurations that cleverly solve a problem.\n* New trends that seem important.\n* Comparisons that make it clear which option is better.\n* Difficult problems with simple, practical solutions.\n* Opportunities to improve something or save costs.\n* Interesting ideas from people who are already testing the latest tech.\n\n**FILTER OUT:**\n* Day-to-day conversations with no useful information.\n* Information that everyone already knows.\n* Social chatter that adds no value.\n\nANALYSIS PROTOCOL\n1. **SMART SCAN**\n Identify the ideas, trends, and opportunities in the groups.\n2. **PRACTICAL EVALUATION**\n * If you detect nothing interesting: \"The radar has been quiet today, with no significant movements in the tech world.\"\n * If there is something worthwhile: Create the report with a clear and useful analysis.\n\nOUTPUT STRUCTURE\n**DISTINCTIVE GREETING**\nPersonality-filled options (vary each time):\n* \"Hello! WhatsOn 🕵🏾♂️ reporting in. Here’s what I've detected today.\"\n* \"Hi team! WhatsOn 🕵🏾♂️ speaking. I'm bringing you the most interesting ideas of the day.\"\n* \"What's up! WhatsOn 🕵🏾♂️ here, with the radar on. I come bearing curious findings.\"\n* \"Good afternoon! WhatsOn 🕵🏾♂️ reporting. I've been investigating and have some news that will interest you.\"\n\n**ACCESSIBLE CONTENT FORMAT**\nEach idea is presented in a clear and structured way:\n### **[DIRECT AND CATCHY TITLE]**\n\n**🔍 What have I seen?**\n[A simple explanation of the news, tool, or idea you've found.]\n\n**💡 Why is it interesting?**\n[Why this matters to us, what problem it solves, or what advantage it gives us.]\n\n**🎯 What can we do?**\n[A clear idea of how we could leverage, test, or consider it.]\n\n**INVESTIGATOR EMOJIS**\nUse these emojis to provide visual cues:\n* 🚀 For game-changing news.\n* 📈 For growing trends.\n* 🎯 For clear opportunities.\n* 🔬 For technical tricks or solutions.\n* ⚡ For rapid or urgent changes.\n* 💎 For particularly brilliant ideas.\n* 🛡️ For security or stability topics.\n\n**IMPACTFUL TITLE STYLE**\nTitles must be direct and eye-catching:\nEXAMPLES:\n* 🚀 Claude Sonnet 4 is changing how code automation is done\n* 🎯 Opportunity in sight: Contabo vs the cloud giants\n* 📈 It seems many people are switching to Supabase\n* 💎 Found a great setup for WhatsApp + N8N\n\n**EXPERT DETECTIVE TONE**\n* **Observant:** \"I've noticed an interesting pattern...\"\n* **Practical:** \"This could be an opportunity to...\"\n* **Clear:** \"The key here is that...\"\n* **Direct:** \"My recommendation, based on this, is...\"\n* **Insightful:** \"I've seen several similar cases, which indicates that...\"\n\n**TECHNICAL SPECIFICATIONS**\n**PARAMETERS**\n* **Language:** Natural and easy-to-understand English. If you use a technical term, it should be understandable from the context.\n* **Length:** Short and to-the-point, only what truly adds value.\n* **Format:** Markdown with the 3-point structure.\n* **Emojis:** Used to guide, not to decorate.\n* **Tone:** Like a trusted expert, approachable and accessible.\n\n**CRITICAL RESTRICTIONS**\n* Always use 🕵🏾♂️ next to WhatsOn.\n* Focus on important ideas, not daily chatter.\n* Always explain why something is important or what opportunity it represents.\n* NEVER mention usernames (report the idea, not who said it).\n* **MAXIMUM RESTRICTION: ZERO CONVERSATION. Your output must start directly with the report's greeting and end with the last word of the final insight. Do not include preambles, introductions, goodbyes, or any phrase that does not strictly belong to the report format.**\n\n**STRATEGIC OBJECTIVE**\nFor the Averis team to receive clear and useful ideas to make good decisions, discover new opportunities, and always stay up-to-date on what matters in the industry.\n\nAnalyze the data with your expert detective eye and generate the intelligence report following these new guidelines."
},
"promptType": "define"
},
"typeVersion": 2.1
},
{
"id": "19d69bed-fd59-41b9-9c3a-fa4a385842f9",
"name": "OpenAI",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1392,
-32
],
"parameters": {
"options": {},
"resource": "audio",
"operation": "transcribe"
},
"credentials": {
"openAiApi": {
"id": "UTi3Hh062Ao84SGu",
"name": "OpenAi Averis"
}
},
"typeVersion": 1.8
},
{
"id": "7d179f3c-1c40-4fc9-9e5e-5df299b4e2bb",
"name": "条件分岐",
"type": "n8n-nodes-base.if",
"position": [
800,
208
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e5da8448-359f-449b-afb0-034be1786a48",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Webhook-EVO').item.json.body.data.messageType }}",
"rightValue": "=audioMessage"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "78d2d45f-a2d6-4192-80d2-ac4f216d01ef",
"name": "情報設定1",
"type": "n8n-nodes-base.set",
"position": [
1760,
-32
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ad7e3078-6fe3-40cb-b82b-4417beb93aea",
"name": "grupo_1",
"type": "string",
"value": "={{ $('Set Info').item.json.grupo_1 }}"
},
{
"id": "41542812-c9d2-4655-b5af-d872d271b557",
"name": "grupo_2",
"type": "string",
"value": "={{ $('Set Info').item.json.grupo_2 }}"
},
{
"id": "ef2b0919-afc7-46c0-b8b3-ef3ae26fd8ea",
"name": "grupo_3",
"type": "string",
"value": "={{ $('Set Info').item.json.grupo_3 }}"
},
{
"id": "450a265d-c325-49b4-96e6-e39721f82c48",
"name": "grupo_recibido",
"type": "string",
"value": "={{ $('Set Info').item.json.grupo_recibido }}"
},
{
"id": "7ea6872d-7fa9-49ac-b1ab-f3c14e94bb14",
"name": "mensaje",
"type": "string",
"value": "={{ $json.content }}"
},
{
"id": "722e2251-7328-41d3-a75f-11aa8554acc9",
"name": "nombre",
"type": "string",
"value": "={{ $('Set Info').item.json.nombre }}"
},
{
"id": "91ec7b09-b97d-4718-92e5-dee3a695ecf7",
"name": "hora",
"type": "string",
"value": "={{ $('Set Info').item.json.hora }}"
},
{
"id": "7b31d367-b881-4826-babe-cf71834b0b1c",
"name": "mensaje_respondido",
"type": "string",
"value": "={{ $('Set Info').item.json.mensaje_respondido }}"
},
{
"id": "ad9af313-4adc-4076-ab5c-13ee7297f277",
"name": "caption",
"type": "string",
"value": "={{ $('Set Info').item.json.caption }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "15223c79-8ffe-4b3e-be6d-da2fb1e39494",
"name": "OpenAI 4.1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1280,
1840
],
"parameters": {
"model": "openai/gpt-4.1",
"options": {
"temperature": 0.2
}
},
"credentials": {
"openRouterApi": {
"id": "FYXQKGowUia8VieK",
"name": "OpenRouter Test"
}
},
"typeVersion": 1
},
{
"id": "9108a296-df9c-4092-9641-e7a8c0a4beb9",
"name": "グループ検索",
"type": "n8n-nodes-evolution-api.evolutionApi",
"disabled": true,
"position": [
-992,
784
],
"parameters": {
"resource": "groups-api",
"operation": "fetch-groups",
"instanceName": "Averis",
"searchMethod": "fetchAll"
},
"credentials": {
"evolutionApi": {
"id": "CIwiRkXyvC3Nbgqf",
"name": "Evolution Averis"
}
},
"typeVersion": 1
},
{
"id": "29324658-a8b2-416b-a457-b36afcb2eea4",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
1968,
432
],
"parameters": {
"color": 3,
"width": 448,
"height": 396,
"content": "🔴 GOOGLE SHEETS CONFIGURATION\n\n## Required Setup\n1. Create Google Sheet with tabs:\n - Grupo_1\n - Grupo_2 \n - Grupo_3\n\n2. Update document ID in ALL \n \"Guarda Mensajes\" nodes\n\n3. Required columns:\n Data | Nombre | Mensaje | Mensaje Respondido | Caption | Hora\n\n⚠️ Each group needs its own sheet tab!"
},
"typeVersion": 1
},
{
"id": "7951897a-1b07-40af-a328-b52acb28af41",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-544,
-448
],
"parameters": {
"color": 7,
"width": 3040,
"height": 1388,
"content": "## 🔄 - REAL-TIME MESSAGE PROCESSING\n\n**Flow Overview:**\nWebhook → Filter Groups → Process Audio → Store in Sheets\n\n**What Happens Here:**\n- Messages arrive via Evolution API webhook\n- System checks if message is from monitored groups\n- Voice messages are transcribed to text\n- All data is organized and stored in Google Sheets\n\n**Result:** Complete message history ready for analysis"
},
"typeVersion": 1
},
{
"id": "8cf0b81b-493b-423f-99a6-6ed69818c4f8",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
1024
],
"parameters": {
"color": 7,
"width": 3904,
"height": 1244,
"content": "## 📊 - DAILY INTELLIGENCE GENERATION\n\n**Flow Overview:**\nSchedule → Extract Data → AI Analysis → Format → Send\n\n**What Happens Here:**\n- Runs automatically at scheduled time\n- Extracts previous day's conversations\n- AI analyzes for business insights\n- Formats into WhatsApp-friendly messages\n- Delivers summary to target group\n\n**Result:** Actionable daily intelligence reports"
},
"typeVersion": 1
},
{
"id": "f53d2306-fe19-4262-8107-3e2a821fabf6",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1248,
-384
],
"parameters": {
"color": 5,
"width": 464,
"height": 316,
"content": "## 🎙️ SMART AUDIO HANDLING\n\n**Voice Message Processing:**\n1. Detects audio messages\n2. Downloads audio file\n3. Converts to proper format\n4. Transcribes with OpenAI\n5. Replaces audio with text\n\n**Why This Matters:**\nVoice messages contain valuable information\nthat would otherwise be lost in analysis."
},
"typeVersion": 1
},
{
"id": "de66f3ab-21d8-4ba0-a9e4-13ff2680c7a0",
"name": "付箋10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1120,
1216
],
"parameters": {
"color": 5,
"width": 464,
"height": 780,
"content": "## 🤖 AI ANALYSIS ENGINE\n\n**Meet WhatsOn 🕵🏾♂️**\nYour AI detective specialized in finding:\n- AI and automation trends\n- Technical solutions\n- Business opportunities\n- Industry insights\n\n**What It Filters Out:**\n- Casual conversations\n- Off-topic discussions\n- Already known information\n\n**Customization:** Modify the system prompt \nto change focus areas or analysis style."
},
"typeVersion": 1
},
{
"id": "2d22eaa0-3837-40de-9933-0f6cc904f7ad",
"name": "付箋11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1216,
1088
],
"parameters": {
"color": 6,
"width": 608,
"height": 540,
"content": "## ⚙️ CUSTOMIZATION OPTIONS\n\n**Schedule Changes:**\nModify \"Schedule Trigger\" to change when\ndaily summaries are generated.\n\n**Add More Groups:**\n1. Add group variables in \"Set Info\"\n2. Create new Google Sheets tabs \n3. Update Switch node conditions\n4. Add corresponding \"Guarda Mensajes\" nodes\n\n**AI Focus Areas:**\nEdit the AI Agent system prompt to:\n- Change analysis priorities\n- Add new topics to monitor\n- Modify output format\n- Adjust filtering criteria\n\n**Audio Processing:**\nDisable voice message handling by \nremoving the audio processing branch\nif not needed."
},
"typeVersion": 1
},
{
"id": "06499d8b-dc03-4626-bca1-ec51ece60c99",
"name": "付箋15",
"type": "n8n-nodes-base.stickyNote",
"position": [
2640,
-208
],
"parameters": {
"color": 5,
"width": 620,
"height": 832,
"content": "## Was this helpful? Let me know!\n\nI truly hope this was helpful. Your feedback is very valuable and helps me create better resources.\n\n### Want to take automation to the next level?\n\nIf you're looking to optimize your business processes or need expert help with a project, here's how I can assist you:\n\n**🚀 Free Discovery Call:** Do you have a process in your business that you'd like to automate but don't know where to start? In this initial call, we'll explore your needs and see if automation is the ideal solution for you.\n#### ➡️ **[Schedule a Discovery Call](https://cal.com/averis/asesoria)**\n\n**💡 Personalized Consulting :** If you already have a specific problem, an integration challenge, or need hands-on help building a custom workflow, this session is for you. Together, we'll find a powerful solution for your case.\n#### ➡️ **[Book Your Consulting Session](https://cal.com/averis/consultoria-personalizada)**\n\n### Stay Up to Date\n\nFor more tricks, ideas, and news about automation and AI, let's connect on LinkedIn!\n#### ➡️ **[Follow me on LinkedIn](https://www.linkedin.com/in/daniel-lianes/)**\n\n--\n\nHappy Automating!\n\nDaniel Lianes"
},
"typeVersion": 1
},
{
"id": "0a0e5f53-132f-489e-9346-4bfa84a9db52",
"name": "出力フォーマッタ",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1888,
1616
],
"parameters": {
"text": "=<summary_groups> \n{{ $json.texto }} \n</summary_groups>\nCRITICAL: If the original message has 500 words, your output must have exactly 500 words. If it has 50 words, exactly 50 words. COUNT THE WORDS.",
"messages": {
"messageValues": [
{
"message": "=PROMPT TO SPLIT WHATSAPP SUMMARY INTO FRAGMENTED MESSAGES\n\nMAIN INSTRUCTIONS\nYou will receive a complete WhatsOn 🕵🏾♂️ summary. Your task is ONLY to split the existing content into separate messages for WhatsApp, WITHOUT MODIFYING OR ADDING ANYTHING.\n\nCRITICAL RULES\nWHAT TO DO:\n\n✅ ONLY split the content by H2 titles\n✅ ONLY convert markdown format to WhatsApp format\n✅ PRESERVE all the exact original text\n✅ MAINTAIN original emojis and structure\n\nWHAT NOT TO DO:\n\n❌ DO NOT modify existing texts\n❌ DO NOT add new content\n❌ DO NOT make anything up\n❌ DO NOT change the original tone\n❌ DO NOT summarize or shorten\n❌ DO NOT add extra \"WhatsOn\" in each message\n\nDIVISION CRITERIA\nAUTOMATIC FRAGMENTATION:\n\nIntroduction: From the greeting to the first ##\nEach H2 title: A separate message with its full content\nPreserve everything: Every paragraph, bullet, original emoji\n\nFORMAT CONVERSION:\n\nTitle → Title (WhatsApp bold)\nKeep all bullets •\nPreserve all original emojis\nPreserve original line breaks\n\nTRANSFORMATION EXAMPLE\nINPUT (Complete Summary):\nHello! WhatsOn 🕵🏾♂️ here with today's summary of what's happening in the groups.\n\n📰 New Claude update that improves automations\nI've seen that Claude Sonnet 4 has been released and people are testing it for automations. They say it's much better for generating N8N code.\n\nBetter context understanding\n\nGenerates cleaner workflows\n\nFewer errors in configurations\n\n💰 Price comparison between VPS providers\nThere have been several comments about Contabo vs DigitalOcean for hosting N8N instances.\n\nContabo: €4/month for 4GB RAM\n\nDigitalOcean: $24/month for 4GB RAM\n\nSimilar performance according to tests\n\nOUTPUT JSON:\n\nJSON\n\n{\n \"messages\": [\n \"Hello! WhatsOn 🕵🏾♂️ here with today's summary of what's happening in the groups.\",\n \n \"*📰 New Claude update that improves automations*\\n\\nI've seen that Claude Sonnet 4 has been released and people are testing it for automations. They say it's much better for generating N8N code.\\n\\n• Better context understanding\\n• Generates cleaner workflows\\n• Fewer errors in configurations\",\n \n \"*💰 Price comparison between VPS providers*\\n\\nThere have been several comments about Contabo vs DigitalOcean for hosting N8N instances.\\n\\n• Contabo: €4/month for 4GB RAM\\n• DigitalOcean: $24/month for 4GB RAM\\n• Similar performance according to tests\"\n ]\n}\nWHATSAPP FORMAT RULES\nSIMPLE CONVERSIONS:\n\nText → Text\nKeep • for bullets\nKeep all original emojis\nPreserve \\n for line breaks\n\nJSON STRUCTURE:\n\nJSON\n\n{\n \"messages\": [\n \"message 1 with exact original content\",\n \"message 2 with exact original content\",\n \"message 3 with exact original content\"\n ]\n}\n\nSPECIAL CASES\nIF THERE ARE NO H2 TITLES:\n\nAll the content goes into a single message\n\nIF THERE IS ONLY AN INTRODUCTION:\n\nA single message with the entire introduction\n\nIF THE MESSAGE IS VERY LONG:\n\nSplit by natural paragraphs while maintaining coherence\nNEVER cut sentences in half\n\nMANDATORY VALIDATIONS\n\n✅ Valid JSON with a messages array\n✅ 100% original content preserved\n✅ Only markdown → WhatsApp format conversion\n✅ Logical division by H2 titles\n✅ Zero text modifications\n✅ Zero content additions\n\nFINAL OBJECTIVE\nTake the complete WhatsOn 🕵🏾♂️ summary and ONLY split it into WhatsApp messages, keeping ALL the original content intact."
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "a7a074cc-dedc-429d-827d-ecc90dc5e763",
"name": "JSON 戻り値型設定",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2240,
1968
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"object\",\n \"properties\": {\n \"mensajes\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"string\"\n }\n }\n },\n \"required\": [\"mensajes\"]\n}"
},
"typeVersion": 1.2
},
{
"id": "c6626966-5114-4db6-98d5-e3c5558b9a9e",
"name": "メッセージ送信",
"type": "n8n-nodes-evolution-api.evolutionApi",
"position": [
2752,
1632
],
"parameters": {
"resource": "messages-api",
"remoteJid": "<YOUR GROUP>",
"messageText": "={{ $json['output.mensajes'] }}",
"instanceName": "<INSTANCE NAME>",
"options_message": {}
},
"credentials": {
"evolutionApi": {
"id": "CIwiRkXyvC3Nbgqf",
"name": "Evolution Averis"
}
},
"typeVersion": 1
},
{
"id": "41c73727-34db-4824-88af-1fa5ac611f23",
"name": "グループ会話",
"type": "n8n-nodes-base.aggregate",
"position": [
176,
1408
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "1f53d13a-3b8f-4a1c-a345-ab6ebf5399b5",
"name": "グループ会話1",
"type": "n8n-nodes-base.aggregate",
"position": [
176,
1616
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "eafd408e-b354-4a0f-9e55-c8f935dcc250",
"name": "グループ会話2",
"type": "n8n-nodes-base.aggregate",
"position": [
176,
1824
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "8b810c56-7f6b-4f08-943e-8f93aaf3935f",
"name": "データ正規化",
"type": "n8n-nodes-base.code",
"position": [
400,
1616
],
"parameters": {
"jsCode": "return (() => {\n try {\n // Obtiene los datos\n let datos = $json.data;\n // Si los datos no son un array, intenta normalizar\n if (!Array.isArray(datos)) {\n if (datos && typeof datos === 'object') {\n // Si es un objeto único, lo pone dentro de un array\n datos = [datos];\n } else {\n // En caso contrario, devuelve un error\n return [{ mensaje: \"Error: Los datos proporcionados no son válidos para procesamiento.\" }];\n }\n }\n // Procesa los datos ahora normalizados\n const resumen = datos.map(item => {\n // Validaciones para campos individuales\n const nombreValido = typeof item.Nombre === 'string' ? item.Nombre.trim() : null;\n const isNombreInvalido = !nombreValido || nombreValido === \"?\" || nombreValido.toLowerCase() === \"desconocido\";\n const nombreUsuario = isNombreInvalido ? \"Usuario no identificado\" : nombreValido;\n const mensajeRespondido = item[\"Mensaje Respondido\"]\n ? `Mensaje Respondido: ${item[\"Mensaje Respondido\"]}`\n : \"Mensaje Respondido: Ninguno\";\n return `Nombre: ${nombreUsuario}, Mensaje: ${item.Mensaje || \"Mensaje no disponible\"}, ${mensajeRespondido}, Hora: ${item.Hora || \"Hora no informada\"}, Fecha: ${item.Data || \"Fecha no informada\"}`;\n }).join('\\n');\n return [{ mensaje: resumen }];\n } catch (error) {\n return [{ mensaje: `Error al procesar los mensajes: ${error.message}` }];\n }\n})();"
},
"typeVersion": 2
},
{
"id": "6a83534d-ed2a-4af1-a978-2a8d2b332949",
"name": "データ正規化1",
"type": "n8n-nodes-base.code",
"position": [
400,
1408
],
"parameters": {
"jsCode": "return (() => {\n try {\n // Obtiene los datos\n let datos = $json.data;\n // Si los datos no son un array, intenta normalizar\n if (!Array.isArray(datos)) {\n if (datos && typeof datos === 'object') {\n // Si es un objeto único, lo pone dentro de un array\n datos = [datos];\n } else {\n // En caso contrario, devuelve un error\n return [{ mensaje: \"Error: Los datos proporcionados no son válidos para procesamiento.\" }];\n }\n }\n // Procesa los datos ahora normalizados\n const resumen = datos.map(item => {\n // Validaciones para campos individuales\n const nombreValido = typeof item.Nombre === 'string' ? item.Nombre.trim() : null;\n const isNombreInvalido = !nombreValido || nombreValido === \"?\" || nombreValido.toLowerCase() === \"desconocido\";\n const nombreUsuario = isNombreInvalido ? \"Usuario no identificado\" : nombreValido;\n const mensajeRespondido = item[\"Mensaje Respondido\"]\n ? `Mensaje Respondido: ${item[\"Mensaje Respondido\"]}`\n : \"Mensaje Respondido: Ninguno\";\n return `Nombre: ${nombreUsuario}, Mensaje: ${item.Mensaje || \"Mensaje no disponible\"}, ${mensajeRespondido}, Hora: ${item.Hora || \"Hora no informada\"}, Fecha: ${item.Data || \"Fecha no informada\"}`;\n }).join('\\n');\n return [{ mensaje: resumen }];\n } catch (error) {\n return [{ mensaje: `Error al procesar los mensajes: ${error.message}` }];\n }\n})();"
},
"typeVersion": 2
},
{
"id": "516d7fe8-e6b5-4dd8-86e3-65c1f6220348",
"name": "データ正規化2",
"type": "n8n-nodes-base.code",
"position": [
400,
1824
],
"parameters": {
"jsCode": "return (() => {\n try {\n // Obtiene los datos\n let datos = $json.data;\n // Si los datos no son un array, intenta normalizar\n if (!Array.isArray(datos)) {\n if (datos && typeof datos === 'object') {\n // Si es un objeto único, lo pone dentro de un array\n datos = [datos];\n } else {\n // En caso contrario, devuelve un error\n return [{ mensaje: \"Error: Los datos proporcionados no son válidos para procesamiento.\" }];\n }\n }\n // Procesa los datos ahora normalizados\n const resumen = datos.map(item => {\n // Validaciones para campos individuales\n const nombreValido = typeof item.Nombre === 'string' ? item.Nombre.trim() : null;\n const isNombreInvalido = !nombreValido || nombreValido === \"?\" || nombreValido.toLowerCase() === \"desconocido\";\n const nombreUsuario = isNombreInvalido ? \"Usuario no identificado\" : nombreValido;\n const mensajeRespondido = item[\"Mensaje Respondido\"]\n ? `Mensaje Respondido: ${item[\"Mensaje Respondido\"]}`\n : \"Mensaje Respondido: Ninguno\";\n return `Nombre: ${nombreUsuario}, Mensaje: ${item.Mensaje || \"Mensaje no disponible\"}, ${mensajeRespondido}, Hora: ${item.Hora || \"Hora no informada\"}, Fecha: ${item.Data || \"Fecha no informada\"}`;\n }).join('\\n');\n return [{ mensaje: resumen }];\n } catch (error) {\n return [{ mensaje: `Error al procesar los mensajes: ${error.message}` }];\n }\n})();"
},
"typeVersion": 2
},
{
"id": "51331ced-d350-400c-bbf3-ab9bb50b831a",
"name": "本日の会話抽出",
"type": "n8n-nodes-base.googleSheets",
"position": [
-32,
1408
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $now.minus({ days: 1 }).format('dd/LL/yyyy') }}",
"lookupColumn": "Data"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit#gid=0",
"cachedResultName": "Grupo_1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit?usp=drivesdk",
"cachedResultName": "Resumen grupos WhatsApp"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OeyDebGZ6hnXoE0m",
"name": "Google Sheets daniel@averis.es"
}
},
"typeVersion": 4.5
},
{
"id": "a95b096d-7e15-4ba9-b6c4-5200ddf7e668",
"name": "本日の会話抽出1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-32,
1616
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $now.minus({ days: 1 }).format('dd/LL/yyyy') }}",
"lookupColumn": "Data"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1844593388,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit#gid=1844593388",
"cachedResultName": "Grupo_2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit?usp=drivesdk",
"cachedResultName": "Resumen grupos WhatsApp"
},
"combineFilters": "OR"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OeyDebGZ6hnXoE0m",
"name": "Google Sheets daniel@averis.es"
}
},
"typeVersion": 4.5
},
{
"id": "0143e4eb-78da-4c04-b486-61f5937ef00a",
"name": "本日の会話抽出2",
"type": "n8n-nodes-base.googleSheets",
"position": [
-32,
1824
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $now.minus({ days: 1 }).format('dd/LL/yyyy') }}",
"lookupColumn": "Data"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1731243803,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit#gid=1731243803",
"cachedResultName": "Grupo_3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit?usp=drivesdk",
"cachedResultName": "Resumen grupos WhatsApp"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OeyDebGZ6hnXoE0m",
"name": "Google Sheets daniel@averis.es"
}
},
"typeVersion": 4.5
},
{
"id": "183cb6b3-0bd5-4b15-954c-3c8ffb2f5116",
"name": "毎日00:00に要約送信",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-368,
1616
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtMinute": 1
}
]
}
},
"typeVersion": 1.2
},
{
"id": "20e4e0fa-b751-4f65-ae05-d78911a34919",
"name": "グループ発信メッセージ確認",
"type": "n8n-nodes-base.if",
"position": [
608,
480
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "903800e9-d7cd-40c7-9058-5c103b602063",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.grupo_1 }}",
"rightValue": "={{ $json.grupo_recibido }}"
},
{
"id": "b0bd14fb-543f-4d46-b5b4-48e29ec17bb0",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.grupo_2 }}",
"rightValue": "={{ $json.grupo_recibido }}"
},
{
"id": "dcf7593e-555e-40f5-a0d9-4aacadf166be",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.grupo_3 }}",
"rightValue": "={{ $json.grupo_recibido }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "5f1e3b6f-ddc4-4e80-9d34-dc021e370ddf",
"name": "メッセージ保存",
"type": "n8n-nodes-base.googleSheets",
"position": [
1648,
240
],
"parameters": {
"columns": {
"value": {
"Data": "={{ $now.format('dd/LL/yyyy') }}",
"Hora": "={{ new Date($json.hora).toLocaleTimeString('es-ES', { timeZone: 'Europe/Madrid' }) }}",
"Nombre": "={{ $json.nombre }}",
"Caption": "={{ $json.caption }}",
"Mensaje": "={{ $json.mensaje }}",
"Mensaje Respondido": "={{ $json.mensaje_respondido }}"
},
"schema": [
{
"id": "Nombre",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Nombre",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mensaje",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Mensaje",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mensaje Respondido",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Mensaje Respondido",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hora",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Hora",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Data",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Data",
"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/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit#gid=0",
"cachedResultName": "Hoja 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit?usp=drivesdk",
"cachedResultName": "Resumen grupos WhatsApp"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OeyDebGZ6hnXoE0m",
"name": "Google Sheets daniel@averis.es"
}
},
"typeVersion": 4.5
},
{
"id": "e720a88c-e0dd-4a6a-9fed-7a8f2caebb0f",
"name": "メッセージ保存1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1648,
464
],
"parameters": {
"columns": {
"value": {
"Data": "={{ $now.format('dd/LL/yyyy') }}",
"Hora": "={{ new Date($json.hora).toLocaleTimeString('es-ES', { timeZone: 'Europe/Madrid' }) }}",
"Nombre": "={{ $json.nombre }}",
"Caption": "={{ $json.caption }}",
"Mensaje": "={{ $json.mensaje }}",
"Mensaje Respondido": "={{ $json.mensaje_respondido }}"
},
"schema": [
{
"id": "Nombre",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Nombre",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mensaje",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Mensaje",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mensaje Respondido",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Mensaje Respondido",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hora",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Hora",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Data",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Data",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1844593388,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit#gid=1844593388",
"cachedResultName": "Grupo_2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit?usp=drivesdk",
"cachedResultName": "Resumen grupos WhatsApp"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OeyDebGZ6hnXoE0m",
"name": "Google Sheets daniel@averis.es"
}
},
"typeVersion": 4.5
},
{
"id": "401fe6d3-497e-49af-8544-875cbd003da4",
"name": "メッセージ保存2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1648,
688
],
"parameters": {
"columns": {
"value": {
"Data": "={{ $now.format('dd/LL/yyyy') }}",
"Hora": "={{ new Date($json.hora).toLocaleTimeString('es-ES', { timeZone: 'Europe/Madrid' }) }}",
"Nombre": "={{ $json.nombre }}",
"Caption": "={{ $json.caption }}",
"Mensaje": "={{ $json.mensaje }}",
"Mensaje Respondido": "={{ $json.mensaje_respondido }}"
},
"schema": [
{
"id": "Nombre",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Nombre",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mensaje",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Mensaje",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Mensaje Respondido",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Mensaje Respondido",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Hora",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Hora",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Data",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Data",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1731243803,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit#gid=1731243803",
"cachedResultName": "Grupo_3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vyva91DZgEWnJ72ocC3s1M8h0G2XC7QudcGYjfjrshk/edit?usp=drivesdk",
"cachedResultName": "Resumen grupos WhatsApp"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "OeyDebGZ6hnXoE0m",
"name": "Google Sheets daniel@averis.es"
}
},
"typeVersion": 4.5
},
{
"id": "99d9f6a6-26f4-4238-b483-50b4e2b84125",
"name": "音声ダウンロード",
"type": "n8n-nodes-base.httpRequest",
"position": [
1008,
-32
],
"parameters": {
"url": "={{ $('Webhook-EVO').item.json.body.server_url }}//chat/getBase64FromMediaMessage/{{ $('Webhook-EVO').item.json.body.instance }}",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "message.key.id",
"value": "={{ $('Webhook-EVO').item.json.body.data.key.id }}"
},
{
"name": "convertToMp4",
"value": "={{ Boolean(false) }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "apikey",
"value": "={{ $('Webhook-EVO').item.json.body.apikey }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "edf60171-2fa4-4850-a872-394ca873b1c3",
"name": "音声変換",
"type": "n8n-nodes-base.convertToFile",
"position": [
1200,
-32
],
"parameters": {
"options": {
"mimeType": "={{ $json.mimetype }}"
},
"operation": "toBinary",
"sourceProperty": "base64"
},
"typeVersion": 1.1
},
{
"id": "9ebc33b4-beb8-41f4-a9ab-9eb17a5b9fcb",
"name": "音声コンテンツ",
"type": "n8n-nodes-base.set",
"position": [
1584,
-32
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a54b459d-e8df-47e1-be8c-a8a476ab93c3",
"name": "content",
"type": "string",
"value": "={{ $json.text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "8f77725e-def9-4f2a-8dff-1b45e10f11ca",
"name": "全会話グループ化",
"type": "n8n-nodes-base.aggregate",
"position": [
928,
1616
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "b9ade45f-e492-43f0-b361-22b0f67afbc3",
"name": "付箋12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1968,
96
],
"parameters": {
"color": 5,
"width": 464,
"height": 316,
"content": "### 🔄 SMART MESSAGE ROUTING\n\n**How messages reach the correct storage:**\n\nThe Switch node routes messages based on group origin:\n- Group 1 messages → Grupo_1 sheet\n- Group 2 messages → Grupo_2 sheet \n- Group 3 messages → Grupo_3 sheet\n\nEach group maintains separate conversation history while contributing to unified daily analysis."
},
"typeVersion": 1
},
{
"id": "aaea02e8-da16-4f71-9396-0068da6c6de2",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1216,
1680
],
"parameters": {
"color": 4,
"width": 620,
"content": "## Sheets Template\n\nhttps://docs.google.com/spreadsheets/d/1REnD1Sac8O2vnyWOIpB4WqMZbWNMq3zxJ-n8a-LSwms/edit?usp=sharing"
},
"typeVersion": 1
}
],
"pinData": {
"Webhook-EVO": [
{
"body": {
"data": {
"key": {
"id": "AA304285A703A65CB84CF3C7C181E84F",
"fromMe": false,
"remoteJid": "120363419074159638@g.us",
"participant": "5492954513698@s.whatsapp.net"
},
"source": "android",
"status": "DELIVERY_ACK",
"message": {
"base64": "T2dnUwACAAAAAAAAAAAAAAAAAAAAACqCBoIBE09wdXNIZWFkAQFoAIA+AAAAAABPZ2dTAAAAAAAAAAAAAAAAAAABAAAAjzLsvAEYT3B1c1RhZ3MIAAAAV2hhdHNBcHAAAAAAT2dnUwAA6FEBAAAAAAAAAAAAAgAAALgfU3oaqv9N/0T/I/8m/07/Hf88zf8Y/wfb8P8A/0hLhgcMHBgsC+TBNuzFgAfyaKfTAUiy0AhbIArJXPOsrbfMBGiPSMb5Dz8C95E+8sMaTTeacdAA5ZA+f0FRILVtv0UMxN1YHxfPON2KxliAE9DZF8nzNdZp/764dagq/kJXqlWaLbcxSGgVfgPfn004cnBvOiIQHQDNgIA8XYhiTk92IKvET/s9r5UC6c4w6nPT/SIfmQMdhfptfrpqHjBoRIgpK1GUzgAKiEuGLDQ9PTuJa1LH1VLgqBwZ6UVQtJjNTENPa8a5Zz5ynMh2ZVHLsmMe2Xkjx3AMpkrcQJpfDf6AODbYVCS0Y/NkdgoN8ZjYQYkRqtg33IEUpYTEWVU38NAWDbqx26QgTYRKis4GRI2axnfmgGzMLppXuEZCBhHyxWgXI8sNsbaTneB+7Q9yb030+mtzKNgfT7x7mH1z8fU7u1Ki4E5BrnrK/UeAm9DnJfUznv7u7KR/5NY1tsjFDVxOF1FWpnfifePBaYtGwo39tTJapzBgH6INqYcr1RzpJxaAGSK2WfPhgJxxBycwYvK06h9jp9YagOMOAv/tz/ird/ZoUgtJva5jm0/kkQWstM4ettyAp0XvxOIk3Ahq51orksuwvcUCzXw3F6RnO754ed8Lp1PMOVkmHME3OcUaGXfQ8F01whkZV2gXIIDGYCKCeiyAS4ZAOS82M5u5mBbqEOoClWOkaNUjOQ9JUd+yJ8fHjilXz9+6idhWR/bwqilbkIHd1nwnYTon8AuFLHpzktbhxLk8aKoDVcCd2YI+62sHK9hSV8KObVcA8Glykbaunmx4adxC4AriuDMa/D9L23mWP/uTnQ6nuLMq+xjSvnNCQNShHM1/JMITuEUeBe+qfirasvraS49zmzbfNww4EjsnUQsvMqgkOIbi4EnF4dld/550MX82M+WDtP33INkggGW54oewwcS5tr5Ov1+b/MZBix2PhGc1qKOXJ8R4u3DaD84my7EEgJweizqZqFAERmxuF+08YkVSW0Ew4U4ZanR5YcrT4gQB3AOlMy9nidDE0WLilnKXE05OgJt55pDM50lKJDEmoSf+iLmvEUJ/XY0/xm0SN5ytWcIBzqSGnJ7MAw+IhUBLhiQpLzQ6iMPF7Q2WdXYqLuo6dddQSTJT9iYY8wxa+T6OyrwgntHQufdDK6lqdjTSzJDcSrBjDr4ZGrskjR8X7ydAMSuorQMu65csOicwWaHsU6yI5XmZko+TDlcLxVanng/Xs+7n1k/cfDjyAFLgHUVMaR8Q4z7yUuKUJpKhLf7d8ppQ1RF8qTze+cjWNIO3CW34sONZXBXzHWqKItaKLexAw2uyyadXQbnKL12/3ZQrIy3SASicQ/vUWkZ6ND7YJzqfwMYWdhyHqmz916nG6sl6gS4Ij0TuF88h3pqFPSQ+bYSfqP6EXPKlidfV2QzAnUNhd3wg8kof0SWicX/x7Wn6br1evM7qbk1g0cq3VhLtnGdmCKHHxOsv3Bk3UBMkC0uGMywkJT+bePakbcNF5jR0/57waliaz4jarA2ruSU+zkjVOkVAuIijML3Mlis6X93lvbH2sSW8SMyAp4tfknDZwZXaTZlW4/JsZa9lcCse1cUAa2afH0M4SknL+cR3W9CorcPMXCcT4Csu82ecHvY2z8xrvu6SRfXkJxHCXLPzfvu83uE6vxDaBCF4EIGVpaWKPJ/f0In6yAbkQvxaPak221yauv384H7J4ntuyAyY9ikLXO5aDdiyl6JwO3KQHhnSa+ZvTTlLzlJG90MKWiVHnalWrp5af4xwIPvuaXHNUGcE39qqB4XAnHNfp+Cb92WZUGAeVwgbeKcHDcWSTz3b36lJNKPia0oZMlqJlUgDWDBJh96u7PtjVzP5zx0axI31boxgS4Y4Mjc3NZwktEmUv1asSaooj9J9guQrp38T8+EPFFpcVBPW16K08F+dbE2eOXJYXRzE5J3YVk+Grt4n59rHnJjtodcWZD8srUgDszdzaoo0/80Jhzar+B7kE4iPsmVrtTnddCty1mrKwtvo91//DiicmozncnaBWdSEzz6kpue2T/8mRX/bb5rU2Ymb0GdtNwKqaW7jDE/FnpSX77y3KDy08XWmxlNgnW5PJz/GRklAPIpSZZBGaa/QNBQj2MmrUnUNb+nryLUzeQHqM99n257vfTD7NeRP1xJ18sADoJz4O9HMPpTk9Vbzw2iZjxPEXvds7tsWYjHNJFD0PdTzQ0unv5Ym+NO3mo7QJSaijOKF4tRYnCAhu2eiKZPV3nOZonRaViSWuXsrT7N88bF/Kyqpu6udLwUdoYOpd8i2WmjqTOvX2SjjJVAfx1mwS4Y1MSYnMJt1v/Y/Tst1jJbWCySs+3ewFz7gBSM6X9GPOAEpZL7LBOVZX92ehxmaaG5HqfdGMCVDc92Am3L2VsCrjWAvH3PCSGwmlE+PrYHLb98d+P1pwlmt3W90DH1dTW/nxGV/EsgxxYPTECouFCGdN7QnAbHVirr8qA4+Xc2DZfDcEJ3/QGCTzcj9VWdTMfsYgKLTgjCXibkyXefDGGCOSoYBpolonk/xJ5CepQbX2HG/KwEtR6GFmcrFjynQmOnypF4LEosrhliCeEqHjrjjEKRfgDz5jx0KPxavqMsWRxOAD/maGqDgmrubtL+9bjAwU+DJQWc1TFHEmsG8QFdZroa+7vvInnFI6czF0RbKsn5rjlA4jDHLtyVLhjQ6MjYxmzIts8v9DvIsueHUytUcJJE3lHJe7OGyRx9S9M5CK4rJ67abEM27IiqjgjXRFqgk5sH4kZ3mvYEY9yhudCzvekJKmW6DZHVLpQVhfFchPoNoT51oQgn1CIqe1PVgPQuCO/2Tlfv8UC4ZwItojICjlCU8UVenP+jcWlBM4aa8z6pohR7TuZV1wUA1QWXl6kMN0c5P5bxH3pfuU8nEmkM1UJ5Kj6KIUJCALSHDssO4HlkGVNpUyx1h26Ueh/G4wghdVo4r4QjZ9d2NHYeUa5JQlqWeUA9YgJxuZIqkWNzuMkDzuNgf6cB6wMHDmSD5iTPQEipa1SXgxFjydkBk1rEz713bOepB34CbePH3Zq6bFuqe7xtAZQItN1OVDd2bgXi4e8qfJQJINAaN4soST3UOK2uZfMBLhiEdGx0oA+K4mKcGxhpE03lylMhZHO83JHZbwif+osIli2u/6RqgI994CAELAxi8HLN3RnH98e/eietUwFV19my55MAbsFGjz2XLLP4fGPhhS1EgOcON2uj6muFbm6AbgDIuboU5x5b7oiquTu0xegBBNAJp3aJ+RyKIgIBVyrzSNNVWaEvzcWGZY70m0lzq3nJnQS+rrHMQVUeLBLnkhLxXNdCIPdS8aPcUl2F/U8fzOfyqyU2FB9wkko0htQK7v/qABnJ8tYKraSVaS4YtLTIqLoDQMRgzAtBStCKjFhbtg19wRiZ3t7/Ki8UWv91JybzJxKPwven2CYfy/bCAQIH9a9v3zQb7okhUnmxqmQPYZdolZ0594TbEN/hsA3MFryxAIqk9pbRfRaFcZILgZAYOetU585s/ID6TQECRU8/wYZdEZujMPmnezFoM1LiGvifCaDb3BEYWqOEx8NNmg1oicaQsTTa78OZpUTO3zNS5sD5CnoFV2SIBqbnmFcbNBVdxoq64gDPAkGyuHI2srSRpOlCoJ8lYrhzBUB9Qn8HqEFpOascbg+6HJsRzcmbeCtK/fBzKYJF5xflIipXGDyC0sk2vwnAR1FJcsZ3EQk6d++1csZJbqzjcDmC1ycsiUGygS4YuLzYvHpF5xeOW/5RSdn35b37Zw7uVZ7Mh6fdJA6BPiWfcwQjX49QOMG1ENnkL5SaHU2CD0pNt+3CpvpxbEySScifORPTGaST3+UvcMIEPfl7lLd3Zj1GNE9QKGYSDiR5YsK2ImQcx8FpR5/igz2ZOmpGqaOm2bxEHlnavOGho3UmLTkyTy4p4r8jToSvSKTEiVWHOR9xQcLJNOY0cSAyeL4+3qB2ZJ8OnFiE4FRU40vK83s1kn5PZXufnkijgWiGgrjXiPNpAs8Njq8bmSmy1GHSNgQhfAvEU2RjJSkHSriIOazrLs3yioIDTnaujIqdyL8UjH4AYxTHDw5CHjjlekYnuU0uGHh8qJSawXsvWHNR7UeIcURXqk1lDqjMGtFSxCNApwGdM022wXriDJTPuh83n2D0P1AlMIMPSBz5QuCC7dLt9gmdErQnIh46KqUwev2A523488c7k3l5EqZV1Z7xWvsMBOa+sMBBpJx6xmk7wrQuBiGtmyv+Ow/IoOJHbRcjZoKnycdejZxcsjRR4OMuTizfrbazshdhkTrwtUbiYfe+z4r/CHTMWMbCxOZuP2BCsO/agWhz2YS3wrTeBzLOho4YvFvfXHiAGCyy3Zth0FMz5/AGP4fUNs/Tn0EuGJiklKiqurX3yDkwqhT5rQye1LJN9MxZQqNI656LaCviV5Okr4Gz3eR2zUKz5ODWVfgrumL4+yb70C/Bh4SXT70tRZqswgqc9rLE2sHP/2aul+INgrPjxIB52+6bV9zg1Ao5ZbhH8arTTr0dsd5iVoUcZMAjDevgS7qz1ExI/igs44nRYRkI2aVPpiQTrEM6naqdcebgcwe0iHgKt2nGSNg3X4KtGeCrhLbrYXsiStMZLVlcODFy2y4dTkAuEQreGwaR9atx88mCa1tvmgKr6smXa+axfUSiM/EEj+dRlpNsiH4SJkOiXcOuCMnQZgEuGJy4uJiSpk6O1k/d/cpZ8X9tneHd16wUKpbMMxThJfdbvAlWLf5vqJOCnoZKpk7iCxpYNmlDFC9CSQYa2gKHjgbOGcLni/nandMpwmpxXNq4GWw5GMpdxv9mAqZOb0VVi/vzxaQcahsa/YJ8Pvx6ZytbuDshTOJeXT0YZns4eZ5CG4OAQWyvbgKfg6XUCcUZqBCHrLrzdy93EV8gcnkFPlyILaDrbm7C81w6qIBlgp/s91pd+ADOLUPdHFjSMUsmVT/xLd2Qgg/IaKFDr4eATzIi4qZOrMQmHFokufYX5qvISXOkUhltmxx1q/s7bPYL8SLFCJuG0wNbYVkQwgEuGMDw0MjepeDFWbwos6By70lDNLJkUvs1bUO6OBv6Wg+WpLEHsIIveKIkWuJj8xkbws4gVWzapk6AsUwlDzAhoY9ZuQuSXRGzpCSQzXsZmliCYAUVKa3mduxfPyxd9ZiWhUKgZaWvs0NK4sV1m/lzUtUipmEak50LEm6QtSKlU/M8VY2Ip+29A0CZoLbiFgLA+jMH9q9TAfcQdWDeMbNkdOIBEcqYGqZOgLE2IEKCH+pZOY/4J7LHSAoanV6bQLq5R0L72bQj2k158NRwLoSCxslw7t824z5ypgpyvMeYZCPF3uAusX736VnYXcpnXlN3RJuMTu6WYoxXGZGl0YbeWP+KEVWbFuAAwqn3tfX8vqYV6moW/ZEKdnKVs5h5ck8oWSQ1aG8VOt8W+eSaPjpMkr6X96Rv2XFZ7dFH7vPDU8n1TzWfyBk9nZ1MAAOiMAgAAAAAAAAAAAAMAAAC+jiK4HP9S/1X/TP8x/yf/Hv80/xb/Wv8d/xD/LP8S/ylLhjc7OzU1qWc9W3A4D4V7T163wlA9MxaaI7u4DMH7RUbjLsGm35u4ns3fQiCOsGSjJi0GKTe7ip9pULHEQKmUmzNf4k+py9RZWUr4ACji7IDfD+HpHxirIRNuP3COfeeazlrzzkbU8OnNgK/3w2xgk6fContLcpZYqZSbKGsoQUddQSPRR2oxIiTA6oTXNQ08D1zR6ILrUKdVVTYVD/oTTK+9hGvfR1axeLWNl2Q8KjcWVL+rTui1Nc4qbowbe8SJfKeCHxNB+DzNevHJdK5/LfN2UTMygWIcrYmlgbgABd3gSGy2u1RbkKs7muWQQPXpiNM8wzEAkxZJfmvwlmFUsyIVJINKl0j/LjvZ6OcBqnJe9z1j0pG8dmZL/c2gq72sV8xu7CSCyzfE+lCDLYrztBZNLpoBx3nXobHNBmjlRKQlpaMbvYqwtq7WKAN/RwgsS4Y4PDQ5NqtO6LU44l2oiet/EYn/srNJYWj0u6iOFKCl4431QccvugxTVEipKrZ30531Xc1bZgcYd4Mm/S6srHJraRSvnaWFr40JyYlHta+6XGkxSFcWfpb5oEJVK2oupQnWLCV67AOm+u2nMKfl9qMi4MSWxWQlQAgkq07otTSUWMdT3wfH+Vneblqt1yoaffW/p7L93hPYN+aqOykDVkTTQRdcEVm+dx+lZ18lcKtO6LU0lFjT+lKeQJCqOGmZwFJcXrstXo2q0ajoHebPmT7LPmZntHoco0QSd95idyy2dBFa1NtNTKu+FncQfMqMqE95QtTnF6cETn4fexuADgdR4l2SV/aGP4m0/AJwaeLXkiArC15V3CDCSagZI6q/qvvoC6Tzd+dZm2Hb1z+wk2wzNNI+3fw8muWTfBGAIdQ+U9mn0l/xqcEZZUJCP4c/7Rmu+kuGNzw1NDSqEwpf/zsw06WpHCodbHcOdMT6oi1bXauxyuEowK004E+bCpdKl5T43K61pMXsE0KHXEc9jkUkq1AT8ZjimMyNXedm+pbYCt3xWaCY34IPxg6Gq0CtUj+6BD6xbBpyNqZf0uK+xxNLk6NE9ZEB01eRzQMwq8u4I2oD4slHb8NnLnbgzc9t6ZTn4ozhUHQe3d+gBjWfjQmO5lnECH/5dPnvPVWsSvj9YEStAai1NAmNAihtirBFmj1Oz7dLsdJbDEZfDDAOVgwa+jXg7+YGgkN+Nqxm5krfDXgqsZCcq1C+Vh7qPS0cQlmqGSdH/yGvvl8twhM8OIiTTq7YuaQpFQjay9fZrWN9eA6AW8ocnDg77KtO6LU0X21XC/1hRfMLz9PvhAilcW8fOiuGgDeiUvYjuCakW6wPnwNuKHHoQZZlt0QNNsBLhi42MTQvq4Y/l84/X6YhEm2aiPMBBug9vALbsHDKit1ZucuuR2jPn7KrDcgQZlV1/J+VBqz4hFL6Yktcmifpryrhgbn2V4UhZRYsjgZkrg8AcZmffqDtONW5XfBLwPdezlr1oeTyQEIhRq7Hl5/yjs2LrahCBmzOYSs6gtdFsDZfht8ggbyK4rKOWeZy/FO/eEViXL5lQqraPhiwn7OJJfCkdmr0Tg+URVfNaS5lbyt/TtHG7FS1vdmQ70cQFAmc05C4IjAlrIsK/+j7m0G4spgBmuWFWwH7kBjH6BJxX/XKBXzrvrPBstpDmp57lZcpMdxEbag3pA99nHWG5nCz1g6eCAWMR7C/G60PJY/zbCNlASX9xExAFqNc4X3yp29+urvWBY5q9N3rMnkMItI5S4YsKzgwL7PWDfoBv0AxRCeHIGpCEc9qqJRywmHKLNvAMgUZheKgNulFA28evyXVxbWAszBMzTo6eL4fGIcMS+Fk71Y67U5MQZvKCJ8W5Flg1xYXGGvb52GSTE/c0K4QsOUjZ8Lj3TWehiyqhxsvGRpOLZjLlMD00RaL+0S9z/buLg6KewS69Q1uzooCOs+OmboySnSGqZrRMOCfL+WXLx9AmjEAxmGcOxoSF+Via8oJnVlS8XBZECDyoIj86mKKYtu1GE+AqZSae+VCGTXKWP3WIeF1H136wJKo25f9UFRS8L85GKcADOi9b26zuB4jzgxkrnCqGkKxT2yhyo/oBC9esq9kMibtemXO0BU3JmBL/6U2tkAV7e54DmWPxPcYNFZDX2KAS4YxLi4vKatO6LU5JkFZlN1twIwsocvpA9wmPul6koXENWaA8wfINYkcVCtkOBfDwj1aeSI9XKOrzQHFENRBoTLbiuXshoBHHqGfX38F3/bMXw0m+UbB4AnaZfeERikXCqKZtZ/YrHJraRSguheC0xrS1hvEjWBdgCVJ+1TxgcQZY3c8onizuW5bQNs5fJkq5pN4gKrxlMqBwWogzW6+C53Sy7cuwHf0bA7px8hNCRVudRMlmxjVxMxHeMlFTeqbY+fQqYOOVsBQxbRcFJMDpHgOncRebLTbOaSDD7vmdx9xn9OGceaRHn4JO8CpBfGstDBR3ZLcYKXMRyz+1fDlWWehi/4Z/lNNoXgsr1NV7C5vJE6Ud/1e2aPFR0vgS4Y1MTMzL6eXnh+AgpzC0o8wrEajkrnXLtsMqcTTuRCGc6FgAeWXuqJeLa4ANx8rAZjxDtD9xzz8GyIgpl92rFO9i9JxVKuvtRFrOJKW/0l3ugnFBR2yqcfv+qjrdrtZiZ3zm/CZ+jH8r9kLsKX93GrV0SqB9qfsuJgtN7j8ECs8iSMBc8+NezshLA8nGhFRz6uxVJq59qsxV76KjtbbwKUSXvfv3DZT+IhHNsdWyBAGyFroXtRdBZjzmQqG7pmJyHDr8TYnaRlomm3IJte1Oe7LYKS3/jl5wneqIHa+rnGTuvDZnUxFGkd7PFUYaCW6I5US5DpHhxwur34JwIVNDrywo2+eKfmJewAXYMNVV/A2EVgltfmAG8Mq7vThv6O2vRM7UKCL1SoqX7OQJ32Cd/LBgEuGLi0vLimippnVGgogYstc468IbcwKOYNalHf60jQRTxVYbyJ3jwpvA8aH27hh57TfoypIpR85WI+u6cu+A3OSc0u0hlqHvtyg+t1Ds1fACPR/O+j7dpx1VZR9S3tJA3QwpRJe+V7lp9Cqo+PkyuVhYHVoMxwvfFhGGGaz8su7PONMn/ywPKKVfcVe2TDqLfylHzpU+CfuQ+qPt+91FTsa2Y6Gduat37MbYrGINBIUAF0WbNNbl73yxh3WUThKpR86VPgn7j3d694IEVfxL6yv6XRCpEqO/k9h+MSjogJgKC4LyD04TdCkt/Xy5FsrnV8oREdpAefvdZm5PbdNi0oA0gqxHwvTvE8sxdgh+/d2UFGYHchLhjk9Oy85ooGfNdj059/VSrq4YhFlsAip96t7PWtYcZXpcdqyt/2SdDO8xn9fEQKjSVkq0Tjxh55a+2DRdV1foru6oHaWjRta9VIADcGR92+jLVDBPd/jZLG+TAYPWBIBCyTtPOgPrD8jn64Xaq1DYRK/vY3XVOiH0eRuQKPr9OZU/ry1Qauv/RTOiOIpGfZqnPdBd+rZSi2XZ29AKVmLNW0Q80X9xxX+uJymWyTVzKJ6sM5qG4TApSjMn3IoRfV3a+32v8hqOTJLQiuJKnxPqWHISyLcKd6iICN3cJcqD5DQ2Bq3KIClGzX7Pv1DuDvfxN6L8d+Y5vjgkxOgmj3wnJlPc3uNVssLBgzoYIPFvGlKxVUEIHTdctx6dsDU4PSkvIQaxJTwbS/9Ycz+zf0QfldxhVaJ0buY3HXf0g5Grwe3OOJ6cf6fOhAGJOl76wON57xWIVOLLIBLhiwtMDAxoqOU9CMr6pmaDsQkYrfoUP7VKIyAnniYTJJ1PSvbnnWuUCc/E7cj2Kg9soClMxTf6YUS2Jrf280OkV3KDnnBwt6kuBufnsPjPPJf7Yk6cIhAjsYhsgjy4hWnxFo0Kd0mTV3Eav/ZCYuL/zZ4uJCxO/eC2uPnBS1+2Ho/Gk9PbxQ1RdvmSK5IhoCp1VH4V4KupVPkhyFI66MG7a3UXU7qHHQPHc+EVHLXNMtm+VQ9oTqanUlQXaubLwKuxi7Hb+c+YGZAjRG8ye8cMNvNIe8h3TSXXF5MniBTKvGinBg+cSp2njghdO2SPPOAseEk6FIWic66AcPU6xgYQTA9gvQ/MNBt2pMY2ucIDnjOpGt6n9wJpDZ2oEuGJygzMiewDu75zDQoZZVXDlMI3eNYv3k3z0W5vU8e/OZS8KAXe/jWKPIc67yuVQYBzTz7Gjb+0Nrf34i/FckSRoKSiq0kQ520AbdVDK4N1NAoulW4qzeFnfKQNGK0kT1eB8LbkexDCRjAlAdGpY0Xzork5jVd2CZdGGnGGml5R0WHz7Tv/Kv+rGU0ULWugPFNx3o7UinK2tDILf+I3fGtBTCVP6Cu+Rh6q/luo6yMiLjfmaE1Dkak3ECpnhOmuONg5V6Dw/j3pPsnL3kPZ4pY6HeS2NF9cnjfytyi9YPdUpSphbVkwugIQB9TQLi4WMf+2FmO0NPhGkYItNz2VRCRAHhJZZLwI2BEuCqK1BRLhjQyKjMsqsNVpu+ZaXUJkOZbmw58kfd0SiR0j7E6A5ZGchNhvVgJES2uFHlfqOXd0ci2v/zBaGNSU6s3w478aM1xJKiBUmNL8rfMHQCOc3b3ZdqfX4w+k0wLIn4+l7xZycc38VXd0NO7pq9AqzWwIqNRC9v1HJX0azhiwiKDFz8JzyiuztNeL4cg0hqVq951+qIH/isaqro2MS0lbITrBv2U1bNc66BffZ7QP9d5KlWO6HqDZ0AVPsFjua6RezfyqS3lSg/3qAOQqZ1dq5THvouAIZWX/J5MBJ0lkFlnzV9gmiUol+Dpwl57SLKKNqxu7Vt712CnkbgZ9O5b6fEvOaTimmEHl8tQsHKCl64JSyyFlcjUauP4U8r1T7clm4hzMby4+/Qubt6mokuGLSwpMiambwqjOCzx5h6Nvl3j4Va8phzOjBMjLsfZNm4RaUjrlLx7rh5M3AKpSSzyTAymbwqjOCFiH5Qxgowaced1QKLK08+62QZWK8ZlXElcg5uvEC8hxdb857kSqKfsLnEDyzum5IeSbf+dvSRBOmGZGPO8qwcOHNjPe2safzlHgbEptt8gpzOebCkqklcmpMJyMuFcE4FKLlQt2u1wMVLlmj/0w1dPfAinmMZnYZvvHlaVwYDCTdilFC8Y8DAkV9qKEUDxTUDGYAf96mA2v1TLHxDbalxmMEYcNMDmgKS1fdrMkPKuqOCVBZI+jV9BDw6ekS/crpP3ahAhKYisUMqew1ipaxrQRwtqIVXy1EuGMjAxMC6j3kqjOC0jSqAs1+fkLF/HUeD0vsVa5xaXKmBbRq4vOhYDWfDoxH7iL1ru5N1BGjIZgKPeSr+HBIZpo1Z2Ri4CIOtdzn/6CBJeGU+g6BBaHR/n+FkjEM3uP3S+A5vFmpydMKQxkAqEYcuwf0JE1bFnl/QTf+F4aAB6BXhKnu9ul7f+0PtwXUe3SPBzEXY0yrAiikCj3jOvPOAMBxp8UOPrPuRPws3/0OYK9kV4qoMIpIfNb8dwgsKTqMqhk9LeBRhaIWikO5B0K/a3/6X7Dj4QvfJgNhGdypOO2ATOF3OoVV8qPtv2EeAUgbWyFhBfoVjwpSaqozgk31n4tA1LvVS8s6cZDuZ57KK43M+XcySegfreL8RBTagmFsjC0jiGHrxAT2dnUwAA6PQDAAAAAAAAAAAABAAAAOzko+4X/zba1uT/Jv9L/x7/YP8q4Lbr/yPT3+5LhjUpMzgyo94eXhbWk1ACf/nRelwOMNtWtr0NvkrTof0s1J5nk8c5hrwGnoRKU+IiRpe26f7FmaoyUoCjn2To8CBt5MpEqOdjUNf59mhxw1Zyqfm/LnwemiAxvaWixhq2y2ZqHKJN2WTg9x9pEU4p5JAcaCuNqqF5ifysI9XIcWJmTleJDWFOqs08JgW7w2ltRzXtmhmF2KBicHQr908sW47siT1NcMkPr7o6JSjzsppBVdEUU1kt1+P6YSN1R4dbtY1t8jFMw1gYUU5dqBJXoU2KKFMWzOQFhfaVlouwwyQRplDEpNDrNsd3k4edowMTjRvjEi2E7/IBIxRfcAzkeJCg48jSOWz5GD/zsGEzvDuB92p9wBYEMzCZ8R9E4/twTUIi7p86rwAdtuywICWGJTut5UhLhiYkIh4ioQpJNp1dsCT8oTNp8zcjFiTETtH6VkXfTRwt6g0G7fDrcap8mm6ekUwexUyLKuOy2E5rEnM24GypO12vfq4p52rVe1y/Iy44C++d4bOq1kVO9vqQv3n6NICNzq0xPJLUOf0MvJkL+g73ntbOnnszVwRoG7RGkcQmCzfAF1JKc4/Zcj0RwkUSLx6CnUh9+n+o/IF9EJvQxWBlTdZ7rZZfSa+6Jtzy0g6FV62wgAWFx48V+i+NRNZMbFlWxkggh4Eg0qI9WCcp3msnje2uq6sBhtmjpEuGHycaKCAFm5miHgcWpSj9EIRklvNU/zb977yzU/0YHuz4s22onc7YFWoO8CtNnm2rqpJWuNHWI+/wyMomhGtF9vG7w+MNn3wVa2gWnkr0mlQx3sqgM9ax47wYsAPrWK6AIZ7oOB0FhAjAq39ZY0Oy5939oaHdqajCDcLKjk8L9ip5ZWqZHUEqFvHe5g3cBX+07AC4jPi4tQzHE2NsbEJ1fJloM0KwhC237/eZYygFQzAE6rRNYebejtnaDABd2n+peanSR/ukK8pz9/HNk9VAFDZQXoBLhi8gLSEfBUwgQsW+0Fz8I0FvPiEGChIzF9NgWJdPShWcNn117XTy8YB882JSGEZ7e9YAgKCcG1STB8kXcEKZvstYu8ieOiXfcXtuppf+8f9uLfFIwAVDMATqtFEpgedzUuOevf4YHjtl1kkh1EdSdSMmKnwKjooUHiimnIXRixHXQAVA5ml05TfskrSbDryPDA6sld7H0N29gOKSizgzukZf8JuXZmESXWM545c1pcWvvUjJuP3LAHl//1n2AqtxJyAEmyaCQX/n+T83RzaaFRyudokwcjTV7RRYHSrfX2w9CSxLhismLyw3BJrrQbfE9WpfcL+otiFJSeCB+pjk0XeNnGqmiDWa3gp3H3w1moHLSfpxBASbkiTq6KMzsr+Knu/vXwZFoyrScwZ9d8/ZjhrxyS5++cdx3l7Amydc5aa3cvBi4c1dC25wh1/BJRgwjfLFK0kLbfkgoYOfWLuLscccX12K5Bau8qibU15dAjIrufJXHhWh71JcXKf1u57S2Ek6/vt5Gvnxk7IebW1QfNzY/KdoRJwYt6m1D1r2/7+P71bPxDxXURmfUo224y2iKnqSCCkiZl0OhAX/oVVQ8OYmf5+RB+8H5dZkT7icQ9ltJ3/Vg4QGrtV/ry2S2seXhIiafmM+w/HqS6e8wgoohubuOqoLyEd0+oAnLp/NRnmUqCyIZ+E0hUuGODo2NzadelMXdB9B3cG22W/pX1UCe4+S8lOSdx5UDFKguRSjlfx/ArMSw3Y+1p8FtubRvbKkR12MT114n73T5YiGwOk/1MWiXR3t9nJRtvi03MQlxvcnzToiXKB5zbNtY9SHL6ATkkpSiJobr9XKMUGhcxM98uC91bD5zKIzmnaMY9FuP83Pjavo8QIyaNZ+5ZXg+DC5QJlgS+K4aQYtMyj/G1ZiTJ/cUrWcH0CdejOy1yTLgBdPAe/GZ4GnzSvd0XgvnmCnAc016gyQuJZj/K3v0IZXe3HEfaeDR7gUCwflC1xunXIfZ3SJnFaFKV8xFdGFuedX20+rpXctZIoO+ZvME9IHxD1Jo2iWjaFstHfBJTLRgX5CoMmAvdGMF02KWa2XJp0Jao3VYbd5PWLluGrX5CvauRkq+s5B4L3+uU4xZ6mHUE+DSEuGJiQoKzyKZi1vy5NY0cEOeYQ8WmP3majLxrgzEUeEQo5DbDnxqOMHDUNNJ4pgGZmeprJnwdBLZBA1ZskN2txkJmeTPKGNpyrXcsJEr+pDYInaIPiD5NMfF24OS/RxE9/tXaJ3g68fsgn4zL7WUsHkZm5xy1zii9iIycqP6wEnDEzBcUTRPxoIkYS6YDRz1UqZNPWg3htXrFLLzSv32ornH/qAmtskmJ59V7cl6aPSl6OvNdJWIrwqCXvP7bTyYg6lBT7CxhCeqfAOvFn2DYmBqNFDCK/tfvQUeZLfU05snJ3PCkwZQuJvkM5rA7U7c6e0kZoes0/YwAwNaZwi18jji2exhoK6ztwWvWBEe94W3zIjRFdyKCMc8iAikEuGPDo8ODegEEXb5RogDDe5iiLvOExADbdyxxd+/aYyxs0/SaEZ9xBeAyFzE+et0R+mmpU3MKv1gUs+XtkIia1oRkqhdprMhSzYcJw/EOxKM93jq2TujmdjoYTwT52dxngBfXjXLOSy2+LeocGS0pEvv2EpnvErAyITiwpRo7m099OFytBWNwP7eHu9gBGOb0NqjimdP06C/m/3QluVEa6fvKJc54xCz3Sj+0tKoP9ao7yGx9tgjNhwpD26w73y1gjUUDwKe9RUL+8dASMZVcPh9T0SBEFoLlm5/PQswVbGh9H+xkkS/7eVqMTlDPyuCMCn/YhYybzVn8S60huiTeK6KgqHt25mVyNK8TrVTe9y3m2WohTuz28SscJ20+HGn8WnCfkIuE9eqaIR7ouYCB4z21wfl0XEx1poY4fam1d5tqwR6pywATPGLlG16UWNQrduVSYBwgP2GpuMCJ4jkkuGMTUuMjCpcPTZjfz/j5qjdTwDF4vzK4i/5YLJ2o3bhCjb3htZZGM8uX65GywZ0p2jnwgiwRhIqYrNR49jqBoAMYRfQwkRbQo24a+EGmuWIpPoJSLFkHnn5sISqbKt+uomQVbQNlUulFR5dGCpP8hSWfYqYD+/C/nUid/snUnA+J1b/SWDPUBvMnzkCg2tF4PjowZc1sM3V/JgvljUVpXjkpIJ+o5Nd+a7cDV3pghRRIF74llh9m71ChMPvzmTI+D/as0aVj5VOFysjyC+VdUHAGu6cD1g3vsfdZFF/tVHHGu9WStGjWxabzxk8Acy6Oc9Eh1gNSfykvjZBECfjpKOr62B/cEDWq6fP5ZNguemOZJfjLR5AVTr0mQo2mSKgjU8ZUy5n4889kuGMC8oHhu9zht9CzF6S/xLiIa8oZbMZm+sqBsW8oQJo+sc0CUQ6ysiIMml/mZyUDBBJE3rv2CcCQ5tzFebS+IetEpkQ8cq3Pcwe6W9XRWz7/WDw076aArSMw0kW87CwEIXIKWIFomCqzUGJHKbBRvm9gLVPYZFgM+cteZE+/0+NHCH81/MOyEUjFjotK0s148vBTv+Sv2Ay6F/JXAZSjRMrbd1HVMxAgAX2jgq7qNcpD2E6xzroTvo2gdTHPQMXsKx5Ydo+uIDvZxeJR0pRdmIadhYPzSJGpJrCmLG0vRgS4YYHB0hHgPDDToa+PPuEd+Mj9oogxdNwOZ5c+iY8SSOPFC5m5OgEABduHDH1zzh4DEAYpcVGMx1a7Ag36NtmEcZ+hOm1hSOM3yaoqL+xIxYd2bhD4SmICZDtApd/csqkqPlSqJRGDUBtsvYFqArQd5qXfQ06fEvgCmW10gG11jw4B+AGt0aSsNayrViFeOUsI82pNuSsCmWkvUT6WH5NZ6Pu+yhQ2oK53ebXJ5Yqpay0bU8FGBLhhogHy4wKUo2BVIhXEFIaVOvQYjQPy/81cF2/qZpIUApuZ+DnUXBsH5xD+BUf60NmiOBiceembIxnRXoYWWz/wQ/pn5maldG8TSw73TWtRaSU8C3/m8lCsvX0dRmkXCA0BUaiyx7aexYyzPqGe+Vi/X8bQkyKY437rCyr39AvmBcmMBIh+2cF+LW0dVogdMpzwWYYm0meiFjZG7MBuEsmN2u8SqZFeJnnQvvazjGAs2GFqur7DqFBwM1VsSOjlKFiEJAlrlWHXJS17niOjMOtK5Ayy5qw4LCdGrOQqCrXBb6veVuIH6RJj+OS4YvODUxKY62U63WsNlNqYVv+DOLbNhZkVYObU+MgZCUsoGb59MKPlIeOLJ24CIiKpekjoKAsjBz1UmIXRMAbMwHjGISMrCdr9hemmri0pug/WRVCXLptBOdMLM+bO+YpSmRMTLnNvzW75T7gCC2S7gIG6HPtj6xn7NzP/mK0QgtUKjtSFVN7K6rZ1gfcN3XiIvBpeptURxSQVIKomrfw76e27fRTy1N/68DBjaK/dFneZFJz4uyAP4KuexxDoqNpPpIfPymvX5X2KfFzAvLTEPKfOC3zzZ/q9R4e3+jQSKMYuCXjc9n0Km80tevq+72aV6y163wMmwZCOCH4bX6rbjm3D9i2JCyOYuBXWBIyQNpy/MF65ezClLU8uIndUww7MxLhiclISIhtQAFniTyBs2lQz5pPQDXba7PdxA+nzQce6SbL1D9WM1EK4UXxNIDs8QweFasD8sqe1AHggUN5BDMI5pZ08RglfWVTMbGIzrffqiBGLIjTdn1Hddfagumad7La/11OlBgy2lP7cva36DQ6UcY1LIjTdilHbTb9ug4+bjkVjFBabwAfCWiapO3XYNt4l5JIECyEmRQbyVbAZp2iXEKJ4Ntk0x0HVo5zKrB6z+EH4QRQiCyEl3IOI8ATRBHWOtox+dJ1O0m7/FL550A8COdS4YgKSIpHbHpWGgjRHQ2hKhvPFUDmZ4taUWbCCyTgnF0oCnx91tIsFGDviipRMZ8/M1Rn4l8iutngw1x2tJhXiz95EOuOmCWdrNo1sBLQkywcFrjrqqYradKLlr4JlfvUdlJaChJlAnXvq4MchnYaLTQsHCPk+5aNxD+8Dh/A+HO2QktSOG7mwXLTBU8Ty76+dlz7uazo6PJjlCwOZCkKvG+aF2g52K+XwBlvFOM9PIQjl2tHmlBcK6s469YXeRQb7B2T0gNjwQklXv0hVl/DtBsu7VM/u9Fj9WuEjaFEEuGJCUiJiOurOzMzj/nPdUraYgt7K7AGRSZNDOGiGPDUGZQtu9VMe7hxiCurXpq8s3OQjUegao/Xeed+FYjwQEwlu2NMK054TWTJeQ9v/OArp9HmmbD72x81wEzTbXUqwcJ9tfc8zHwW0epcxafvZ5MMK6s2DXh97YTCAl3nsPy0Lx26QhvG5OyWyYwLHWGey7g01SAKdiqrn0XfnZ48pXMwOA05oRGkXzlUyOfSXig/MdzP8Uv7eMtI4Cs+hf0zXN1i/4Ut6C44zD/+3z48XYwdmSGelI0jlkB8Rn3QwppPMj8cSJ7nZXHZm3Oo0BPZ2dTAACofwQAAAAAAAAAAAAFAAAAyLR8OA3/Q/9I/0z/Of9I/zo6S4Y/NSs1M68jpZ2iAN9akHOg/YvM9fLdZzuzonHe3AkFslffcSXj4LmP2Lu6/m13lCSyS+q2IfN9OXx/BAcJy79Q/J0eTLBfl/UUjNNrhCFAHR6rljVgAXfo4Y08J4AJQSaXb+dg4qV38ny9ux+NZNjAQ3iKhlXr7Y/wshJZRV9QMgY9skGjwL7pT3FC6TJOpigPjw62tLswraJYYlwpMHU4TjcUqrISWUVfS5vmvLvYD7lpvB0bF+Z3azhDAEJxC1hCoDosgsnmJDxMNujeUH/c3Muj8u/bN6GQskiYxg4oEc8pOj+8wC47TWrPhlpgFwnvfa7iGrn6RKdWOJy3DfqNa5/zsu3krodx2QJAsiPOXf+9OfS5UCWjp7VQpyLT/s7kulyxe59mBjpaGGeYzZ6bdstGEzw05i+jmuz/3tgAH0uGLjA6MzqzxRhenLDVu2ddCloF0A3lx8IPweLxMlUtdLHtvMW4De6CsLH7bojCYRlpOIK5sz+fjpvmjx+hQ76xi8SZsfZcr3igVdraOwcfrgkzhcdvNfdIT5pMFvm8cmFEP1+qsdpCE1BsIVY6h6C+qCjckpBg47npm5oxxElDSzNHCGAKNamQIocdhB9XCN4vvN7XVU/TLfzwhGuF0qygdiBBnYRv4UawYzxCQ9Gs/m4z7R17qNQbNTdfg0BKoqOhqDFWjj3Fjb/M+Yi2nFHFT6XuxzrZoTviimUHAke7KuzBOb8BQzP2i6jW573TuXrZk7l6sWmYwP6zejFrNg6x3B1pqcUm5k9vR+ChoGoYjJT4MhHize0hKJkK+QCJWu693OnySfSNvSyHM3LiTurnYSLIvJXglmBSepDNwfQyma7req2r7kuGPzQyNTahqo6NKGfSa9772rbQ8B26AoNJps3FHD0p/GqnbXkl5aPZyne3c1ogTkwqMe7rP979fnxgSVZMEJxOax+IdVilUSxvRwE5DXQoh10J0I7lYukQ5R07/XZdU2dPu5RsF0kOsB7fitQMHv2Cz5QPT7l17tBhqFiYTP9dRbAQQRxaxedk9D/L8mg3UEnNp5CQqZbsriHXw+rsnt4LBsT4Tcp0N5SC2WCn4HT0IUzyFqf9PjeNY0Q8xVKXRfTGjB5mjESNNBShtZrfM9UVtwyt9J72q1bqjyPGgotTHKmIftfKMjrZZ6br7QUocW4cAaudB/yKWcJYPxqhXdZYfU9LPnFdSAK0ThzBl2vSsn4QfUF/JKmTlkAy0glrBDObneXHQvCSnD0QNjEnSqbGT9WJ4lCnabA5KZgtPPSbP4UfwzG25OihFhBLhjcyOTIrqr96i7Y97gNRmwlAo/k62goZsjNvPbP/Ze0D3+1pq9bACJ3Afhfe7CAiD540zgXKflcUk7tQgKlpMq/8tJU7mY5PxdIlthUHrK7k+ZUaWsgfbUboXN0rVrQSFDHrMSxVponyr85eRe9qqQbo6KMsWcnqsLBJ06aFmR+bAxxhVI6aHannuxziKWvxTSnBqfl72GIqY1yoq7dc16pfVm1nvt+Ap+s+pT2HaYNpb9kOj7l5/vrRsYfpZCPm4KbjEiLVXFKurJ7rHM+/v5SAlbytah0WwzCntxPXmNYRg1DKOXNgJ9Io4dK5wuNN+iUf4ZfVa11WWa436nOSUU7hz7LoplzygpBOu1r5izQozZbk7gQPoD/76fOCa2lOXlCDqpNniaEjezpB4UmJX193ad1I5LBLhjM1NTkzpm+dt7nD10nn25G1yIAgznAZaLWD3/uyLx6mwg8Nk3lkJZmrtxWFi2VEz0xADElV3e+ApnyswbT59LAk3yBSkWxry3S3c8Mt3YnF+SToTiaAJIY/zUZ8GtkoismVfCul4PRu41HOjpSn1GTNhn847wTlmV77IKsBSO0BWrzaFhH9Mt8QdSRE3lDFC9h/FJ7PZ/skggkYSw3k1NolJaggyNGAEi5LACHCRpTq4Aj3H95Jr1h4LarZVB8txuZM3m43WYAuQR/clOHKeFALdYo6SyrQJATa56mrhRXgSOIUNGGhlZgStDBfEbR8kF/AEf9h35kS2AS/yLii/fxu2ZiSspOWxYq482kMzKuBS8Vpgg0s4f6CAqOEn4nbMR2uWDO3yyHZ8s5L8Z2vvBDros+PqUzYgR/R75Wgl9HczFipioBLhjUvNi4zrTC3kVHJGv6yp/Rs7RcwUefJa71OWnyurHvpKtXdbPKPvqYleWQcucpLoDFYc0YITORAIXusX1EEOqG0gdfisUKR8AEmmdLREamHpTht/Ixrk0IJ7HsxbI/N4px/GQ9RxTkEIKmv8vazmLUiubiseB6MKmbJ0T2iXVpVhN3BfTutK/FLmW/h2u353g9/TST7epAmNfX996Rh6aqydmpSicm+d6/1BQT04d4NS0xHlfRq2utW7x8CX5/nZH97EvLEC0cEaBems3in1Orj4SzyQOkyqpu4USe5orQXii39h2yctlqnA/5qvNV68g18Kb7fEyfLIN631p5IzUCn8m+RoFEnF/DzIYLC6BQO2++C5KGMdlsVWFRVXdF5OpSdwd7fttHG1wA8sdF2c7LjzYCBSPk7SKfk5vIKsqbSzY26yvFsW2UwcCI3fwdN610DcO9EsVYPBwXZEj8rvXNiqoNDHHaMIiaed4Ze3I/AXQ==",
"audioMessage": {
"ptt": true,
"url": "https://mmg.whatsapp.net/v/t62.7117-24/532791164_813918324527908_982228961076361219_n.enc?ccb=11-4&oh=01_Q5Aa2QHtqXJe2zyLzTm7rbJQlc8t6kx1NaTabyIHNAt9sgXrsg&oe=68C5C407&_nc_sid=5e03e0&mms3=true",
"seconds": 6,
"mediaKey": "Vmo+wv1lzgUkOpX1DsXGXi7E5lTS+3wyj2OT6UHOy/8=",
"mimetype": "audio/ogg; codecs=opus",
"waveform": "AAskPSMuJDAvJyIkAwA8PFxZWVpcWFRYV1dfVVFIQkFFTF5hX1hUUkM3OzklISEYP0YlAAAATltgXVpdW0tKAA==",
"directPath": "/v/t62.7117-24/532791164_813918324527908_982228961076361219_n.enc?ccb=11-4&oh=01_Q5Aa2QHtqXJe2zyLzTm7rbJQlc8t6kx1NaTabyIHNAt9sgXrsg&oe=68C5C407&_nc_sid=5e03e0",
"fileLength": "14785",
"fileSha256": "mDwe4Rx5Wgg3Bl+XIsaSqL8VH6nATaF8d1C4VxMXG8k=",
"contextInfo": {
"stanzaId": "3EB0E1CEBCEB208BE45FBB",
"participant": "34644498183@s.whatsapp.net",
"quotedMessage": {
"conversation": "https://www.youtube.com/watch?v=FeE1mx-sCDo\n\nCualquier duda, lo hablamos por el chat general.\n\nEspero que os guste."
}
},
"fileEncSha256": "XUkp7hUuj34V/sLlzwv8AVFqLtkrgftGl0B6LQhFzi8=",
"mediaKeyTimestamp": "1755206897"
},
"messageContextInfo": {
"messageSecret": "KBiPDeTQA/fpw+3ktagQsO3KmRzh9zEYexoJaMxrl44="
},
"senderKeyDistributionMessage": {
"groupId": "120363419074159638@g.us",
"axolotlSenderKeyDistributionMessage": "MwjTr7+BBBAAGiCVBkWlXaWo5Zgj9PXX5tVcQbpRqShG2FYHyk66cg5eZCIhBQE2zbPXLmb/nc4/ZtyXDisGkcjj7vAaluN7D6M5KiJJ"
}
},
"pushName": "Esteban Fortunas",
"instanceId": "8bd860e0-8d60-4032-9605-22b627b53f2f",
"contextInfo": {
"stanzaId": "3EB0E1CEBCEB208BE45FBB",
"participant": "34644498183@s.whatsapp.net",
"quotedMessage": {
"conversation": "https://www.youtube.com/watch?v=FeE1mx-sCDo\n\nCualquier duda, lo hablamos por el chat general.\n\nEspero que os guste."
}
},
"messageType": "audioMessage",
"chatwootInboxId": 1,
"messageTimestamp": 1755206906,
"chatwootMessageId": 2274,
"chatwootConversationId": 16
},
"event": "messages.upsert",
"apikey": "FA4CA8720ACD-444F-B064-3BCA270C9A68",
"sender": "34623922886@s.whatsapp.net",
"instance": "Averis",
"date_time": "2025-08-14T18:28:27.218Z",
"server_url": "https://desarrollo-evolution-api.swxu19.easypanel.host",
"destination": "https://ssn8n.averis.cloud/webhook/resumen"
},
"query": {},
"params": {},
"headers": {
"host": "ssn8n.averis.cloud",
"x-real-ip": "172.18.0.1",
"user-agent": "axios/1.7.9",
"content-type": "application/json",
"content-length": "22040",
"accept-encoding": "gzip, compress, deflate, br",
"x-forwarded-for": "172.18.0.1",
"x-forwarded-host": "ssn8n.averis.cloud",
"x-forwarded-port": "443",
"x-forwarded-proto": "https",
"x-forwarded-server": "19ad9afe7b64"
},
"webhookUrl": "https://ssn8n.averis.cloud/webhook/resumen",
"executionMode": "production"
}
],
"Send Summary every day at 00.00h": [
{
"Hour": "00",
"Year": "2025",
"Month": "August",
"Minute": "01",
"Second": "43",
"Timezone": "Europe/Madrid (UTC+02:00)",
"timestamp": "2025-08-17T00:01:43.065+02:00",
"Day of week": "Sunday",
"Day of month": "17",
"Readable date": "August 17th 2025, 12:01:43 am",
"Readable time": "12:01:43 am"
}
]
},
"connections": {
"7d179f3c-1c40-4fc9-9e5e-5df299b4e2bb": {
"main": [
[
{
"node": "99d9f6a6-26f4-4238-b483-50b4e2b84125",
"type": "main",
"index": 0
}
],
[
{
"node": "79fc1fe9-ef9b-450c-afe8-22cacdc63fd4",
"type": "main",
"index": 0
}
]
]
},
"007d739d-30bc-42fa-bd92-5526e2dc6ac3": {
"main": [
[
{
"node": "9e0cc150-9a86-4562-980f-45eb82ffb528",
"type": "main",
"index": 0
}
]
]
},
"6c29d63f-54a8-4146-b270-55b67073f9b2": {
"main": [
[
{
"node": "8f77725e-def9-4f2a-8dff-1b45e10f11ca",
"type": "main",
"index": 0
}
]
]
},
"19d69bed-fd59-41b9-9c3a-fa4a385842f9": {
"main": [
[
{
"node": "9ebc33b4-beb8-41f4-a9ab-9eb17a5b9fcb",
"type": "main",
"index": 0
}
]
]
},
"79fc1fe9-ef9b-450c-afe8-22cacdc63fd4": {
"main": [
[
{
"node": "5f1e3b6f-ddc4-4e80-9d34-dc021e370ddf",
"type": "main",
"index": 0
}
],
[
{
"node": "e720a88c-e0dd-4a6a-9fed-7a8f2caebb0f",
"type": "main",
"index": 0
}
],
[
{
"node": "401fe6d3-497e-49af-8544-875cbd003da4",
"type": "main",
"index": 0
}
]
]
},
"34765b6f-3751-436d-90f4-9e185d879e1f": {
"main": [
[
{
"node": "2a2f7841-df24-4803-b64a-d23cb4eafc59",
"type": "main",
"index": 0
}
]
]
},
"9de8d3e6-d0b0-4c34-bc38-a71ea9cd11e6": {
"main": [
[
{
"node": "20e4e0fa-b751-4f65-ae05-d78911a34919",
"type": "main",
"index": 0
}
]
]
},
"78d2d45f-a2d6-4192-80d2-ac4f216d01ef": {
"main": [
[
{
"node": "79fc1fe9-ef9b-450c-afe8-22cacdc63fd4",
"type": "main",
"index": 0
}
]
]
},
"81bcf337-856c-4197-9b37-a7cd58994013": {
"main": [
[
{
"node": "9e0cc150-9a86-4562-980f-45eb82ffb528",
"type": "main",
"index": 0
}
]
]
},
"25fbdc44-44df-4882-9a2e-77b14bc69bdb": {
"ai_outputParser": [
[
{
"node": "0a0e5f53-132f-489e-9346-4bfa84a9db52",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"15223c79-8ffe-4b3e-be6d-da2fb1e39494": {
"ai_languageModel": [
[
{
"node": "34765b6f-3751-436d-90f4-9e185d879e1f",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"2a2f7841-df24-4803-b64a-d23cb4eafc59": {
"main": [
[
{
"node": "0a0e5f53-132f-489e-9346-4bfa84a9db52",
"type": "main",
"index": 0
}
]
]
},
"d551f496-15af-43a9-b783-1318a155c7df": {
"main": [
[
{
"node": "9de8d3e6-d0b0-4c34-bc38-a71ea9cd11e6",
"type": "main",
"index": 0
}
]
]
},
"c6626966-5114-4db6-98d5-e3c5558b9a9e": {
"main": [
[
{
"node": "007d739d-30bc-42fa-bd92-5526e2dc6ac3",
"type": "main",
"index": 0
}
]
]
},
"9ebc33b4-beb8-41f4-a9ab-9eb17a5b9fcb": {
"main": [
[
{
"node": "78d2d45f-a2d6-4192-80d2-ac4f216d01ef",
"type": "main",
"index": 0
}
]
]
},
"edf60171-2fa4-4850-a872-394ca873b1c3": {
"main": [
[
{
"node": "19d69bed-fd59-41b9-9c3a-fa4a385842f9",
"type": "main",
"index": 0
}
]
]
},
"99d9f6a6-26f4-4238-b483-50b4e2b84125": {
"main": [
[
{
"node": "edf60171-2fa4-4850-a872-394ca873b1c3",
"type": "main",
"index": 0
}
]
]
},
"8b810c56-7f6b-4f08-943e-8f93aaf3935f": {
"main": [
[
{
"node": "6c29d63f-54a8-4146-b270-55b67073f9b2",
"type": "main",
"index": 1
}
]
]
},
"9e0cc150-9a86-4562-980f-45eb82ffb528": {
"main": [
[],
[
{
"node": "c6626966-5114-4db6-98d5-e3c5558b9a9e",
"type": "main",
"index": 0
}
]
]
},
"6a83534d-ed2a-4af1-a978-2a8d2b332949": {
"main": [
[
{
"node": "6c29d63f-54a8-4146-b270-55b67073f9b2",
"type": "main",
"index": 0
}
]
]
},
"516d7fe8-e6b5-4dd8-86e3-65c1f6220348": {
"main": [
[
{
"node": "6c29d63f-54a8-4146-b270-55b67073f9b2",
"type": "main",
"index": 2
}
]
]
},
"36f67a90-c12c-4f70-a78b-ce20246a80a1": {
"ai_languageModel": [
[
{
"node": "0a0e5f53-132f-489e-9346-4bfa84a9db52",
"type": "ai_languageModel",
"index": 0
},
{
"node": "25fbdc44-44df-4882-9a2e-77b14bc69bdb",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"0a0e5f53-132f-489e-9346-4bfa84a9db52": {
"main": [
[
{
"node": "81bcf337-856c-4197-9b37-a7cd58994013",
"type": "main",
"index": 0
}
]
]
},
"41c73727-34db-4824-88af-1fa5ac611f23": {
"main": [
[
{
"node": "6a83534d-ed2a-4af1-a978-2a8d2b332949",
"type": "main",
"index": 0
}
]
]
},
"1f53d13a-3b8f-4a1c-a345-ab6ebf5399b5": {
"main": [
[
{
"node": "8b810c56-7f6b-4f08-943e-8f93aaf3935f",
"type": "main",
"index": 0
}
]
]
},
"eafd408e-b354-4a0f-9e55-c8f935dcc250": {
"main": [
[
{
"node": "516d7fe8-e6b5-4dd8-86e3-65c1f6220348",
"type": "main",
"index": 0
}
]
]
},
"8f77725e-def9-4f2a-8dff-1b45e10f11ca": {
"main": [
[
{
"node": "34765b6f-3751-436d-90f4-9e185d879e1f",
"type": "main",
"index": 0
}
]
]
},
"a7a074cc-dedc-429d-827d-ecc90dc5e763": {
"ai_outputParser": [
[
{
"node": "25fbdc44-44df-4882-9a2e-77b14bc69bdb",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"51331ced-d350-400c-bbf3-ab9bb50b831a": {
"main": [
[
{
"node": "41c73727-34db-4824-88af-1fa5ac611f23",
"type": "main",
"index": 0
}
]
]
},
"a95b096d-7e15-4ba9-b6c4-5200ddf7e668": {
"main": [
[
{
"node": "1f53d13a-3b8f-4a1c-a345-ab6ebf5399b5",
"type": "main",
"index": 0
}
]
]
},
"0143e4eb-78da-4c04-b486-61f5937ef00a": {
"main": [
[
{
"node": "eafd408e-b354-4a0f-9e55-c8f935dcc250",
"type": "main",
"index": 0
}
]
]
},
"183cb6b3-0bd5-4b15-954c-3c8ffb2f5116": {
"main": [
[
{
"node": "0143e4eb-78da-4c04-b486-61f5937ef00a",
"type": "main",
"index": 0
},
{
"node": "a95b096d-7e15-4ba9-b6c4-5200ddf7e668",
"type": "main",
"index": 0
},
{
"node": "51331ced-d350-400c-bbf3-ab9bb50b831a",
"type": "main",
"index": 0
}
]
]
},
"20e4e0fa-b751-4f65-ae05-d78911a34919": {
"main": [
[
{
"node": "7d179f3c-1c40-4fc9-9e5e-5df299b4e2bb",
"type": "main",
"index": 0
}
],
[
{
"node": "1e226472-85c4-483a-b727-c434d1822b89",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - その他, AI要約, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
Twitterデータ取得 - n8n Creator
Gemini 2.5 Proを使用してTwitterのインテリジェンス要約を自動生成し、WhatsAppグループに送信
Set
Code
Wait
+
Set
Code
Wait
39 ノードDaniel Lianes
AI要約
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
デリバリー ハンバーガーショップ MVP
🤖 レストランと配送の自動化を支援するAI駆動型WhatsAppアシスタント
If
Set
Code
+
If
Set
Code
152 ノードBruno Dias
AIとFreepikを使用してRedditのビジネス課題をウイルスのLinkedInコンテンツに変換
AIとFreepikを使用してRedditのビジネス課題をウイルスのなLinkedInコンテンツに変換
If
Set
Code
+
If
Set
Code
48 ノードDaniel Lianes
コンテンツ作成
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
ワークフロー情報
難易度
上級
ノード数52
カテゴリー3
ノードタイプ23
作成者
Daniel Lianes
@daniellianesAs a strategic consultant in Automation and AI, I'm passionate about helping business owners simplify operations and scale smarter. My approach is a partnership: I listen to your unique needs to design custom solutions that solve real challenges. But I don't just build and leave—I also coach your team to master these new systems, empowering you for sustainable success. Beyond client work, I'm a true enthusiast, always exploring new possibilities and sharing what I learn with the community.
外部リンク
n8n.ioで表示 →
このワークフローを共有