🍳 Kochbegleiter — 30-Schritt-Workflow (Telegram + Google Sheets + LLM)
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
- •Telegram Bot Token
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
- •Google Gemini API Key
Verwendete Nodes (41)
Kategorie
{
"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
}
]
]
}
}
}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.
Verwandte Workflows
Issam AGGOUR
@devgorDiesen Workflow teilen