Google Calendar and OpenAI integration

AI-Powered Automatic Timesheet Generator for Google Sheets Stop wasting billable hours on manual time-tracking. AutoTimesheet Pro uses AI to collect emails, meetings, and GitHub work, then writes a clean timesheet straight into Google Sheets. Perfect for developers, consultants, agencies, and remote teams. Get Started with n8n now! 🚀 Key Features Automated Google Sheets time-tracking** — zero spreadsheet prep. AI-generated activity summaries** (≤ 120 chars) via OpenAI GPT-4o-mini. Gmail integration** — logs only important emails, skipping newsletters & no-replies. Google Calendar time logger** — captures confirmed events, duration, and attendees. GitHub commit & PR tracker** — records your commits plus opened/closed PRs. Daily 7 PM cron trigger** (easily adjustable). Month-based sheet creation** — new tab spins up on the first run each month. No-code n8n template* — just connect credentials and tweak one Set Variables* node. 🔌 Easily extensible** — drag-and-drop extra n8n nodes to add Slack, Jira, Notion, Asana, Trello, Toggl, or any other data source you need. 🔍 How It Works Collect — n8n pulls data from Gmail, Google Calendar, and chosen GitHub repos. Clean — filters remove noise (newsletters, irrelevant commits, etc.). Condense — OpenAI rewrites each item into a concise, SEO-friendly description. Write — workflow appends Date, Type, and Description to your Timesheet Google Sheet. Extend — simply insert new n8n nodes (e.g., Slack, Notion, Jira) and merge them into the same pipeline. 📈 Benefits for SEO-Minded Professionals Keyword-rich activity log** improves internal search and reporting. Structured data** in Sheets simplifies export to accounting or PM tools. Consistent naming** (CALENDAR_EVENT, EMAIL, COMMIT, PR) makes analytics easy. ✅ Why Choose AutoTimesheet Pro? Zero manual entry — just open the sheet and bill clients. Immediate visibility into where your hours went. Works with any GitHub repo list and any inbox you own. 100 % no-code setup — activate in minutes. Built on n8n, so you can customize and scale without limits. 📥 Get Started Ready to replace manual time-tracking with smart automation? https://n8n.partnerlinks.io/ds9podzjls6d Join N8N now, connect your Google & GitHub accounts, and let AI handle your daily log.

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

WATCH THE n8n STARTER GUIDE 👇 This template is featured in the n8n Starter Guide series. The template is free, but comes with two additional PDFs and a Quick Start video if you grab the full download pack on gumroad. How it works This template is a visual map of many useful n8n nodes. It groups nodes like Triggers, AI tools, and App connectors onto the canvas. Explore the sections to learn about different nodes and easily copy them for your own workflows. It acts as a handy visual reference guide. Set up steps • Setup takes about 5 minutes. • Import the template into your n8n instance. • Explore the node categories visually on the canvas. • A Quick Start video is included in the download pack, along with a prompts PDF and PDF with links to other awesome n8n templates here on the n8n template gallery.

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.

🤖 Multi-Agent AI Telegram Bot for Service Businesses Transform your salon/service business with this streamlined Telegram automation system featuring Claude integration, zero-setup database management, and intelligent conversation handling. How It Works Core Architecture Claude MCP Integration** - Direct connection to Claude Sonnet 4 via Model Context Protocol Streamlined 2-Agent System** - Booking Agent and Admin Agent (simplified from 5 for better reliability) GPT-5 Mini Primary** with Gemini 2.5 Flash backup for cost-effective processing Multi-Media Support** - Handles text, voice (Whisper transcription), images, and PDFs with cost extraction Smart Acknowledgments** - "One moment…", "Let me check availability…" during processing Rate Limiting & Spam Protection** - Configurable limits (default: 100 msg/hour) with professional UX Zero-Setup Database Management Autonomous Airtable Creation** - Bot creates all necessary tables automatically Complete CRUD Operations** - Create, edit, delete services and settings via Telegram Dynamic Business Configuration** - Modify hours, pricing, services conversationally Friend Booking Support** - "Book for my friend Sarah" functionality Setup Steps Telegram Business API setup (detailed instructions included) Airtable Base ID extraction (store in Redis or hardcode - recommended) Google Calendar integration for scheduling Redis for caching, rate limiting, and conversation memory MCP Server deployment for Claude integration Telegram for notifications Key Features Booking Management Booking Limit Control** - Default 6 appointments per customer (configurable in workflow) Service Name Matching** - GPT-5 Nano workflow for cost-optimized service recognition 24-Hour Advance Reminders** - Automatic Telegram reminders sent at 8 PM Conversation Handling Conversation Memory** maintains context across interactions Error Resilience** with backup models and graceful failure handling Use Cases Perfect for: Salons Spas Clinics Consulting services Any appointment-based business Complete business setup happens through conversational commands - no manual database configuration required. Transform your service business with intelligent automation powered by AI and Telegram integration.

Who this workflow is for Consulting firms in strategy, management, or IT who want to automate client onboarding and internal task assignment. What this workflow does Automatically creates onboarding tasks and checklists using AI, routes them to the right consultant, logs client info in Google Sheets, and sends client welcome emails. Internal teams get Slack notifications, and kickoff meetings can be scheduled automatically. How the workflow works New client intake triggers workflow AI generates onboarding checklist Tasks routed based on project type Client info logged in Google Sheets Slack notifications sent to consultants Optional PDF of onboarding sent to client Email confirmation delivered to client Optional CRM integration Setup Instructions Connect Webhook/Form for intake Connect Google Sheets Connect OpenAI Connect Slack and email Configure optional CRM integration Author: Hyrum Hurst, AI Automation Engineer Company: QuarterSmart Contact: [email protected]