Personal Knowledgebase AI Agent for Telegram
AI agent that summarizes YouTube videos/articles from Google Sheets, stores them, and retrieves via Telegram chat for instant access.
This n8n workflow builds a personal AI knowledge assistant integrated with Telegram and Google Sheets. It automatically processes new URLs added to a Google Sheet (Sheet2), detects if they are YouTube videos or articles, extracts content using Apify for transcripts or HTTP requests for webpages, and generates concise summaries with Google Gemini AI. Summaries are stored in another Sheet (Sheet1) with metadata, marking the original entry as processed.
A separate Telegram trigger enables user que
- Platform
- n8n
- Category
- File & Document Management
- Price
- $24.99
- Creator
- Andre Ulrich
- AI Agent
- Telegram Bot
- Google Sheets
- YouTube Summarizer
- Article Extraction
- Google Gemini
- Apify
- Knowledge Base
- Automation
- Personal AI
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related File & Document Management workflows
- Automate Invoice Data Extraction to Airtable with OCR and AI$14.99
- Automate PDF Invoice Creation from Google Sheets Using PDF.co$4.99
- Create Custom PDF Documents from Templates with Gemini & Google Drive$24.99
- Automatically Save and Organize Outlook Email Attachments in OneDrive Folders$9.99
- Automate Invoice Data Extraction from Google Drive to Google Sheets with Mistral OCR$14.99
- Convert Files to Markdown with Datalab.to API in n8n$9.99
More from Andre Ulrich
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.