🍳 Kochbegleiter — 30-Schritt-Workflow (Telegram + Google Sheets + LLM)

Experte

Dies ist ein Personal Productivity, AI Chatbot-Bereich Automatisierungsworkflow mit 41 Nodes. Hauptsächlich werden Switch, Function, Telegram, GoogleSheets, Agent und andere Nodes verwendet. Verwaltung von Rezepten mit einem KI-gesteuerten Telegram-Bot und einer Google Sheets-Datenbank

Voraussetzungen
  • Telegram Bot Token
  • Google Sheets API-Anmeldedaten
  • OpenAI API Key
  • Google Gemini API Key
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "name": "🍳 Culinary Companion — 30-Step Workflow (Telegram + Google Sheets + LLM)",
  "nodes": [
    {
      "name": "Telegram Trigger",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -1920,
        128
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Telegram-Trigger-0"
    },
    {
      "name": "Rezeptnamen lesen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        496,
        432
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Rezeptnamen-lesen-1"
    },
    {
      "name": "Listen-Nachricht formatieren",
      "type": "n8n-nodes-base.function",
      "position": [
        1088,
        432
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Listen-Nachricht-formatieren-2"
    },
    {
      "name": "Telegram Rezeptliste senden",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1744,
        432
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Telegram-Rezeptliste-senden-3"
    },
    {
      "name": "Auswahlparameter extrahieren",
      "type": "n8n-nodes-base.function",
      "position": [
        -736,
        816
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Auswahlparameter-extrahieren-4"
    },
    {
      "name": "Rezeptzeile nachschlagen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        496,
        1120
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Rezeptzeile-nachschlagen-5"
    },
    {
      "name": "Vollständiges Rezept formatieren",
      "type": "n8n-nodes-base.function",
      "position": [
        1104,
        1120
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Vollst-ndiges-Rezept-formatieren-6"
    },
    {
      "name": "Telegram Vollständiges Rezept senden",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1744,
        1120
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Telegram-Vollst-ndiges-Rezept-senden-7"
    },
    {
      "name": "Telegram KI-Antwort senden",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1760,
        1600
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Telegram-KI-Antwort-senden-8"
    },
    {
      "name": "Befehlsrouter",
      "type": "n8n-nodes-base.switch",
      "position": [
        -1440,
        64
      ],
      "parameters": {},
      "typeVersion": 3.2,
      "id": "Befehlsrouter-9"
    },
    {
      "name": "Rezept-KI-Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        848,
        1600
      ],
      "parameters": {},
      "typeVersion": 2.2,
      "id": "Rezept-KI-Agent-10"
    },
    {
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        400,
        2288
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Google-Gemini-Chat-Model-11"
    },
    {
      "name": "Konversationsspeicher",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        688,
        2288
      ],
      "parameters": {},
      "typeVersion": 1.3,
      "id": "Konversationsspeicher-12"
    },
    {
      "name": "Think",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        1040,
        2288
      ],
      "parameters": {},
      "typeVersion": 1.1,
      "id": "Think-13"
    },
    {
      "name": "Rezept-Tabelle lesen",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        1440,
        2272
      ],
      "parameters": {},
      "typeVersion": 4.7,
      "id": "Rezept-Tabelle-lesen-14"
    },
    {
      "name": "Rezept-Tabelle aktualisieren",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        1792,
        2272
      ],
      "parameters": {},
      "typeVersion": 4.7,
      "id": "Rezept-Tabelle-aktualisieren-15"
    },
    {
      "name": "Telegram Menü senden",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1760,
        -64
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Telegram-Men-senden-16"
    },
    {
      "name": "Suchbegriff extrahieren",
      "type": "n8n-nodes-base.function",
      "position": [
        -768,
        1296
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Suchbegriff-extrahieren-17"
    },
    {
      "name": "Rezepterstellung vorbereiten",
      "type": "n8n-nodes-base.function",
      "position": [
        -768,
        1824
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Rezepterstellung-vorbereiten-18"
    },
    {
      "name": "Rezeptänderung vorbereiten",
      "type": "n8n-nodes-base.function",
      "position": [
        -768,
        2304
      ],
      "parameters": {},
      "typeVersion": 1,
      "id": "Rezept-nderung-vorbereiten-19"
    },
    {
      "name": "Notizzettel",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1696,
        -240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel-20"
    },
    {
      "name": "Notizzettel1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1680,
        256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel1-21"
    },
    {
      "name": "Notizzettel2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1696,
        912
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel2-22"
    },
    {
      "name": "Notizzettel3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1712,
        1440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel3-23"
    },
    {
      "name": "Notizzettel5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        432,
        256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel5-24"
    },
    {
      "name": "Notizzettel6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        912
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel6-25"
    },
    {
      "name": "Notizzettel7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        432,
        912
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel7-26"
    },
    {
      "name": "Notizzettel8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        608
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel8-27"
    },
    {
      "name": "Notizzettel9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        1424
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel9-28"
    },
    {
      "name": "Notizzettel10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        1168
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel10-29"
    },
    {
      "name": "Notizzettel11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        2096
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel11-30"
    },
    {
      "name": "Notizzettel12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -848,
        1632
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel12-31"
    },
    {
      "name": "Notizzettel13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1712,
        2112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel13-32"
    },
    {
      "name": "Notizzettel14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1360,
        2112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel14-33"
    },
    {
      "name": "Notizzettel15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        2112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel15-34"
    },
    {
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        224,
        2288
      ],
      "parameters": {},
      "typeVersion": 1.2,
      "id": "OpenAI-Chat-Model-35"
    },
    {
      "name": "Notizzettel16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1504,
        -224
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel16-36"
    },
    {
      "name": "Notizzettel17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1984,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel17-37"
    },
    {
      "name": "Notizzettel18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        2112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel18-38"
    },
    {
      "name": "Notizzettel19",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        2112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel19-39"
    },
    {
      "name": "Notizzettel4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1,
      "id": "Notizzettel4-40"
    }
  ],
  "pinData": {},
  "connections": {
    "Think-13": {
      "ai_tool": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Befehlsrouter-9": {
      "main": [
        [
          {
            "node": "Telegram-Men-senden-16",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Rezeptnamen-lesen-1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Auswahlparameter-extrahieren-4",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Rezept-nderung-vorbereiten-19",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Rezepterstellung-vorbereiten-18",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Suchbegriff-extrahieren-17",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Rezept-KI-Agent-10": {
      "main": [
        [
          {
            "node": "Telegram-KI-Antwort-senden-8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Telegram-Trigger-0": {
      "main": [
        [
          {
            "node": "Befehlsrouter-9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Rezeptzeile-nachschlagen-5": {
      "main": [
        [
          {
            "node": "Vollst-ndiges-Rezept-formatieren-6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI-Chat-Model-35": {
      "ai_languageModel": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Rezeptnamen-lesen-1": {
      "main": [
        [
          {
            "node": "Listen-Nachricht-formatieren-2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Vollst-ndiges-Rezept-formatieren-6": {
      "main": [
        [
          {
            "node": "Telegram-Vollst-ndiges-Rezept-senden-7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Rezept-Tabelle-lesen-14": {
      "ai_tool": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Konversationsspeicher-12": {
      "ai_memory": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Suchbegriff-extrahieren-17": {
      "main": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Listen-Nachricht-formatieren-2": {
      "main": [
        [
          {
            "node": "Telegram-Rezeptliste-senden-3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Auswahlparameter-extrahieren-4": {
      "main": [
        [
          {
            "node": "Rezeptzeile-nachschlagen-5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Rezept-Tabelle-aktualisieren-15": {
      "ai_tool": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Rezepterstellung-vorbereiten-18": {
      "main": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google-Gemini-Chat-Model-11": {
      "ai_languageModel": [
        []
      ]
    },
    "Rezept-nderung-vorbereiten-19": {
      "main": [
        [
          {
            "node": "Rezept-KI-Agent-10",
            "type": "main",
            "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?

Experte - Persönliche Produktivität, KI-Chatbot

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.

Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes41
Kategorie2
Node-Typen12
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34