Turn your Telegram into a smart event helper. It answers schedule questions using live data from a Google Sheet. This is ideal for clubs, meetups, courses, and community groups that get many repeated questions.

Two inputs can start the chat. People can message your Telegram bot, or you can test inside n8n chat. The flow grabs the latest schedule from Google Sheets, converts it into a simple table, and passes it to an AI chat agent. The agent uses memory to keep context across messages and writes clear replies. A typing indicator shows users that a response is coming, and a switch sends the final message back to Telegram or to the n8n chat window.

Setup needs a Telegram bot token, access to the Google Sheet, and an OpenRouter API key for the AI model. Once active, most routine questions run without staff time. Organizers save time, reduce mistakes, and offer fast answers for members.

• Two triggers accept chat input from Telegram and from n8n chat for easy testing
• Google Sheets node reads the schedule using a shared document URL
• Code node converts rows into a clean Markdown table for the AI
• LLM agent uses OpenRouter with a memory window to keep context
• Send typing action lets users see the bot is working
• Switch node routes the final answer to Telegram or to the n8n chat view
• Set nodes normalize input and assemble the final response message
• Session key uses chatId so each user gets a consistent conversation

• Reduce manual schedule replies from 1 hour a day to 5 minutes
• Automate up to 80 percent of repeated schedule questions
• Cut wrong answers by using one source of truth in Google Sheets
• Support many Telegram chats at once without extra staff
• Connect chat and data in one flow for faster responses

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 Google Sheets, Telegram and OpenRouter. See the Tools Required section above for links to create accounts with these services.
3. Create a Telegram bot in BotFather and copy the bot token. In n8n, open the Telegram Trigger node and the Telegram Send/Response nodes, choose Create new credential, and paste the token when asked.
4. Connect Google Sheets. Double click the Google Sheets node, create a new Google Sheets OAuth credential, and follow the on screen login. Share the target Sheet with the Google account you used.
5. Get an OpenRouter API key from your OpenRouter account. In the LLM node, create a new OpenRouter credential and paste the API key.
6. Open the Settings node and paste your Google Sheet link into the scheduleURL field. Make sure the first row in the sheet has headers and the data is in the first tab.
7. Check chatId mapping. In telegramChatSettings, ensure chatId is taken from the Telegram trigger message so replies go back to the correct user. The telegramResponse node should read chatId from Settings.
8. Review the Code node that formats the schedule. Confirm it runs without errors and returns a Markdown table preview in the node output.
9. Activate the workflow. Send a test message to your Telegram bot asking about the next event. You should see the typing indicator and then a reply with details.
10. If replies fail, verify the Sheet is accessible, the scheduleURL is correct, and credentials are connected. If Telegram does not respond, recheck the bot token and that the workflow is active.