Google Calendar and Telegram integration

The CA - Tele Assistant workflow is an intelligent Telegram bot designed to help you manage your Google Calendar effortlessly through natural language and voice commands. 💡 Why Use CA - Tele Assistant? Hands-free calendar management:** Manage your events via text or voice with zero manual calendar app usage Smart reminders:** Receive tailored, friendly reminders well in advance, helping you stay prepared Multifunctional AI assistant:** Create, view, update, or delete events simply by chatting naturally Seamless integration:** Combines Google Calendar, Telegram, OpenAI transcription, and Google Gemini model for powerful capabilities Context-aware messaging:** Personalized message tone, emoji use, and prep tips depending on event type and urgency ⚡ Who Is This For? Busy professionals:** Who want to manage their schedule quickly without opening multiple apps Remote teams:** Needing easy calendar coordination and friendly reminders via Telegram People who prefer voice commands:** Allows scheduling and querying via Indonesian voice messages Anyone overwhelmed by calendar clutter:** Automates reminders and event organization effortlessly ❓ What Problem Does It Solve? Manually juggling your calendar events—creating entries, checking your schedule, or remembering appointments—is time-consuming and error-prone. Traditional calendar apps require multiple interactions and can flood you with generic notifications that lack context or personality. Voice commands or natural chat to manage calendars are rarely supported natively. CA - Tele Assistant solves these issues by offering a chat-based, AI-powered interface that understands your natural language or voice, automates calendar operations, and sends smart reminders tailored to your event and preferences. This reduces the cognitive load, minimizes missed appointments, and makes calendar management seamless. 🔧 How This Workflow Works ⏱ Step 1: Incoming Telegram messages or voice messages trigger the workflow via Telegram Trigger node 📥 Step 2: Voice messages are automatically downloaded and transcribed into text using OpenAI 🔀 Step 3: A Switch node routes text and voice commands for unified processing ✍️ Step 4: The Google Gemini AI model processes natural language commands for calendar actions 🧠 Step 5: A Langchain AI agent ("Calendar Manage!") handles operations such as event creation, update, deletion, and fetching events using Google Calendar API tools. It uses session memory to keep contextual chat flow 🔔 Step 6: A scheduled trigger every 15 minutes retrieves upcoming calendar events (within 45-60 mins), filters duplicates, and an AI Reminder Message Agent crafts personalized reminder messages 💬 Step 7: Reminder messages are sent automatically to the user's Telegram chat, with typing indicators for a humanized feel 🛠 Step 8: All data flows and interactions are combined, ensuring seamless conversational experience with real-time calendar sync 🔐 Setup Instructions Import the provided JSON workflow into your n8n instance Set up credentials: Telegram API Bot credentials via BotFather Google Calendar OAuth2 credentials OpenAI API key (for voice transcription) Google Palm API credentials (for Gemini AI) Customize: Adjust chat IDs, timezone preferences, and reminder timing (default 45-60 minutes before events) Update: Replace placeholder chat IDs with your Telegram chat ID Test: Send test commands or voice messages through your Telegram bot to verify event creation, updates, and reminder delivery 🧩 Pre-Requirements Telegram Bot: Create bot via @BotFather Google Calendar: Setup OAuth2 credentials OpenAI API: For voice message transcription Google Gemini: For AI language model 📚 Useful Resources n8n Documentation Telegram Bot API Google Calendar API OpenAI API Docs 🛠️ Customize It Further Add support for additional languages in voice transcription or chat responses Integrate weather or traffic APIs for more enhanced reminder tips Enable multi-user support with dynamic chat ID handling for group chats Enhance personality or tone configurations for more formal or casual responses 🧠 Nodes Used Telegram Trigger** Telegram** (Send Typing Indicator, Send Message, Download Voice) OpenAI** (Audio transcription) Langchain Google Gemini Model** Langchain AI Agents** (Reminder Message Agent, Calendar Manage! agent) Google Calendar** node (Get Upcoming Events) Google Calendar Tools** (Create, Update, Delete, Get events) Remove Duplicates** node Merge** node Switch** node Set** node Schedule Trigger** Memory Buffer Window** node 📞 Support Made by: khaisa Studio Tag: AI, Google Calendar, Telegram, Reminder, Schedule, Voice, OpenAI, Gemini, Category: Productivity Automation Need a custom? contact khaisa for more tailored templates

Overview This workflow is an AI-powered Dental Appointment Assistant that automates appointment booking, rescheduling, and cancellations through Telegram or a Webhook. It uses intelligent agents to understand user intent, gather details, manage Google Calendar events, update records in Google Sheets, and send confirmation emails — creating a fully automated and customizable booking system suitable for any business, not just dental clinics. How It Works User Interaction The workflow can be triggered via Telegram, Webhook, and can easily be extended to WhatsApp or Facebook Messenger. The Planning Agent starts the conversation and collects essential details like: Appointment type (book, update, or delete) Date and time preference Service type or reason for visit Personal details (name, email, etc.) Based on the user’s intent, it routes the conversation to the appropriate booking flow. Booking Flow The Booking Agent handles the actual scheduling logic. It interacts with Google Calendar to: Create new events for fresh appointments Update existing events for reschedules Delete events for cancellations It ensures proper validation (availability, overlaps, etc.) before confirming any calendar changes. Post-Booking Actions Once the booking action is completed: The Mail and Sheet Entry Agent updates the Google Sheet with user details such as: Name Email Appointment date & time Status (booked/updated/cancelled) Short description of the appointment Sends an email confirmation to the user (for all actions — create, update, or delete). Sends a final message via Telegram (or chosen platform) confirming the status of the appointment. How to Use Trigger the workflow via Telegram or a Webhook URL. The AI assistant will guide the user step-by-step through booking, updating, or cancelling an appointment. Once confirmed, the system: Updates Google Calendar automatically Logs the appointment details in Google Sheets Sends an email and chat confirmation message to the user Requirements To deploy this workflow, you’ll need: n8n account** (self-hosted or cloud) Telegram Bot Token**, or other chat integrations (WhatsApp / Facebook) OpenAI or OpenRouter API Key** (for AI conversation agents) Google Calendar API access** (to manage events) Google Sheets API access** (to store booking records) Gmail / SMTP credentials** (to send confirmation emails)

This Workflow simulates an AI-powered phone agent with RetellAI with two main functions: 📅 Appointment Booking – It can schedule appointments directly into Google Calendar. 🧠 RAG-based Information Retrieval – It provides answers using a Retrieval-Augmented Generation (RAG) system. For example, it can respond to questions such as store opening hours, return policies, or product details. The guide also explains how to purchase a dedicated phone number (with a +1 prefix) and link it to the AI agent. This setup is cost-effective, as it uses a FREE $10 credit to operate without additional charges in the beginning. ✨ Advantages 🕐 24/7 Availability** – The AI agent can answer calls and assist customers at any time. 🤖 Automation** – It reduces the workload on human staff by handling repetitive tasks like appointment scheduling and FAQ responses. 🔌 Easy Integration** – Built with n8n, it’s flexible and customizable for various platforms and tools. 💸 Low-cost Setup** – Using the free credit, businesses can get started without an upfront investment. 📦 Use Cases 🛍 E-commerce** – Answer common product questions or order inquiries. 🏬 Retail Stores** – Provide store hours, address info, and return policies. 🍽 Restaurants** – Take reservations or share menu information. 💼 Service Providers** – Book appointments or consultations. 📞 Any Local Business** – Offer phone support without needing a live operator. How It Works This Workflow simulates an AI-powered phone agent with two primary functions: Appointment Booking The workflow captures call events (e.g., call_ended or call_analyzed) and extracts key details (transcript, caller info, duration, etc.). Using OpenAI, it summarizes the conversation and parses structured data (e.g., names, contact info, dates). For scheduling, it converts user-provided dates into Google Calendar-compatible formats and creates events automatically. RAG-Based Information Retrieval When a query is received (e.g., store hours, product details), the workflow retrieves relevant information from a Qdrant vector store. An AI agent processes the query using the retrieved data and responds via a webhook, ensuring accurate, context-aware answers. Set Up Steps Prepare Qdrant Vector Store Create/refresh a Qdrant collection (via HTTP requests). Upload and vectorize documents (e.g., from Google Drive) using OpenAI embeddings. Configure RetellAI Agent Sign up for RetellAI, create an agent, and set the webhook URLs (n8n_call for call events, n8n_rag_function for RAG queries). Purchase a Twilio phone number and link it to the agent. n8n Workflow Setup Connect OpenAI, Qdrant, Google Calendar, and Telegram nodes with credentials. Customize prompts for summarization, date parsing, and RAG responses. Test the workflow to ensure data flows from call events → processing → actions (e.g., calendar bookings, Telegram alerts). Deploy Trigger the workflow via RetellAI webhooks during calls. Monitor outputs (e.g., call summaries in Telegram, calendar events). Note: Replace placeholders (e.g., QDRANTURL, COLLECTION, CHAT_ID) with actual values. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

The Ultimate Beginner's Guide to an AI-Powered Telegram Assistant (PDF, Brave search & Google Suite) This comprehensive workflow bundle is designed as a powerful starter kit, enabling you to build a multi-functional AI assistant on Telegram. It seamlessly integrates AI-powered voice interactions, an intelligent PDF document search using a Retrieval-Augmented Generation (RAG) system, and automates various Google Suite tasks like calendar management and document generation. Perfect for beginners looking to explore advanced AI and automation capabilities. Disclaimer This template is designed for self-hosted n8n instances. 🚀 Key Features Telegram Bot Interface:** Interact with your AI assistant using both text and voice commands through Telegram. AI Voice Bot:** Transcribes user voice messages using OpenAI Whisper. Processes requests with an AI agent powered by Google Gemini. Responds with AI-synthesized voice using Replicate API. PDF RAG System:** Index PDF documents from Google Drive via Telegram commands. Utilizes Mistral AI for Optical Character Recognition (OCR) on PDFs. Stores document content and embeddings in a Qdrant vector database. Answers questions about your documents using Google Gemini, based on retrieved context. Google Suite Automation:** Manage Google Calendar: Create events, find upcoming holidays, and list birthdays. Google Drive: Search for PDF files and manage document templates. Google Docs: Automatically generate invoices from templates. Intelligent Web Search:** Employs Brave Search for fetching real-time information from the web. Versatile AI Agent:** Leverages Google Gemini with a suite of tools including a calculator, date & time utilities, and custom integrations (e.g., example Airbnb tools). Command-Driven Functionality:** Easily trigger specific actions using Telegram commands like /help, /pdf, /rag, /invoice, /chat, /brave, and /birthday. ⚙️ How It Works The workflow is initiated by messages or commands sent to your Telegram bot. A central Switch node directs the flow based on the input received. Telegram Interaction & Command Routing A Telegram Trigger node listens for new messages (text or voice). A "typing..." indicator is sent to Telegram for better user experience. The Switch node parses the message content and routes it to the appropriate sub-workflow based on predefined commands (e.g., /pdf, /rag, /voice) or general chat. AI Voice Bot Functionality For voice messages (or if the voice path is triggered): The voice file is downloaded from Telegram. OpenAI Whisper transcribes the audio into text. The transcribed text is fed to an AI Agent (powered by Google Gemini and equipped with various tools and memory). The AI Agent's text response is then sent to the Replicate API to generate a natural-sounding voice. The generated audio response is sent back to the user on Telegram. PDF RAG System with Mistral OCR & Qdrant Indexing PDFs (via /qdrant <Google_Drive_File_ID> command):** The specified PDF is downloaded from Google Drive. The PDF is uploaded to Mistral AI for OCR processing. The extracted text (in markdown format) is retrieved. The text is split into manageable chunks. OpenAI Embeddings are generated for each chunk. These chunks and their embeddings are stored in a Qdrant vector collection. A confirmation message is sent to Telegram. Querying PDFs (via /rag <your_question> command):** The user's question is processed by a RetrievalQA Chain. This chain uses Google Gemini as the Language Model and retrieves relevant document chunks from Qdrant based on semantic similarity (embeddings). Google Gemini then generates a concise answer based on the user's question and the retrieved contextual information from the documents. The answer is sent back to the user on Telegram. Searching PDFs in Drive (via /pdf <search_term> command):** Searches your Google Drive for PDF files matching the provided search term. Sends a list of found PDF files (name and ID) to the user on Telegram, allowing them to easily identify files for indexing with /qdrant. AI Chat & Task Automation (General Chat & /chat command) Handles general text messages or transcribed voice inputs that are not specific commands. An AI Agent (Google Gemini) processes these inputs. The agent is equipped with tools such as: Google Calendar Tools: To create events, find the next public holiday, or list upcoming birthdays. Brave Search Tool: To search the internet for information. Calculator Tool: For mathematical computations. Date & Time Utility: For handling and formatting dates. Example Airbnb Tools: Demonstrates extensibility for custom tool integrations. The agent utilizes a "Think Node" process for reasoning and Window Buffer Memory to maintain conversational context. Responses are formulated and sent back to the user on Telegram. Google Automations Invoice Generation (via /invoice command):** Copies a predefined Google Docs invoice template from your Google Drive. Populates the new document with details (client name, items, etc. – currently uses placeholder data from an 'Edit Fields' node, which can be customized to parse input from the command). Converts the populated Google Doc into a PDF file. Sends the generated PDF invoice to the user via Telegram. Calendar Management (via AI Agent or specific commands like /birthday):** The /birthday command fetches upcoming birthdays from a specified Google Calendar. The AI Agent can also interact with Google Calendar to create events or retrieve information based on natural language requests. Web Search (via /brave <query> command or AI Agent) Performs a web search using the Brave Search API. Returns a list of search results, including titles and URLs, to the user on Telegram. Help Command (/help) Provides the user with a formatted list of all available Telegram commands and their basic usage instructions. 🛠️ Setup Steps & Credentials To get this workflow bundle up and running, you'll need to configure several credentials: Telegram: Create a new bot via @BotFather on Telegram to obtain a Bot Token. Add this token to the Telegram Trigger node and all Telegram (sender) nodes in the workflow. OpenAI: Obtain an API Key from platform.openai.com. Create an OpenAI credential. Use this credential in the Convert audio to text (OpenAI node for Whisper transcription) and all Embeddings OpenAI nodes (for RAG system). Replicate API (Text-to-Speech): Sign up at replicate.com and get your API token. Create an HTTP Bearer Auth credential using this token. Assign this credential to the Call Replicate API (HTTP Request) node. Google Gemini (PaLM API): Get an API key from Google AI Studio or Google Cloud Console. Create a Google Gemini(PaLM) Api credential. Assign it to all Google Gemini Chat Model nodes. Qdrant (Vector Database): Set up a Qdrant instance (either cloud-hosted or self-managed). Note your Qdrant instance URL and API Key (if security is enabled). Create a QdrantApi credential with these details. Assign it to the Qdrant Vector Store nodes. For the Refresh collection node (an HTTP Request node used to clear the collection for /pdf command demo), create an HTTP Header Auth credential with your Qdrant API key if required by your instance. Mistral AI (PDF OCR): Obtain an API key from console.mistral.ai. Create a Mistral Cloud API credential. Assign this to the Mistral Upload, Mistral Signed URL, and Mistral DOC OCR (HTTP Request) nodes. Google Drive & Google Docs: Ensure the Google Drive API and Google Docs API are enabled in your Google Cloud Console project. Set up OAuth 2.0 credentials (Client ID and Client Secret). Create Google Drive OAuth2 Api and Google Docs OAuth2 Api credentials. Assign these to the respective Google Drive and Google Docs nodes throughout the workflow. Important: Configure relevant Folder IDs (for PDF search, invoice template source, invoice output) and the invoice template Document ID in the Google Drive and Google Docs nodes. Google Calendar: Enable the Google Calendar API in your Google Cloud Console project. Set up OAuth 2.0 credentials. Create a Google Calendar OAuth2 Api credential. Assign it to the Google CalendarTool and Google Calendar nodes. Specify the correct calendar names or IDs in the nodes (e.g., for birthdays, holidays, new event creation). Brave Search: Get a Brave Search API key from their developer portal. Create a Brave Search API credential. Assign it to the Brave Search nodes and tools. (Optional) Airbnb MCP Client: The workflow includes example nodes for Airbnb MCP tools. If you intend to use or expand these, set up the corresponding MCP Client API credentials. 💡 Customization & Learning This "Beginner Bundle" is not just a ready-to-use solution but also a fantastic learning resource: Explore AI Agent Prompts:** Dive into the AI Agent nodes to see how prompts are structured to guide the LLM's behavior, including the "Think Node" process and character guidance for robust messaging. Modify Toolsets:** Easily add or remove tools for the AI agent to expand its capabilities. Invoice Customization:** Adapt the Edit Fields node and the Google Docs template to match your invoicing needs. You can extend it to parse invoice details directly from the Telegram command. RAG Parameters:** Experiment with chunk sizes, overlap, and different embedding models in the RAG pipeline. Extend Commands:** Add new commands and corresponding functionalities by expanding the main Switch node and building out new automation paths. By setting up and dissecting this workflow, beginners can gain a practical understanding of building complex, AI-driven applications, integrating various services, and managing different data flows.

Telegram Appointment Scheduling Bot with n8n 📃 Description Tired of managing appointments manually? This template transforms your Telegram account into a smart virtual assistant that handles the entire scheduling process for you, 24/7. This workflow allows you to deploy a fully functional Telegram bot that not only schedules appointments but also checks real-time availability in your Google Calendar, logs a history in Google Sheets, and allows your clients to cancel or view their upcoming appointments. It's the perfect solution for professionals, small businesses, or anyone looking to automate their booking system professionally and effortlessly. ✨ Key Features Complete Appointment Management:** Allows users to schedule, cancel, and list their future appointments. Conflict Prevention:** Integrates with Google Calendar to check availability before confirming a booking, eliminating the risk of double-booking. Automatic Logging:** Every confirmed appointment is saved to a row in Google Sheets, creating a perfect database for tracking and analysis. Smart Interaction:** The bot handles unrecognized commands and guides the user, ensuring a smooth experience. Easy to Adapt:** Connect your own accounts, customize messages, and tailor it to your business needs in minutes. 🚀 Setup Follow these steps to deploy your own instance of this bot: Prerequisites An n8n instance (Cloud or self-hosted). A Telegram account. A Google account. Telegram Bot Talk to @BotFather on Telegram. Create a new bot using /newbot. Give it a name and a username. Copy and save the API token it provides. Google Cloud & APIs Go to the Google Cloud Console. Create a new project. Enable the Google Calendar API and Google Sheets API. Create OAuth 2.0 Client ID credentials. Make sure to add your n8n instance's OAuth redirect URL. Save the Client ID and Client Secret. Google Sheets Create a new spreadsheet in Google Sheets. Define the column headers in the first row. For example: id, Client Name, Date and Time, ISO Date. n8n Import the workflow JSON file into your n8n instance. Set up the credentials: Telegram: Create a new credential and paste your bot's token. Google Calendar & Google Sheets (OAuth2): Create a new credential and paste the Client ID and Client Secret from the Google Cloud Console. Review the Google Calendar and Google Sheets nodes to select your correct calendar and spreadsheet. Activate the workflow! 💬 Usage Once the bot is running, you can interact with it using the following commands in Telegram: To start the bot:** /start To schedule a new appointment:** agendar YYYY-MM-DD HH:MM Your Full Name To cancel an existing appointment:** cancelar YYYY-MM-DD HH:MM Your Full Name To view your future appointments:** mis citas Your Full Name 👥 Authors Jaren Pazmiño President of the Polytechnic Artificial Intelligence Club (CIAP)

Get Forex Factory News Release to Telegram, Google Sheets. Record News Data and Live Price from MyFxBook for Affected Currency Pairs. This n8n template demonstrates how to capture Actual Data Releases as quickly as possible for trading decisions. Use cases: Get notified if the actual data release is positive or negative for the relevant currency. Use the Telegram chat message about the news release as a trigger to open a trading position in MetaTrader 4. Record news data and live price to google sheets for analysis. Currency Pairs EURUSD, GBPUSD, AUDUSD, NZDUSD, USDJPY, USDCHF, USDCAD, XAUUSD How it works A news release event acts as the trigger. Only news with a numerical Forecast value will be processed. Events that cannot be measured numerically (e.g., speeches) are ignored. Extract news details: currency, impact level (high/medium), release date, and news link. Wait 10 seconds to ensure the Actual value is available on the news page. Scrape the Actual value from the news link using Airtop. If the Actual value is not available, wait another 5 seconds and retry scraping. Extract both Actual and Forecast values from the scraped content. Remove non-numeric characters (%, K, M, B, T) and convert values to numbers. Determine the effect: If the Actual value is lower than the Forecast value (and lower is better), send it to the True branch. Otherwise, send it to the False branch. Record news data and live price from MyFxBook to Google Sheets. How to use Enter all required credentials. Create or Download Google Sheets file like this in your Google Drive: https://docs.google.com/spreadsheets/d/1OhrbUQEc_lGegk5pRWWKz5nrnMbTZGT0lxK9aJqqId4/edit?usp=drive_link Run the workflow. Requirements Google Calendar credentials Airtop API key Telegram Chat ID Telegram Bot API token Enable Google Drive API in Google Cloud Console Google Sheets credentials Need Help? Join the Discord or ask in the Forum! Thank you! Update Sept 26, 2025: Add new edit node