Personal knowledgebase AI agent
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (12)
- If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Markdown
n8n-nodes-base.markdown - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Telegram Trigger
n8n-nodes-base.telegramTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Telegram
n8n-nodes-base.telegram - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Filter
n8n-nodes-base.filter
What it does
How it works: This project creates a personal AI knowledge assistant that operates through Telegram. The assistant can extract summaries from YouTube videos or online articles, store them in Google Sheets for later reference, and retrieve stored summaries when requested by the user. Step-by-step: Google Sheets Trigger: The workflow starts by detecting a new YouTube or article URL added to a dedicated sheet (Sheet2). It checks whether the link is already processed. Link Type Detection: The system identifies if the URL is from YouTube or a standard article. Data Retrieval: If it’s YouTube: Uses Apify to fetch the transcript. If it’s an article: Uses an HTTP Request node to fetch the webpage content. AI Summarization: The transcript or article content is passed to Google Gemini for refined summarization. Google Sheets Storage: The summary and title are appended to another sheet (Sheet1) for long-term storage, along with a “Stored” status update in Sheet2. Telegram Assistant: A Telegram Trigger listens for messages from the user. The assistant searches stored summaries in Google Sheets. If a match is found, it returns the result to the user on Telegram; otherwise, it politely apologizes. ---