AI Chatbot + Task and Calendar Automation (n8n)

Project Description
When a user sends a message to the Telegram bot, the AI Agent (powered by Google Gemini and integrated memory) understands natural language requests and determines whether the intent is to create, update, or retrieve a task or calendar event. It then interacts with Google Sheets and Google Calendar based on the command—saving new data, fetching records, or updating existing entries. The bot keeps users informed in real time, providing chat confirmations for every action completed.
Key Features and Steps
Natural Language Task Parsing:
Uses a conversational AI (Google Gemini) to understand and extract intent from Telegram messages without rigid commands.Bi-Directional Integration:
Connects Telegram, Google Sheets, and Google Calendar to enable creating, updating, and retrieving tasks and events from chat.Intelligent Routing & Memory:
Employs a switch node and memory modules to execute the right workflow (e.g., create task vs. update event) based on user’s message context.Instant Feedback to User:
Sends immediate confirmations to the user on Telegram for successful saves and updates, ensuring smooth, interactive experience.Automated Data Management:
Appends, updates, and retrieves data in Google Sheets for task tracking, while also allowing event management directly in Google Calendar.