Document Q&A Chatbot with Gemini AI and Supabase Vector Search for Telegram โ€” n8n ์›Œํฌํ”Œ๋กœ

๋†’์Œ ๋ณต์žก๋„โšก ํŠธ๋ฆฌ๊ฑฐ25๊ฐœ์˜ ๋…ธ๋“œ๐Ÿท๏ธ Personal Productivity๐Ÿ‘ 16,500ํšŒ ์กฐํšŒ์ž‘์„ฑ์ž: Mohammad Ghaffarifar

๊ฐœ์š”

This template creates a Telegram AI Assistant that answers questions based on your documents, powered by Google Gemini and Supabase. Key features include Intelligent HTML Post-processing for rich formatting in Telegram and Adaptive Message Chunking to handle long text responses. ๐Ÿ“น Watch the Bot in Action

โ–ถ๏ธ Click the image above to watch a live demo on YouTube.

This video provides a live demonstration of the bot's core features and how it interacts. See a quick walkthrough of its capabiliti

์‚ฌ์šฉ๋œ ๋…ธ๋“œ

TelegramCodeAI AgentSimple MemoryRecursive Character Text SplitterSupabase Vector StoreDefault Data LoaderEmbeddings Google GeminiGoogle Gemini Chat ModelVector Store Question Answer ToolThink Tool

์›Œํฌํ”Œ๋กœ ๋ฏธ๋ฆฌ๋ณด๊ธฐ

โœ… Scenario 2 โ€“ Document Upload and Embedding
Flow for downloading a document sent via Telegram, extr
โœ… Scenario 1 โ€“ Chatbot Interaction
Flow for handling user messages sent to the bot. Includ
๐Ÿค– Telegram AI Assistant for Your Documents (
This project transforms a standard Telegram bot into yo
toolmemorytooldocembedembedmodelmodeltool
Google Gemini Chat Model
O
OpenWeatherMap
AI Agent
โšก
T
Telegram Trigger
Telegram
Think
Embeddings Google Gemini
Default Data Loader
Recursive Character Textโ€ฆ
E
Extract from File
Answer questions with a โ€ฆ
Supabase Vector Store
Telegram - Embedding Comโ€ฆ
Supabase - Save Embeddings
C
Command Router
Telegram - Download file
A
Aggregate
Fallback- No formatting
S
Split Out
Simple Memory
Handle formatting and spโ€ฆ
M
Manual Mapping
Unsupported message
Send processing documentโ€ฆ
Send embedding Started mโ€ฆ
25 nodes26 edges

์ž‘๋™ ์›๋ฆฌ

  1. 1

    ํŠธ๋ฆฌ๊ฑฐ

    ์›Œํฌํ”Œ๋กœ๋Š” ํŠธ๋ฆฌ๊ฑฐ ํŠธ๋ฆฌ๊ฑฐ๋กœ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.

  2. 2

    ์ฒ˜๋ฆฌ

    ๋ฐ์ดํ„ฐ๊ฐ€ 25๊ฐœ์˜ ๋…ธ๋“œ๋ฅผ ํ†ตํ•ด ํ๋ฆ…๋‹ˆ๋‹ค, connecting agent, aggregate, code.

  3. 3

    ์ถœ๋ ฅ

    ์›Œํฌํ”Œ๋กœ๊ฐ€ ์ž๋™ํ™”๋ฅผ ์™„๋ฃŒํ•˜๊ณ  ๊ตฌ์„ฑ๋œ ๋Œ€์ƒ์— ๊ฒฐ๊ณผ๋ฅผ ์ „๋‹ฌํ•ฉ๋‹ˆ๋‹ค.

๋…ธ๋“œ ์„ธ๋ถ€ ์ •๋ณด (25)

TE

Telegram

telegram

#1
CO

Code

code

#2
AI

AI Agent

n8n-nodes-langchain.agent

#3
SI

Simple Memory

n8n-nodes-langchain.memoryBufferWindow

#4
RE

Recursive Character Text Splitter

n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter

#5
SU

Supabase Vector Store

n8n-nodes-langchain.vectorStoreSupabase

#6
DE

Default Data Loader

n8n-nodes-langchain.documentDefaultDataLoader

#7
EM

Embeddings Google Gemini

n8n-nodes-langchain.embeddingsGoogleGemini

#8
GO

Google Gemini Chat Model

n8n-nodes-langchain.lmChatGoogleGemini

#9
VE

Vector Store Question Answer Tool

n8n-nodes-langchain.toolVectorStore

#10
TH

Think Tool

n8n-nodes-langchain.toolThink

#11

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๋Š” ๋ฐฉ๋ฒ•

  1. 1์˜ค๋ฅธ์ชฝ์˜ JSON ๋‹ค์šด๋กœ๋“œ ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ ์›Œํฌํ”Œ๋กœ ํŒŒ์ผ์„ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
  2. 2n8n ์ธ์Šคํ„ด์Šค๋ฅผ ์—ด๊ณ  ์›Œํฌํ”Œ๋กœ โ†’ ์ƒˆ๋กœ ๋งŒ๋“ค๊ธฐ โ†’ ํŒŒ์ผ์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค.
  3. 3๋‹ค์šด๋กœ๋“œ๋œ document-qa-chatbot-with-gemini-ai-and-supabase-vector-search-for-telegram ํŒŒ์ผ์„ ์„ ํƒํ•˜๊ณ  ๊ฐ€์ ธ์˜ค๊ธฐ๋ฅผ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.
  4. 4๊ฐ ์„œ๋น„์Šค ๋…ธ๋“œ์— ๋Œ€ํ•œ ์ž๊ฒฉ ์ฆ๋ช…๏ผˆAPI ํ‚ค, OAuth ๋“ฑ๏ผ‰์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  5. 5์›Œํฌํ”Œ๋กœ ํ…Œ์ŠคํŠธ๋ฅผ ํด๋ฆญํ•˜์—ฌ ๋ชจ๋“  ๊ฒƒ์ด ์ž‘๋™ํ•˜๋Š”์ง€ ํ™•์ธํ•œ ํ›„ ํ™œ์„ฑํ™”ํ•ฉ๋‹ˆ๋‹ค.

๋˜๋Š” n8n โ†’ JSON์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ์— ์ง์ ‘ ๋ถ™์—ฌ๋„ฃ๊ธฐ:

{ "name": "Document Q&A Chatbot with Gemini AI and Supabase Vector Search for Telegram", "nodes": [...], ...}

ํ†ตํ•ฉ

agentaggregatecodedocumentdefaultdataloaderembeddingsgooglegeminiextractfromfilelmchatgooglegeminimemorybufferwindowopenweathermaptoolsetsplitoutswitchtelegramtelegramtriggertextsplitterrecursivecharactertextsplittertoolthinktoolvectorstorevectorstoresupabase

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๊ธฐ

ํ•œ ๋ฒˆ์˜ ํด๋ฆญ์œผ๋กœ ๋‹ค์šด๋กœ๋“œ ๋ฐ ๊ฐ€์ ธ์˜ค๊ธฐ

JSON ๋‹ค์šด๋กœ๋“œn8n.io์—์„œ ๋ณด๊ธฐ
๋…ธ๋“œ25
๋ณต์žก๋„high
ํŠธ๋ฆฌ๊ฑฐtrigger
์กฐํšŒ์ˆ˜16,500
์นดํ…Œ๊ณ ๋ฆฌPersonal Productivity

์ œ์ž‘์ž

Mohammad Ghaffarifar

Mohammad Ghaffarifar

@mohamadghaffari

ํƒœ๊ทธ

agentaggregatecodedocumentdefaultdataloaderembeddingsgooglegeminiextractfromfilelmchatgooglegeminimemorybufferwindowopenweathermaptoolset
โšก

n8n์„ ์ฒ˜์Œ ์‚ฌ์šฉํ•˜์‹œ๋‚˜์š”?

n8n์€ ๋ฌด๋ฃŒ ์˜คํ”ˆ์†Œ์Šค ์›Œํฌํ”Œ๋กœ ์ž๋™ํ™” ๋„๊ตฌ์ž…๋‹ˆ๋‹ค. ์ž์ฒด ํ˜ธ์ŠคํŒ…ํ•˜๊ฑฐ๋‚˜ ํด๋ผ์šฐ๋“œ ๋ฒ„์ „์„ ์‚ฌ์šฉํ•˜์„ธ์š”.

n8n ๋ฌด๋ฃŒ๋กœ ์‹œ์ž‘ํ•˜๊ธฐ โ†’

Related Personal Productivity Workflows

CODIFIHT+8
high

Automate Epic Games Freebie Alerts via Discord & Puppeteer

Never miss a premium title again with this advanced n8n automation designed to track the Epic Games Store's rotating free game catalog. This workflow leverages the power of the Puppeteer community node to perform headless browser scraping, bypassing traditional static HTML limitations to detect real-time changes in the store's interface. By monitoring specific DOM containers, the automation identifies new releases, processes game metadata through custom JavaScript logic, and formats the data into professional Discord embeds. Beyond simple notifications, this flow incorporates robust error handling and looping mechanisms to ensure delivery even if a specific request fails. For community managers or gaming enthusiasts, this replaces the manual chore of daily store checks with a high-performance, set-and-forget monitoring system. It effectively demonstrates how to combine web scraping, data transformation, and third-party API integrations into a cohesive, production-ready automation pipeline. **Common Use Cases:** - Community Engagement for Gaming Servers - Automated Content Sourcing for Gaming News Portals - Real-time Price and Promotion Monitoring for Digital Goods

โฐ Scheduledยท20 nodes
AIGOGOHT+5
high

Automate Forex News Alerts: Telegram & Google Sheets n8n Flow

Bridge the gap between economic data releases and trade execution with this sophisticated n8n automation. This workflow monitors Forex Factory and MyFxBook in real-time, instantly pushing critical news data and live price fluctuations for affected currency pairs directly to Telegram and Google Sheets. By automating the data capture process, traders eliminate the manual lag of refreshing browser tabs during high-volatility events. The flow systematically parses 'Actual' vs. 'Forecast' figures, calculates market impact, and logs the live price at the exact moment of the release for backtesting accuracy. Whether you are scaling a proprietary trading desk or managing personal capital, this template ensures you never miss a high-impact news event. It utilizes advanced conditional logic to filter relevant currency pairs and Airtop integration for seamless data extraction, providing a professional-grade infrastructure for algorithmic or semi-automated trading strategies. **Common Use Cases:** - Real-time sentiment analysis by syncing economic surprises to a centralized trading dashboard. - Automated journal logging for backtesting the correlation between news deviations and price slippage. - Telegram-based trade signal triggers that bridge economic calendar events to MetaTrader 4 execution.

โšก Triggerยท34 nodes
CHGMGOIF+6
high

AI Meeting Briefing Automation: n8n, OpenAI & Slack Guide

Stop walking into meetings unprepared. This advanced n8n workflow acts as an automated executive assistant, delivering comprehensive attendee intelligence directly to your Slack workspace. Instead of manually digging through old threads, the automation triggers hourly to scan your Google Calendar for upcoming appointments. Once a meeting is detected, the flow initiates a deep search across Gmail to extract the most recent correspondence and activity history for every participant. By leveraging OpenAIโ€™s Large Language Models (LLMs) and LangChain integration, the workflow synthesizes disparate data points into a concise, high-value briefing. It identifies key talking points, previous blockers, and the current relationship status with each stakeholder. This ensures you have the full context needed to drive decisions without the pre-meeting administrative burden. Perfect for high-volume sales teams, account managers, and executives, this template transforms how you prepare for calls by replacing manual research with instant, AI-generated insights delivered precisely when they are most relevant. **Common Use Cases:** - High-Stakes Sales Discovery: Automatically briefing Account Executives on a prospect's recent support tickets and email inquiries before a demo. - Client Relationship Management: Equipping Account Managers with a summary of the last three months of cross-departmental communication before a quarterly business review. - Executive Leadership Syncs: Providing CEOs with rapid context on internal stakeholders' recent project updates and Slack mentions prior to board or department meetings.

โฐ Scheduledยท18 nodes
AGCOGOGO+6
medium

AI Assistant for Finding Nearby Workspaces via n8n & Slack

Maximize your billable hours and productivity with this intelligent AI-driven workflow designed to turn schedule gaps into efficient work sessions. This automation acts as a personal concierge for mobile professionals and digital nomads. By proactively monitoring your Google Calendar, the system identifies upcoming free periods between appointments. It then utilizes OpenRouter AI and Google Maps API to scout nearby cafes or coworking spaces that match your specific preferences. Unlike manual searching, this workflow analyzes your current location and travel time to ensure you never waste a moment. Once a prime location is identified, the workflow pushes a detailed notification to Slack, including navigation links and venue details. This eliminates decision fatigue and the stress of finding reliable Wi-Fi or a quiet environment on the fly. From a technical perspective, the flow triggers on a schedule, scrapes calendar data, processes spatial logic via custom Code nodes, and leverages an LLM agent to make qualitative recommendations based on live data, ultimately logging your visits in Google Sheets for future reference. **Common Use Cases:** - Field Sales Optimization: Automatically suggesting quiet cafes for account managers to update CRM records between client on-site visits. - Executive Assistant Automation: Providing traveling executives with curated 'third-space' options for impromptu deep-work sessions without manual research. - Digital Nomad Productivity: Syncing with a dynamic travel schedule to identify the best-rated workspaces with high-speed internet in new cities.

โฐ Scheduledยท12 nodes
AGEMFIGO+7
high

Automate Excel to Google Calendar Sync with AI Summaries

Stop manually copying spreadsheets into your schedule. This advanced n8n automation streamlines event management by transforming static Excel files into dynamic Google Calendar entries using GPT-4o-mini. The workflow monitors your Google Drive for new schedules, extracts raw data, and utilizes a dual-layer AI analysis to validate dates and categorize events with high precision. Unlike basic sync tools, this logic includes a structured output parser to ensure data integrity and a smart enrichment phase that adds context to every calendar invite. Once the calendar is updated, the system generates a human-readable executive summary of the week's agenda and distributes it via email automatically. This is a game-changer for professionals managing high-volume scheduling tasks where human error is a risk. By integrating OpenAIโ€™s LLMs directly into the data pipeline, the workflow handles inconsistent formatting and complex project timelines that traditional automation tools often fail to process. It effectively acts as an AI executive assistant, ensuring your team stays synchronized without a single manual click. **Common Use Cases:** - Academic Term Scheduling: Automatically syncing university lecture timetables from faculty spreadsheets to student-facing calendars. - Project Milestone Tracking: Converting complex Excel project trackers into visual deadlines for cross-functional engineering teams. - Shift Management for Healthcare: Transforming weekly staff rosters into individual calendar invites with automated shift summaries sent to personnel.

โฐ Scheduledยท17 nodes
AGAGCODA+9
high

AI Agent: Auto-Sync Gmail/Outlook to Google Tasks & To Do

Stop losing critical action items in your overflowing inbox. This advanced n8n workflow leverages a sophisticated multi-agent AI system powered by Mistral Large to intelligently bridge the gap between your communication and project management. Unlike simple triggers, this flow uses an autonomous Orchestrator Agent that analyzes the context of incoming emails from both Gmail and Microsoft Outlook. It determines if an email is truly actionable, extracts the core requirement, and assigns it to the appropriate platformโ€”be it Google Tasks or Microsoft To Do. The automation executes a multi-step logic sequence: first, it fetches unread messages through specialized integrations; second, it utilizes a memory-buffered Mistral AI agent to structure the data into high-quality task descriptions; and finally, it employs sub-agents to handle rate-limiting and platform-specific API calls. This ensures a seamless, error-free transfer of data without manual intervention. By centralizing your cross-platform tasks into a single source of truth, you eliminate context switching and ensure that high-priority client requests or internal directives are never overlooked. It is the ultimate productivity engine for professionals managing hybrid ecosystems. **Common Use Cases:** - Executive Assistant Automation: Automatically triaging executive inboxes and converting stakeholder requests into prioritized task lists. - Project Management Sync: Converting client feedback received via email into actionable tickets within a team's shared Microsoft To Do or Google environment. - Freelance Workflow Optimization: Managing multiple client communication channels by consolidating all 'next steps' into a unified personal dashboard.

โฐ Scheduledยท26 nodes