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 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.