Save, search, and summarize Telegram links with Google Sheets and Supabase
Ready for 3.0What this workflow does
This AI workflow has 50 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Telegram, Google Sheets, HTTP Request and Embeddings Google Gemini and 3 more. It also calls n8n.anan.dev over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Create Link Library Spreadsheet (Google Sheets): work with spreadsheet
- Clean URL (Edit Fields (Set)): sets 2 fields: url, note
- New chat? (If): checks a condition and branches into true / false
- Seed Columns (Edit Fields (Set)): sets 10 fields: ID, URL, Title…
- Generate ID (Crypto): hashes or encrypts values
- Clear memory (Chat Memory Manager): uses Chat Memory Manager, with memory: Memory
- Get Message Basics (Edit Fields (Set)): sets 2 fields: rawText, chatId
- Write Headers (Google Sheets): append
- Read Page (Jina) (HTTP Request): calls an HTTP API
- Notify memory cleared (Telegram): send rich message
…plus 25 more steps. See the full node list below.
Services it uses
HTTP calls to: n8n.anan.dev
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (27)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Telegram
n8n-nodes-base.telegram - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Respond to Webhook
n8n-nodes-base.respondToWebhook - Webhook
n8n-nodes-base.webhook - Http Request Tool
n8n-nodes-base.httpRequestTool - Embeddings Google Gemini
@n8n/n8n-nodes-langchain.embeddingsGoogleGemini - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Chat Memory Manager
@n8n/n8n-nodes-langchain.memoryManager - Remove Duplicates
n8n-nodes-base.removeDuplicates - Crypto
n8n-nodes-base.crypto - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Limit
n8n-nodes-base.limit - Manual Trigger
n8n-nodes-base.manualTrigger - No Operation, do nothing
n8n-nodes-base.noOp - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Supabase
n8n-nodes-base.supabase - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Quick overview This workflow turns a Telegram bot into a “second brain” link library by saving shared URLs to Google Sheets, generating titles/summaries/categories with Google Gemini, and indexing full-page content in Supabase (pgvector) for semantic search.…