This n8n workflow automates the extraction, summarization, and storage of data from YouTube videos and articles. It starts by detecting links added to a Google Sheet, then fetches transcripts via Apify for YouTube videos or content via HTTP requests for articles. Using Google Gemini AI, it generates summaries, which are stored in designated Google Sheets. Additionally, it provides an interactive Telegram interface where users can query the stored data. The workflow is ideal for content creators, researchers, or anyone wanting to organize multimedia data efficiently for later analysis or reference.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.informationExtractor, @n8n/n8n-nodes-langchain.lmChatGoogleGemini, filter, googleSheets, googleSheetsTool, googleSheetsTrigger, httpRequest, if, markdown, stickyNote, telegram, telegramTrigger