๐ณ ์๋ฆฌ ๋๋ฐ์ โ 30๋จ๊ณ ์์ ํ๋ฆ (Telegram + Google Sheets + LLM)
์ด๊ฒ์Personal Productivity, AI Chatbot๋ถ์ผ์์๋ํ ์ํฌํ๋ก์ฐ๋ก, 41๊ฐ์ ๋ ธ๋๋ฅผ ํฌํจํฉ๋๋ค.์ฃผ๋ก Switch, Function, Telegram, GoogleSheets, Agent ๋ฑ์ ๋ ธ๋๋ฅผ ์ฌ์ฉํ๋ฉฐ. AI ์ถ์ง Telegram ๋ก๋ด๊ณผ Google Sheets ๋ฐ์ดํฐ๋ฒ ์ด์ค๋ก ์๋ฆฌ ๊ด๋ฆฌ
- โขTelegram Bot Token
- โขGoogle Sheets API ์ธ์ฆ ์ ๋ณด
- โขOpenAI API Key
- โขGoogle Gemini API Key
์ฌ์ฉ๋ ๋ ธ๋ (41)
์นดํ ๊ณ ๋ฆฌ
{
"name": "๐ณ Culinary Companion โ 30-Step Workflow (Telegram + Google Sheets + LLM)",
"nodes": [
{
"name": "Telegram ํธ๋ฆฌ๊ฑฐ",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-1920,
128
],
"parameters": {},
"typeVersion": 1,
"id": "Telegram--0"
},
{
"name": "๋ ์ํผ ์ด๋ฆ ์ฝ๊ธฐ",
"type": "n8n-nodes-base.googleSheets",
"position": [
496,
432
],
"parameters": {},
"typeVersion": 1,
"id": "--1"
},
{
"name": "๋ชฉ๋ก ๋ฉ์์ง ํฌ๋งทํ
",
"type": "n8n-nodes-base.function",
"position": [
1088,
432
],
"parameters": {},
"typeVersion": 1,
"id": "--2"
},
{
"name": "Telegram ๋ ์ํผ ๋ชฉ๋ก ์ ์ก",
"type": "n8n-nodes-base.telegram",
"position": [
1744,
432
],
"parameters": {},
"typeVersion": 1,
"id": "Telegram--3"
},
{
"name": "์ ํ ํ๋ผ๋ฏธํฐ ์ถ์ถ",
"type": "n8n-nodes-base.function",
"position": [
-736,
816
],
"parameters": {},
"typeVersion": 1,
"id": "--4"
},
{
"name": "๋ ์ํผ ํ ์กฐํ",
"type": "n8n-nodes-base.googleSheets",
"position": [
496,
1120
],
"parameters": {},
"typeVersion": 1,
"id": "--5"
},
{
"name": "์ ์ฒด ๋ ์ํผ ํฌ๋งทํ
",
"type": "n8n-nodes-base.function",
"position": [
1104,
1120
],
"parameters": {},
"typeVersion": 1,
"id": "--6"
},
{
"name": "Telegram ์ ์ฒด ๋ ์ํผ ์ ์ก",
"type": "n8n-nodes-base.telegram",
"position": [
1744,
1120
],
"parameters": {},
"typeVersion": 1,
"id": "Telegram--7"
},
{
"name": "Telegram AI ์๋ต ์ ์ก",
"type": "n8n-nodes-base.telegram",
"position": [
1760,
1600
],
"parameters": {},
"typeVersion": 1,
"id": "Telegram-AI--8"
},
{
"name": "๋ช
๋ น ๋ผ์ฐํฐ",
"type": "n8n-nodes-base.switch",
"position": [
-1440,
64
],
"parameters": {},
"typeVersion": 3.2,
"id": "--9"
},
{
"name": "๋ ์ํผ AI ์์ด์ ํธ",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
848,
1600
],
"parameters": {},
"typeVersion": 2.2,
"id": "-AI--10"
},
{
"name": "Google Gemini ์ฑํ
๋ชจ๋ธ",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
400,
2288
],
"parameters": {},
"typeVersion": 1,
"id": "Google-Gemini--11"
},
{
"name": "๋ํ ๋ฉ๋ชจ๋ฆฌ",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
688,
2288
],
"parameters": {},
"typeVersion": 1.3,
"id": "--12"
},
{
"name": "์๊ฐํ๊ธฐ",
"type": "@n8n/n8n-nodes-langchain.toolThink",
"position": [
1040,
2288
],
"parameters": {},
"typeVersion": 1.1,
"id": "--13"
},
{
"name": "๋ ์ํผ ์ํธ ์ฝ๊ธฐ",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
1440,
2272
],
"parameters": {},
"typeVersion": 4.7,
"id": "--14"
},
{
"name": "๋ ์ํผ ์ํธ ์
๋ฐ์ดํธ",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
1792,
2272
],
"parameters": {},
"typeVersion": 4.7,
"id": "--15"
},
{
"name": "Telegram ๋ฉ๋ด ์ ์ก",
"type": "n8n-nodes-base.telegram",
"position": [
1760,
-64
],
"parameters": {},
"typeVersion": 1,
"id": "Telegram--16"
},
{
"name": "๊ฒ์์ด ์ถ์ถ",
"type": "n8n-nodes-base.function",
"position": [
-768,
1296
],
"parameters": {},
"typeVersion": 1,
"id": "--17"
},
{
"name": "๋ ์ํผ ์์ฑ ์ค๋น",
"type": "n8n-nodes-base.function",
"position": [
-768,
1824
],
"parameters": {},
"typeVersion": 1,
"id": "--18"
},
{
"name": "๋ ์ํผ ์์ ์ค๋น",
"type": "n8n-nodes-base.function",
"position": [
-768,
2304
],
"parameters": {},
"typeVersion": 1,
"id": "--19"
},
{
"name": "์คํฐํค ๋
ธํธ",
"type": "n8n-nodes-base.stickyNote",
"position": [
1696,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "--20"
},
{
"name": "์คํฐํค ๋
ธํธ1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1680,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-1-21"
},
{
"name": "์คํฐํค ๋
ธํธ2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1696,
912
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-2-22"
},
{
"name": "์คํฐํค ๋
ธํธ3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1712,
1440
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-3-23"
},
{
"name": "์คํฐํค ๋
ธํธ5",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-5-24"
},
{
"name": "์คํฐํค ๋
ธํธ6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
912
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-6-25"
},
{
"name": "์คํฐํค ๋
ธํธ7",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
912
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-7-26"
},
{
"name": "์คํฐํค ๋
ธํธ8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-816,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-8-27"
},
{
"name": "์คํฐํค ๋
ธํธ9",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
1424
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-9-28"
},
{
"name": "์คํฐํค ๋
ธํธ10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-832,
1168
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-10-29"
},
{
"name": "์คํฐํค ๋
ธํธ11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-832,
2096
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-11-30"
},
{
"name": "์คํฐํค ๋
ธํธ12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-848,
1632
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-12-31"
},
{
"name": "์คํฐํค ๋
ธํธ13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1712,
2112
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-13-32"
},
{
"name": "์คํฐํค ๋
ธํธ14",
"type": "n8n-nodes-base.stickyNote",
"position": [
1360,
2112
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-14-33"
},
{
"name": "์คํฐํค ๋
ธํธ15",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
2112
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-15-34"
},
{
"name": "OpenAI ์ฑํ
๋ชจ๋ธ",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
224,
2288
],
"parameters": {},
"typeVersion": 1.2,
"id": "OpenAI--35"
},
{
"name": "์คํฐํค ๋
ธํธ16",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1504,
-224
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-16-36"
},
{
"name": "์คํฐํค ๋
ธํธ17",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1984,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-17-37"
},
{
"name": "์คํฐํค ๋
ธํธ18",
"type": "n8n-nodes-base.stickyNote",
"position": [
624,
2112
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-18-38"
},
{
"name": "์คํฐํค ๋
ธํธ19",
"type": "n8n-nodes-base.stickyNote",
"position": [
976,
2112
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-19-39"
},
{
"name": "์คํฐํค ๋
ธํธ4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1,
"id": "-4-40"
}
],
"pinData": {},
"connections": {
"--13": {
"ai_tool": [
[
{
"node": "-AI--10",
"type": "ai_tool",
"index": 0
}
]
]
},
"--9": {
"main": [
[
{
"node": "Telegram--16",
"type": "main",
"index": 0
}
],
[
{
"node": "--1",
"type": "main",
"index": 0
}
],
[
{
"node": "--4",
"type": "main",
"index": 0
}
],
[
{
"node": "--19",
"type": "main",
"index": 0
}
],
[
{
"node": "--18",
"type": "main",
"index": 0
}
],
[
{
"node": "--17",
"type": "main",
"index": 0
}
]
]
},
"-AI--10": {
"main": [
[
{
"node": "Telegram-AI--8",
"type": "main",
"index": 0
}
]
]
},
"Telegram--0": {
"main": [
[
{
"node": "--9",
"type": "main",
"index": 0
}
]
]
},
"--5": {
"main": [
[
{
"node": "--6",
"type": "main",
"index": 0
}
]
]
},
"OpenAI--35": {
"ai_languageModel": [
[
{
"node": "-AI--10",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"--1": {
"main": [
[
{
"node": "--2",
"type": "main",
"index": 0
}
]
]
},
"--6": {
"main": [
[
{
"node": "Telegram--7",
"type": "main",
"index": 0
}
]
]
},
"--14": {
"ai_tool": [
[
{
"node": "-AI--10",
"type": "ai_tool",
"index": 0
}
]
]
},
"--12": {
"ai_memory": [
[
{
"node": "-AI--10",
"type": "ai_memory",
"index": 0
}
]
]
},
"--17": {
"main": [
[
{
"node": "-AI--10",
"type": "main",
"index": 0
}
]
]
},
"--2": {
"main": [
[
{
"node": "Telegram--3",
"type": "main",
"index": 0
}
]
]
},
"--4": {
"main": [
[
{
"node": "--5",
"type": "main",
"index": 0
}
]
]
},
"--15": {
"ai_tool": [
[
{
"node": "-AI--10",
"type": "ai_tool",
"index": 0
}
]
]
},
"--18": {
"main": [
[
{
"node": "-AI--10",
"type": "main",
"index": 0
}
]
]
},
"Google-Gemini--11": {
"ai_languageModel": [
[]
]
},
"--19": {
"main": [
[
{
"node": "-AI--10",
"type": "main",
"index": 0
}
]
]
}
}
}์ด ์ํฌํ๋ก์ฐ๋ฅผ ์ด๋ป๊ฒ ์ฌ์ฉํ๋์?
์์ JSON ๊ตฌ์ฑ ์ฝ๋๋ฅผ ๋ณต์ฌํ์ฌ n8n ์ธ์คํด์ค์์ ์ ์ํฌํ๋ก์ฐ๋ฅผ ์์ฑํ๊ณ "JSON์์ ๊ฐ์ ธ์ค๊ธฐ"๋ฅผ ์ ํํ ํ, ๊ตฌ์ฑ์ ๋ถ์ฌ๋ฃ๊ณ ํ์์ ๋ฐ๋ผ ์ธ์ฆ ์ค์ ์ ์์ ํ์ธ์.
์ด ์ํฌํ๋ก์ฐ๋ ์ด๋ค ์๋๋ฆฌ์ค์ ์ ํฉํ๊ฐ์?
๊ณ ๊ธ - ๊ฐ์ธ ์์ฐ์ฑ, AI ์ฑ๋ด
์ ๋ฃ์ธ๊ฐ์?
์ด ์ํฌํ๋ก์ฐ๋ ์์ ํ ๋ฌด๋ฃ์ด๋ฉฐ ์ง์ ๊ฐ์ ธ์ ์ฌ์ฉํ ์ ์์ต๋๋ค. ๋ค๋ง, ์ํฌํ๋ก์ฐ์์ ์ฌ์ฉํ๋ ํ์ฌ ์๋น์ค(์: OpenAI API)๋ ์ฌ์ฉ์ ์ง์ ๋น์ฉ์ ์ง๋ถํด์ผ ํ ์ ์์ต๋๋ค.
๊ด๋ จ ์ํฌํ๋ก์ฐ ์ถ์ฒ
Issam AGGOUR
@devgor์ด ์ํฌํ๋ก์ฐ ๊ณต์