Assistant personnel

• •Compte Google et informations d'identification Gmail API
• •Informations d'identification Google Sheets API
• •Clé API OpenAI

{
  "id": "chCFNRonfZBJVoUK",
  "meta": {
    "instanceId": "a51a10c949270e540a12639c8a3df5e1b80aa3342c96f49f7646a09c92df9d8c",
    "templateCredsSetupCompleted": true
  },
  "name": "Personal Assistant",
  "tags": [],
  "nodes": [
    {
      "id": "f1ecb3d0-eca9-4055-966f-9afbd2ccffca",
      "name": "Déclencheur Serveur MCP",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        -20,
        -640
      ],
      "webhookId": "cbbbcf9a-2105-4289-9874-45d3ca20dd2e",
      "parameters": {
        "path": "cbbbcf9a-2105-4289-9874-45d3ca20dd2e"
      },
      "typeVersion": 1
    },
    {
      "id": "056176ce-7aed-44e1-8c95-6545d8742d63",
      "name": "Envoyer un message par Gmail",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        300,
        -460
      ],
      "webhookId": "101ef28f-8092-4013-8f87-c5b81e9dbfa5",
      "parameters": {
        "sendTo": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('To', ``, 'string') }}",
        "message": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}",
        "options": {},
        "subject": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Subject', ``, 'string') }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "N9jC76TL1WVjVRW4",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "579d3a6f-8f64-4d1f-8837-ed566ffe56cc",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -620,
        -720
      ],
      "parameters": {
        "color": 4,
        "width": 1140,
        "height": 480,
        "content": "## To implement this personal email assistant for suppliers,\n## you need to follow these steps.\n\n### In Google Drive, create a Google Sheets file named \"Suppliers\",\nwhich should contain 2 columns:\n(Supplier Name, Contact Email)\nThis is the MCP Server.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0e3e99ef-434c-4c65-b282-6f2d267ad9f9",
      "name": "Note adhésive 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -620,
        -200
      ],
      "parameters": {
        "color": 5,
        "width": 1140,
        "height": 660,
        "content": "## This would be the AI Agent that connects to the MCP Server — in other words, it is the MCP Client.\n\n### 1. The message arrives and is passed to the AI agent.\n### 2. The assistant first executes the node that helps it think — the \"Thinker\".\n### 3. Then it runs the Google Sheets node to search for the supplier,\n### in case the user only mentions the name and doesn't provide the email.\n### 4. It executes the MCP Server and sends the email as requested.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "fda2fd56-fb9b-4074-9a4f-ae14e94d95de",
      "name": "Point d'entrée : Discuter avec l'Agent",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -300,
        40
      ],
      "webhookId": "0a1b3beb-fe6e-4a05-9150-944517f0a65b",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
      "name": "Assistant Email Personnel",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        60,
        40
      ],
      "parameters": {
        "options": {
          "systemMessage": "=Eres mi asistente personal. Tienes acceso a diferentes herramientas (como Think y Google Sheets). Sigue estas instrucciones paso a paso para responder correctamente:\n\n1. Ejecuta la herramienta **Think** para analizar si tienes toda la información necesaria para completar la solicitud del usuario.\n2. La fecha y hora actual es: {{ $now.setZone('America/Mexico_City').toFormat('yyyy-MM-dd HH:mm') }}.\n3. Si para cumplir la solicitud del usuario necesitas el **correo de un proveedor**, búscalo usando la herramienta **Google Sheets** con el nombre del proveedor como referencia.\n4. Una vez tengas toda la información, **realiza la acción solicitada por el usuario** y responde de forma clara y directa.\n5. Si falta información o no puedes encontrarla, pide al usuario que complete lo que falta o reporta que no la encontraste.\n"
        }
      },
      "typeVersion": 1.9
    },
    {
      "id": "05ab000e-3d2c-4429-a75e-7b4db94baa03",
      "name": "Modèle IA Open AI",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -160,
        260
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "QDynOcTL9yRJIEpN",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cd649882-bd30-4589-ac73-e23da4f4d16e",
      "name": "Mémoire de Chat",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -20,
        240
      ],
      "parameters": {
        "contextWindowLength": 20
      },
      "typeVersion": 1.3
    },
    {
      "id": "804571d9-95b1-427e-90ad-a6562c246310",
      "name": "Nœud connecté au serveur MCP.",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        120,
        260
      ],
      "parameters": {
        "sseEndpoint": "https://lucychats-n8n.jpe85q.easypanel.host/mcp/cbbbcf9a-2105-4289-9874-45d3ca20dd2e/sse"
      },
      "typeVersion": 1
    },
    {
      "id": "df1ba763-2ab5-4cc9-adf0-47f39bf6e0ec",
      "name": "Thinker, réfléchir avant d'exécuter.",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        260,
        220
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e2721ce5-6283-4c20-945f-e0e88b25514f",
      "name": "Base de données des fournisseurs.",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        400,
        260
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values0_Value', ``, 'string') }}",
              "lookupColumn": "Nombre del Proveedor"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vFkApkyOU1npZJvl90sIZ4x8xnSXylfTjvCGhWTeOB8/edit#gid=0",
          "cachedResultName": "Hoja 1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1vFkApkyOU1npZJvl90sIZ4x8xnSXylfTjvCGhWTeOB8",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vFkApkyOU1npZJvl90sIZ4x8xnSXylfTjvCGhWTeOB8/edit?usp=drivesdk",
          "cachedResultName": "Proveedores"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "kbToWpEBxTdKlK78",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "517b84f6-a704-4934-87a9-d550677b7bee",
  "connections": {
    "Gmail": {
      "ai_tool": [
        [
          {
            "node": "f1ecb3d0-eca9-4055-966f-9afbd2ccffca",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "cd649882-bd30-4589-ac73-e23da4f4d16e": {
      "ai_memory": [
        [
          {
            "node": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "05ab000e-3d2c-4429-a75e-7b4db94baa03": {
      "ai_languageModel": [
        [
          {
            "node": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "e2721ce5-6283-4c20-945f-e0e88b25514f": {
      "ai_tool": [
        [
          {
            "node": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "de8be0e7-2eea-43d5-9f8c-a6232986c524": {
      "main": [
        []
      ]
    },
    "fda2fd56-fb9b-4074-9a4f-ae14e94d95de": {
      "main": [
        [
          {
            "node": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "df1ba763-2ab5-4cc9-adf0-47f39bf6e0ec": {
      "ai_tool": [
        [
          {
            "node": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "804571d9-95b1-427e-90ad-a6562c246310": {
      "ai_tool": [
        [
          {
            "node": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}