Persönlicher Assistent

Name: Persönlicher Assistent
Rating: 4.5 (10 reviews)
Author: Omar Hdez

Fortgeschritten

Dies ist ein Support, AI-Bereich Automatisierungsworkflow mit 11 Nodes. Hauptsächlich werden GmailTool, Agent, GoogleSheetsTool, ToolThink, McpTrigger und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Automatisierter E-Mail-Assistent für Lieferanten mit OpenAI und Google Tabellen

Voraussetzungen

•Google-Konto + Gmail API-Anmeldedaten
•Google Sheets API-Anmeldedaten
•OpenAI API Key

Verwendete Nodes (11)

Kategorie

Support

Künstliche Intelligenz

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

MCP Server Trigger

Nachricht senden von Gmail

Einstiegspunkt: Mit dem Agenten chatten

Persönlicher E-Mail-Assistent

KI-Modell Open AI

Chat-Speicher

Knoten, der mit dem MCP-Server verbindet.

Denker, denkt vor der Ausführung.

Lieferantendatenbank.

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "chCFNRonfZBJVoUK",
  "meta": {
    "instanceId": "a51a10c949270e540a12639c8a3df5e1b80aa3342c96f49f7646a09c92df9d8c",
    "templateCredsSetupCompleted": true
  },
  "name": "Personal Assistant",
  "tags": [],
  "nodes": [
    {
      "id": "f1ecb3d0-eca9-4055-966f-9afbd2ccffca",
      "name": "MCP Server Trigger",
      "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": "Nachricht senden von 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": "Haftnotiz",
      "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": "Haftnotiz1",
      "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": "Einstiegspunkt: Mit dem Agenten chatten",
      "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": "Persönlicher E-Mail-Assistent",
      "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": "KI-Modell 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": "Chat-Speicher",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -20,
        240
      ],
      "parameters": {
        "contextWindowLength": 20
      },
      "typeVersion": 1.3
    },
    {
      "id": "804571d9-95b1-427e-90ad-a6562c246310",
      "name": "Knoten, der mit dem MCP-Server verbindet.",
      "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": "Denker, denkt vor der Ausführung.",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        260,
        220
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e2721ce5-6283-4c20-945f-e0e88b25514f",
      "name": "Lieferantendatenbank.",
      "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
          }
        ]
      ]
    }
  }
}

Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Support, Künstliche Intelligenz

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.