What This Workflow Does
This automation solves the common problem of team members constantly asking about upcoming events, schedules, and speaker details. Instead of manually checking spreadsheets or answering repetitive questions, this workflow turns your Google Sheets event schedule into an interactive Telegram chatbot.
The system understands natural language questions like "When is the next conference?" or "Who's speaking on Thursday?" and responds instantly with accurate information pulled directly from your Google Sheet. This eliminates manual lookups and ensures everyone gets consistent, up-to-date event information.
How It Works
1. Query Processing
The workflow first analyzes incoming Telegram messages to identify key parameters like date ranges, event types, or speaker names. It uses natural language processing to understand the intent behind questions.
2. Google Sheets Lookup
Based on the parsed query, the system searches your Google Sheets event schedule for matching records. It can filter by date, event type, speaker, or other criteria you've defined in your spreadsheet columns.
3. Response Generation
The workflow formats the matching event data into a readable response, highlighting key details like dates, times, locations, and speaker information before sending it back through Telegram.
Pro tip: Structure your Google Sheet with clear column headers (Date, Event Name, Speaker, etc.) to make query responses more accurate and informative.
Who This Is For
This automation is ideal for event organizers, community managers, and teams that regularly host meetings, conferences, or webinars. It's particularly valuable for:
- Meetup groups with frequent events
- Conference planning teams
- Corporate training departments
- Community managers running regular webinars
- Teams coordinating multiple speaker sessions
What You'll Need
- An n8n instance (cloud or self-hosted)
- A Google Sheets document with your event schedule
- A Telegram bot token (create via BotFather)
- Basic familiarity with n8n workflow editing
Quick Setup Guide
- Download and import the JSON template into your n8n instance
- Connect your Google Sheets account in the Google Sheets node
- Add your Telegram bot token in the Telegram node
- Map your spreadsheet columns to the query parameters
- Test with sample questions in your Telegram group
Key Benefits
Save 5+ hours monthly by eliminating manual schedule lookups and repetitive question answering. Team members get instant answers without interrupting organizers.
Reduce scheduling errors by providing answers directly from your master event sheet, ensuring everyone works from the same accurate information.
Improve attendee experience with 24/7 access to event details, even when organizers aren't available to answer questions.
Scale event communications effortlessly as your community grows, without proportionally increasing administrative workload.