Answer event questions in chat using your live schedule. Messages from Telegram or your internal chat get clear replies based on one source of truth in Google Sheets. Great for meetup hosts, clubs, and community managers who need fast answers without manual checking.

Incoming messages arrive from Telegram or the n8n chat input. A settings step normalizes the text and stores keys like chat ID and spreadsheet URL. The Google Sheets node loads the latest rows, and a code step turns them into a Markdown table for context. An AI agent with OpenRouter and short term memory reads that table and writes a helpful reply. A switch routes the message back to Telegram or the n8n chat, and a typing action shows users that a response is on the way. Responses are assembled in a single place so both channels stay consistent.

You will need a Telegram bot token, a Google account for sheet access, and an OpenRouter API key. Expect to cut daily schedule questions from hours to minutes while keeping answers current and consistent. Useful for meetups, training schedules, and community events that change often. Results include faster replies, fewer mistakes, and simpler handoffs across your team.

• Dual chat entry points with Telegram trigger and n8n chat input
• Typing indicator in Telegram so users see activity right away
• Settings step stores chat ID and spreadsheet URL for easy control
• Google Sheets reader pulls the latest schedule from your sheet
• Code step converts rows into a clear Markdown table for the AI
• AI agent uses OpenRouter with short term memory for context aware answers
• Switch node routes replies back to Telegram or the n8n chat
• Unified response builder keeps message format consistent across channels

• Reduce manual replies from 2 hours to 10 minutes per day
• Improve answer accuracy by 80 percent using one live sheet
• Handle up to 10 times more chat questions without extra staff
• Average reply time under 30 seconds with instant typing feedback
• Connect Telegram, Google Sheets and AI in one simple flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Telegram, Google Sheets and OpenRouter. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create a Telegram credential. Get your bot token from BotFather in Telegram, then paste it into the Telegram credential. Save it and select it on the Telegram Trigger and Telegram nodes.
4. Start a chat with your bot in Telegram and send a short message. This creates an incoming event so you can read the chat ID in the telegramInput node when testing.
5. Open the Settings node and paste your Google Sheet URL into the scheduleURL field. Optionally set a default chatId for outbound Telegram replies if you want to route to a fixed chat.
6. Open the Google Sheets node named Schedule. In the credential dropdown, click Create new credential and connect your Google account. Confirm the sheet tab matches your data and save.
7. Open the LLM node. Create a new OpenRouter credential and paste your API key from the OpenRouter account page. Save and select the credential.
8. Review the system message in the ScheduleBot node to match your event tone, rules, and policies. Keep the schedule table reference in place.
9. Test data retrieval: execute the Schedule and ScheduleToMarkdown nodes and check the Markdown table output in the node panel.
10. Test end to end with the n8n chat input by executing the workflow, sending a message, and checking the n8nResponse output.
11. Activate the workflow and send a message to your bot in Telegram. You should see the typing indicator and then the final answer.
12. If no reply appears, verify the Telegram webhook by opening the Telegram Trigger node and checking the activation status, confirm your Google Sheet is accessible, and make sure Settings.chatId is correct or switch the telegramResponse chatId to use the incoming message chat ID.