Animated data flow diagram

AI-Powered Telegram Schedule & Info Bot

Version: 1.0.0 | Last Updated: 2025-05-16

Integrates with:

Telegram Google Sheets OpenRouter Langchain

Overview

Unlock Effortless Event & Meetup Info with this AI Agent

This AI Agent transforms your Telegram into an intelligent assistant for managing and answering questions about schedules. It connects directly to a Google Sheet where you maintain your event, meetup, or operational calendar. When a user asks a question in Telegram (or via the n8n chat interface for testing), the agent fetches the latest schedule, converts it to a format understandable by a Large Language Model (LLM) via OpenRouter, and then uses the LLM to provide natural, context-aware answers. It's like having a dedicated, always-on support person for your schedule inquiries, capable of understanding and responding intelligently.

Key Features & Benefits

  • Intelligent Q&A Ability: Leverages LLMs (via OpenRouter and Langchain) to understand user intent and provide accurate answers based on your schedule data.
  • Dynamic Schedule Source: Pulls real-time data from a Google Sheet, ensuring the AI's information is always current without manual updates to the bot itself.
  • Telegram Native Interaction: Engages users directly within Telegram, offering a convenient and widely-used platform for information access.
  • Multi-Channel Input Support: Can be triggered via Telegram for live user interactions and via n8n's internal chat UI for testing and debugging.
  • Contextual Awareness: The AI Agent is fed the schedule (converted to Markdown) as direct context, enabling it to answer specific questions about timings, topics, locations, etc.
  • Conversational Memory: Utilizes Langchain's memory capabilities to retain context within a session, allowing for more natural follow-up questions.
  • Enhanced User Experience: Implements "typing" indicators in Telegram, improving perceived responsiveness.
  • Customizable AI Personality: The system prompt for the AI can be easily modified to adjust its tone, role, and specific instructions.

Use Cases

  • For B2C e-commerce: Instantly answer customer queries on Telegram about upcoming flash sale schedules, product demonstration times, or special event details.
  • For B2B SaaS companies: Provide internal teams or clients with quick access to webinar schedules, training session timetables, or project meeting calendars via Telegram.
  • Automate responses to frequently asked questions for community meetups, workshops, or conference schedules, reducing organizer workload.
  • Offer a 24/7 AI-powered information point for event attendees, providing details on session timings, locations, and speakers directly in Telegram.

Prerequisites

  • An n8n instance (Cloud or self-hosted).
  • A Telegram Bot API Token.
  • Google Sheets credentials (OAuth2 setup in n8n) and the URL of your Google Sheet containing the schedule.
  • An OpenRouter API Key.
  • Ensure your Google Sheet has a clear header row as the first row, as this is used to structure the data for the AI.

Setup Instructions

  1. Download the n8n workflow JSON file.
  2. Import the workflow into your n8n instance.
  3. Configure the 'telegramInput' (Telegram Trigger) node with your Telegram Bot API Token.
  4. Configure the 'SendTyping' and 'telegramResponse' (Telegram) nodes using the same Telegram Bot API credentials.
  5. In the 'Settings' node, update the scheduleURL variable to the direct URL of your Google Sheet.
  6. Configure the 'Schedule' (Google Sheets) node: authorize your Google account and ensure it can access the specified sheet. Select the correct sheet name/ID if necessary.
  7. Configure the 'LLM' (OpenRouter Chat Model) node with your OpenRouter API Key. You can also select your preferred LLM model here.
  8. (Optional) Customize the systemMessage in the 'ScheduleBot' (Agent) node to refine the AI's role, instructions, and how it should use the schedule data.
  9. Review the 'ScheduleToMarkdown' (Code) node if your sheet has a very unusual structure; the default setup expects a standard tabular format.
  10. Activate the workflow. Test by sending a message to your Telegram bot or using the n8n Chat input.

Tags:

AI AgentAutomationTelegramGoogle SheetsLLMOpenRouterChatbotEvent ManagementLangchain

Want your own unique AI agent?

Talk to us - we know how to build custom AI agents for your specific needs.

Schedule a Consultation