Personal knowledgebase AI agent
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
At a glance
Personal knowledgebase AI agent is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Telegram, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, Telegram, Gemini
- Modules
- 19
- Price
- Free
- Version
- v1.0

About this workflow
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. ---
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
BrowserAct Intelligent Software Category Search Bot
Add Google Sheets rows for new Memberful subscriptions created
Smart Gmail cleaner with AI validator & Telegram alerts
Create new Bannerbear images from new Google Sheets spreadsheet rows
Send Chatwork messages for new rows in Google Sheets
Generate personalized language learning news digests with LLaMA-3.1 & DeepSeek AI
Compare flight prices across multiple booking platforms with email reports
Conversing with data: transforming text into SQL queries and visual curves
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you