Description
This automation workflow enables conversational access to an event schedule stored in Google Sheets — all from within a Telegram bot. Built for event organizers, community leaders, and teams, it allows users to ask natural language questions about upcoming or past events and get instant, intelligent responses.
🔍 Key Use Cases
📅 Event Organizers
Allow participants or team members to get real-time answers about upcoming or past events.
👥 Community Managers
Provide audience-friendly access to schedules, speakers, and event gaps.
💼 Internal Teams
Track meetings, presentations, or deadlines using chat-based queries.
🛠️ Automation Builders
Easily adapt this system to query any tabular data with a similar interface.
🤖 What This Workflow Does
📨 Message Trigger via Telegram Bot
Starts when a user sends a message to the Telegram bot.
📊 Fetches Google Sheets Data
Connects to your chosen Google Spreadsheet and retrieves event data.
🧠 Prepares Input for LLM
Formats the spreadsheet as a markdown table and includes it in the system prompt.
💬 Generates Natural Language Responses
Uses OpenRouter and your selected LLM to generate an intelligent reply.
📤 Delivers Chat-Based Reply
Sends the AI-generated response back to the Telegram chat seamlessly.
⚙️ Customization Options
📁 Replace the spreadsheet with any Google Sheet containing tabular data.
📝 Modify the system prompt to reflect different domains (e.g., meetings, school events, conferences).
🔄 Swap the LLM in OpenRouter for other models based on your goals.
🎨 Style the chatbot’s tone, formatting, and responses to match your brand voice.
💬 Example Questions You Can Ask
“When is the next meetup?”
“Which future meetups have no presenters yet?”
“Who presented on AI in Healthcare?”
“How many events are there in August?”
🚀 Why Use This?
⚡ Real-Time Querying
Access structured data instantly without touching spreadsheets.
🗣️ Natural Language Interface
Perfect for non-technical users to interact with schedules.
🔧 Highly Adaptable
Works with any structured spreadsheet — ideal for events, classes, or projects.
📲 Seamless Integration
Runs entirely within Telegram using n8n and OpenRouter, with simple setup.
